boomer77Hard AAve
Updated 2021-09-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with rate as (select date_trunc('day', block_hour) as block_day, atoken_address, avg(utilization_rate) as Utilization_Ratio,avg(borrow_rate_stable)*100 as Stable_borrow_rate,
avg(borrow_rate_variable)*100 as Variable_borrow_rate, avg(supply_rate)*100 as Supply_rate
from aave.market_stats
where aave_version = 'Aave V2' and block_day >= CURRENT_DATE - 184
group by 1,2
order by 1 desc),
symbol as (select symbol, aave_token
from aave.deposits
where symbol in ('USDC','USDT','DAI','WETH','WBTC') and aave_version = 'Aave V2'
group by 1,2)
select A.block_day, B.symbol, A.Utilization_Ratio, A.Stable_borrow_rate, A.Variable_borrow_rate, A.supply_rate
from rate A
join symbol B on A.atoken_address = B.aave_token
order by 1 desc
Run a query to Download Data