ERC1155 Balances Latest

The current ERC1155 balance of all addresses.

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 latest ERC1155 Balances address.

select * from ethereum.assets.erc1155_balances_latest
where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy

Note that ERC1155 permits the creation of both semi-fungible tokens and non-fungible tokens. In other words, there can be more than one quantity for a particular ERC1155 token ID.

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

Table Columns

Column Name
Description
Example

address

Address of the account.

0x8080a4d7ef2401b90bd5cf0041e533ce51035ebb

token_address

Addres of the token.

0xd955e7bd8ca9f2aad391760f849cfa4ee2d80d57

token_name

Name of the token.

HELIX - Collectables

token_symbol

Symbol of the token.

token_id

Token ID.

19

raw_balance

Balance of ERC1155 token unnormalized.

1

raw_balance_str

Balance of ERC1155 token unnormalized in string.

1

balance_str

Balance of ERC1155 token in string.

1

balance

Balance of ERC1155 token.

1

usd_balance_current

USD balance of ERC1155 token at the current timestamp.

NULL

usd_balance_at_block_timestamp

USD balance of ERC1155 token at the timestamp of the last activity that resulted in balance change.

NULL

usd_exchange_rate_current

USD exchange rate of ERC1155 token at the current timestamp.

NULL

usd_exchange_rate_at_block_timestamp

USD exchange rate of ERC1155 token at the timestamp of the last activity that resulted in balance update.

NULL

last_activity_block_timestamp

The timestamp of the block that that resulted in the balance.

2023-03-14 10:12:59

last_activity_block_number

The number of the block that resulted in the balance.

16,825,516

last_activity_block_hash

The hash of the block that that resulted in the balance.

0xe9e8062af71dc440cad49079844d88e6b3a8cdec95cd036f2b27d10a239b6c77

_updated_at__usd_exchange_rate_current

Timestamp of the current USD exchange.

NULL

unique_id

Unique ID of the balance.

block-16825516_address-0x8080a4d7ef2401b90bd5cf0041e533ce51035ebb_token_address-0xd955e7bd8ca9f2aad391760f849cfa4ee2d80d57_token_id-19_erc1155

_updated_at

Timestamp of the balance update.

2023-03-14 16:28:37

Last updated