Trades

In progress. This table is not served yet. The page documents it as it lands.

facts.dex_trades_volume holds one row per swap, in token amounts rather than dollars. Instead of signing the amounts, each row names the token the trader handed over in token_in_id and the token they got back in token_out_id, both amounts positive. Every swap keeps its row: if the pool is missing from the registry, app_id is left empty rather than the swap being dropped. log_index is the swap event’s position within its block on EVM chains; chains that are not EVM put their own event position in the same column.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	The time when the block containing this swap was included.
`transaction_hash`	`STRING`	Hash of the transaction containing the swap.
`log_index`	`INT64`	Position of the swap event within its block.
`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 table. Empty when that table does not carry the pool.
`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.
`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

Put a filter on block_timestamp in every query. The table is partitioned on it, and leaving the filter out reads every day we hold.

One pool, one day
Largest purchases

Read one pool’s swaps on a single day. Amounts are in whole token units, so a dollar value means joining a price yourself.

select
    block_timestamp,
    transaction_hash,
    token_in_id,
    token_out_id,
    amount_in,
    amount_out,
    fee_rate
from `facts.dex_trades_volume`
where dex_pool_id = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640-ethereum'
  and block_timestamp >= timestamp('2026-08-01')
  and block_timestamp < timestamp('2026-08-02')
order by block_timestamp
limit 100

Rank the largest purchases of one token in a window. token_out_id is the token the trader received, keyed like dimensions.tokens.

select
    trades.block_timestamp,
    trades.transaction_hash,
    trades.dex_pool_id,
    trades.app_id,
    trades.amount_out,
    tokens.symbol
from `facts.dex_trades_volume` as trades
join `dimensions.tokens` as tokens
    on tokens.token_id = trades.token_out_id
where trades.token_out_id = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2-ethereum'
  and trades.block_timestamp >= timestamp('2026-08-01')
  and trades.block_timestamp < timestamp('2026-08-08')
order by trades.amount_out desc
limit 20

Notes

fee_rate describes the individual swap. On most venues it is the same as the pool’s fixed fee_tier, so every trade in the pool carries the same value. Where the venue can change its fee, the rate is set swap by swap and two trades in the same pool can differ. This table carries token amounts and no dollar column. The daily tables apply our token prices once, in one place, which is what makes their pool, app and project totals agree with each other. For a dollar figure on an individual swap, join whichever price you trust. Metrics covers daily pool volume, fees and TVL.

Overview

Core entities

Market verticals

Chain verticals

Columns

Sample queries

Notes

​Columns

​Sample queries

​Notes

Columns

Sample queries

Notes