Balances Daily

The Stablecoins Balances Daily table contains one row per (address, stablecoin, date) capturing the address’s closing balance for each day. Use it for holder segmentation, treasury and issuer balance monitoring, and time-series of who is holding what.

Table Columns

Unique Key: date, address, token_address

Column Name	Data Type	Description
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
product_id	VARCHAR	Allium stablecoin product identifier (e.g. usdc, usdt)
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	INTEGER	Block number of the most recent balance-changing activity
unique_id	VARCHAR	Unique identifier for the (date, address, token) row

Overview Supply Change

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns