ERC1155 Balances

Historical ERC1155 balances of all addresses at every block height.

The assets.erc1155_balances table contains the ERC1155 balances of all addresses, at every block height.

USD prices for NFT token balances are not supported currently.

Table Columns

Unique Key: unique_id

Column Name
Data Type
Description

address

VARCHAR

The wallet address holding the tokens

token_address

VARCHAR

Contract address of the token

token_name

VARCHAR

Name of the token

token_symbol

VARCHAR

Symbol of the token

token_id

VARCHAR

Unique identifier for the specific token within the collection

raw_balance

FLOAT

Token balance, unnormalized

raw_balance_str

VARCHAR

Token balance as string to retain precision

balance

FLOAT

Token balance, normalized

balance_str

VARCHAR

Token balance as string to retain precision

transaction_hash

VARCHAR

Hash of the transaction that last modified the balance

block_timestamp

TIMESTAMP_NTZ(9)

Timestamp of the block

block_number

BIGINT

Number of the block

block_hash

VARCHAR

Hash of the block

unique_id

VARCHAR

Unique identifier of the balances entry.

Last updated