Balances Daily - Allium Documentation Hub

stablecoins.core.balances_daily contains one row per (chain, address, token_address, date) capturing each address’s closing stablecoin balance for that day. Use it for holder segmentation, treasury monitoring, and time-series analysis of who holds what across chains.

Sample Query

Top 20 USDC holders on Ethereum by balance as of yesterday

select
    address,
    token_symbol,
    balance,
    usd_balance
from stablecoins.core.balances_daily
where chain = 'ethereum'
    and token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
    and date = current_date - 1
order by usd_balance desc
limit 20

Table Columns

Unique Key: date, chain, address, token_address

Column Name	Data Type	Description
chain	VARCHAR	Blockchain of the balance
date	DATE	The UTC date this daily balance snapshot covers
address	VARCHAR	The wallet address holding the stablecoin
token_address	VARCHAR	Contract address of the stablecoin token
currency	VARCHAR	The reference currency the stablecoin is pegged to (e.g. usd, eur)
token_name	VARCHAR	Name of the stablecoin
token_symbol	VARCHAR	Symbol of the stablecoin
raw_balance_str	VARCHAR	Balance, unnormalized, as string to retain precision
balance_str	VARCHAR	Balance, normalized, as string to retain precision
balance	FLOAT	Balance, normalized by token decimals
usd_balance	FLOAT	Balance in USD
usd_exchange_rate	FLOAT	Exchange rate used for USD conversion
price_source	VARCHAR	Source used to determine the USD price (e.g. coingecko, peg)
last_activity_block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the most recent balance-changing activity
last_activity_block_number	BIGINT	Block number of the most recent balance-changing activity
unique_id	VARCHAR	Unique identifier for the (date, chain, address, token) row
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the row was first created
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the row was last updated

​Sample Query

​Table Columns

Sample Query

Table Columns