CryptoIcicleETH Merge: Actually Good? - Block Level 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
35
36
›
⌄
-- 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 tpb as (
select
type,
min(n_txns_block) as min_tpb,
median(n_txns_block) as median_tpb,
avg(n_txns_block) as avg_tpb,
max(n_txns_block) as max_tpb,
min(gas_block) as min_gpb,
median(gas_block) as median_gpb,
avg(gas_block) as avg_gpb,
max(gas_block) as max_gpb,
min(diff_sec) as min_diff,
median(diff_sec) as median_diff,
avg(diff_sec) as avg_diff,
max(diff_sec) as max_diff
from(
select
Run a query to Download Data