Sbhn_NPrate 2
Updated 2023-03-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select 'Stable Rate' as type,
count(DISTINCT tx_hash) as borrows,
count(DISTINCT borrower_address) as users,
sum(borrowed_usd) as volume_usd
from ethereum.aave.ez_borrows
where block_timestamp >= CURRENT_DATE - {{Date}}
and borrow_rate_mode = 'Stable Rate'
group by 1
UNION ALL
select 'Variable Rate' as type,
count(DISTINCT tx_hash) as borrows,
count(DISTINCT borrower_address) as users,
sum(borrowed_usd) as volume_usd
from ethereum.aave.ez_borrows
where block_timestamp >= CURRENT_DATE - {{Date}}
and borrow_rate_mode = 'Variable Rate'
group by 1
Run a query to Download Data