TVL Daily

The ethereum.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