mattkstewAAVE 2
Updated 2023-01-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
sum(LIQUIDATED_AMOUNT_USD),
avg(LIQUIDATED_AMOUNT_USD),
max(LIQUIDATED_AMOUNT_USD),
count(distinct LIQUIDATOR),
count(distinct BORROWER)
from ethereum.aave.ez_flashloans left outer join ethereum.aave.ez_liquidations
on ethereum.aave.ez_flashloans.tx_hash = ethereum.aave.ez_liquidations.tx_hash
where LIQUIDATED_AMOUNT_USD < 1e9
Run a query to Download Data