> ## 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   | `near.assets.fungible_balances_daily`            |
| Table Status | Production-Ready                                 |
| Unique Key   | `date`, `address`, `token_address`, `account_id` |

### Table Columns

| Column Name                      | Data Type         | Description                                                                             |
| -------------------------------- | ----------------- | --------------------------------------------------------------------------------------- |
| date                             | TIMESTAMP\_NTZ(9) | End-of-day date (UTC) of the balance snapshot.                                          |
| address                          | VARCHAR(16777216) | NEAR account that holds the token balance.                                              |
| token\_address                   | VARCHAR(16777216) | Contract account of the fungible token, or the native NEAR sentinel for unwrapped NEAR. |
| account\_id                      | VARCHAR(16777216) | NEAR account ID associated with this balance (same as `address` for most wallets).      |
| token\_type                      | VARCHAR(16777216) | Token category (`native` or `ft`).                                                      |
| token\_name                      | VARCHAR(16777216) | Full name of the token.                                                                 |
| token\_symbol                    | VARCHAR(16777216) | Ticker symbol of the token.                                                             |
| token\_decimals                  | NUMBER(38,0)      | Number of decimal places used to normalize the token's raw amounts.                     |
| raw\_balance\_str                | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision.              |
| raw\_balance                     | FLOAT             | Token balance in the smallest unit (not decimal-adjusted).                              |
| balance\_str                     | VARCHAR(16777216) | Normalized token balance stored as a string for full precision.                         |
| balance                          | FLOAT             | Token balance normalized by the token's decimal precision.                              |
| usd\_exchange\_rate              | FLOAT             | USD price per token unit used to compute `usd_balance`.                                 |
| usd\_balance                     | FLOAT             | USD value of the token balance at this daily snapshot.                                  |
| last\_activity\_block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp of the most recent balance-changing activity.                                 |
| last\_activity\_block\_height    | NUMBER(38,0)      | Block height of the most recent balance-changing activity.                              |
| last\_activity\_block\_hash      | VARCHAR(16777216) | Block hash of the most recent balance-changing activity.                                |
| \_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.                           |