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 | fees | Total revenue generated (same as chain_fees) |
| ez_metrics | fees_native | The total native AVAX value from all user-paid fees |
| ez_metrics | burned_fee_allocation | USD value of AVAX burned through transaction fees |
| ez_metrics | burned_fee_allocation_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_fee_allocation |
| ez_metrics | revenue_native | Legacy naming for burned_fee_allocation_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 |
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 |
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,
fees,
burned_fee_allocation,
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,
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,
stablecoin_transfer_volume
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_fee_allocation_native,
emissions_native - burned_fee_allocation_native as net_daily_supply_change,
price,
(emissions_native - burned_fee_allocation_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