> ## 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.lending.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. Used in daily aggregate tables.                                                                                                                                           |
| project             | VARCHAR(16777216) | 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            | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. `uniswap_v3`, `aave_v2`, `stargate_v2`). Qualifies the `project` field with version information.                                                                    |
| address             | VARCHAR(16777216) | Lending pool contract address holding this balance.                                                                                                                                                                   |
| market\_address     | VARCHAR(16777216) | Address of the lending market contract. For Aave this is the Pool/LendingPool address; for Compound this is the cToken contract; for Morpho this is the specific market address.                                      |
| token\_address      | VARCHAR(16777216) | Identifier of the asset held. `native` for the chain's native asset (XLM on Stellar); otherwise the asset's contract or issuer-qualified identifier.                                                                  |
| token\_symbol       | VARCHAR(16777216) | Ticker symbol of the token (e.g. "USDC", "WETH").                                                                                                                                                                     |
| token\_decimals     | NUMBER(38,0)      | Number of decimal places used to represent the token's smallest unit. Used to convert raw amounts: normalized\_amount = raw\_amount / 10^decimals. For example, USDC has 6 decimals, so 2500000 raw units = 2.5 USDC. |
| usd\_exchange\_rate | FLOAT             | USD price per unit of the token at the time of the event, used to compute `usd_amount`. Sourced from Allium's hourly price feed.                                                                                      |
| 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 i128 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, null if it would exceed the \$10B outlier guard.                                                                                                                                           |
| ledger\_close\_time | TIMESTAMP\_NTZ(9) | Timestamp (UTC) when the XRP or Stellar ledger closed and was validated by the network. Equivalent to block\_timestamp on EVM chains.                                                                                 |
| ledger\_sequence    | NUMBER(38,0)      | Stellar ledger sequence number.                                                                                                                                                                                       |
| ledger\_hash        | VARCHAR(16777216) | Hash of the XRP or Stellar ledger. Equivalent to block\_hash on EVM chains.                                                                                                                                           |
| unique\_id          | VARCHAR(16777216) | 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\_NTZ(9) | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed.                                                                                                         |
| \_updated\_at       | TIMESTAMP\_NTZ(9) | 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).                                                            |

### Related Docs

* [OTHER Lending TVL Daily](/historical-data/supported-blockchains/other-ecosystems/core-schemas/lending/tvl-daily)