USD prices for NFT token balances are not supported currently.

ERC721 balances table contains the ERC721 balances of all addresses, at every block height. Use this table to easily plot the change in the balance of ERC721 tokens for an address or a group of addresses over time.

​
Sample Query

Getting the ERC721 Balances of Beanz NFT from an address.

select * from ethereum.assets.erc721_balances

where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy

and token_address = '0x306b1ea3ecdf94ab739f1910bbda052ed4a9f949' -- Beanz NFT 

order by block_number desc

​
Table Columns

Column NameDescriptionExampleColumn Name
addressAddress of the account.0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459
token_addressToken address of the ERC721 token.0x306b1ea3ecdf94ab739f1910bbda052ed4a9f949
token_name Name of the ERC721 token.Beanz
token_symbolToken symbol of this token.BEANZ
token_idUnique token ID of the ERC721 token.5688
raw_balanceBalance of tokens (unnormalized). For ERC721 tokens, there are no decimals division involved. 1
balanceBalance of tokens. For ERC721 tokens, the max balance is 1. 1
usd_valueThe amount of tokens, in $USD.
usd_exchange_rateThe exchange rate used to calculate the usd_value.
block_timestampThe timestamp of the block that that resulted in the balance.2022-04-24T06:03:02
block_numberThe number of the block that resulted in the balance.14645764
block_hashThe hash of the block that resulted in the balance.0x7ec027adfb36e4e1bfe77c787e91df77a239f914c5760ce19ca32cfb270ab7ef