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

### Table Details

| Property            | Value                                                  |
| ------------------- | ------------------------------------------------------ |
| Table Name          | `near.unhydrated.fungible_balances_eod`                |
| Table Status        | Production-Ready                                       |
| Unique Key          | `block_date`, `address`, `token_address`, `account_id` |
| Clustering Key(s)   | `block_date, _short_address, _short_token_address`     |
| Search Optimization | `address`, `token_address`                             |

### Table Columns

| Column Name             | Data Type         | Description                                                                             |
| ----------------------- | ----------------- | --------------------------------------------------------------------------------------- |
| 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`).                                                      |
| raw\_balance\_str       | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision.              |
| block\_date             | TIMESTAMP\_NTZ(9) | Date of the snapshot (block\_timestamp truncated to day).                               |
| block\_timestamp        | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block this end-of-day snapshot is taken from.                    |
| block\_height           | NUMBER(38,0)      | Height of the block this end-of-day snapshot is taken from.                             |
| block\_hash             | VARCHAR(16777216) | Hash of the block this end-of-day snapshot is taken from.                               |
| \_short\_address        | VARCHAR(64)       | Truncated address used for clustering and search.                                       |
| \_short\_token\_address | VARCHAR(64)       | Truncated token address used for clustering and search.                                 |
| \_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.                           |