Date | Average Block Utilization (%) | LAG_UTILIZATION | Block Utilization Change % | |
|---|---|---|---|---|
1 | 2025-07-28 00:00:00.000 | 8.0463454323 | 7.9220382743 | 1.57 |
2 | 2025-07-21 00:00:00.000 | 7.9220382743 | 9.0463406831 | -12.43 |
3 | 2025-07-14 00:00:00.000 | 9.0463406831 | 8.3233042243 | 8.69 |
4 | 2025-07-07 00:00:00.000 | 8.3233042243 | 8.2986205366 | 0.3 |
5 | 2025-06-30 00:00:00.000 | 8.2986205366 | 7.5153895034 | 10.42 |
6 | 2025-06-23 00:00:00.000 | 7.5153895034 | 6.3529332585 | 18.3 |
7 | 2025-06-16 00:00:00.000 | 6.3529332585 | 6.8462722308 | -7.21 |
8 | 2025-06-09 00:00:00.000 | 6.8462722308 | 6.8710086933 | -0.36 |
9 | 2025-06-02 00:00:00.000 | 6.8710086933 | 7.2622539314 | -5.39 |
10 | 2025-05-26 00:00:00.000 | 7.2622539314 | 8.0631959301 | -9.93 |
11 | 2025-05-19 00:00:00.000 | 8.0631959301 | 11.5705750717 | -30.31 |
12 | 2025-05-12 00:00:00.000 | 11.5705750717 | 8.4555861263 | 36.84 |
13 | 2025-05-05 00:00:00.000 | 8.4555861263 | 9.5150990458 | -11.14 |
14 | 2025-04-28 00:00:00.000 | 9.5150990458 | 11.6977048259 | -18.66 |
15 | 2025-04-21 00:00:00.000 | 11.6977048259 | 10.6893027113 | 9.43 |
16 | 2025-04-14 00:00:00.000 | 10.6893027113 | 10.7032040872 | -0.13 |
17 | 2025-04-07 00:00:00.000 | 10.7032040872 | 11.7947041997 | -9.25 |
18 | 2025-03-31 00:00:00.000 | 11.7947041997 | 11.5461353501 | 2.15 |
19 | 2025-03-24 00:00:00.000 | 11.5461353501 | 10.9770015 | 5.18 |
20 | 2025-03-17 00:00:00.000 | 10.9770015 | 11.7831292316 | -6.84 |
MrftiMonad Average Block Utilization
Updated 2025-07-31
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
›
⌄
-- forked from victorious-purple @ https://flipsidecrypto.xyz/studio/queries/ef85a9ab-2953-4e08-81a5-8ba24c35abfc
WITH block_data AS (
SELECT
date_trunc({{period_type}}, block_timestamp) AS "Date",
AVG(GAS_USED / NULLIF(GAS_LIMIT, 0)) * 100 AS "Average Block Utilization (%)"
FROM
monad.testnet.fact_blocks
WHERE
BLOCK_TIMESTAMP::date >= '{{start_day}}'
AND date_trunc({{period_type}}, BLOCK_TIMESTAMP) <= '{{target_day}}'
GROUP BY 1
)
SELECT
"Date",
AVG("Average Block Utilization (%)") AS "Average Block Utilization (%)",
LAG(AVG("Average Block Utilization (%)")) OVER (ORDER BY "Date") AS lag_utilization,
ROUND(100 * (AVG("Average Block Utilization (%)") - lag_utilization) / NULLIF(lag_utilization, 0), 2) AS "Block Utilization Change %"
FROM block_data
GROUP BY 1
ORDER BY 1 DESC
Last run: about 2 months ago
24
1KB
6s