Available Tables
Aerodrome data is available in two main tables:- ez_metrics: Main aggregated metrics for the Aerodrome Protocol across both V1 and Slipstream
- ez_metrics_by_chain: Chain-specific metrics (currently focused on Base network)
Table Schema
Trading and DEX Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | spot_dau | The number of daily active traders on Aerodrome V1 and Slipstream |
| ez_metrics | spot_txns | The number of daily trades on Aerodrome V1 and Slipstream |
| ez_metrics | spot_volume | The total trading volume on Aerodrome V1 and Slipstream |
| ez_metrics | spot_fees | The total amount of fees (in USD) on Aerodrome V1 and Slipstream |
| ez_metrics | unique_traders | Same as spot_dau (legacy naming) |
| ez_metrics | number_of_swaps | Same as spot_txns (legacy naming) |
| ez_metrics | trading_volume | Same as spot_volume (legacy naming) |
| ez_metrics | trading_fees | Same as spot_fees (legacy naming) |
Revenue and Fee Distribution
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | fees | The total USD value generated through trading fees on Aerodrome’s AMM |
| ez_metrics | fee_sharing_token_fee_allocation | 100% of trading fees are directed to veAERO voters for fee sharing |
Token Economics and Supply
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | gross_emissions | The amount of USD value emitted in AERO tokens |
| ez_metrics | gross_emissions_native | The amount of native AERO tokens emitted |
| ez_metrics | circulating_supply_native | The circulating supply of AERO tokens in native units |
| ez_metrics | net_supply_change_native | The net change in the circulating supply of AERO tokens |
| ez_metrics | premine_unlocks_native | The amount of native AERO tokens unlocked from premine |
| ez_metrics | locked_supply | The amount of AERO tokens locked in veAERO |
| ez_metrics | total_supply | The total supply of AERO tokens |
Buyback Mechanics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | buybacks | The amount of tokens actually bought back by the protocol (USD) |
| ez_metrics | buybacks_native | The amount of tokens actually bought back by the protocol (native AERO) |
Liquidity and Protocol Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | tvl | The total value locked in Aerodrome protocols |
| ez_metrics | total_pools | The cumulative number of liquidity pools |
| ez_metrics | token_incentives | USD value of token incentives distributed |
Market and Token Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | price | The price of AERO token in USD |
| ez_metrics | market_cap | The market cap of AERO token in USD |
| ez_metrics | fdmc | The fully diluted market cap of AERO token in USD |
| ez_metrics | token_volume | The trading volume of AERO token in USD |
| ez_metrics | token_turnover_circulating | The turnover of AERO token based on circulating supply |
| ez_metrics | token_turnover_fdv | The turnover of AERO token based on fully diluted supply |
Chain-Specific Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics_by_chain | chain | The blockchain (currently ‘base’) |
| ez_metrics_by_chain | spot_dau | Daily active traders on the specific chain |
| ez_metrics_by_chain | spot_txns | Daily trades on the specific chain |
| ez_metrics_by_chain | spot_volume | Trading volume on the specific chain |
| ez_metrics_by_chain | spot_fees | Trading fees on the specific chain |
| ez_metrics_by_chain | fees | Revenue generated on the specific chain |
| ez_metrics_by_chain | fee_sharing_token_fee_allocation | Fee sharing to veAERO holders on the specific chain |
| ez_metrics_by_chain | tvl | Total value locked on the specific chain |
| ez_metrics_by_chain | token_incentives | Token incentives on the specific chain |
Sample Queries
Basic DEX Activity Query
-- Pull fundamental DEX activity data for Aerodrome
SELECT
date,
spot_dau,
spot_txns,
spot_volume,
spot_fees,
fees,
tvl,
price
FROM
art_share.aerodrome.ez_metrics
WHERE
date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
date ASC
Fee Sharing Analysis
-- Analyze Aerodrome's fee sharing mechanism to veAERO holders
SELECT
date,
fees,
fee_sharing_token_fee_allocation,
spot_volume,
locked_supply,
fee_sharing_token_fee_allocation / NULLIF(fees, 0) * 100 as fee_sharing_percentage,
fee_sharing_token_fee_allocation / NULLIF(locked_supply, 0) as fees_per_locked_aero,
spot_fees / NULLIF(spot_volume, 0) * 100 as trading_fee_rate
FROM
art_share.aerodrome.ez_metrics
WHERE
date >= DATEADD(month, -3, CURRENT_DATE())
AND fees > 0
ORDER BY
date ASC
Token Economics Analysis
-- Analyze AERO token supply mechanics and emissions
SELECT
date,
circulating_supply_native,
locked_supply,
total_supply,
gross_emissions_native,
net_supply_change_native,
premine_unlocks_native,
buybacks_native,
locked_supply / NULLIF(total_supply, 0) * 100 as lock_percentage,
gross_emissions_native - buybacks_native as net_emissions_after_buybacks,
price
FROM
art_share.aerodrome.ez_metrics
WHERE
date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
date ASC
DEX Performance and Efficiency
-- Analyze DEX performance and trading efficiency
SELECT
date,
spot_dau,
spot_txns,
spot_volume,
spot_fees,
tvl,
total_pools,
spot_volume / NULLIF(spot_dau, 0) as avg_volume_per_trader,
spot_txns / NULLIF(spot_dau, 0) as avg_txns_per_trader,
spot_volume / NULLIF(tvl, 0) as volume_to_tvl_ratio,
spot_volume / NULLIF(total_pools, 0) as avg_volume_per_pool
FROM
art_share.aerodrome.ez_metrics
WHERE
date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
date ASC
Market Performance vs Protocol Activity
-- Analyze AERO token market performance vs protocol metrics
SELECT
date,
price,
market_cap,
token_volume,
spot_volume,
fees,
locked_supply,
token_volume / NULLIF(spot_volume, 0) * 100 as token_vs_dex_volume_ratio,
market_cap / NULLIF(fees, 0) as mcap_to_revenue_ratio,
fees / NULLIF(locked_supply * price, 0) * 365 * 100 as annualized_yield_on_locked
FROM
art_share.aerodrome.ez_metrics
WHERE
date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
date ASC
Liquidity and Pool Growth
-- Track liquidity provision and pool ecosystem growth
SELECT
date,
tvl,
total_pools,
spot_volume,
token_incentives,
LAG(total_pools, 1) OVER (ORDER BY date) as prev_total_pools,
total_pools - LAG(total_pools, 1) OVER (ORDER BY date) as new_pools_daily,
tvl / NULLIF(total_pools, 0) as avg_tvl_per_pool,
spot_volume / NULLIF(tvl, 0) * 100 as daily_volume_to_tvl_percentage
FROM
art_share.aerodrome.ez_metrics
WHERE
date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
date ASC
Buyback Impact Analysis
-- Analyze the impact of protocol buybacks on token supply
SELECT
date,
buybacks,
buybacks_native,
gross_emissions_native,
net_supply_change_native,
fees,
price,
buybacks / NULLIF(fees, 0) * 100 as buyback_percentage_of_revenue,
buybacks_native / NULLIF(gross_emissions_native, 0) * 100 as buyback_vs_emissions_percentage,
-- Cumulative impact
SUM(buybacks_native) OVER (ORDER BY date) as cumulative_buybacks_native,
SUM(gross_emissions_native) OVER (ORDER BY date) as cumulative_emissions_native
FROM
art_share.aerodrome.ez_metrics
WHERE
date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
date ASC
veAERO Locking Analysis
-- Analyze veAERO locking behavior and incentives
SELECT
date,
locked_supply,
circulating_supply_native,
fee_sharing_token_fee_allocation,
token_incentives,
price,
locked_supply / NULLIF(circulating_supply_native, 0) * 100 as lock_rate_percentage,
(fee_sharing_token_fee_allocation + token_incentives) / NULLIF(locked_supply, 0) as daily_yield_per_locked_aero,
(fee_sharing_token_fee_allocation + token_incentives) / NULLIF(locked_supply * price, 0) * 365 * 100 as annualized_apy
FROM
art_share.aerodrome.ez_metrics
WHERE
date >= DATEADD(month, -1, CURRENT_DATE())
AND locked_supply > 0
ORDER BY
date ASC
Protocol Growth Metrics
-- Track overall protocol growth and adoption
SELECT
date,
spot_dau,
spot_volume,
tvl,
fees,
total_pools,
LAG(spot_dau, 7) OVER (ORDER BY date) as dau_7d_ago,
LAG(tvl, 7) OVER (ORDER BY date) as tvl_7d_ago,
LAG(fees, 7) OVER (ORDER BY date) as revenue_7d_ago,
(spot_dau - LAG(spot_dau, 7) OVER (ORDER BY date)) / NULLIF(LAG(spot_dau, 7) OVER (ORDER BY date), 0) * 100 as dau_growth_7d,
(tvl - LAG(tvl, 7) OVER (ORDER BY date)) / NULLIF(LAG(tvl, 7) OVER (ORDER BY date), 0) * 100 as tvl_growth_7d,
(fees - LAG(fees, 7) OVER (ORDER BY date)) / NULLIF(LAG(fees, 7) OVER (ORDER BY date), 0) * 100 as revenue_growth_7d
FROM
art_share.aerodrome.ez_metrics
WHERE
date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
date ASC
Chain Activity Breakdown
-- Analyze activity by chain (currently Base-focused)
SELECT
date,
chain,
spot_dau,
spot_volume,
spot_fees,
tvl,
fees,
fee_sharing_token_fee_allocation,
token_incentives
FROM
art_share.aerodrome.ez_metrics_by_chain
WHERE
date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
date DESC, spot_volume DESC