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

> End-of-day fungible (native & ERC20) balances per (address, token), before normalization and USD hydration.

The Fungible Balances EOD table holds the raw end-of-day fungible token balance for each (address, token) pair. It is an intermediate, "unhydrated" table: balances are unnormalized and token metadata and USD values are added downstream. Columns prefixed with `_` are internal helpers used for clustering, query pruning, and error tracking.

### Table Columns

| Column Name             | Data Type         | Description                                                                  |
| ----------------------- | ----------------- | ---------------------------------------------------------------------------- |
| address                 | VARCHAR           | The wallet address holding the tokens                                        |
| token\_address          | VARCHAR           | Contract address of the token (or sentinel address for the native token)     |
| raw\_balance\_str       | VARCHAR           | 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            | Block number of the last balance-changing activity on this date              |
| block\_hash             | VARCHAR           | Block hash of the last balance-changing activity on this date                |
| \_has\_error            | NUMBER            | Flag indicating whether an error occurred computing this balance (1 = error) |
| \_short\_address        | VARCHAR           | Truncated form of address used as a clustering key for query pruning         |
| \_short\_token\_address | VARCHAR           | Truncated form of token\_address used as a clustering key for query pruning  |