Note that we don’t have USD prices for NFT balances yet

The ERC721 balances latest table contains the current ERC721 balances of all addresses.

Sample Query

Getting the ERC721 latest balance of an NFT from an address.

select * from avalanche.assets.erc721_balances_latest

where address = '0xec451d6a06741e86e5ff0f9e5cc98d3388480c7a'

and token_address = '0xe030543b943bdcd6559711ec8d344389c66e1d56'

Currently, the USD exchange rates of ERC721 tokens are not available.

Table Columns

Column NameDescriptionExample
addressAddress of the account.0x44228c343e102d2860a800f05da2f09cd00f0c60
token_addressAddres of the token.0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258
token_nameName of the token.Otherdeed
token_symbolSymbol of the token.OTHR
token_idToken ID of the ERC721 token.80383
raw_balanceBalance of tokens (unnormalized). For ERC721 tokens, there are no decimals division involved.1
raw_balance_strBalance of tokens (unnormalized) in string. For ERC721 tokens, there are no decimals division involved.1
balance_strBalance of tokens in string. For ERC721 tokens, the max balance is 1.1
balanceBalance of tokens. For ERC721 tokens, the max balance is 1.1
last_activity_block_timestampTimestamp of the last activity that resulted in this balance.2023-03-14 14:12:23
last_activity_block_numberBlock number of the last activity that resulted in this balance.16,826,706
last_activity_block_hashBlock hash of the last activity that resulted in this balance.0x230f13eae18b694dae232baae4dc78e9b9ca09f937d242d13380f075eb888ead
unique_idUnique ID of the balance.block-16826706_address-0x44228c343e102d2860a800f05da2f09cd00f0c60_token_address-0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258_token_id-80383_erc721
_updated_atTimestamp of the balance update.2023-03-14 15:28:54