mlhUntitled Query
Updated 2022-07-23Copy Reference Fork
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
›
⌄
with polygon as (
select min(datediff(second, table_1.block_timestamp, table_2.block_timestamp)) AS min_difference
from polygon.core.fact_blocks table_1 join polygon.core.fact_blocks table_2
on table_1.block_number = table_2.block_number - 1
),
solana as (
select min(datediff(second, table_1.block_timestamp, table_2.block_timestamp)) AS min_difference
from solana.core.fact_blocks table_1 join solana.core.fact_blocks table_2
on table_1.block_id = table_2.block_id - 1
),
ethereum as(
select min(datediff(second, table_1.block_timestamp, table_2.block_timestamp)) AS min_difference
from ethereum.core.fact_blocks table_1 join ethereum.core.fact_blocks table_2
on table_1.block_number = table_2.block_number - 1
),
arbitrum as(
select min(datediff(second, table_1.block_timestamp, table_2.block_timestamp)) AS min_difference
from arbitrum.core.fact_blocks table_1 join arbitrum.core.fact_blocks table_2
on table_1.block_number = table_2.block_number - 1
)
select *, 'Polygon' as Chain from polygon union
select *, 'Ethereum' as Chain from ethereum union
select *, 'Solana' as Chain from solana union
select *, 'Arbitrum' as Chain from arbitrum
Run a query to Download Data