bachiaave - tvl
Updated 2021-12-16Copy Reference Fork
9
1
2
3
4
›
⌄
select date_trunc(day, block_hour) as date, sum(TOTAL_LIQUIDITY_USD) - sum(TOTAL_STABLE_DEBT_USD) - sum(total_variable_debt_usd) as aave_TVL,
sum(TOTAL_LIQUIDITY_USD) as aave_SUPPLY, aave_version from aave.market_stats
where date > dateadd(MONTH, -6, getdate()) and reserve_name <> 'AAVE'
group by aave_version, date order by date desc
Run a query to Download Data