boomer77Top initiator
Updated 2021-09-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with ass as (select sum(flashloan_amount_usd) as Volume, sum(flashloan_amount) as Vol_token, initiator_address,
case when volume is null then vol_token
else volume
end as Final_Volume
from aave.flashloans
where flashloan_amount is not null and aave_version = 'Aave V2'
group by 3
order by 4 desc
limit 10)
select final_volume, initiator_address
from ASS
order by 1 desc
Run a query to Download Data