boomer77liquidity aave
Updated 2021-09-15
9
1
2
3
4
5
6
7
8
9
›
⌄
with market as (select date_trunc('day', block_hour) as block_day, reserve_name as assets,
avg(total_liquidity_usd) as supply, avg(total_stable_debt_usd) as stabledebt, avg(total_variable_debt_usd) as variabledebt
from aave.market_stats
where block_day >= CURRENT_DATE - 365 and total_liquidity_usd is not null
group by 1,2)
select *, (supply - stabledebt - variabledebt) as Liquidity
from market
where liquidity > 0
Run a query to Download Data