TVL Daily - Allium Documentation Hub

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.

select date, project, sum(usd_balance) as usd 
from ethereum.lending.tvl_daily
where project = 'aave'
group by all

Finding the total TVL of WETH across all protocol versions of Aave on Ethereum.

select
    date, 
    project, 
    protocol,,
    token_address,
    token_name, 
    sum(usd_balance) as usd 
from ethereum.lending.tvl_daily
where project = 'aave' and token_address = lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2') -- WETH Address
group by all

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
market_address	VARCHAR	Address of the lending market
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

​Sample Query

​Table Columns

Sample Query

Table Columns