DHOUR | LABEL | BLOCKS | |
|---|---|---|---|
1 | 2025-02-19 00:00:00.000 | Non-Empty | 254 |
2 | 2025-02-19 00:00:00.000 | Empty | 6944 |
3 | 2025-02-19 01:00:00.000 | Empty | 6295 |
4 | 2025-02-19 01:00:00.000 | Non-Empty | 910 |
5 | 2025-02-19 02:00:00.000 | Non-Empty | 1034 |
6 | 2025-02-19 02:00:00.000 | Empty | 6173 |
7 | 2025-02-19 03:00:00.000 | Non-Empty | 718 |
8 | 2025-02-19 03:00:00.000 | Empty | 6506 |
9 | 2025-02-19 04:00:00.000 | Empty | 5997 |
10 | 2025-02-19 04:00:00.000 | Non-Empty | 1212 |
11 | 2025-02-19 05:00:00.000 | Non-Empty | 1148 |
12 | 2025-02-19 05:00:00.000 | Empty | 6057 |
13 | 2025-02-19 06:00:00.000 | Non-Empty | 2603 |
14 | 2025-02-19 06:00:00.000 | Empty | 4226 |
15 | 2025-02-19 07:00:00.000 | Empty | 4408 |
16 | 2025-02-19 07:00:00.000 | Non-Empty | 2025 |
17 | 2025-02-19 08:00:00.000 | Non-Empty | 1268 |
18 | 2025-02-19 08:00:00.000 | Empty | 5351 |
19 | 2025-02-19 09:00:00.000 | Non-Empty | 2212 |
20 | 2025-02-19 09:00:00.000 | Empty | 4444 |
TheLaughingManhourly - block_metrics
Updated 2025-02-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with base as (
SELECT
date_trunc('hour', block_timestamp) as dhour
, CASE WHEN tx_count=0 THEN 'Empty' ELSE 'Non-Empty' END as label
, COUNT(*) as blocks
from monad.testnet.fact_blocks
WHERE 1=1
AND block_timestamp>='2025-02-19'
GROUP by 1, 2
)
SELECT * from base
ORDER by dhour ASC
Last run: 17 days ago
...
399
16KB
2s