ERC721 Balances

The assets.erc721_balances table contains the block-level balance changes of erc721 compatible tokens. Each entry in the model corresponds to a specific event/transaction that causes a balance change in a particular asset at the block level. This means a new data entry is only created when a transaction alters token’s balance at the block level.

Table Columns

Unique Key: unique_id

Column Name	Data Type	Description
address	VARCHAR	The wallet address holding the tokens
token_address	VARCHAR	Contract address of the token
token_name	VARCHAR	Name of the token
token_symbol	VARCHAR	Symbol of the token
token_id	VARCHAR	Unique identifier for the specific token within the collection (e.g., for ERC721 or ERC1155)
raw_balance	FLOAT	Token balance, unnormalized
raw_balance_str	VARCHAR	Token balance as string to retain precision
balance	FLOAT	Token balance, normalized
balance_str	VARCHAR	Token balance as string to retain precision
transaction_hash	VARCHAR	Hash of the transaction that last modified the balance
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block
block_number	BIGINT	Number of the block
block_hash	VARCHAR	Hash of the block
unique_id	VARCHAR	Unique identifier of the balances entry
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated
_changed_since_full_refresh	BOOLEAN	Indicates if the record has changed since the last full refresh

ERC20 Balances ERC1155 Balances

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns