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

# TVL Daily

### Table Details

| Property | Value |
| - | - |
| Table Name | `stellar.dex.tvl_daily` |
| Table Status | Production-Ready |
| Unique Key | `date`, `address`, `token_address` |
| Clustering Key(s) | `date, project` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| 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. |