ERC1155 Balances EOD Delta - Allium Documentation Hub

The ERC1155 Balances EOD Delta table records the net end-of-day change in ERC1155 balance for each (address, token, token_id) pair on days where a balance-changing event occurred. It is an intermediate, “unhydrated” table feeding the end-of-day balance snapshots. 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 change covers
_short_token_address	VARCHAR	Truncated form of token_address used as a clustering key for query pruning
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
balance_delta	VARCHAR	Net change in token balance on this date versus the prior end-of-day snapshot

ERC1155 Balances EOD ERC721 Balances EOD

⌘I

​Table Columns

Table Columns