The assets.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

Unique Key: unique_id

Column NameData TypeDescription
addressVARCHARAddress of the account
token_addressVARCHARAddress of the token
token_nameVARCHARName of the token
token_symbolVARCHARSymbol of the token
token_idVARCHARToken ID of the ERC721 token
raw_balanceINTEGERBalance of tokens (unnormalized). For ERC721 tokens, there are no decimals division involved
raw_balance_strVARCHARBalance of tokens (unnormalized) in string. For ERC721 tokens, there are no decimals division involved
balance_strVARCHARBalance of tokens in string. For ERC721 tokens, the max balance is 1
balanceINTEGERBalance of tokens. For ERC721 tokens, the max balance is 1
usd_balance_currentFLOATUSD balance of ERC721 token at the current timestamp (N/A for ERC721 tokens currently)
usd_balance_at_block_timestampFLOATUSD balance of ERC721 token at the timestamp of the last activity that resulted in balance change
usd_exchange_rate_currentFLOATUSD exchange rate of ERC721 token at the current timestamp (N/A for ERC721 tokens currently)
usd_exchange_rate_at_block_timestampFLOATUSD exchange rate of ERC721 token at the timestamp of the last activity that resulted in balance update
last_activity_block_timestampTIMESTAMP_NTZ(9)Timestamp of the last activity that resulted in this balance
last_activity_block_numberINTEGERBlock number of the last activity that resulted in this balance
last_activity_block_hashVARCHARBlock hash of the last activity that resulted in this balance
_updated_at__usd_exchange_rate_currentTIMESTAMP_NTZ(9)Timestamp of the current USD exchange
unique_idVARCHARUnique ID of the balance
_updated_atTIMESTAMP_NTZ(9)Timestamp of the balance update