> ## 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   | `hyperevm.lending.tvl_daily`       |
| Table Status | Production-Ready                   |
| Unique Key   | `date`, `address`, `token_address` |

### Table Columns

| Column Name            | Data Type         | Description                                                    |
| ---------------------- | ----------------- | -------------------------------------------------------------- |
| date                   | TIMESTAMP\_NTZ(9) | Date of the TVL snapshot                                       |
| project                | VARCHAR(16777216) | Name of the lending project                                    |
| protocol               | VARCHAR(16777216) | Underlying protocol that the lending project is utilizing      |
| address                | VARCHAR(16777216) | Address of the lending market or contract                      |
| market\_address        | VARCHAR(16777216) | Address of the lending market                                  |
| token\_address         | VARCHAR(16777216) | Address of the token locked in the protocol                    |
| token\_name            | VARCHAR(16777216) | Name of the token locked in the protocol                       |
| token\_symbol          | VARCHAR(16777216) | Symbol of the token locked in the protocol                     |
| token\_decimals        | NUMBER(38,0)      | Number of decimals of the token                                |
| raw\_balance\_str      | VARCHAR(16777216) | Raw token balance in string format to retain precision         |
| raw\_balance           | FLOAT             | Raw token balance as a numeric value                           |
| balance\_str           | VARCHAR(16777216) | Normalized token balance in string format to retain precision  |
| balance                | FLOAT             | Normalized token balance as a numeric value                    |
| usd\_balance           | FLOAT             | USD value of the token balance at the time of the snapshot     |
| usd\_exchange\_rate    | FLOAT             | USD exchange rate of the token at the time of the snapshot     |
| last\_block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp of the last block included in the TVL calculation    |
| last\_block\_number    | NUMBER(38,0)      | Block number of the last block included in the TVL calculation |
| \_created\_at          | TIMESTAMP\_NTZ(9) | Timestamp of when the record was created                       |
| \_updated\_at          | TIMESTAMP\_NTZ(9) | Timestamp of when the record was last updated                  |

### Related Docs

* [EVM Lending TVL Daily](/historical-data/supported-blockchains/evm/core-schemas/lending/tvl-daily)
