TheDocumentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
fungible_balances_latest table contains the latest observed balance for each address and fungible token.
Table Columns
Unique Key:unique_id
| Column Name | Description |
|---|---|
| address | The wallet address holding the balance. |
| currency | The currency or token denomination for the balance. |
| token_name | The human-readable name of the token. |
| token_symbol | The ticker symbol of the token. |
| token_decimals | The number of decimal places used to normalize the token balance. |
| raw_balance_str | The raw balance as a string to retain precision. |
| raw_balance | The raw balance as a numeric value. |
| balance_str | The normalized balance as a string to retain precision. |
| balance | The normalized balance as a numeric value. |
| usd_balance_current | The current USD value of the balance, based on the latest available exchange rate. |
| usd_balance_at_last_activity | The USD value of the balance at the exchange rate available at the time of the last activity. |
| usd_exchange_rate_current | The current USD exchange rate for the token, based on the latest available rate. |
| usd_exchange_rate_at_last_activity | The USD exchange rate for the token at the time of the last activity. |
| last_activity_block_timestamp | The timestamp of the block that last changed this balance. |
| last_activity_block_height | The height of the block that last changed this balance. |
| last_activity_block_hash | The hash of the block that last changed this balance. |
| last_activity_transaction_hash | The hash of the transaction that last changed this balance. |
| last_activity_transaction_index | The index of the transaction that last changed this balance within its block. |
| unique_id | A unique identifier for this latest balance record. |
| _updated_at__usd_exchange_rate_current | The timestamp when the current USD exchange rate was last updated. |
| _updated_at__historical | The timestamp when the historical balance data used for this record was last updated. |