Overview

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?

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Overview