DEX

A decentralized exchange, or DEX, lets users swap one token for another against a pool: a contract holding a reserve of two tokens that anyone can trade with. Base pools appear in three tables.

dimensions.dex_pools: one row per pool. fee_tier records a pool’s configurable fee level, so it is null on pools whose design fixes the fee.
metrics_dex_pools: one table per measure, one row per pool per day.
metrics_dex_pool_pairs: one row per pool and traded token pair per day, in trading_volume_daily.

Trading volume and fees are flows, so they add up: a week of daily rows sums to the week, and a set of pools sums to the group. Value locked, in metrics_dex_pools.tvl_daily, is a level: the latest row is the answer, and summing it across days gives a meaningless number. Every pool gets a TVL row every day it exists; volume and fee rows land only on the days a pool saw trading. Every column is documented at DEX.

Sample queries

The daily pool tables are among the largest in the catalog. Bound timestamp and filter chain_id in every query; without them the query reads the whole table.

Top pools, one day
Busiest pairs

Rank Base pools by trading volume on one day. Reading the day from the volume table and joining the pool list afterwards keeps the join small.

with top_pools as (
    select
        dex_pool_id,
        trading_volume
    from `metrics_dex_pools.trading_volume_daily`
    where timestamp >= timestamp('2026-08-20')
      and timestamp < timestamp('2026-08-21')
      and chain_id = 'base'
    order by trading_volume desc
    limit 20
)

select
    pools.pool_display_name,
    pools.fee_tier,
    top_pools.trading_volume
from top_pools
join `dimensions.dex_pools` as pools
    using (dex_pool_id)
order by top_pools.trading_volume desc

Find the busiest traded token pairs on Base, and how many pools each one trades in. dex_pair_id joins the two token addresses and the chain in sorted address order, so the same two tokens produce the same identifier whichever way round the trade went.

select
    dex_pair_id,
    count(distinct dex_pool_id) as pools,
    sum(trading_volume) as trading_volume
from `metrics_dex_pool_pairs.trading_volume_daily`
where timestamp >= timestamp('2026-08-16')
  and timestamp < timestamp('2026-08-23')
  and chain_id = 'base'
group by dex_pair_id
order by trading_volume desc
limit 20

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Sample queries

​Sample queries

Sample queries