Balances Daily

The stablecoins.core.balances_daily table gives a daily forward-filled balance snapshot for every address holding a tracked stablecoin, across EVM-compatible chains, Tron, and Solana. This table is new — there is no legacy crosschain.stablecoin.* equivalent. On EVM-compatible chains and Tron, the grain is (date, address, token_address) and token_account is null. On Solana, the grain is (date, address, token_account, mint) — token_account is the SPL token account holding the balance, and mint is normalized into token_address. Unique Key: chain, date, address, token_address (EVM/Tron); chain, date, address, token_account (Solana)

Sample Query

Get the top 20 USDC holders on Ethereum as of the most recent balance date

select
    address,
    balance,
    usd_balance,
    last_activity_block_timestamp
from stablecoins.core.balances_daily
where 1=1
    and chain = 'ethereum'
    and token_symbol = 'USDC'
    and date = (select max(date) from stablecoins.core.balances_daily where chain = 'ethereum')
order by balance desc
limit 20

Table Columns

Column Name	Description
chain	Blockchain network of the balance.
date	Date of the balance snapshot (forward-filled from the last on-chain activity).
address	Holder address. Not the token account for Solana — see `token_account`.
token_account	The SPL token account holding the balance, for Solana only. Null on EVM chains and Tron.
product_id	Internal Allium identifier for the stablecoin product. Groups together the canonical and bridged variants of the same stablecoin on the same chain. Join key to `stablecoins.registry.catalog`.
token_address	Contract address of the stablecoin on EVM chains/Tron, or the normalized mint address on Solana.
currency	Fiat or reference currency this stablecoin is pegged to, lowercase ISO code.
token_name	Name of the token.
token_symbol	Symbol of the token.
raw_balance_str	Balance (unnormalized), as a string to preserve full precision.
balance_str	Balance, normalized, as a string to preserve full precision.
balance	Balance, normalized.
usd_balance	USD value of the balance.
holder_rank	Rank of this holder by `balance`, among all holders of the same `token_address` on the same `date` (1 = largest balance).
usd_exchange_rate	USD exchange rate applied to compute `usd_balance`.
price_source	Source used to obtain the price applied to this balance (e.g. market-aggregated).
is_circulating	False when this address is classified as an issuer-basis non-circulating holder (treasury, pre-mint, issuer-reserve); true otherwise.
last_activity_block_timestamp	Timestamp of the last on-chain activity that changed this balance.
last_activity_block_number	Block number (or Solana slot) of the last on-chain activity that changed this balance.
unique_id	Unique identifier for the row.
_created_at	Timestamp this row was first created.
_updated_at	Timestamp this row was last updated.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

Sample Query

Table Columns

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

​Sample Query

​Table Columns

Sample Query

Table Columns