ERC1155 Balances Latest

Historical ERC1155 balances of all addresses at every block height.

Note that we don't have USD prices for NFT balances yet

The ERC1155 balances latest table contains the current ERC1155 balances of all addresses.

Sample Query

Getting the ERC1155 latest balance of a NFT from an address.

select * from avalanche.assets.erc1155_balances_latest
where address = '0xfb9de654ec4d5ad14cacecb035b75a81340674ad' limit 10

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

Table Columns

Column Name
Description
Example

address

Address of the account.

0x44228c343e102d2860a800f05da2f09cd00f0c60

token_address

Address of the token.

0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258

token_name

Name of the token.

Otherdeed

token_symbol

Symbol of the token.

OTHR

token_id

Token ID of the ERC1155 token.

80383

raw_balance

Balance of tokens (unnormalized).

1

raw_balance_str

Balance of tokens (unnormalized) in string.

1

balance_str

Balance of tokens in string.

1

balance

Balance of tokens

1

last_activity_block_timestamp

Timestamp of the last activity that resulted in this balance.

2023-03-14 14:12:23

last_activity_block_number

Block number of the last activity that resulted in this balance.

16,826,706

last_activity_block_hash

Block hash of the last activity that resulted in this balance.

0x230f13eae18b694dae232baae4dc78e9b9ca09f937d242d13380f075eb888ead

unique_id

Unique ID of the balance.

block-16826706_address-0x44228c343e102d2860a800f05da2f09cd00f0c60_token_address-0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258_token_id-80383_erc721

_updated_at

Timestamp of the balance update.

2023-03-14 15:28:54

Last updated