Tokens

Four surfaces cover token activity on Ethereum.

facts_tokens.transfers: one row per token transfer.
functions.calculate_latest_token_balances and its historical sibling: holder balances at any date, computed at query time.
metrics_tokens.price_daily: one USD price per token per day.

The token list is everything we see onchain, which reaches far past the tokens anyone would want: a ranking of the busiest tokens returns contracts whose symbols imitate well-known ones. Nothing has gone wrong when those appear. Joining dimensions.asset_tokens keeps the tokens tied to a named asset with a named issuer; Assets covers that layer. Every column and both function signatures are documented at Tokens.

Sample queries

facts_tokens.transfers is large and split by month. Bound partition_key and filter chain_id on every query, or you read the whole table and the whole table is billed to you.

Count the transfers and the accounts behind them on one day. A distinct-account count holds for the window it was asked for, and summing several days counts anyone active on more than one of them twice; Assets ▸ Senders covers the longer windows.

select
    count(*) as transfers,
    count(distinct from_address) as senders,
    count(distinct to_address) as recipients
from `facts_tokens.transfers`
where partition_key >= timestamp('2026-08-01')
  and partition_key < timestamp('2026-09-01')
  and block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
  and chain_id = 'ethereum'
  and token_type = 'erc20'

Rank the busiest Ethereum tokens on one day. Joining dimensions.tokens on token_id adds the symbol and name of each contract.

select
    tokens.symbol,
    transfers.token_address,
    count(*) as transfer_count,
    count(distinct transfers.from_address) as senders
from `facts_tokens.transfers` as transfers
join `dimensions.tokens` as tokens
    using (token_id)
where transfers.partition_key >= timestamp('2026-08-01')
  and transfers.partition_key < timestamp('2026-09-01')
  and transfers.block_timestamp >= timestamp('2026-08-20')
  and transfers.block_timestamp < timestamp('2026-08-21')
  and transfers.chain_id = 'ethereum'
group by tokens.symbol, transfers.token_address
order by transfer_count desc
limit 20

Find the accounts that gained and lost the most of one token on one day. Each movement is unnested into its two legs — the sender debited, the receiver credited — and summing them per account nets the day; dividing by 10^decimals converts to token amounts. The token is named by token_address and chain_id, and those two hold the read to one token’s blocks.

select
    leg.account_address,
    sum(leg.balance_change_raw) / pow(10, tokens.decimals) as net_change
from `facts_tokens.transfers` as movements
cross join unnest([
    struct(movements.from_address as account_address,
           -cast(movements.amount_raw as bignumeric) as balance_change_raw),
    struct(movements.to_address as account_address,
            cast(movements.amount_raw as bignumeric) as balance_change_raw)
]) as leg
join `dimensions.tokens` as tokens
    on tokens.token_id = movements.token_id
where movements.partition_key >= timestamp('2026-08-01')
  and movements.partition_key < timestamp('2026-09-01')
  and movements.block_timestamp >= timestamp('2026-08-20')
  and movements.block_timestamp < timestamp('2026-08-21')
  and movements.chain_id = 'ethereum'
  and movements.token_address = '0xdac17f958d2ee523a2206206994597c13d831ec7'
  and leg.account_address is not null
group by leg.account_address, tokens.decimals
order by net_change desc
limit 20

List the largest current holders of one Ethereum token. The returned balance is already converted out of raw units. Each call adds up the token’s whole movement history, so a one-off holder set costs a full scan; Assets ▸ Metrics holds a daily supply and holder-count series for curated assets.

select
    account_address,
    balance
from `functions.calculate_latest_token_balances`(
    'ethereum',
    '0xdac17f958d2ee523a2206206994597c13d831ec7',
    'erc20'
)
order by balance desc
limit 20

Trace one account’s balance in one token over time. The function returns a row only on the days the balance moved; the balance on any other date is the latest row at or before it. The function replays the same history, so it costs a full scan of the token as well.

select
    balance_date,
    balance
from `functions.calculate_historical_eod_token_balances`(
    'ethereum',
    '0xdac17f958d2ee523a2206206994597c13d831ec7',
    'erc20'
)
where account_address = '0x28c6c06298d514db089934071355e5743bf21d60'
order by balance_date desc
limit 20

Read one Ethereum token’s daily price. Each row is the midnight UTC price in USD.

select
    prices.timestamp,
    tokens.symbol,
    prices.price
from `metrics_tokens.price_daily` as prices
join `dimensions.tokens` as tokens
    using (token_id)
where prices.timestamp >= timestamp('2026-08-16')
  and prices.timestamp < timestamp('2026-08-23')
  and prices.token_id = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48-ethereum'
order by prices.timestamp

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Sample queries

​Sample queries

Sample queries