kitlunaBlock Performance
Updated 2022-07-22
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
›
⌄
SELECT
'Polygon' AS Blockchain,
AVG (a."Time Between Blocks") AS "Average Time Between Blocks",
MAX (a."Time Between Blocks") AS "Maximum Time Between Blocks",
Min (a."Time Between Blocks") AS "Minimum Time Between Blocks",
AVG (a.TX_COUNT) AS "Average Transactions Per Block",
MAX (a.TX_COUNT) AS "Maximum Transactions Per Block"
FROM (
SELECT
BLOCK_NUMBER,
TX_COUNT,
DATEDIFF(second, LAG(block_timestamp) OVER (ORDER BY BLOCK_NUMBER), block_timestamp) AS "Time Between Blocks"
FROM polygon.core.fact_blocks
WHERE BLOCK_TIMESTAMP BETWEEN '2022-06-23' AND '2022-07-21') a
UNION
SELECT
'Ethereum' AS Blockchain,
AVG (a."Time Between Blocks") AS "Average Time Between Blocks",
MAX (a."Time Between Blocks") AS "Maximum Time Between Blocks",
Min (a."Time Between Blocks") AS "Minimum Time Between Blocks",
AVG (a.TX_COUNT) AS "Average Transactions Per Block",
MAX (a.TX_COUNT) AS "Maximum Transactions Per Block"
FROM (
SELECT
BLOCK_NUMBER,
TX_COUNT,
DATEDIFF(second, LAG(block_timestamp) OVER (ORDER BY BLOCK_NUMBER), block_timestamp) AS "Time Between Blocks"
FROM ethereum.core.fact_blocks
WHERE BLOCK_TIMESTAMP BETWEEN '2022-06-23' AND '2022-07-21') a
UNION
SELECT
'Solana' AS Blockchain,
Run a query to Download Data