> ## 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          | `cardano.unhydrated.fungible_balances_eod` |
| Table Status        | Production-Ready                           |
| Unique Key          | `block_date`, `address`, `token`           |
| Clustering Key(s)   | `block_date, _short_address, _short_token` |
| Search Optimization | `address`, `token`                         |

### Table Columns

| Column Name           | Data Type         | Description                                                                             |
| --------------------- | ----------------- | --------------------------------------------------------------------------------------- |
| address               | VARCHAR(16777216) | The Cardano address holding the balance.                                                |
| token                 | VARCHAR(16777216) | The token identifier (policy ID + asset name for native tokens, or "lovelace" for ADA). |
| raw\_balance\_str     | VARCHAR(16777216) | Raw cumulative balance as a string to retain precision.                                 |
| block\_date           | TIMESTAMP\_NTZ(9) | Date of the balance snapshot.                                                           |
| block\_timestamp      | TIMESTAMP\_NTZ(9) | Timestamp of the last activity on this date.                                            |
| block\_height         | NUMBER(38,0)      | Block height of the last activity on this date.                                         |
| block\_hash           | VARCHAR(16777216) | Block hash of the last activity on this date.                                           |
| transaction\_hash     | VARCHAR(16777216) | Transaction hash of the last activity on this date.                                     |
| transaction\_index    | NUMBER(38,0)      | Transaction index of the last activity on this date.                                    |
| pseudo\_global\_order | NUMBER(38,0)      | Ordering key combining block height and transaction index.                              |
| \_short\_address      | VARCHAR(16777216) | Short prefix of the address for search optimization.                                    |
| \_short\_token        | VARCHAR(16777216) | Short prefix of the token for search optimization.                                      |
| \_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.                           |