Transfers - Token Terminal Docs

facts.token_transfers holds one row per fungible token transfer, read from the Transfer logs token contracts emit onchain. token_type names the token standard and chain_id the chain.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Time of the block containing the transfer. Partition column.
`block_number`	`INT64`	Number of the block containing the transfer.
`transaction_hash`	`STRING`	Hash of the transaction that emitted the transfer.
`log_index`	`INT64`	Position of the Transfer log in the block.
`unique_id`	`INT64`	Row key: fingerprint of `chain_id`, `block_number`, `transaction_hash`, `log_index`.
`chain_id`	`STRING`	Chain the transfer happened on.
`token_type`	`STRING`	Token standard, such as `erc20`.
`token_id`	`STRING`	Token transferred: `{token_address}-{chain_id}`.
`token_address`	`STRING`	Contract address of the token.
`from_address`	`STRING`	Account the value left.
`to_address`	`STRING`	Account the value arrived at.
`value_raw`	`STRING`	Raw amount as text; a `uint256` exceeds every BigQuery number type.

Sample queries

The table is partitioned on block_timestamp and holds billions of rows. Bound that column in every query; without a bound the query reads the whole table.

One token, one day
Largest transfers

Read one token’s transfers on a single day. Cast value_raw to BIGNUMERIC and divide by 10^decimals from dimensions.tokens to get the token amount.

select
    transfers.block_timestamp,
    transfers.transaction_hash,
    transfers.from_address,
    transfers.to_address,
    cast(transfers.value_raw as bignumeric) / pow(10, tokens.decimals) as amount
from `facts.token_transfers` as transfers
join `dimensions.tokens` as tokens
    using (token_id)
where transfers.token_id = '0xdac17f958d2ee523a2206206994597c13d831ec7-ethereum'
  and transfers.block_timestamp >= timestamp('2026-08-01')
  and transfers.block_timestamp < timestamp('2026-08-02')
limit 100

Rank the largest transfers of one token in a window.

select
    transfers.block_timestamp,
    transfers.transaction_hash,
    transfers.from_address,
    transfers.to_address,
    cast(transfers.value_raw as bignumeric) / pow(10, tokens.decimals) as amount
from `facts.token_transfers` as transfers
join `dimensions.tokens` as tokens
    using (token_id)
where transfers.token_id = '0xdac17f958d2ee523a2206206994597c13d831ec7-ethereum'
  and transfers.block_timestamp >= timestamp('2026-08-01')
  and transfers.block_timestamp < timestamp('2026-08-08')
order by amount desc
limit 20

⌘I