scottincryptoEIP1559 Peak Block Sizes
Updated 2021-08-06
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
›
⌄
with pre_query as (
select
date_trunc('hour', block_timestamp) as hr,
block_id,
sum(gas_used) as post_eip1559_gas_per_block,
0 as pre_eip1559_gas_per_block
from ethereum.TRANSACTIONs
where block_id >= 12965000
group by 1,2
union all
select
date_trunc('hour', block_timestamp) as hr,
block_id,
0 as post_eip1559_gas_per_block,
sum(gas_used) as pre_eip1559_gas_per_block
from ethereum.TRANSACTIONs
where block_id < 12965000
and block_timestamp > '2021-08-05'
and block_timestamp < '2021-08-05T12:00:00Z'
group by 1,2
)
select
hr,
max(post_eip1559_gas_per_block) as post_eip1559_max_gas,
max(pre_eip1559_gas_per_block) as pre_eip1559_max_gas
from pre_query
group by 1
order by 1
Run a query to Download Data