Zanyar_98Average block time (second) in the last 1M blocks
Updated 2022-07-26
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_BLOCK_NUMBER AS
(SELECT BLOCK_NUMBER "Block number", BLOCK_TIMESTAMP
FROM polygon.core.fact_blocks
ORDER BY "Block number" DESC LIMIT 1000000 ),
Polygon_BLOCK_NUMBER_PLUS_ONE AS
( SELECT "Block number" + 1 "Block number plus 1" , BLOCK_TIMESTAMP AS "Previous block TIMESTAMP"
FROM Polygon_BLOCK_NUMBER),
Polygon_Block_time AS
(SELECT AVG(DATEDIFF(second, "Previous block TIMESTAMP", BLOCK_TIMESTAMP)) AS Block_time
FROM Polygon_BLOCK_NUMBER
JOIN Polygon_BLOCK_NUMBER_PLUS_ONE ON "Block number" = "Block number plus 1"),
---------------------------------------------------Ethereum---------------------------------------------------
Ethereum_BLOCK_NUMBER AS
(SELECT BLOCK_NUMBER "Block number", BLOCK_TIMESTAMP
FROM ethereum.core.fact_blocks
ORDER BY "Block number" DESC LIMIT 1000000 ),
Ethereum_BLOCK_NUMBER_PLUS_ONE AS
( SELECT "Block number" + 1 "Block number plus 1" , BLOCK_TIMESTAMP AS "Previous block TIMESTAMP"
FROM Ethereum_BLOCK_NUMBER),
Ethereum_Block_time AS
(SELECT AVG(DATEDIFF(second, "Previous block TIMESTAMP", BLOCK_TIMESTAMP)) AS Block_time
FROM Ethereum_BLOCK_NUMBER
JOIN Ethereum_BLOCK_NUMBER_PLUS_ONE ON "Block number" = "Block number plus 1"),
---------------------------------------------------Solana---------------------------------------------------
solana_BLOCK_NUMBER AS
(SELECT BLOCK_ID "Block number", BLOCK_TIMESTAMP
FROM solana.core.fact_blocks
ORDER BY "Block number" DESC LIMIT 1000000 ),
Run a query to Download Data