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 Beanz NFT from an address.

select * from ethereum.assets.erc721_balances_latest
where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy
and token_address = '0x306b1ea3ecdf94ab739f1910bbda052ed4a9f949' -- Beanz NFT

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
usd_balance_current

USD balance of ERC721 token at the current timestamp.

N/A for ERC721 tokens currently.

NULL
usd_balance_at_block_timestampUSD balance of ERC721 token at the timestamp of the last activity that resulted in balance change.NULL
usd_exchange_rate_currentUSD exchange rate of ERC721 token at the current timestamp.

N/A for ERC721 tokens currently.		NULL
usd_exchange_rate_at_block_timestampUSD exchange rate of ERC721 token at the timestamp of the last activity that resulted in balance update.NULL
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
_updated_at__usd_exchange_rate_currentTimestamp of the current USD exchange.NULL
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