Lending
TVL Daily
The lending.tvl_daily
contains the daily total value locked (TVL) for lending project by token.
For a lending protocol, the may be multiple protocols, e.g. Aave V1, V2, v3.
Each protocol can have a different market address (address
) that holds tokens that contribute to the total TVL of the project.
We do not include assets that are being lent out to borrowers in the total TVL calculation. The TVL calculation only includes assets that are being held in the protocol.
Sample Query
Finding the daily TVL of Aave on Ethereum, we group by date
and project
.
Finding the total TVL of WETH across all protocol versions of Aave on Ethereum.
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 |