DEX pools - Token Terminal Docs

One row per DEX pool on one chain in dimensions.dex_pools, listing every pool ever created. dex_pool_id is the pool address joined with the chain, and it is the key every pool figure joins on.

Coverage

One row per app, and a tick marks every app that reports the measure at this grain. It is the same table as the Pool tab of DEX.

App	Project	Trading volume
`aerodrome-slipstream`	`aerodrome`	✓
`aerodrome-stable`	`aerodrome`	✓
`aerodrome-volatile`	`aerodrome`	✓
`aperture-swap-v1`	`aperture`	✓
`apeswap-dex`	`apeswap`	✓
`blackhole-dex`	`blackhole`	✓
`camelot-dex`	`camelot`	✓
`curve-dex`	`curve`	✓
`dodo-dex`	`dodo`	✓
`equalizer-dex`	`equalizer`	✓
`etherex-dex`	`etherex`	✓
`euler-swap`	`euler`	✓
`fathom-dex`	`fathom`	✓
`honeypop-dex`	`honeypop`	✓
`instadapp-fluid-dex`	`instadapp`	✓
`instadapp-fluid-dex-lite`	`instadapp`	✓
`integral-dex`	`integral`	✓
`maverick-dex`	`maverick`	✓
`meteora-launchpad`	`meteora`	✓
`meteora-liquidity-pools`	`meteora`	✓
`okutrade-dex`	`okutrade`	✓
`orca-token-swap-v2`	`orca`	✓
`orca-whirlpools`	`orca`	✓
`pancakeswap-v2`	`pancakeswap`	✓
`pancakeswap-v3`	`pancakeswap`	✓
`pangolin-dex`	`pangolin`	✓
`pharaoh-dex`	`pharaoh`	✓
`pumpfun-amm`	`pumpfun`	✓
`pumpfun-launchpad`	`pumpfun`	✓
`quickswap-v2`	`quickswap`	✓
`quickswap-v3`	`quickswap`	✓
`ramses-dex`	`ramses`	✓
`raydium-clmm`	`raydium`	✓
`raydium-cpmm`	`raydium`	✓
`raydium-launchlab`	`raydium`	✓
`raydium-openbook`	`raydium`	✓
`raydium-stable-swap`	`raydium`	✓
`shadowexchange-concentrated-liquidity`	`shadowexchange`	✓
`shadowexchange-constant-product`	`shadowexchange`	✓
`shadowexchange-dex`	`shadowexchange`	✓
`solidlizard-dex`	`solidlizard`	✓
`spookyswap-dex`	`spookyswap`	✓
`sushiswap-dex`	`sushiswap`	✓
`thena-dex`	`thena`	✓
`thruster-clamm`	`thruster`	✓
`thruster-classic`	`thruster`	✓
`traderjoe-dex`	`traderjoe`	✓
`uniswap-v2`	`uniswap`	✓
`uniswap-v3`	`uniswap`	✓
`uniswap-v4`	`uniswap`	✓
`velodrome-dex`	`velodrome`	✓
`versedex-dex`	`versedex`	✓
`zkswap-dex`	`zkswap`	✓

Columns

Column	Type	Description
`dex_pool_id`	STRING	Identifier of the pool: the pool address joined with the chain.
`protocol_id`	STRING	The app operating the pool. Older name for `app_id`, and the same values.
`chain_id`	STRING	Chain the pool lives on.
`project_id`	STRING	Project the operating app belongs to.
`pool_address`	STRING	Onchain address of the pool. Where one contract holds every pool, this is the pool’s id inside that contract.
`pool_name`	STRING	The pool’s tokens as a name, for example `USDC-WETH`.
`pool_display_name`	STRING	Pool name with the fee added on, where the pool charges a fixed one.
`fee_tier`	BIGNUMERIC	The fee the pool charges on every swap, as a decimal fraction, so `0.0005` reads 0.05%. Empty where the venue sets the fee swap by swap.
`created_at`	TIMESTAMP	Time of the block the pool was created in.
`hooks_address`	STRING	Address of the pool’s hooks contract, on venues that attach one. A hooks contract is extra code the venue runs around each swap.
`token_ids`	ARRAY<STRING>	The tokens the pool holds, in pool order, as keys of `dimensions.tokens`.

Sample queries

Rank pools by volume
Registry against traded pools

The volume table keys on dex_pool_id, and the registry turns that key into a readable pair and the fee the pool charges. Filter chain_id on both sides so the result stays on one chain.

select
    pools.pool_display_name,
    pools.protocol_id as app_id,
    pools.fee_tier,
    sum(volume.trading_volume) as trading_volume
from `metrics_dex_pools.trading_volume_daily` as volume
join `dimensions.dex_pools` as pools
    using (dex_pool_id)
where volume.chain_id = 'ethereum'
  and pools.chain_id = 'ethereum'
  and volume.timestamp >= timestamp('2026-08-01')
  and volume.timestamp < timestamp('2026-08-08')
group by 1, 2, 3
order by trading_volume desc
limit 20

A pool enters the registry when its factory emits the creation event, so the registry side counts every pool an app has ever created and the traded side counts the ones that saw a swap. protocol_id is the older name for app_id, so alias it to join the two.

with registry as (
    select
        protocol_id as app_id,
        count(*) as pools_in_registry
    from `dimensions.dex_pools`
    where chain_id = 'ethereum'
    group by app_id
),

traded as (
    select
        app_id,
        count(distinct dex_pool_id) as pools_traded
    from `metrics_dex_pools.trading_volume_daily`
    where chain_id = 'ethereum'
      and timestamp >= timestamp('2026-08-01')
      and timestamp < timestamp('2026-08-08')
    group by app_id
)

select
    app_id,
    registry.pools_in_registry,
    traded.pools_traded
from registry
left join traded
    using (app_id)
order by registry.pools_in_registry desc