Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| date | End-of-day date (UTC) of the balance snapshot. | |
| project | Business name of the protocol being used (e.g. uniswap, aave, lido, paraswap). Consistent across verticals — every table with a project column uses this field to identify the top-level protocol brand. | |
| protocol | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. | |
| version | Schema version discriminator. | |
| chain | Slug identifying the blockchain this record belongs to (e.g. ethereum, base, avalanche, solana). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. | |
| address_type | Component of protocol-controlled value: settlement_pools, core_olp_vault, or treasury. | |
| token_address | Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address. | |
| token_symbol | Ticker symbol of the token (e.g. “USDC”, “WETH”). | |
| balance | Sum of end-of-day token balances for this address_type. | |
| balance_usd | Sum of end-of-day USD balances for this address_type (a TVL component). | |
| address_count | Number of distinct addresses of this address_type holding the token on this date. | |
| unique_id | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. | |
| _created_at | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. | |
| _updated_at | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |