Native Balances Latest
The Native Balances Latest table contains the latest balance of native tokens of all addresses.
This table is derived from the Native Balances table, by selecting the most recent balance update for each unique address-asset combination.
Sample Query
Getting the latest native token balance of an address.
Table Columns
Unique Key: unique_id
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR | Address of the account |
| token_address | VARCHAR | Address of the native token, which is represented as null address (0x0000000000000000000000000000000000000000) |
| token_name | VARCHAR | Name of the native token |
| token_symbol | VARCHAR | Symbol of the token |
| raw_balance | FLOAT | Raw balance of native token in wei |
| raw_balance_str | VARCHAR | Raw balance of native token in wei and in string format |
| balance | FLOAT | Balance of native token normalized |
| balance_str | VARCHAR | Balance of native token normalized and in string format |
| usd_balance_current | FLOAT | USD balance of ETH at the current timestamp |
| usd_balance_at_block_timestamp | FLOAT | USD balance of ETH at the timestamp of the last activity that resulted in balance change |
| usd_exchange_rate_current | FLOAT | USD exchange rate of ETH at the current timestamp |
| usd_exchange_rate_at_block_timestamp | FLOAT | USD exchange rate of ETH at the timestamp of the last activity that resulted in balance update |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | The last timestamp of the block that resulted in the balance update |
| last_activity_block_number | BIGINT | The last block number that resulted in the balance update |
| last_activity_block_hash | VARCHAR | The last hash of the block that resulted in the balance update |