ERC721 Balances Daily

The ERC721 Balances Daily table provides one row per (address, token, token_id, date) capturing the closing ERC721 balance for each day. Use this table for day-over-day ownership analysis and point-in-time holder views. For per-block balance changes, use the erc721_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 ERC721 token
token_name	VARCHAR	Name of the token
token_symbol	VARCHAR	Symbol of the token
token_id	VARCHAR	Token ID of the ERC721 token
balance	INTEGER	Token balance. For ERC721 tokens, the max balance is 1
balance_str	VARCHAR	Token balance as a string. For ERC721 tokens, the max is 1
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

ERC1155 Balances Daily Overview

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns