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