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

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

Sample Query

Getting the ERC1155 latest balance of a NFT from an address.

select * from avalanche.assets.erc1155_balances_latest

where address = '0xfb9de654ec4d5ad14cacecb035b75a81340674ad' limit 10

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

Table Columns

Column NameDescriptionExample
addressAddress of the account.0x44228c343e102d2860a800f05da2f09cd00f0c60
token_addressAddress of the token.0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258
token_nameName of the token.Otherdeed
token_symbolSymbol of the token.OTHR
token_idToken ID of the ERC1155 token.80383
raw_balanceBalance of tokens (unnormalized). 1
raw_balance_strBalance of tokens (unnormalized) in string.1
balance_strBalance of tokens in string. 1
balanceBalance of tokens1
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