superflyGeneral table for comparison
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
›
⌄
---How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
----This table compares these four blockchains
WITH BASIC_Polygon AS (
SELECT BLOCK_NUMBER,BLOCK_TIMESTAMP,lag(BLOCK_TIMESTAMP) OVER (order BY BLOCK_NUMBER ASC) Previous_block_time
FROM polygon.core.fact_blocks-----i us tael orginal polu for us data
WHERE date_trunc('day',BLOCK_TIMESTAMP)>=dateadd('month',-{{Months}},CURRENT_DATE())
ORDER BY BLOCK_NUMBER ASC),
BASIC_Solana AS (SELECT BLOCK_HEIGHT,BLOCK_TIMESTAMP,lag(BLOCK_TIMESTAMP) OVER (order BY BLOCK_HEIGHT ASC) Previous_block_time
FROM solana.core.fact_blocks---i us general tabel sol
WHERE date_trunc('day',BLOCK_TIMESTAMP)>=dateadd('month',-{{Months}},CURRENT_DATE())
ORDER BY BLOCK_HEIGHT ASC),
BASIC_arbitrum AS (SELECT BLOCK_NUMBER,BLOCK_TIMESTAMP,lag(BLOCK_TIMESTAMP) OVER (order BY BLOCK_NUMBER ASC) Previous_block_time
FROM arbitrum.core.fact_blocks----i us general tabel arbi
WHERE date_trunc('day',BLOCK_TIMESTAMP)>=dateadd('month',-{{Months}},CURRENT_DATE())
ORDER BY BLOCK_NUMBER ASC),
BASIC_optimism AS (SELECT BLOCK_NUMBER,BLOCK_TIMESTAMP,lag(BLOCK_TIMESTAMP) OVER (order BY BLOCK_NUMBER ASC) Previous_block_time
FROM optimism.core.fact_blocks-----i us general tabel opti
WHERE date_trunc('day',BLOCK_TIMESTAMP)>=dateadd('month',-{{Months}},CURRENT_DATE())
ORDER BY BLOCK_NUMBER ASC),
A_Polygon AS (SELECT *,DATEDIFF('SECOND',Previous_block_time,BLOCK_TIMESTAMP) time_between_two_blocks
FROM BASIC_Polygon ORDER BY BLOCK_NUMBER ASC),
A_Solana AS (SELECT *,DATEDIFF('SECOND',Previous_block_time,BLOCK_TIMESTAMP) time_between_two_blocks
FROM BASIC_Solana ORDER BY BLOCK_HEIGHT ASC),
A_arbitrum AS
(SELECT *,DATEDIFF('SECOND',Previous_block_time,BLOCK_TIMESTAMP) time_between_two_blocks
FROM BASIC_arbitrum
ORDER BY BLOCK_NUMBER ASC),
A_optimism AS (SELECT *,DATEDIFF('SECOND',Previous_block_time,BLOCK_TIMESTAMP) time_between_two_blocks
FROM BASIC_optimism
ORDER BY BLOCK_NUMBER ASC)
SELECT max(time_between_two_blocks) max,min(time_between_two_blocks) minimum,AVG(time_between_two_blocks) avg,'Polygon' blockChains
FROM A_Polygon UNION SELECT max(time_between_two_blocks) max,min(time_between_two_blocks) minimum,AVG(time_between_two_blocks) avg,'Arbitrum' blockChains
FROM A_arbitrum UNION SELECT max(time_between_two_blocks) max,min(time_between_two_blocks) minimum,AVG(time_between_two_blocks) avg,'Optimism' blockChains
FROM A_optimism UNION SELECT max(time_between_two_blocks) max,min(time_between_two_blocks) minimum,AVG(time_between_two_blocks) avg,'Solana' blockChains FROM A_Solana
Run a query to Download Data