Metrics

Trading volume, TVL, fees and revenue, in USD. One row per thing per day, at four grains: project, app, pool and pair.

Tables

Daily pool trading volume and position principal, uncollected fees and TVL cover closed UTC days and follow the availability cutoff of each pool’s chain.

A tab per grain. Coverage shows which apps report which measure.

Project
App
Pool
Pair

One row per project per day.

Table	Value column	What it holds
`metrics_projects.trading_volume_daily`	`trading_volume`	Total value of trades executed.
`metrics_projects.tvl_daily`	`tvl`	Total value locked.
`metrics_projects.fees_daily`	`fees`	Total fees paid by users.
`metrics_projects.fees_supply_side_daily`	`fees_supply_side`	Fees paid out to the supply side.
`metrics_projects.revenue_daily`	`revenue`	Fees retained by the protocol.

One row per app per day.

Table	Value column	What it holds
`metrics_apps.trading_volume_daily`	`trading_volume`	Value of trades executed by the app, measured on the quote leg at execution price.
`metrics_apps.tvl_daily`	`tvl`	Total value locked across the app’s lending markets and vaults.
`metrics_apps.fees_daily`	`fees`	Fees paid by users of the app across every chain it runs on.
`metrics_apps.fees_supply_side_daily`	`fees_supply_side`	Fees the app passed through to builders and, on HIP-3 markets, to market deployers.
`metrics_apps.revenue_daily`	`revenue`	Fees the app retained across every chain it runs on.

One row per pool per day. The volume table names the app in app_id; the others use the older protocol_id, which holds the same values.

Table	Value column	What it holds
`metrics_dex_pools.trading_volume_daily`	`trading_volume`	Total value of trades executed through the DEX pool.
`metrics_dex_pools.tvl_daily`	`tvl`	USD value of assets held in the DEX pool.
`metrics_dex_pools.fees_daily`	`fees`	Fees paid by users of the DEX pool.
`metrics_dex_pools.flash_loan_volume_daily`	`flash_loan_volume`	Total value of flash loans executed through the DEX pool.

One row per pool and token pair per day.

Table	Value column	What it holds
`metrics_dex_pool_pairs.trading_volume_daily`	`trading_volume`	Total value of trades executed through the DEX pool.

Sample queries

Each measure is its own table, so a row with all three is a join on dex_pool_id and timestamp, bounded on every side. Join with full join: a pool can hold liquidity on a day nothing traded.

with volume as (
    select timestamp, trading_volume
    from `metrics_dex_pools.trading_volume_daily`
    where dex_pool_id = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640-ethereum'
      and timestamp >= timestamp('2026-06-01')
),

tvl as (
    select timestamp, tvl
    from `metrics_dex_pools.tvl_daily`
    where dex_pool_id = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640-ethereum'
      and timestamp >= timestamp('2026-06-01')
),

fees as (
    select timestamp, fees
    from `metrics_dex_pools.fees_daily`
    where dex_pool_id = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640-ethereum'
      and timestamp >= timestamp('2026-06-01')
)

select
    timestamp,
    volume.trading_volume,
    tvl.tvl,
    fees.fees
from volume
full join tvl
    using (timestamp)
full join fees
    using (timestamp)
order by timestamp

One day of pool volume across the catalog, ranked. dex_pool_id joins dimensions.dex_pools for the pool’s tokens and its fee tier.

select
    dex_pool_id,
    app_id,
    chain_id,
    trading_volume
from `metrics_dex_pools.trading_volume_daily`
where timestamp = timestamp('2026-08-01')
order by trading_volume desc
limit 25

The same pair can trade in many pools, and it has the same dex_pair_id in all of them, so a total across pools is a group by on that column.

select
    timestamp,
    sum(trading_volume) as trading_volume
from `metrics_dex_pool_pairs.trading_volume_daily`
where dex_pair_id = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48-0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2-ethereum'
  and timestamp >= timestamp('2026-08-01')
group by timestamp
order by timestamp

A pool’s pair rows add back up to its row on the pool table. A breakdown by single token would not: every swap involves two tokens, so counting it under each one counts it twice and the total stops matching the pool.

select
    dex_pair_id,
    sum(trading_volume) as trading_volume
from `metrics_dex_pool_pairs.trading_volume_daily`
where dex_pool_id = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640-ethereum'
  and timestamp >= timestamp('2026-08-01')
  and timestamp < timestamp('2026-08-08')
group by dex_pair_id
order by trading_volume desc

A sector total is a grouping over the pool volume table joined to dimensions.projects, by day. Group by primary_market_sector, where every project appears exactly once.

select
    daily.timestamp,
    sum(daily.trading_volume) as sector_volume
from `metrics_dex_pools.trading_volume_daily` as daily
join `dimensions.projects` as projects
    on projects.project_id = daily.project_id
where 'exchange' in unnest(projects.market_sectors)
  and daily.timestamp >= timestamp('2026-08-01')
group by daily.timestamp
order by daily.timestamp

The pool row is the sum of its pair rows. On any day the pool traded, the two sides agree exactly.

with pairs as (
    select
        dex_pool_id,
        timestamp,
        sum(trading_volume) as summed
    from `metrics_dex_pool_pairs.trading_volume_daily`
    where dex_pool_id = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640-ethereum'
      and timestamp >= timestamp('2026-08-01')
    group by dex_pool_id, timestamp
),

pools as (
    select
        dex_pool_id,
        timestamp,
        trading_volume
    from `metrics_dex_pools.trading_volume_daily`
    where dex_pool_id = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640-ethereum'
      and timestamp >= timestamp('2026-08-01')
)

select
    timestamp,
    pools.trading_volume as pool_grain,
    pairs.summed as pair_grain
from pools
join pairs
    using (dex_pool_id, timestamp)
order by timestamp

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries