Transfers - Token Terminal Docs

One row per stablecoin movement: a transfer, a mint or a burn of one deployment, at the moment it happened onchain. amount_raw is the movement in the token’s smallest unit; divide by 10^decimals from dimensions.tokens for a token amount.

Columns

Column	Type	Description
`partition_key`	`TIMESTAMP`	The month the row belongs to. The table is partitioned on it, so a date filter is cheapest when it names this alongside `block_timestamp`.
`block_timestamp`	`TIMESTAMP`	When the block was produced.
`block_number`	`INT64`	Block height, or the slot on Solana.
`transaction_hash`	`STRING`	Transaction the movement belongs to. Null on `hydradx`, where a transfer can be emitted by a block hook rather than by a transaction.
`transaction_index`	`INT64`	Position of the transaction in its block. Solana only.
`outer_event_index`	`INT64`	Enclosing instruction position on Solana. Null on the log-shaped chains, which have one nesting level, and null on Solana wherever the instruction is top level and has nothing enclosing it.
`event_index`	`INT64`	Position within the transaction: the log index, or the instruction index on Solana.
`chain_id`	`STRING`	Chain the movement happened on.
`token_type`	`STRING`	Token standard: `erc20`, `spl` or `trc20`.
`token_id`	`STRING`	Join key to `dimensions.tokens` and to `dimensions.asset_tokens`, which is what names the stablecoin.
`token_address`	`STRING`	The token. Filter on this. Null on the Solana transfers whose token account the upstream decode could not resolve, which also leaves `token_id` null.
`event_type`	`STRING`	`transfer`, `mint` or `burn`.
`from_address`	`STRING`	Account debited. Null on a mint.
`to_address`	`STRING`	Account credited. Null on a burn.
`to_owner`	`STRING`	Holder behind `to_address`. Solana transfers only: null on exactly the rows where `token_address` is, and always null on mints and burns.
`authority_address`	`STRING`	Account that authorised the instruction. Solana only.
`transaction_signer`	`STRING`	Signer of the enclosing transaction. Solana only.
`executing_account`	`STRING`	Program that executed the instruction. Solana only.
`amount_raw`	`STRING`	Amount in the token’s smallest unit, as a decimal string, because a uint256 exceeds every BigQuery numeric type. Divide by `10^decimals`.
`surrogate_key`	`BYTES`	Row identity, a 128-bit hash of the columns that define the grain. Stable across rebuilds; nothing else needs it.

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 stablecoin, one day
Largest native movements
Issuance in a window

Joining dimensions.asset_tokens on token_id is what keeps the stablecoin rows, and the same join names the asset. The table is clustered on token_address then chain_id, and naming the pair reads less than the address alone.

select
    transfers.block_timestamp,
    transfers.transaction_hash,
    transfers.from_address,
    transfers.to_address,
    cast(transfers.amount_raw as bignumeric) / pow(10, tokens.decimals) as amount
from `facts_tokens.transfers` as transfers
join `dimensions.asset_tokens` as deployments
    using (token_id)
join `dimensions.tokens` as tokens
    on tokens.token_id = transfers.token_id
where deployments.asset_id = 'usdc'
  and transfers.chain_id = 'ethereum'
  and transfers.block_timestamp >= timestamp('2026-08-01')
  and transfers.block_timestamp < timestamp('2026-08-02')
limit 100

bridged_status keeps the natively issued deployments, the side that answers a question about the issuer.

select
    assets.symbol,
    transfers.block_timestamp,
    transfers.transaction_hash,
    cast(transfers.amount_raw as bignumeric) / pow(10, tokens.decimals) as amount
from `facts_tokens.transfers` as transfers
join `dimensions.asset_tokens` as deployments
    using (token_id)
join `dimensions.assets` as assets
    on assets.asset_id = deployments.asset_id
join `dimensions.tokens` as tokens
    on tokens.token_id = transfers.token_id
where assets.asset_type = 'stablecoin'
  and deployments.bridged_status = 'native'
  and transfers.chain_id = 'ethereum'
  and transfers.block_timestamp >= timestamp('2026-08-01')
  and transfers.block_timestamp < timestamp('2026-08-08')
order by amount desc
limit 20

event_type separates the three movements, and a mint leaves from_address empty and a burn to_address. The daily totals behind the same events are mints_total and redemptions_total on Metrics.

select
    transfers.event_type,
    count(*) as movements,
    sum(cast(transfers.amount_raw as bignumeric) / pow(10, tokens.decimals)) as amount
from `facts_tokens.transfers` as transfers
join `dimensions.asset_tokens` as deployments
    using (token_id)
join `dimensions.tokens` as tokens
    on tokens.token_id = transfers.token_id
where deployments.asset_id = 'usdc'
  and transfers.chain_id = 'ethereum'
  and transfers.event_type in ('mint', 'burn')
  and transfers.block_timestamp >= timestamp('2026-08-01')
  and transfers.block_timestamp < timestamp('2026-08-08')
group by transfers.event_type