Sbhn_NPrates2
Updated 2023-03-09
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select date_trunc('{{Date}}',block_hour) as date,
case when reserve_name = 'MKR' then 'MKR'
when reserve_name = 'SNX' then 'SNX'
when reserve_name = 'UNI' then 'UNI'
end as token,
sum(borrow_rate_variable) as variable,
sum(borrow_rate_stable) as stable
from ethereum.aave.ez_market_stats
where reserve_name in ('MKR','SNX','UNI')
group by 1,2
Run a query to Download Data