Skip to main content
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.
TableUse CaseQuestion
ERC1155 Balances EODEnd-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 DeltaEnd-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 EODEnd-of-day ERC721 balance per (address, token, token_id).What NFTs did an address hold at the end of a given day?
Fungible Balances EODEnd-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?