Avalanche

Avalanche Schema Description and Methodology

This schema contains comprehensive datasets for tracking Avalanche fundamental data across multiple metrics categories, including network activity, fees, staking, stablecoin usage, bridge activity, developer engagement, and market data.

Available Tables

Avalanche data is available in several tables:

• ez_metrics: Main aggregated metrics for the Avalanche network
• ez_metrics_by_category_v2: Metrics broken down by transaction category
• ez_metrics_by_application_v2: Metrics broken down by application
• ez_metrics_by_subcategory: Metrics broken down by subcategory
• ez_metrics_by_contract_v2: Metrics broken down by contract
• ez_metrics_by_chain: Cross-chain flow metrics with inflow and outflow data

Table Schema

Network and Usage Metrics

Table Name	Column Name	Description
ez_metrics	chain_txns	Daily transactions on the Avalanche network
ez_metrics	chain_dau	Daily unique users on Avalanche
ez_metrics	chain_wau	Weekly unique users on Avalanche
ez_metrics	chain_mau	Monthly unique users on Avalanche
ez_metrics	chain_avg_txn_fee	The average transaction fee on Avalanche
ez_metrics	chain_median_txn_fee	The median transaction fee on Avalanche
ez_metrics	returning_users	The number of returning users on Avalanche
ez_metrics	new_users	The number of new users on Avalanche
ez_metrics	dau_over_100_balance	The number of users with balances over $100

User Classification Metrics

Table Name	Column Name	Description
ez_metrics	sybil_users	The number of sybil users (suspected bots) on Avalanche
ez_metrics	non_sybil_users	The number of non-sybil users on Avalanche
ez_metrics	low_sleep_users	Users with continuous activity (possible bots)
ez_metrics	high_sleep_users	Users with normal activity patterns (likely humans)

Fee and Revenue Metrics

Table Name	Column Name	Description
ez_metrics	chain_fees	The total transaction fees paid on Avalanche (in USD)
ez_metrics	ecosystem_revenue	Total revenue generated (same as chain_fees)
ez_metrics	ecosystem_revenue_native	The total native AVAX value from all user-paid fees
ez_metrics	burned_cash_flow	USD value of AVAX burned through transaction fees
ez_metrics	burned_cash_flow_native	Amount of native AVAX burned through transaction fees
ez_metrics	fees	Legacy naming for chain_fees
ez_metrics	fees_native	Transaction fees in native AVAX tokens
ez_metrics	revenue	Legacy naming for burned_cash_flow
ez_metrics	revenue_native	Legacy naming for burned_cash_flow_native

Volume and Trading Metrics

Table Name	Column Name	Description
ez_metrics	chain_spot_volume	Total spot DEX volume on Avalanche
ez_metrics	chain_nft_trading_volume	The total volume of NFT trading on Avalanche
ez_metrics	settlement_volume	Total volume of DEX + NFT + P2P transfers
ez_metrics	dex_volumes	Legacy naming for chain_spot_volume
ez_metrics	nft_trading_volume	Legacy naming for chain_nft_trading_volume

P2P Transfer Metrics

Table Name	Column Name	Description
ez_metrics	p2p_native_transfer_volume	Volume of AVAX transfers directly between wallets
ez_metrics	p2p_token_transfer_volume	Volume of ERC-20 token transfers between wallets
ez_metrics	p2p_transfer_volume	Total volume of all P2P transfers

Staking Metrics

Table Name	Column Name	Description
ez_metrics	total_staked	The total USD value staked on Avalanche
ez_metrics	total_staked_native	The total amount of native AVAX staked
ez_metrics	total_staked_usd	Legacy naming for total_staked

Stablecoin Metrics

Table Name	Column Name	Description
ez_metrics	stablecoin_total_supply	The total supply of stablecoins on Avalanche
ez_metrics	stablecoin_txns	The number of stablecoin transactions
ez_metrics	stablecoin_dau	Daily active users of stablecoins
ez_metrics	stablecoin_mau	Monthly active users of stablecoins
ez_metrics	stablecoin_transfer_volume	The total volume of stablecoin transfers
ez_metrics	stablecoin_tokenholder_count	The number of unique stablecoin tokenholders
ez_metrics	artemis_stablecoin_txns	Stablecoin transactions excluding MEV transactions
ez_metrics	artemis_stablecoin_dau	Daily users excluding MEV addresses
ez_metrics	artemis_stablecoin_mau	Monthly users excluding MEV addresses
ez_metrics	artemis_stablecoin_transfer_volume	Stablecoin volume excluding MEV transactions
ez_metrics	p2p_stablecoin_txns	P2P stablecoin transactions (wallet-to-wallet)
ez_metrics	p2p_stablecoin_dau	Daily users of P2P stablecoin transfers
ez_metrics	p2p_stablecoin_mau	Monthly users of P2P stablecoin transfers
ez_metrics	p2p_stablecoin_transfer_volume	Volume of P2P stablecoin transfers
ez_metrics	p2p_stablecoin_tokenholder_count	Unique holders conducting P2P transfers
ez_metrics	non_p2p_stablecoin_transfer_volume	Volume of non-P2P stablecoin transfers (contract interactions)

Bridge Metrics

Table Name	Column Name	Description
ez_metrics	bridge_volume	The total volume bridged to/from Avalanche
ez_metrics	bridge_daa	Daily active users of Avalanche bridges

Tokenomics Metrics

Table Name	Column Name	Description
ez_metrics	emissions_native	The amount of new AVAX tokens emitted
ez_metrics	issuance	Legacy naming for emissions_native

Developer Activity Metrics

Table Name	Column Name	Description
ez_metrics	weekly_commits_core_ecosystem	Commits to the Avalanche core ecosystem repositories
ez_metrics	weekly_commits_sub_ecosystem	Commits to Avalanche sub-ecosystem repositories
ez_metrics	weekly_developers_core_ecosystem	Developers contributing to core repositories
ez_metrics	weekly_developers_sub_ecosystem	Developers contributing to sub-ecosystem repositories
ez_metrics	weekly_contracts_deployed	The number of new contracts deployed on Avalanche
ez_metrics	weekly_contract_deployers	The number of addresses deploying contracts

Market and Token Metrics

Table Name	Column Name	Description
ez_metrics	price	The price of AVAX token in USD
ez_metrics	market_cap	The market cap of AVAX token in USD
ez_metrics	fdmc	The fully diluted market cap of AVAX token in USD
ez_metrics	tvl	The total value locked in Avalanche protocols

Sample Queries

Basic Network Activity Query

-- Pull fundamental network activity data for Avalanche
SELECT
    date,
    chain_txns,
    chain_dau,
    chain_fees,
    chain_avg_txn_fee,
    chain_median_txn_fee,
    price
FROM
    art_share.avalanche.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

Fee and Revenue Analysis

-- Analyze Avalanche fee metrics
SELECT
    date,
    chain_fees,
    ecosystem_revenue,
    burned_cash_flow,
    chain_txns,
    chain_fees / chain_txns as fee_per_transaction,
    chain_avg_txn_fee,
    chain_median_txn_fee
FROM
    art_share.avalanche.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

Staking Analysis

-- Analyze Avalanche staking metrics
SELECT
    date,
    total_staked,
    total_staked_native,
    price,
    market_cap,
    total_staked / market_cap * 100 as staking_ratio,
    emissions_native,
    emissions_native / total_staked_native * 365 * 100 as annualized_yield
FROM
    art_share.avalanche.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

User Analysis

-- Analyze different user types on Avalanche
SELECT
    date,
    chain_dau,
    new_users,
    returning_users,
    sybil_users,
    non_sybil_users,
    low_sleep_users,
    high_sleep_users,
    dau_over_100_balance,
    non_sybil_users / NULLIF(chain_dau, 0) * 100 as non_sybil_percentage
FROM
    art_share.avalanche.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

Volume Analysis

-- Analyze different volume sources on Avalanche
SELECT
    date,
    settlement_volume,
    chain_spot_volume,
    chain_nft_trading_volume,
    p2p_transfer_volume,
    p2p_native_transfer_volume,
    p2p_token_transfer_volume,
    stablecoin_transfer_volume,
    chain_spot_volume / NULLIF(settlement_volume, 0) * 100 as dex_percentage
FROM
    art_share.avalanche.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

Stablecoin Analysis

-- Track stablecoin usage on Avalanche
SELECT
    date,
    stablecoin_total_supply,
    stablecoin_dau,
    artemis_stablecoin_dau,
    p2p_stablecoin_dau,
    stablecoin_transfer_volume,
    p2p_stablecoin_transfer_volume,
    non_p2p_stablecoin_transfer_volume,
    p2p_stablecoin_transfer_volume / NULLIF(stablecoin_transfer_volume, 0) * 100 as p2p_percentage
FROM
    art_share.avalanche.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

Bridge Activity Analysis

-- Track bridge activity on Avalanche
SELECT
    date,
    bridge_volume,
    bridge_daa as bridge_dau,
    bridge_volume / NULLIF(bridge_daa, 0) as avg_bridge_volume_per_user,
    chain_dau,
    bridge_daa / NULLIF(chain_dau, 0) * 100 as bridging_user_percentage
FROM
    art_share.avalanche.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

Developer Activity Monitoring

-- Track developer activity on Avalanche
SELECT
    date,
    weekly_contracts_deployed,
    weekly_contract_deployers,
    weekly_commits_core_ecosystem,
    weekly_commits_sub_ecosystem,
    weekly_developers_core_ecosystem,
    weekly_developers_sub_ecosystem,
    weekly_contracts_deployed / NULLIF(weekly_contract_deployers, 0) as avg_contracts_per_deployer
FROM
    art_share.avalanche.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

Tokenomics Analysis

-- Analyze Avalanche tokenomics
SELECT
    date,
    emissions_native,
    burned_cash_flow_native,
    emissions_native - burned_cash_flow_native as net_daily_supply_change,
    price,
    (emissions_native - burned_cash_flow_native) * price as net_daily_supply_change_usd,
    emissions_native / NULLIF(total_staked_native, 0) * 365 * 100 as annualized_emission_rate
FROM
    art_share.avalanche.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

Application-specific Analysis

-- Analyze metrics for specific applications on Avalanche
SELECT
    date,
    app,
    friendly_name,
    category,
    txns,
    dau,
    returning_users,
    new_users
FROM
    art_share.avalanche.ez_metrics_by_application_v2
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND app IN ('trader-joe', 'aave-v3', 'gmx')
ORDER BY
    app, date ASC

Cross-chain Flow Analysis

-- Analyze cross-chain flows to and from Avalanche
SELECT
    date,
    inflow,
    outflow,
    inflow - outflow as net_flow,
    SUM(inflow - outflow) OVER (ORDER BY date) as cumulative_net_flow
FROM
    art_share.avalanche.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC