Tokens

In progress. This table is not served yet. The page documents it as it lands.

Four surfaces cover token activity on Arbitrum.

facts.token_transfers: one row per token transfer.
facts.token_balance_changes: one row per account per transfer, so a transfer produces a negative row for the sender and a positive one for the receiver.
The balance functions: holder balances at any date, computed at query time.
metrics.tokens_prices_daily: one USD price per token per day.

Every column and both function signatures are documented at Tokens.

Sample queries

The event tables split by day on block_timestamp and hold billions of rows. Bound that column in every query; without a bound the query reads the whole table.

Count the transfers and the accounts behind them on one day. Counts of distinct accounts across longer windows cannot be added up day by day; Assets ▸ Senders covers the surface built for that question.

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

Rank the busiest Arbitrum 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.token_transfers` as transfers
join `dimensions.tokens` as tokens
    using (token_id)
where transfers.block_timestamp >= timestamp('2026-08-20')
  and transfers.block_timestamp < timestamp('2026-08-21')
  and transfers.chain_id = 'arbitrum'
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. Summing balance_change_raw per account nets the incoming and outgoing legs; dividing by 10^decimals converts to token amounts.

select
    changes.account_address,
    sum(changes.balance_change_raw) / pow(10, tokens.decimals) as net_change
from `facts.token_balance_changes` as changes
join `dimensions.tokens` as tokens
    using (token_id)
where changes.block_timestamp >= timestamp('2026-08-20')
  and changes.block_timestamp < timestamp('2026-08-21')
  and changes.chain_id = 'arbitrum'
  and changes.token_address = '0xaf88d065e77c8cc2239327c5edb3a432268e5831'
group by changes.account_address, tokens.decimals
order by net_change desc
limit 20

List the largest current holders of one Arbitrum token. The returned balance is already converted out of raw units.

select
    account_address,
    balance
from `functions.calculate_latest_token_balances`(
    'arbitrum',
    '0xaf88d065e77c8cc2239327c5edb3a432268e5831',
    '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.

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

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

select
    prices.timestamp,
    tokens.symbol,
    prices.price
from `metrics.tokens_prices_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 = '0xaf88d065e77c8cc2239327c5edb3a432268e5831-arbitrum'
order by prices.timestamp

Notes

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.

Overview

Core entities

Market verticals

Chain verticals

Sample queries

Notes

​Sample queries

​Notes

Sample queries

Notes