ERC1155 Balances EOD

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

Table Columns

Column Name	Data Type	Description
address	VARCHAR	The wallet address holding the tokens
token_address	VARCHAR	Contract address of the ERC1155 token
token_id	VARCHAR	Token ID of the ERC1155 token
block_date	TIMESTAMP_NTZ(9)	The UTC date (end of day) this balance snapshot covers
balance	VARCHAR	Token balance as of the end of the day, as a string to retain precision
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
transaction_hash	VARCHAR	Transaction hash of the last balance-changing activity on this date
_short_token_address	VARCHAR	Truncated form of token_address used as a clustering key for query pruning

Overview ERC1155 Balances EOD Delta

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns