Balances

One row per holder of one stablecoin deployment, computed at query time from the transfer history by functions.calculate_latest_token_balances and functions.calculate_historical_eod_token_balances. balance is the holder’s amount in whole token units, and each call takes a chain, a token address and a token standard from Registry. Coming: a curated pair for stablecoins. functions.calculate_latest_asset_token_balances and functions.calculate_historical_eod_asset_token_balances cover the tokenized asset registry, which every stablecoin here belongs to. They refuse rather than returning a number where a deployment cannot be modelled, so a figure they give back is one that has been checked. In progress: under test, not yet served. The generic pair above also accepts these tokens, and will answer for a rebasing stablecoin with a number that drifts below the chain. Both signatures are identical and documented at Tokens ▸ Balances. What the curated pair covers, and which stablecoins it declines, is at Assets ▸ Balance changes.

Columns

Column	Type	Description
`balance_date`	`DATE`	Day the balance moved. Returned by `calculate_historical_eod_token_balances`, which writes a row per day an account’s balance changed.
`account_address`	`STRING`	Account holding the balance. On Solana this is the token account; `dimensions.accounts` resolves the wallet behind it.
`balance`	`BIGNUMERIC`	End-of-day balance in whole token units, already scaled down by `decimals`. `calculate_latest_token_balances` returns the last one per account, positive balances only.

Sample queries

Current holders
Concentration on a date

Each call adds up the whole balance-change history of one deployment; a daily holder count is cheaper read from metrics_assets.holders_native_daily on Metrics. Addresses are lowercased on input, so a checksummed address pasted from an explorer resolves.

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

The historical function writes a row only on a day the balance moved. An account’s balance on a given date is its most recent row at or before that date.

with balances_on_date as (
    select
        account_address,
        balance,
        row_number() over (partition by account_address order by balance_date desc) as recency
    from `functions.calculate_historical_eod_token_balances`(
        'ethereum',
        '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',
        'erc20'
    )
    where balance_date <= date '2026-06-30'
),

holders as (
    select
        balance,
        rank() over (order by balance desc) as balance_rank
    from balances_on_date
    where recency = 1
      and balance > 0
)

select
    count(*) as holders,
    sum(balance) as supply,
    sum(case when balance_rank <= 10 then balance end) / sum(balance) as top_10_share
from holders

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Columns

Sample queries

​Columns

​Sample queries

Columns

Sample queries