ERC1155 Balances Daily

The ERC1155 Balances Daily table provides one row per (address, token, token_id, date) capturing the closing ERC1155 balance for each day. Use this table for day-over-day balance analysis and point-in-time holder views. For per-block balance changes, use the erc1155_balances table instead.

Table Columns

Column Name	Data Type	Description
date	TIMESTAMP_NTZ(9)	The UTC date this daily balance snapshot covers
address	VARCHAR	The wallet address holding the tokens
token_address	VARCHAR	Contract address of the ERC1155 token
token_name	VARCHAR	Name of the token
token_symbol	VARCHAR	Symbol of the token
token_id	VARCHAR	Token ID of the ERC1155 token
balance	INTEGER	Token balance, normalized
balance_str	VARCHAR	Token balance, normalized, as a string to retain precision
last_activity_block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the most recent balance-changing activity
last_activity_block_number	INTEGER	Block number of the most recent balance-changing activity
last_activity_block_hash	VARCHAR	Block hash of the most recent balance-changing activity

Fungible Balances Daily ERC721 Balances Daily

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns