hessBlocks Compare (Min)
Updated 2022-07-27
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
›
⌄
with pol_blocks as ( select block_timestamp , lead(block_timestamp) over(order by block_number) as block , datediff('second',block_timestamp,block) as difference
from polygon.core.fact_blocks
),
eth_blocks as ( select block_timestamp , lead(block_timestamp) over(order by block_number) as block , datediff('second',block_timestamp,block) as difference
from ethereum.core.fact_blocks)
,
sol_blocks as ( select block_timestamp , lead(block_timestamp) over(order by block_id) as block , datediff('second',block_timestamp,block) as difference
from solana.core.fact_blocks)
,
arbi_blocks as ( select block_timestamp , lead(block_timestamp) over(order by block_number) as block , datediff('second',block_timestamp,block) as difference
from arbitrum.core.fact_blocks)
,
opti_blocks as ( select block_timestamp , lead(block_timestamp) over(order by block_number) as block , datediff('second',block_timestamp,block) as difference
from optimism.core.fact_blocks)
,
flow_blocks as ( select block_timestamp , lead(block_timestamp) over(order by BLOCK_HEIGHT) as block , datediff('second',block_timestamp,block) as difference
from flow.core.fact_blocks)
,
bsc_blocks as ( select block_timestamp , lead(block_timestamp) over(order by block_number) as block , datediff('second',block_timestamp,block) as difference
from bsc.core.fact_blocks)
,
ava_blocks as ( select block_timestamp , lead(block_timestamp) over(order by block_number) as block , datediff('second',block_timestamp,block) as difference
from avalanche.core.fact_blocks)
select 'Polygon' as type , min(difference) as time
from pol_blocks
where difference > 0
group by 1
UNION
select 'Ethereum' as type , min(difference) as time
from eth_blocks
where difference > 0
group by 1
UNION
select 'Solana' as type , min(difference) as time
from sol_blocks
Run a query to Download Data