Aerodrome

Aerodrome Schema Description and Methodology

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 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	ecosystem_revenue	The total USD value generated through trading fees on Aerodrome’s AMM
ez_metrics	fee_sharing_token_cash_flow	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	ecosystem_revenue	Revenue generated on the specific chain
ez_metrics_by_chain	fee_sharing_token_cash_flow	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,
    ecosystem_revenue,
    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,
    ecosystem_revenue,
    fee_sharing_token_cash_flow,
    spot_volume,
    locked_supply,
    fee_sharing_token_cash_flow / NULLIF(ecosystem_revenue, 0) * 100 as fee_sharing_percentage,
    fee_sharing_token_cash_flow / 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 ecosystem_revenue > 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,
    ecosystem_revenue,
    locked_supply,
    token_volume / NULLIF(spot_volume, 0) * 100 as token_vs_dex_volume_ratio,
    market_cap / NULLIF(ecosystem_revenue, 0) as mcap_to_revenue_ratio,
    ecosystem_revenue / 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,
    ecosystem_revenue,
    price,
    buybacks / NULLIF(ecosystem_revenue, 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_cash_flow,
    token_incentives,
    price,
    locked_supply / NULLIF(circulating_supply_native, 0) * 100 as lock_rate_percentage,
    (fee_sharing_token_cash_flow + token_incentives) / NULLIF(locked_supply, 0) as daily_yield_per_locked_aero,
    (fee_sharing_token_cash_flow + 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,
    ecosystem_revenue,
    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(ecosystem_revenue, 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,
    (ecosystem_revenue - LAG(ecosystem_revenue, 7) OVER (ORDER BY date)) / NULLIF(LAG(ecosystem_revenue, 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,
    ecosystem_revenue,
    fee_sharing_token_cash_flow,
    token_incentives
FROM
    art_share.aerodrome.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date DESC, spot_volume DESC