Trades - Token Terminal Docs

One row per swap, in the pool’s own token amounts. amount_in and amount_out are the two legs, and deduplicating a router’s fills on transaction_hash turns venue volume into interface volume.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Time of the block containing the swap. Partition column.
`transaction_hash`	`STRING`	Hash of the transaction containing the swap. Several rows share a hash when a router splits one swap across pools.
`log_index`	`INT64`	Position of the swap event in the block. `(chain_id, transaction_hash, log_index)` identifies a row.
`dex_pool_id`	`STRING`	Pool the swap executed in, keyed like `dimensions.dex_pools`.
`app_id`	`STRING`	The app operating the pool, read from the pool registry.
`chain_id`	`STRING`	Chain the swap executed on.
`project_id`	`STRING`	Project the operating app belongs to.
`token_in_id`	`STRING`	Token the trader handed to the pool, keyed like `dimensions.tokens`.
`token_out_id`	`STRING`	Token the trader received from the pool.
`fee_rate`	`BIGNUMERIC`	Fee charged on this swap, as a decimal fraction of its size. Fixed per pool on most venues, set per swap where the venue supports dynamic fees. Null where the venue publishes no per-swap rate the catalog decodes (Aerodrome, Velodrome).
`amount_in`	`BIGNUMERIC`	Amount of `token_in_id` handed over, in whole token units, always positive.
`amount_out`	`BIGNUMERIC`	Amount of `token_out_id` received, in whole token units, always positive.

Sample queries

This table is large and split by day. Bound block_timestamp and filter chain_id on every query, or you read the whole table and the whole table is billed to you.

One day, one pool
Venue vs interface volume

The pool here is the Uniswap v3 USDC-WETH 0.05% pool on Ethereum; find any pool’s id in dimensions.dex_pools.

select
    trades.block_timestamp,
    trades.transaction_hash,
    trades.token_in_id,
    trades.amount_in,
    trades.token_out_id,
    trades.amount_out,
    trades.fee_rate
from `facts_dex_pools.trades` as trades
where trades.dex_pool_id = '0x88e6a0c2ddd26feeb64f039a2c41296fca843a45-ethereum'
  and trades.chain_id = 'ethereum'
  and trades.block_timestamp >= timestamp('2026-08-20')
  and trades.block_timestamp < timestamp('2026-08-21')
order by trades.amount_in desc
limit 100

The venue lens sums every fill; the interface lens counts each transaction once, taking its largest fill as the user’s swap, so router-split swaps stop double counting.

with fills as (
    select
        trades.transaction_hash,
        trades.amount_in
    from `facts_dex_pools.trades` as trades
    where trades.token_in_id = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48-ethereum'
      and trades.chain_id = 'ethereum'
      and trades.block_timestamp >= timestamp('2026-08-20')
      and trades.block_timestamp < timestamp('2026-08-21')
),

per_transaction as (
    select max(amount_in) as swap_amount
    from fills
    group by transaction_hash
)

select
    (select sum(amount_in) from fills) as venue_volume,
    (select sum(swap_amount) from per_transaction) as interface_volume