CryptoIcicleETH Merge: Actually Good? - Swap metrics
Updated 2022-09-30
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
›
⌄
-- ETH Merge: Actually Good?
-- Recently, ETH devs and observers have opined on Twitter regarding whether the Merge was good or bad for the Ethereum network. We want you to prove one side or the other, with the help of Flipside data.
-- Pay by Quality Your score determines your final payout.
-- Grand Prize 112.5 USDC (A score of 11 or 12 earns you a Grand Prize title)
-- Payout 75 USDC
-- Score Multiplier0-7 : 0% 8 : 50% 9 : 75% 10 : 100% 11 : 125% 12 : 150%
-- Payout Network Ethereum
-- Level Intermediate
-- Difficulty Hard
-- Recently, ETH devs and observers have opined on Twitter regarding whether the Merge was good or bad for the Ethereum network.
-- We want you to prov11e one side or the other, with the help of Flipside data.
-- Demonstrate whether the Merge had positive or negative effects on the network.
-- Include least three queries and visualizations in your submission.
with
txns as (
select
*
from ethereum.core.ez_dex_swaps
where (block_number >= 15537351 - {{n_blocks}} and block_number <= 15537351 + {{n_blocks}})
)
select
date_trunc('day', block_timestamp) as date,
iff(block_number < 15537351, 'before', 'after') as category,
concat(platform,'::',category) as type,
count(distinct origin_from_address) as n_users,
count(distinct tx_hash) as tx_frequency,
sum(n_users) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_n_users,
sum(tx_frequency) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_tx_frequency
from txns
group by date, category, type
Run a query to Download Data