ERC721 Balances
Historical ERC721 balances of all addresses at every block height.
Note that we don't have USD prices for NFT balances yet
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.
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
Column Name | Description | Example |
|---|---|---|
address | Address of the account. | 0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459 |
token_address | Token address of the ERC721 token. | 0x306b1ea3ecdf94ab739f1910bbda052ed4a9f949 |
token_name | Name of the ERC721 token. | Beanz |
token_symbol | Token symbol of this token. | BEANZ |
token_id | Unique token ID of the ERC721 token. | 5688 |
raw_balance | Balance of tokens (unnormalized). For ERC721 tokens, there are no decimals division involved. | 1 |
balance | Balance of tokens. For ERC721 tokens, the max balance is 1. | 1 |
usd_value | The amount of tokens, in $USD. | |
usd_exchange_rate | The exchange rate used to calculate the usd_value. | |
block_timestamp | The timestamp of the block that that resulted in the balance. | 2022-04-24T06:03:02 |
block_number | The number of the block that resulted in the balance. | 14645764 |
block_hash | The hash of the block that resulted in the balance. | 0x7ec027adfb36e4e1bfe77c787e91df77a239f914c5760ce19ca32cfb270ab7ef |
Last modified 13d ago