Balances

Stablecoin holder balances at any past date: who holds it, how much, and how concentrated. Two functions compute them at query time; pass a deployment’s chain_id and token_address from Registry. Every signature is documented at Tokens ▸ Balances.

Sample queries

Current holders
Concentration on a date

List the current holders of one stablecoin. Addresses are lowercased on input, so a checksummed address copied from an explorer resolves. Balances arrive in whole token units. For a daily supply series, read the metrics page instead.

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

Measure holder concentration on a past date. 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

Core entities

Market verticals

Chain verticals

Sample queries

​Sample queries

Sample queries