ERC1155 Balances Latest
Fetch the current ERC1155 balance of all addresses.
The ERC1155 Balances Latest table contains the current ERC1155 balances of all addresses.
This table is derived from the ERC1155 Balances table, by selecting the most recent balance update for each unique address-asset combination.
Sample Query
Getting the latest ERC1155 Balances address.
Note that ERC1155 permits the creation of both semi-fungible tokens. In other words, there can be more than one quantity for a particular ERC1155 token ID.
Table Columns
Unique Key: unique_id
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR | Address of the account |
| token_address | VARCHAR | Address of the token |
| token_name | VARCHAR | Name of the token |
| token_symbol | VARCHAR | Symbol of the token |
| token_id | VARCHAR | Token ID of the ERC1155 token |
| raw_balance | INTEGER | Balance of ERC1155 token unnormalized |
| raw_balance_str | VARCHAR | Balance of ERC1155 token unnormalized in string format |
| balance_str | VARCHAR | Balance of ERC1155 token in string format |
| balance | INTEGER | Balance of ERC1155 token normalized |
| usd_balance_current | FLOAT | USD balance of ERC1155 token at the current timestamp |
| usd_balance_at_block_timestamp | FLOAT | USD balance of ERC1155 token at the timestamp of the last activity that resulted in balance change |
| usd_exchange_rate_current | FLOAT | USD exchange rate of ERC1155 token at the current timestamp |
| usd_exchange_rate_at_block_timestamp | FLOAT | USD exchange rate of ERC1155 token at the timestamp of the last activity that resulted in balance update |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block that resulted in the balance |
| last_activity_block_number | INTEGER | The number of the block that resulted in the balance |
| last_activity_block_hash | VARCHAR | The hash of the block that resulted in the balance |
| _updated_at__usd_exchange_rate_current | TIMESTAMP_NTZ(9) | Timestamp of the current USD exchange rate |
| unique_id | VARCHAR | Unique ID of the balance |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the balance update |