Lending
TVL Daily
Lending
TVL Daily
The lending.tvl_daily table contains daily total value locked (TVL) for lending protocols, providing a comprehensive view of the assets locked in these protocols over time.
This table offers daily snapshots of TVL across major lending protocols, broken down by token, enabling analysis of protocol growth, token distribution, and market trends.
Table Columns
Unique Key: date, address, token_address
| Column | Data Type | Description |
|---|---|---|
| date | DATE | Date of the TVL snapshot |
| project | VARCHAR | Name of the lending project |
| protocol | VARCHAR | Underlying protocol that the lending project is utilizing |
| address | VARCHAR | Address of the lending market or contract |
| token_address | VARCHAR | Address of the token locked in the protocol |
| token_name | VARCHAR | Name of the token locked in the protocol |
| token_symbol | VARCHAR | Symbol of the token locked in the protocol |
| token_decimals | INTEGER | Number of decimals of the token |
| raw_balance_str | VARCHAR | Raw token balance in string format to retain precision |
| raw_balance | FLOAT | Raw token balance as a numeric value |
| balance_str | VARCHAR | 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 | INTEGER | 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 |