adriaparcerisasfba 1
Updated 2023-03-09
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
--How many unique borrowers of SNX, UNI, & MKR are there on Aave V2?
--What is total cumulative borrow for each asset on Aave V2?
--Can you visualize borrowing of each asset over time?
SELECT
distinct symbol,
count(distinct tx_hash) as borrowing_actions,
count(distinct borrower_address) as unique_borrowers,
sum(borrowed_usd) as total_borrowed_volume
from ethereum.aave.ez_borrows where symbol in ('SNX','UNI','MKR')
and aave_version = 'Aave V2'
group by 1 order by 2 desc
Run a query to Download Data