DAY | Daily Average Block Utilization (%) | |
|---|---|---|
1 | 2025-01-07 00:00:00.000 | 0.0012559474 |
2 | 2025-01-08 00:00:00.000 | 0.0019362294 |
3 | 2025-01-09 00:00:00.000 | 0.0033224626 |
4 | 2025-01-10 00:00:00.000 | 0.0310354975 |
5 | 2025-01-11 00:00:00.000 | 0.0001297698 |
6 | 2025-01-12 00:00:00.000 | 0.0002444025 |
7 | 2025-01-13 00:00:00.000 | 0.0013972879 |
8 | 2025-01-14 00:00:00.000 | 0.0010085794 |
9 | 2025-01-15 00:00:00.000 | 0.0033786111 |
10 | 2025-01-16 00:00:00.000 | 0.003545668 |
11 | 2025-01-17 00:00:00.000 | 0.0015858525 |
12 | 2025-01-18 00:00:00.000 | 0.0002698618 |
13 | 2025-01-19 00:00:00.000 | 0.0007414552 |
14 | 2025-01-20 00:00:00.000 | 0.0004777626 |
15 | 2025-01-21 00:00:00.000 | 0.0017983181 |
16 | 2025-01-22 00:00:00.000 | 0.0009380584 |
17 | 2025-01-23 00:00:00.000 | 0.0088060491 |
18 | 2025-01-24 00:00:00.000 | 1.9711820748 |
19 | 2025-01-25 00:00:00.000 | 0.0004523539 |
20 | 2025-01-26 00:00:00.000 | 0.00068447 |
Mrftidirty-crimson
Updated 2025-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH daily_block_data AS
(
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
AVG(GAS_USED / NULLIF(GAS_LIMIT, 0)) * 100 AS daily_avg_block_utilization
FROM monad.testnet.fact_blocks
GROUP BY 1
)
SELECT
day,
daily_avg_block_utilization AS "Daily Average Block Utilization (%)"
FROM daily_block_data
where day > '2025-01-01 00:00:00.000'
ORDER BY 1
Last run: about 2 months ago
...
207
8KB
6s