mattkstewAAVE 0
Updated 2023-01-10
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
›
⌄
with tab1 as (
select
to_address as "Contract Address",
sum(FLASHLOAN_AMOUNT_USD) as "Flashloan Volume USD"
from ethereum.aave.ez_flashloans left outer join ethereum.core.fact_transactions
on ethereum.aave.ez_flashloans.tx_hash = ethereum.core.fact_transactions.tx_hash
where FLASHLOAN_AMOUNT_USD < 1e9
group by 1
order by 2 desc
)
select
name,
"Flashloan Volume USD"
from tab1 left outer join ethereum.core.dim_contracts_extended
on "Contract Address" = CONTRACT_ADDRESS
where name is not null
and name not like 'DSProxy'
and name not like 'InstaAccountV2'
and name not like 'AaveMonitorV2'
order by 2 desc
limit 100
Run a query to Download Data