Documentation Index
Fetch the complete documentation index at: /docs/llms.txt
Use this file to discover all available pages before exploring further.
Arc trading pools and their daily volume.
dimensions.dex_pools: one row per pool.metrics_dex_pools: trading_volume_daily, one row per pool per day.metrics_dex_pools_by_pair: one row per pool and traded token pair per day, in trading_volume_daily.timestamp and filter chain_id in every query; without them the query reads the whole table.with top_pools as (
select
dex_pool_id,
trading_volume
from `metrics_dex_pools.trading_volume_daily`
where timestamp >= timestamp('2026-10-14')
and timestamp < timestamp('2026-10-15')
and chain_id = 'arc'
order by trading_volume desc
limit 20
)
select
pools.pool_display_name,
top_pools.trading_volume
from top_pools
join `dimensions.dex_pools` as pools
using (dex_pool_id)
order by top_pools.trading_volume desc
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_pools_by_pair.trading_volume_daily`
where timestamp >= timestamp('2026-10-12')
and timestamp < timestamp('2026-10-19')
and chain_id = 'arc'
group by dex_pair_id
order by trading_volume desc
limit 20