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 Details
| Property | Value |
|---|---|
| Table Name | cosmos.assets.fungible_balances_latest |
| Table Status | Beta 🌱 |
| Unique Key | token_address, address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR(16777216) | The wallet address holding the balance. |
| currency | VARCHAR(16777216) | The currency or token denomination for the balance. |
| token_name | VARCHAR(16777216) | The human-readable name of the token. |
| token_symbol | VARCHAR(16777216) | The ticker symbol of the token. |
| token_decimals | NUMBER(38,0) | The number of decimal places used to normalize the token balance. |
| raw_balance_str | VARCHAR(16777216) | The raw balance as a string to retain precision. |
| raw_balance | FLOAT | The raw balance as a numeric value. |
| balance_str | VARCHAR(16777216) | The normalized balance as a string to retain precision. |
| balance | FLOAT | The normalized balance as a numeric value. |
| usd_balance_current | FLOAT | The current USD value of the balance, based on the latest available exchange rate. |
| usd_balance_at_last_activity | FLOAT | The USD value of the balance at the exchange rate available at the time of the last activity. |
| usd_exchange_rate_current | FLOAT | The current USD exchange rate for the token, based on the latest available rate. |
| usd_exchange_rate_at_last_activity | FLOAT | The USD exchange rate for the token at the time of the last activity. |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block that last changed this balance. |
| last_activity_block_height | NUMBER(38,0) | The height of the block that last changed this balance. |
| last_activity_block_hash | VARCHAR(16777216) | The hash of the block that last changed this balance. |
| last_activity_transaction_hash | VARCHAR(16777216) | The hash of the transaction that last changed this balance. |
| last_activity_transaction_index | NUMBER(38,0) | The index of the transaction that last changed this balance within its block. |
| unique_id | VARCHAR(16777216) | A unique identifier for this latest balance record. |
| _updated_at__usd_exchange_rate_current | TIMESTAMP_NTZ(9) | The timestamp when the current USD exchange rate was last updated. |
| _updated_at__historical | TIMESTAMP_NTZ(9) | The timestamp when the historical balance data used for this record was last updated. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |