REPORT_DATE | DAILY_BLOCKS | BLOCK_TIME_SECONDS | |
|---|---|---|---|
1 | 2025-05-26 00:00:00.000 | 50823 | 1.7 |
2 | 2025-05-25 00:00:00.000 | 84027 | 1.03 |
3 | 2025-05-24 00:00:00.000 | 72919 | 1.18 |
4 | 2025-05-23 00:00:00.000 | 83032 | 1.04 |
5 | 2025-05-22 00:00:00.000 | 84802 | 1.02 |
6 | 2025-05-21 00:00:00.000 | 86153 | 1 |
7 | 2025-05-20 00:00:00.000 | 86262 | 1 |
8 | 2025-05-19 00:00:00.000 | 86492 | 1 |
9 | 2025-05-18 00:00:00.000 | 83587 | 1.03 |
10 | 2025-05-17 00:00:00.000 | 44001 | 1.96 |
11 | 2025-05-16 00:00:00.000 | 33861 | 2.55 |
12 | 2025-05-15 00:00:00.000 | 18425 | 4.69 |
13 | 2025-05-14 00:00:00.000 | 13996 | 6.17 |
14 | 2025-05-13 00:00:00.000 | 14548 | 5.94 |
15 | 2025-05-12 00:00:00.000 | 23316 | 3.71 |
16 | 2025-05-11 00:00:00.000 | 7240 | 11.93 |
17 | 2025-05-10 00:00:00.000 | 57421 | 1.5 |
18 | 2025-05-09 00:00:00.000 | 53863 | 1.6 |
19 | 2025-05-08 00:00:00.000 | 14571 | 5.93 |
20 | 2025-05-07 00:00:00.000 | 14180 | 6.09 |
yasmin DAILY_BLOCKS
Updated 5 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH block_data AS (
SELECT
data.value [0] :: STRING AS raw_date_string,
data.value [1] :: INTEGER AS block_count
FROM
TABLE(
FLATTEN(
PARSE_JSON(
livequery.live.udf_api(
'GET',
'https://api.routescan.io/v2/network/mainnet/evm/43419/aggregations/blocks',
{'accept': 'application/json'}, NULL
) : data ) )) data )
SELECT
TO_DATE(raw_date_string) AS report_date,
block_count AS daily_blocks ,
ROUND(86400 / block_count, 2) AS block_time_seconds
FROM
block_data
ORDER BY
report_date DESC;
Last run: 5 days ago
75
3KB
3s