Elprognerd7 - one week before and after of Hack
Updated 2022-12-09
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
›
⌄
select 'Ethereum' as network,
CASE WHEN block_timestamp >= '2022-11-11' then 'After FTX Hack'
ELSE 'Before FTX Hack' END AS ERA,
count(distinct tx_hash) as n_swaps,
count(distinct Origin_from_address) as n_users,
count(distinct contract_address) as n_pools
--sum(n_swaps) over (order by date) as n_cumulative_swap,
--sum(Swappers_Count) over (order by date) as n_cumulative_swappers
from ethereum.core.fact_event_logs
where origin_to_address = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57'
and event_name = 'Swap'
and (block_timestamp BETWEEN '2022-11-04' AND '2022-11-18')
group by 1, 2
UNION ALL
select 'Arbitrum' as network,
CASE WHEN block_timestamp >= '2022-11-11' then 'After FTX Hack'
ELSE 'Before FTX Hack' END AS ERA,
count(distinct tx_hash) as n_swaps,
count(distinct Origin_from_address) as n_users,
count(distinct contract_address) as n_pools
from arbitrum.core.fact_event_logs
where origin_to_address = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57'
and event_name = 'Swap'
and tx_status = 'SUCCESS'
and (block_timestamp BETWEEN '2022-11-04' AND '2022-11-18')
group by 1, 2
UNION ALL
select 'Polygon' as network,
CASE WHEN block_timestamp >= '2022-11-11' then 'After FTX Hack'
ELSE 'Before FTX Hack' END AS ERA,
count(distinct tx_hash) as n_swaps,
count(distinct Origin_from_address) as n_users,
Run a query to Download Data