Balances - Allium Documentation Hub

Point-in-time snapshots of token balances for every address. Each row represents a balance snapshot at a specific block, capturing the raw token balance held by an address.

Table Columns

Unique Key: block_number, address, token_address

Column Name	Data Type	Description
address	VARCHAR	The wallet or contract address holding the token balance.
token_address	VARCHAR	The contract address of the token, or the native token sentinel address.
raw_balance	VARCHAR	The unnormalized token balance at this block, stored as a string to preserve precision.
block_number	NUMBER(38,0)	The block number at which this balance snapshot was recorded.
block_timestamp	TIMESTAMP_NTZ(9)	The timestamp of the block at which this balance snapshot was recorded.
block_hash	VARCHAR	The hash of the block at which this balance snapshot was recorded.
is_balance_change	BOOLEAN	Whether this snapshot was triggered by a balance-changing event in this block.
_metadata	VARIANT	Internal metadata from the balance ingestion pipeline.
_error	VARIANT	Error information if the balance fetch encountered an issue.
_source	VARCHAR	The data source or ingestion pipeline that produced this record.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.

Overview Token Supply

⌘I