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

> Daily, end-of-day, and latest fungible balances on Aptos with metadata and USD prices.

# Fungible balances

The `aptos.assets.fungible_balances_daily` table contains daily fungible balances forward-filled from end-of-day snapshots, including FA store addresses and USD prices.

## Table Columns

| Column Name                           | Description                                                |
| ------------------------------------- | ---------------------------------------------------------- |
| date                                  | Daily timestamp of the balance snapshot.                   |
| token\_standard                       | Token standard (coin or fungible\_asset).                  |
| address                               | Wallet address holding the balance.                        |
| fa\_store\_address                    | FungibleStore address for FA balances.                     |
| token\_address                        | Token address or FA metadata address.                      |
| token\_name                           | Token name.                                                |
| token\_symbol                         | Token symbol.                                              |
| token\_decimals                       | Token decimals.                                            |
| raw\_balance\_str                     | Raw balance as a string.                                   |
| raw\_balance                          | Raw balance cast to float.                                 |
| balance\_str                          | Normalized balance as a string.                            |
| balance                               | Normalized balance as a float.                             |
| usd\_exchange\_rate                   | USD exchange rate at the daily timestamp.                  |
| usd\_balance                          | USD balance at the daily timestamp.                        |
| is\_frozen                            | Whether the FA store is frozen.                            |
| last\_activity\_block\_timestamp      | Block timestamp of the last activity used to forward fill. |
| last\_activity\_block\_height         | Block height of the last activity used to forward fill.    |
| last\_activity\_global\_change\_index | Global change index of the last activity.                  |

The `aptos.assets.fungible_balances_eod` table contains end-of-day fungible balances (coin and fungible asset standards) for each address and token, hydrated with token metadata and USD prices.

## Table Columns

| Column Name           | Description                                |
| --------------------- | ------------------------------------------ |
| token\_standard       | Token standard (coin or fungible\_asset).  |
| address               | Wallet address holding the balance.        |
| fa\_store\_address    | FungibleStore address for FA balances.     |
| token\_address        | Token address or FA metadata address.      |
| token\_name           | Token name.                                |
| token\_symbol         | Token symbol.                              |
| token\_decimals       | Token decimals.                            |
| raw\_balance\_str     | Raw balance as a string.                   |
| raw\_balance          | Raw balance cast to float.                 |
| balance\_str          | Normalized balance as a string.            |
| balance               | Normalized balance as a float.             |
| usd\_balance          | USD balance using hourly prices.           |
| usd\_exchange\_rate   | USD exchange rate used for balance.        |
| is\_frozen            | Whether the FA store is frozen.            |
| transaction\_version  | Transaction version of the balance update. |
| transaction\_index    | Transaction index in the block.            |
| change\_index         | Change index within the transaction.       |
| block\_timestamp      | Block timestamp of the balance update.     |
| block\_height         | Block height of the balance update.        |
| global\_change\_index | Global order of the change.                |
| unique\_id            | Deterministic unique identifier.           |
| \_created\_at         | Row creation timestamp.                    |
| \_updated\_at         | Row update timestamp.                      |

The `aptos.assets.fungible_balances_latest` table contains the latest fungible balances with current and historical USD pricing.

## Table Columns

| Column Name                                   | Description                                           |
| --------------------------------------------- | ----------------------------------------------------- |
| token\_standard                               | Token standard (coin or fungible\_asset).             |
| address                                       | Wallet address holding the balance.                   |
| fa\_store\_address                            | FungibleStore address for FA balances.                |
| token\_address                                | Token address or FA metadata address.                 |
| token\_name                                   | Token name.                                           |
| token\_symbol                                 | Token symbol.                                         |
| token\_decimals                               | Token decimals.                                       |
| raw\_balance\_str                             | Raw balance as a string.                              |
| raw\_balance                                  | Raw balance cast to float.                            |
| balance\_str                                  | Normalized balance as a string.                       |
| balance                                       | Normalized balance as a float.                        |
| usd\_balance\_current                         | USD balance using latest prices.                      |
| usd\_balance\_at\_block\_timestamp            | USD balance using historical prices at last activity. |
| usd\_exchange\_rate\_current                  | Latest USD exchange rate.                             |
| usd\_exchange\_rate\_at\_block\_timestamp     | Historical USD exchange rate at last activity.        |
| last\_activity\_block\_timestamp              | Block timestamp of the last activity.                 |
| last\_activity\_block\_height                 | Block height of the last activity.                    |
| unique\_id                                    | Deterministic unique identifier.                      |
| \_updated\_at\_\_usd\_exchange\_rate\_current | Timestamp of the latest USD exchange rate.            |
| \_updated\_at\_\_historical                   | Timestamp of the historical balance row update.       |
| \_created\_at\_\_onchain\_lake                | Timestamp when the onchain balance row was created.   |
| \_updated\_at                                 | Row update timestamp.                                 |
| \_changed\_since\_full\_refresh               | Whether the row changed since last full refresh.      |

### Sample Query 1

Finding distribution of balances at a given point of time.

```
select * from aptos.assets.fungible_balances_eod 
where date(block_timestamp) <= '2026-01-01' -- Date of interest
and token_address = '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b' -- USDC Token Address
and token_standard = 'fungible_asset' 
qualify row_number() over (partition by address, fa_store_address order by global_change_index desc) = 1 
```