Soheil_MKUntitled Query
Updated 2022-07-24
999
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 polygon_Blocks as (
SELECT
block_number as block_number,
block_timestamp as block_timestamp,
datediff(second, lag(block_timestamp,1,block_timestamp)
over (order by block_number), block_timestamp) as time_diff
from polygon.core.fact_blocks
group by 1,2
order by block_number
),
flow_Blocks as (
SELECT
BLOCK_HEIGHT as block_number,
block_timestamp as block_timestamp,
datediff(second, lag(block_timestamp,1,block_timestamp)
over (order by block_number), block_timestamp) as time_diff
from flow.core.fact_blocks
group by 1,2
order by block_number
),
solana_Blocks as (
SELECT
BLOCK_ID as block_number,
block_timestamp as block_timestamp,
datediff(second, lag(block_timestamp,1,block_timestamp)
over (order by block_number), block_timestamp) as time_diff
from solana.core.fact_blocks
group by 1,2
order by block_number
),
Arbitrum_Blocks as (
SELECT
BLOCK_NUMBER as block_number,
Run a query to Download Data