Fungible Balances EOD

The Fungible Balances EOD table holds the raw end-of-day fungible token balance for each (address, token) pair. It is an intermediate, “unhydrated” table: balances are unnormalized and token metadata and USD values are added downstream. Columns prefixed with _ are internal helpers used for clustering, query pruning, and error tracking.

Table Columns

Column Name	Data Type	Description
address	VARCHAR	The wallet address holding the tokens
token_address	VARCHAR	Contract address of the token (or sentinel address for the native token)
raw_balance_str	VARCHAR	Token balance, unnormalized, as a string to retain precision
block_date	TIMESTAMP_NTZ(9)	The UTC date (end of day) this balance snapshot covers
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the last balance-changing activity on this date
block_number	NUMBER	Block number of the last balance-changing activity on this date
block_hash	VARCHAR	Block hash of the last balance-changing activity on this date
_has_error	NUMBER	Flag indicating whether an error occurred computing this balance (1 = error)
_short_address	VARCHAR	Truncated form of address used as a clustering key for query pruning
_short_token_address	VARCHAR	Truncated form of token_address used as a clustering key for query pruning

ERC721 Balances EOD Overview

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns