This schema contains comprehensive datasets for tracking Aerodrome fundamental data across multiple metrics categories, including DEX trading activity, liquidity provision, token emissions, fee sharing mechanisms, and market data for the leading DEX on Base.

​
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 NameColumn NameDescription
ez_metricsspot_dauThe number of daily active traders on Aerodrome V1 and Slipstream
ez_metricsspot_txnsThe number of daily trades on Aerodrome V1 and Slipstream
ez_metricsspot_volumeThe total trading volume on Aerodrome V1 and Slipstream
ez_metricsspot_feesThe total amount of fees (in USD) on Aerodrome V1 and Slipstream
ez_metricsunique_tradersSame as spot_dau (legacy naming)
ez_metricsnumber_of_swapsSame as spot_txns (legacy naming)
ez_metricstrading_volumeSame as spot_volume (legacy naming)
ez_metricstrading_feesSame as spot_fees (legacy naming)

​
Revenue and Fee Distribution

Table NameColumn NameDescription
ez_metricsfeesThe total USD value generated through trading fees on Aerodrome’s AMM
ez_metricsfee_sharing_token_fee_allocation100% of trading fees are directed to veAERO voters for fee sharing

​
Token Economics and Supply

Table NameColumn NameDescription
ez_metricsgross_emissionsThe amount of USD value emitted in AERO tokens
ez_metricsgross_emissions_nativeThe amount of native AERO tokens emitted
ez_metricscirculating_supply_nativeThe circulating supply of AERO tokens in native units
ez_metricsnet_supply_change_nativeThe net change in the circulating supply of AERO tokens
ez_metricspremine_unlocks_nativeThe amount of native AERO tokens unlocked from premine
ez_metricslocked_supplyThe amount of AERO tokens locked in veAERO
ez_metricstotal_supplyThe total supply of AERO tokens

​
Buyback Mechanics

Table NameColumn NameDescription
ez_metricsbuybacksThe amount of tokens actually bought back by the protocol (USD)
ez_metricsbuybacks_nativeThe amount of tokens actually bought back by the protocol (native AERO)

​
Liquidity and Protocol Metrics

Table NameColumn NameDescription
ez_metricstvlThe total value locked in Aerodrome protocols
ez_metricstotal_poolsThe cumulative number of liquidity pools
ez_metricstoken_incentivesUSD value of token incentives distributed

​
Market and Token Metrics

Table NameColumn NameDescription
ez_metricspriceThe price of AERO token in USD
ez_metricsmarket_capThe market cap of AERO token in USD
ez_metricsfdmcThe fully diluted market cap of AERO token in USD
ez_metricstoken_volumeThe trading volume of AERO token in USD
ez_metricstoken_turnover_circulatingThe turnover of AERO token based on circulating supply
ez_metricstoken_turnover_fdvThe turnover of AERO token based on fully diluted supply

​
Chain-Specific Metrics

Table NameColumn NameDescription
ez_metrics_by_chainchainThe blockchain (currently ‘base’)
ez_metrics_by_chainspot_dauDaily active traders on the specific chain
ez_metrics_by_chainspot_txnsDaily trades on the specific chain
ez_metrics_by_chainspot_volumeTrading volume on the specific chain
ez_metrics_by_chainspot_feesTrading fees on the specific chain
ez_metrics_by_chainfeesRevenue generated on the specific chain
ez_metrics_by_chainfee_sharing_token_fee_allocationFee sharing to veAERO holders on the specific chain
ez_metrics_by_chaintvlTotal value locked on the specific chain
ez_metrics_by_chaintoken_incentivesToken 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