h4wkspeed comparison block time 2
Updated 2025-03-04
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
›
⌄
-- forked from speed comparison block time @ https://flipsidecrypto.xyz/edit/queries/cda97aa2-96ed-4b1c-96b9-4a82be65d64f
-- ETH
with eth_block as (
select BLOCK_NUMBER, block_timestamp,
datediff (second, lag(block_timestamp, 1) over (order by block_timestamp asc), block_timestamp) as block_time
from ethereum.core.fact_blocks where block_timestamp > '2023-08-01'
order by block_number
)
, eth_final as (
select
'Ethereum' as chain,
-- date_trunc ('day', block_timestamp) as dates,
avg (block_time) as avg_block_time
from eth_block
group by 1
)
-- Polygon
, polygon_block as (
select BLOCK_NUMBER, block_timestamp,
datediff (second, lag(block_timestamp, 1) over (order by block_timestamp asc), block_timestamp) as block_time
from polygon.core.fact_blocks where block_timestamp > '2023-08-01'
order by block_number
)
, polygon_final as (
select
'Polygon' as chain,
-- date_trunc ('day', block_timestamp) as dates,
avg (block_time) as avg_block_time
from polygon_block
group by 1
)
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived