apostleoffinanceTop 10 AAVE Liquidation
Updated 2022-10-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
⌄
--Top 10 AAVE Liquidation
SELECT
liquidator,
liquidated_amount,
liquidated_amount_usd,
date_trunc('day', block_timestamp) AS timing
FROM ethereum.aave.ez_liquidations
WHERE timing > CURRENT_DATE - 365
AND liquidated_amount_usd IS NOT NULL
GROUP BY 1,2,3,4
ORDER BY 3 DESC LIMIT 10;
--Query Total Flashloans per Assets/token
SELECT
SYMBOL,
SUM(FLASHLOAN_AMOUNT_USD) AS Total_FLASHLOAN_USD
FROM ethereum.aave.ez_flashloans
WHERE AAVE_VERSION = 'Aave V2'
GROUP BY 1
ORDER BY 2 DESC
Run a query to Download Data