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 oasys.assets.erc721_balances_latest
limit 100

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

Table Columns

Column NameDescriptionExample
addressAddress of the account.0x22b2d8bfe3991fd5344d4ab11ea9435d65edd386
token_addressAddres of the token.0xb9e6ff06179fa9604d8102fb3aa428e64b981c3f
token_nameName of the token.Chain Colosseum Phoenix Gen3
token_symbolSymbol of the token.Gen3Book
token_idToken ID of the ERC721 token.2091
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
transaction_hashTransaction hash that resulted in this balance.0x0f75fa7c5e9bfae661f20b744a66bd6203501de198b6d4041b6267a280f4ee78
last_activity_block_timestampTimestamp of the last activity that resulted in this balance.2024-01-23 16:00:46+00:00
last_activity_block_numberBlock number of the last activity that resulted in this balance.2767126
last_activity_block_hashBlock hash of the last activity that resulted in this balance.0xda2875ccfe8815303dc7b7162c54e53b7fdae17eff79a1fea0f879188685a52b
unique_idUnique ID of the balance.block-2767126_address-0x22b2d8bfe3991fd5344d4ab11ea9435d65edd386_token_address-0xb9e6ff06179fa9604d8102fb3aa428e64b981c3f_token_id-2091_erc721
_updated_atTimestamp of the balance update.2024-02-19 03:37:13.651000+00:00