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

# Overview

> Intermediate, unhydrated end-of-day balance tables before token-metadata and USD enrichment.

The unhydrated schema holds intermediate end-of-day balance tables. Balances are computed here but token metadata and USD values are added downstream in the hydrated `assets` tables. Columns prefixed with `_` are internal helpers used for clustering and query pruning.

| Table                          | Use Case                                                                  | Question                                                           |
| ------------------------------ | ------------------------------------------------------------------------- | ------------------------------------------------------------------ |
| **ERC1155 Balances EOD**       | End-of-day ERC1155 balance per (address, token, token\_id).               | What ERC1155 tokens did an address hold at the end of a given day? |
| **ERC1155 Balances EOD Delta** | End-of-day net change in ERC1155 balance per (address, token, token\_id). | How did an address's ERC1155 balance change on a given day?        |
| **ERC721 Balances EOD**        | End-of-day ERC721 balance per (address, token, token\_id).                | What NFTs did an address hold at the end of a given day?           |
| **Fungible Balances EOD**      | End-of-day raw fungible (native & ERC20) balance per (address, token).    | What was an address's raw token balance at the end of a given day? |