Transfers

ERC-20 and native token transfers enriched with symbols and USD pricing across 7 chains.

7 tables — one per chain.

Table	Chain	Notable
`agent.ethereum_transfers`	Ethereum	Billions of rows
`agent.base_transfers`	Base	7.5B+ rows
`agent.arbitrum_transfers`	Arbitrum
`agent.bsc_transfers`	BSC	BNB is native token (18 decimals)
`agent.tron_transfers`	Tron	4.6B rows, base58 addresses, USDT-heavy
`agent.robinhood_transfers`	Robinhood Chain	Event-based ERC-20 + NFT transfers, extended schema (see below)
`agent.tempo_transfers`	Tempo	TIP-20 stablecoin transfers, different schema (see below)

Schema

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

Column	Type	Description
`blockchain`	String	Chain name
`block_date`	Date	Always filter on this — tables are billions of rows
`block_time`	DateTime64(3)	UTC timestamp
`block_number`	UInt64
`tx_hash`	String	Transaction hash
`evt_index`	UInt32	Event log index
`trace_address`	Array(Int64)	Non-empty for native transfers, empty for ERC-20
`token_standard`	String	`'erc20'` or `'native'`
`tx_from`	String	Transaction sender (EOA)
`tx_to`	String	Transaction recipient
`tx_index`	UInt32
`from`	String	Transfer sender
`to`	String	Transfer recipient
`contract_address`	String	Token contract. Zero address for native token.
`symbol`	String	Token symbol
`amount_raw`	UInt256	Raw amount — divide by 10^decimals
`amount`	Float64	Decimal-adjusted amount
`price_usd`	Float64	USD price at transfer time
`amount_usd`	Nullable(Float64)	USD value

Good to Know

These are the largest tables in the catalog. Always use tight block_date filters.
token_standard is 'erc20' or 'native' — filter accordingly.
Native transfers come from traces and include internal contract-to-contract transfers.
Does not include ERC-721 (NFT) or ERC-1155 (multi-token) transfers.
For net flows: SUM(amount WHERE to=addr) - SUM(amount WHERE from=addr).

Tempo Transfers Schema

agent.tempo_transfers uses a different schema. Tempo is a stablecoin payment chain — all tokens are USD-pegged, so amounts are pre-computed in USD with no need for price lookups.

Engine: MergeTree | Partition: toYYYYMM(block_date) | ORDER BY: block_date, token_address, transfer_from, block_number, log_index

Column	Type	Description
`block_date`	Date	Partition key
`block_number`	UInt64
`transaction_index`	UInt32
`log_index`	UInt32
`transaction_hash`	String
`transfer_from`	String	Sender address
`transfer_to`	String	Recipient address
`amount_usd`	Float64	Transfer amount in USD (all Tempo tokens are USD stablecoins)
`token_address`	String	TIP-20 token contract
`token_symbol`	String	Token symbol (e.g., pathUSD, USDC)

Robinhood Chain Transfers Schema

agent.robinhood_transfers has every column of the EVM schema above, plus the columns below. It requires a block_date lower bound.

Column	Type	Description
`unique_key`	String	Unique row identifier
`item_index`	UInt32	Item position within a batch transfer event
`from_address` / `to_address`	String	Same values as `from` / `to`
`token_id`	UInt256	NFT token ID
`has_token_id`	Bool	True for ERC-721 / ERC-1155 rows
`token_name`	Nullable(String)	Token name
`decimals`	Nullable(Int64)	Token decimals
`metadata_available`	UInt8	1 when token metadata was resolved
`price_available`	UInt8	1 when `amount_usd` is populated
`price_source`	Nullable(String)	Price source (e.g., `coingecko`, `dex_vwap`)
`amount_usd_semantics`	String	`per_event_valuation_not_volume`
`coverage_semantics`	String	`event_only_no_traces`

token_standard is 'erc20', 'erc721', or 'erc1155' — unlike the other chains, NFT transfers are included. Filter to 'erc20' for fungible flows.
Built from transfer events only (no traces), so native ETH transfers are not included.
amount_usd values each event; summing it is not trading volume. Only part of ERC-20 transfers are priced — filter on price_available = 1.