Fungible Balances Latest
The Fungible Balances Latest table contains the latest balance of fungible tokens (ERC20 and native (gas) tokens) of all addresses.
This table is derived from the Fungible Balances table, by selecting the most recent balance update for each unique address-asset combination.
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 | NUMERIC | 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 |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | The last timestamp of the block that resulted in the balance update |
| last_activity_block_number | INTEGER | 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 |
| _updated_at__usd_exchange_rate_current | TIMESTAMP_NTZ(9) | Timestamp of the current USD exchange |
| unique_id | VARCHAR | Unique ID of the balance |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the balance update |