> ## Documentation Index
> Fetch the complete documentation index at: https://artemis.ai/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# 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 | 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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
```