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. Celo pools appear in three tables.

dimensions.dex_pools: one row per pool.
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.

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 Celo 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 = 'celo'
    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 Celo, 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 = 'celo'
group by dex_pair_id
order by trading_volume desc
limit 20

Notes

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. fee_tier is empty for pools whose design has no configurable fee. A null there records that the pool has no tier to report.

Overview

Core entities

Core datasets

Market verticals

Chain verticals

Sample queries

Notes

​Sample queries

​Notes

Sample queries

Notes