ERC721 Balances EOD

The ERC721 Balances EOD table holds the end-of-day ERC721 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 token
token_address	VARCHAR	Contract address of the ERC721 token
token_id	VARCHAR	Token ID of the ERC721 token
block_date	TIMESTAMP_NTZ(9)	The UTC date (end of day) this balance snapshot covers
balance	NUMBER	Token balance as of the end of the day. For ERC721 tokens, the max is 1
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

ERC1155 Balances EOD Delta Fungible Balances EOD

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns