| date | TIMESTAMP_NTZ(9) | Calendar date (UTC) this record represents. Each pool balance is carried forward from its last change to every following day until the next change. |
| project | VARCHAR(16777216) | Project slug of the DEX that owns the pool: aquarius or aqua_router (Aquarius), soroswap or sushiswap. Phoenix pools are not included because their pool tokens are not tracked. |
| protocol | VARCHAR(16777216) | Protocol identifier that qualifies the project: aquarius, soroswap or sushiswap_v3. |
| address | VARCHAR(16777216) | Liquidity pool address holding this balance. |
| liquidity_pool_address | VARCHAR(16777216) | Contract address of the liquidity pool. Same value as address. |
| token_address | VARCHAR(16777216) | Token contract id held by the pool. Pool tokens are Soroban contracts, including SAC-wrapped classic assets. |
| token_symbol | VARCHAR(16777216) | Asset code of the token (e.g. USDC), from Stellar token metadata, falling back to the asset code on the balance record. |
| token_decimals | NUMBER(38,0) | Number of decimal places of the token, from Stellar token metadata. Defaults to 7, the precision of Stellar classic assets, when metadata is missing. |
| usd_exchange_rate | FLOAT | USD price per unit of the token at 00:00 UTC on date, from Allium’s hourly Stellar prices. Used to compute usd_balance. |
| raw_balance_str | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision. Avoids floating-point truncation for tokens with very large integer balances. |
| raw_balance | FLOAT | Raw balance, string cast to float (precision-lossy for very large values; use raw_balance_str for exact amounts). |
| balance_str | VARCHAR(16777216) | Decimal-normalized balance, string-typed for precision. |
| balance | FLOAT | Decimal-normalized balance. |
| usd_balance | FLOAT | USD value of this balance, balance multiplied by usd_exchange_rate. Null if it would exceed the $10B outlier guard. |
| ledger_close_time | TIMESTAMP_NTZ(9) | Close time of the ledger containing the last balance change carried forward to this date. |
| ledger_sequence | NUMBER(38,0) | Sequence of the ledger containing the last balance change carried forward to this date. |
| ledger_hash | VARCHAR(16777216) | Hash of the ledger containing the last balance change carried forward to this date. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row, built from the pool address, token address and date. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
