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.Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Columns
Unique Key:unique_id
| Column Name | Data Type | Description |
|---|---|---|
| token_type | VARCHAR | Type of the token (e.g., ERC20, native). |
| 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 |
| usd_balance_current | FLOAT | The current USD value of the balance, based on the latest available exchange rate. |
| usd_balance_at_block_timestamp | FLOAT | The USD value of the balance at the time of the block that resulted in the balance update. |
| usd_exchange_rate_current | FLOAT | The current USD exchange rate of the token, based on the latest available rate. |
| usd_exchange_rate_at_block_timestamp | FLOAT | The USD exchange rate of the token at the time of the block that resulted in the 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 | 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__historical | TIMESTAMP_NTZ(9) | Timestamp of the historical balance row update. |
| _created_at__onchain_lake | TIMESTAMP_NTZ(9) | Timestamp when the balance row was first created in the onchain data lake. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the balance update |