garlicArbitrum Daily Block Time
Updated 2022-07-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- SELECT
-- DATE(a.block_timestamp) as date,
-- AVG(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as avg_block_time
-- FROM polygon.core.fact_transactions a
-- JOIN polygon.core.fact_transactions b
-- ON a.block_number = b.block_number-1
-- GROUP BY DATE(a.block_timestamp)
SELECT
DATE(a.block_timestamp) as date,
AVG(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as avg_block_time
FROM arbitrum.core.fact_blocks a
JOIN arbitrum.core.fact_blocks b
ON a.block_number = b.block_number-1
WHERE date >= DATE('2022-06-06')
GROUP BY DATE(a.block_timestamp)
Run a query to Download Data