HOUR | BLOCK_COUNT | TOTAL_TRANSACTIONS | AVG_TPB | MAX_TPB | MIN_TPB | TPB_STDDEV | |
|---|---|---|---|---|---|---|---|
1 | 2024-02-24 00:00:00.000 | 4693 | 4692 | 1 | 1 | 1 | 0 |
2 | 2024-02-25 00:00:00.000 | 43200 | 43207 | 1.000162 | 2 | 1 | 0.01272792206 |
3 | 2024-02-26 00:00:00.000 | 43200 | 43217 | 1.000394 | 2 | 1 | 0.0198242276 |
4 | 2024-02-27 00:00:00.000 | 43200 | 43272 | 1.001667 | 3 | 1 | 0.04191658383 |
5 | 2024-02-28 00:00:00.000 | 43200 | 43904 | 1.016296 | 7 | 1 | 0.1344172608 |
6 | 2024-02-29 00:00:00.000 | 43200 | 435613 | 10.083634 | 289 | 1 | 12.752963969 |
7 | 2024-03-01 00:00:00.000 | 43200 | 855464 | 19.802407 | 384 | 1 | 11.85133001 |
8 | 2024-03-02 00:00:00.000 | 43200 | 550450 | 12.741898 | 126 | 1 | 5.706970124 |
9 | 2024-03-03 00:00:00.000 | 43200 | 520551 | 12.049792 | 189 | 1 | 5.39376566 |
10 | 2024-03-04 00:00:00.000 | 43200 | 476026 | 11.01912 | 195 | 1 | 5.815305495 |
11 | 2024-03-05 00:00:00.000 | 43200 | 360079 | 8.335162 | 194 | 1 | 4.338295748 |
12 | 2024-03-06 00:00:00.000 | 43200 | 459008 | 10.625185 | 340 | 1 | 13.647155161 |
13 | 2024-03-07 00:00:00.000 | 43200 | 311896 | 7.219815 | 223 | 1 | 3.81070361 |
14 | 2024-03-08 00:00:00.000 | 43200 | 273933 | 6.341042 | 108 | 1 | 3.015943468 |
15 | 2024-03-09 00:00:00.000 | 43200 | 245980 | 5.693981 | 99 | 1 | 2.818426334 |
16 | 2024-03-10 00:00:00.000 | 43200 | 244213 | 5.653079 | 75 | 1 | 2.478900966 |
17 | 2024-03-11 00:00:00.000 | 43200 | 247957 | 5.739745 | 121 | 1 | 2.855011384 |
18 | 2024-03-12 00:00:00.000 | 43200 | 241528 | 5.590926 | 47 | 1 | 2.532041271 |
19 | 2024-03-13 00:00:00.000 | 43200 | 210601 | 4.875023 | 432 | 1 | 5.619834695 |
20 | 2024-03-14 00:00:00.000 | 43200 | 308097 | 7.131875 | 103 | 1 | 4.182080344 |
rezarwzTPB
Updated 2025-04-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH t AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS hour,
COUNT(*) AS block_count,
SUM(tx_count) AS total_transactions,
AVG(tx_count) AS avg_tpb,
MAX(tx_count) AS max_tpb,
MIN(tx_count) AS min_tpb,
STDDEV(tx_count) AS tpb_stddev
FROM
blast.core.fact_blocks
GROUP BY
DATE_TRUNC('day', block_timestamp)
)
SELECT
*
FROM
t
ORDER BY
hour ASC
Last run: 17 days agoAuto-refreshes every 24 hours
...
405
27KB
2s