maybeyonastop_liquidated_peeps
Updated 2021-11-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- select count(*) from (
select
borrower,
-- collateral_token_symbol,
sum(liquidated_amount_usd) as liquidated_amount_usd,
sum(debt_to_cover_amount_usd) as debt_to_cover_amount_usd
from aave.liquidations
where
-- collateral_token_symbol is not null
liquidated_amount_usd is not null
and debt_to_cover_amount_usd is not null
group by 1--,2
order by debt_to_cover_amount_usd desc
limit 20
-- limit 100
-- )
Run a query to Download Data