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

### Table Details

| Property     | Value                                    |
| ------------ | ---------------------------------------- |
| Table Name   | `stellar.assets.fungible_balances_daily` |
| Table Status | Production-Ready                         |

### Table Columns

| Column Name                         | Data Type         | Description                                                                       |
| ----------------------------------- | ----------------- | --------------------------------------------------------------------------------- |
| date                                | TIMESTAMP\_NTZ(9) | Calendar date (UTC) of the daily balance snapshot.                                |
| account\_id                         | VARCHAR(16777216) | Stellar account (G-address) holding the balance.                                  |
| asset\_type                         | VARCHAR(16777216) | Stellar asset type: `native`, `credit_alphanum4`, or `credit_alphanum12`.         |
| 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\_exchange\_rate                 | FLOAT             | USD price per unit of the asset, used to compute `usd_balance`.                   |
| usd\_balance                        | FLOAT             | USD value of the balance on this date.                                            |
| 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.                       |