ArioBitcoin Current Block Time
Updated 2024-11-11
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
›
⌄
SELECT
*
FROM
(
SELECT
AVG(block_time) AS "Curreny Avg Block Time"
FROM
(
SELECT DISTINCT
block_timestamp,
block_number,
DATEDIFF('MINUTE', LAG(block_timestamp, 1) OVER (ORDER BY block_number ASC), block_timestamp) AS block_time
FROM
bitcoin.core.fact_blocks
) a
WHERE
DATE_TRUNC('DAY', block_timestamp) >= DATE_TRUNC('DAY', CURRENT_TIMESTAMP() - INTERVAL '3 DAY')
ORDER BY
1 DESC
LIMIT
1
)
QueryRunArchived: QueryRun has been archived