cypherTBB leading up to the merge
Updated 2022-09-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with data as (select block_number, block_timestamp, tx_count,
lead(block_timestamp, 1, null) over (order by block_number desc) as prev_block_time,
abs(datediff('second', block_timestamp, prev_block_time)) as seconds_between_blocks
from ethereum.core.fact_blocks
where block_timestamp >= current_date() - 7
and block_timestamp <= '2022-9-14')
select
date_trunc('hour', block_timestamp) as hour,
avg(seconds_between_blocks) as avg_tbb
from data
group by hour
Run a query to Download Data