CryptoLionCopy of aave flashloans
Updated 2021-08-31
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
35
36
›
⌄
with addys as (
select
block_timestamp,
tx_id,
target_address,
aave_market,
symbol,
flashloan_amount_usd as flash_volume,
premium_amount_usd as premium_amount
from aave.flashloans
where block_timestamp >= getdate() - interval '1 month'
-- group by 1,2
-- order by 1 desc
)
select
addys.tx_id,
contract_name,
contract_address,
event_name,
target_address,
case
when event_name = 'Swap' then
case
when contract_name like '%UNI-V2%' or contract_name like '%UniswapV2%' or contract_name like '%uniswap v2%' then 'UNI V2'
when contract_name like '%UNI-V3%' or contract_name like '%UniswapV3%' then 'UNI V3'
when contract_name like '%SLP%' or contract_name like '%sushi%' then 'sushi'
when contract_name is null then 'UNKNOWN'
when contract_name = 'Vault' then 'Balancer'
when contract_name = 'Root' then 'SyUSD'
else contract_name end
when event_name = 'RepayBorrow' then
'compound'
when event_name = 'TokenExchange' or event_name = 'DODOSwap' or event_name like '%LimitOrder%' then
case
when contract_name like '%curv%' then 'curve.fi'
else contract_name end
Run a query to Download Data