DEX Trades

Enriched swap events across 8 chains with token symbols, USD amounts, and protocol attribution.

14 tables — one trade table per chain, plus additional Tempo DEX detail tables.

Table	Chain	Notable
`agent.ethereum_dex_trades`	Ethereum	Most DEX diversity
`agent.base_dex_trades`	Base	Aerodrome-heavy
`agent.arbitrum_dex_trades`	Arbitrum	GMX, Camelot
`agent.bsc_dex_trades`	BSC	Largest table (~4B rows), PancakeSwap-dominant
`agent.tron_dex_trades`	Tron	SunSwap-dominant, base58 addresses
`agent.hyperevm_dex_trades`	HyperEVM	Newest chain, thinner coverage
`agent.robinhood_dex_trades`	Robinhood Chain	Extended schema with per-side prices and USD method (see below)
`agent.tempo_dex_swaps`	Tempo	Solver/intent-based swaps, different schema (see below)

Tempo also has raw and aggregated DEX detail tables:

Table	What it is
`agent.tempo_dex_base_trades`	Raw per-event swaps in the standard bought/sold shape (project, taker, amounts, USD)
`agent.tempo_dex_trades_daily`	Daily volume, trade count, and unique traders per token pair (ReplacingMergeTree — use `FINAL`)
`agent.tempo_stablecoindex_swaps`	Individual StablecoinDEX swap events
`agent.tempo_exchange_v2_pairs`	TempoExchange V2 pair-creation registry (ReplacingMergeTree — use `FINAL`)
`agent.tempo_uniswap_v2_pairs`	Uniswap V2 pair-creation registry (ReplacingMergeTree — use `FINAL`)
`agent.tempo_uniswap_v4_pools`	Uniswap V4 pool initializations with fee, tick spacing, hooks (ReplacingMergeTree — use `FINAL`)

Schema (EVM Chains)

The 6 EVM tables share this schema. Minor type differences noted where applicable.

Engine: MergeTree | Partition: toYYYYMM(block_date) | ORDER BY: block_time, tx_hash, evt_index

Column	Type	Description
`blockchain`	String	Chain name
`project`	String	Protocol (lowercase): uniswap, sushiswap, curve, pancakeswap, aerodrome, etc.
`version`	String	Protocol version: '1', '2', '3', 'v3', 'slipstream'
`block_date`	Date	Partition key — always filter on this
`block_time`	DateTime64(3)	UTC timestamp
`block_number`	UInt64
`token_bought_symbol`	Nullable(String)	Token received
`token_sold_symbol`	Nullable(String)	Token sent
`token_pair`	String	Alphabetically sorted pair (e.g., 'ETH-USDC')
`token_bought_amount`	Float64	Human-readable (decimal-adjusted)
`token_sold_amount`	Float64	Human-readable (decimal-adjusted)
`token_bought_amount_raw`	UInt256	Raw pre-decimal amount
`token_sold_amount_raw`	UInt256	Raw pre-decimal amount
`amount_usd`	Nullable(Float64)	One-sided USD value (token_sold). Null for unpriced tokens.
`token_bought_address`	String	Contract address
`token_sold_address`	String	Contract address
`taker`	String	EOA that initiated the swap (not the router)
`maker`	Nullable(String)	Liquidity pool address
`project_contract_address`	String	Pool or router contract
`tx_hash`	String	Transaction hash
`tx_from`	String	Transaction sender
`tx_to`	String	Transaction recipient
`evt_index`	UInt32	Event log index

Good to Know

amount_usd is one-sided (token_sold value). Multiply by 2 for two-sided volume.
taker is the EOA, not the router/aggregator contract.
token_pair is alphabetically sorted — always 'ETH-USDC', never 'USDC-ETH'.
No aggregator attribution — a 1inch-routed swap shows as the underlying DEX.
USD prices from CoinGecko hourly — new/illiquid tokens may have null amount_usd.
Does not include limit orders, RFQ fills, or off-chain matching.

Tempo DEX Swaps Schema

agent.tempo_dex_swaps uses a different schema — Tempo is a stablecoin payment chain with solver/intent-based swaps, not a standard AMM DEX.

Engine: MergeTree | Partition: toYYYYMM(block_date) | ORDER BY: block_date, transaction_hash

Column	Type	Description
`block_date`	Date	Partition key
`block_number`	UInt64
`transaction_index`	UInt32
`transaction_hash`	String
`user_address`	String	Swapper address
`token_in`	String	Input token contract
`token_in_symbol`	String	Input token symbol
`amount_in_usd`	Float64	Input amount in USD
`token_out`	String	Output token contract
`token_out_symbol`	String	Output token symbol
`amount_out_usd`	Float64	Output amount in USD
`reason_hex`	String	Swap reason/memo (hex-encoded)

Robinhood Chain DEX Trades Schema

agent.robinhood_dex_trades has every column of the EVM schema above, plus per-side pricing and provenance columns. Like the other trade tables, it requires a block_date lower bound.

Column	Type	Description
`unique_key`	String	Unique row identifier
`token_bought_decimals` / `token_sold_decimals`	Nullable(Int64)	Token decimals
`token_bought_price_usd` / `token_sold_price_usd`	Nullable(Float64)	Per-token USD price used for valuation
`token_bought_price_source` / `token_sold_price_source`	Nullable(String)	Where each side's price came from
`amount_usd_method`	String	How `amount_usd` was derived — values include `external_sold`, `external_bought`, `dex_sold`, `dex_bought`, `external_both_min`, `dex_both_min`, and `unpriced`
`price_available`	UInt8	1 when `amount_usd` is populated
`taker_source`	String	How `taker` was resolved
`swap_sender`	String	`sender` from the swap event
`registry_source`	String	Source of the pool registry entry

Unlike the other chains, amount_usd is not always the sold side: check amount_usd_method — it can use the bought side, or the smaller of the two sides (*_both_min).
A large share of swaps involve unpriced tokens (amount_usd_method = 'unpriced', amount_usd NULL). Filter on price_available = 1 before summing volume.