> ## 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.

# Fungible Balances Latest

### Table Details

| Property     | Value                                     |
| ------------ | ----------------------------------------- |
| Table Name   | `stellar.assets.fungible_balances_latest` |
| Table Status | Production-Ready                          |
| Unique Key   | `token_address`, `address`                |

### Table Columns

| Column Name                                   | Data Type         | Description                                                                                |
| --------------------------------------------- | ----------------- | ------------------------------------------------------------------------------------------ |
| asset\_type                                   | VARCHAR(16777216) | Stellar asset type: `native`, `credit_alphanum4`, or `credit_alphanum12`.                  |
| account\_id                                   | VARCHAR(16777216) | Stellar account (G-address) holding the balance.                                           |
| asset\_id                                     | VARCHAR(16777216) | Composite asset identifier in `issuer:code` form for Classic assets.                       |
| asset\_code                                   | VARCHAR(16777216) | Asset code for the Classic asset.                                                          |
| asset\_issuer                                 | VARCHAR(16777216) | Issuer G-address of the Classic asset.                                                     |
| raw\_balance\_str                             | VARCHAR(16777216) | Balance in stroops (unnormalized integer), stored as a string for full precision.          |
| raw\_balance                                  | FLOAT             | Balance in stroops (unnormalized), not decimal-adjusted.                                   |
| balance\_str                                  | VARCHAR(16777216) | Normalized balance stored as a string for full precision.                                  |
| balance                                       | FLOAT             | Balance normalized by the asset's decimal precision (raw\_balance / 10^decimals).          |
| usd\_balance\_current                         | FLOAT             | USD value of the balance using the most recent available price.                            |
| usd\_balance\_at\_last\_activity              | FLOAT             | USD value of the balance at the price as of the account's last on-chain activity.          |
| usd\_exchange\_rate\_current                  | FLOAT             | Most recent USD price per unit of the asset.                                               |
| usd\_exchange\_rate\_at\_last\_activity       | FLOAT             | USD price per unit of the asset as of the account's last on-chain activity.                |
| last\_activity\_ledger\_close\_time           | TIMESTAMP\_NTZ(9) | Close time of the last ledger in which this account had activity.                          |
| last\_activity\_ledger\_sequence              | NUMBER(38,0)      | Sequence number of the last ledger in which this account had activity.                     |
| last\_activity\_ledger\_hash                  | VARCHAR(16777216) | Hash of the last ledger in which this account had activity.                                |
| last\_activity\_transaction\_hash             | VARCHAR(16777216) | Hash of the transaction in the account's last on-chain activity.                           |
| unique\_id                                    | VARCHAR(16777216) | Allium's deterministic unique identifier for this row.                                     |
| \_updated\_at\_\_usd\_exchange\_rate\_current | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the most recent update to the current USD exchange rate for this asset. |
| \_updated\_at\_\_historical                   | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the most recent update to the at-last-activity data for this row.       |
| \_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.                              |