ERC721 Balances
Historical ERC721 balances of all addresses at every block height.
The assets.erc721_balances
table contains the ERC721 balances of all addresses, at every block height.
USD prices for NFT token balances are not supported currently.
Table Columns
Unique Key: unique_id
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
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.
Last updated