boomer77Average Supply Rate Daily V2
Updated 2021-09-01
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc('day', block_hour) as block_day,
aave_market,
case when aave_market = '0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48' then 'USDC'
else 'USDT'
end as Token,
(avg(supply_rate)*100) as interest_rate_supply
from aave.market_stats
where aave_market in ('0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48', '0XDAC17F958D2EE523A2206206994597C13D831EC7')
and block_day >= CURRENT_DATE - 184 and aave_version = 'Aave V2'
group by 1,2,3
order by 1 desc
Run a query to Download Data