jackguyTop Contracts by Use In Aave Flashloans
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
WITH tab1 as (
SELECT
tx_hash,
FLASHLOAN_AMOUNT_USD as flashloan_volume_usd,
PREMIUM_AMOUNT_USD as fee_volume_usd
FROM ethereum.aave.ez_flashloans
WHERE FLASHLOAN_AMOUNT_USD < 100000000000
--GROUP BY 1
)
SELECT
ADDRESS_NAME,
events,
volume
FROM (
SELECT
contract_address,
count(DISTINCT tab1.tx_hash) as events,
sum(FLASHLOAN_VOLUME_USD) as volume
FROM ethereum.core.fact_event_logs
LEFT outer JOIN tab1
ON tab1.tx_hash = ethereum.core.fact_event_logs.tx_hash
WHERE ethereum.core.fact_event_logs.tx_hash in (SELECT tx_hash from tab1)
--AND not event_name in ('Approval', 'Transfer')
GROUP BY 1
ORDER BY 2 DESC
LIMIT 1500
) LEFT outer JOIN ethereum.core.dim_labels
ON address = contract_address
HAVING not ADDRESS_NAME is NULL
ORDER BY 2 DESC
Run a query to Download Data