Transfers

Stablecoin transfers are the rows of facts.token_transfers whose token is a stablecoin deployment. Join dimensions.asset_tokens on token_id to keep those rows and name the stablecoin. Every column is documented at Tokens ▸ Transfers.

Sample queries

The transfer 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 stablecoin, one day
Largest native transfers

Read one stablecoin’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.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.block_timestamp >= timestamp('2026-08-01')
  and transfers.block_timestamp < timestamp('2026-08-02')
limit 100

Rank the largest native stablecoin transfers in a window. bridged_status keeps natively issued deployments and drops bridged copies.

select
    assets.symbol,
    transfers.block_timestamp,
    transfers.transaction_hash,
    cast(transfers.value_raw as bignumeric) / pow(10, tokens.decimals) as amount
from `facts.token_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.block_timestamp >= timestamp('2026-08-01')
  and transfers.block_timestamp < timestamp('2026-08-08')
order by amount desc
limit 20

⌘I

Overview

Core entities

Market verticals

Chain verticals

Sample queries

​Sample queries

Sample queries