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

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| address | VARCHAR(42) | The wallet address holding the tokens |
| token\_address | VARCHAR(42) | Contract address of the token (or sentinel address for the native token) |
| raw\_balance\_str | VARCHAR(16777216) | Token balance, unnormalized, as a string to retain precision |
| block\_date | TIMESTAMP\_NTZ(9) | The UTC date (end of day) this balance snapshot covers |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Block timestamp of the last balance-changing activity on this date |
| block\_number | NUMBER(38,0) | Block number of the last balance-changing activity on this date |
| block\_hash | VARCHAR(16777216) | Block hash of the last balance-changing activity on this date |
| \_has\_error | NUMBER(1,0) | Flag indicating whether an error occurred computing this balance (1 = error) |
| \_short\_address | VARCHAR(42) | Truncated form of address used as a clustering key for query pruning |
| \_short\_token\_address | VARCHAR(42) | Truncated form of token\_address used as a clustering key for query pruning |
| \_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. |

### Related Docs

* [EVM Unhydrated Fungible Balances Eod](https://docs.allium.so/historical-data/supported-blockchains/evm/core-schemas/unhydrated/fungible-balances-eod.md)
