Date | Average Block Utilization (%) | LAG_UTILIZATION | Block Utilization Change % | |
---|---|---|---|---|
1 | 2024-12-30 00:00:00.000 | 51.3821749338 | 51.197811853 | 0.36 |
2 | 2024-12-23 00:00:00.000 | 51.197811853 | 51.4181312774 | -0.43 |
3 | 2024-12-16 00:00:00.000 | 51.4181312774 | 51.3644495053 | 0.1 |
4 | 2024-12-09 00:00:00.000 | 51.3644495053 | 50.7373946085 | 1.24 |
5 | 2024-12-02 00:00:00.000 | 50.7373946085 | 51.2185124304 | -0.94 |
6 | 2024-11-25 00:00:00.000 | 51.2185124304 | 51.4759746245 | -0.5 |
7 | 2024-11-18 00:00:00.000 | 51.4759746245 | 50.9821049739 | 0.97 |
8 | 2024-11-11 00:00:00.000 | 50.9821049739 | 50.8849942409 | 0.19 |
9 | 2024-11-04 00:00:00.000 | 50.8849942409 | 48.1156851786 | 5.76 |
10 | 2024-10-28 00:00:00.000 | 48.1156851786 | 51.0011103053 | -5.66 |
11 | 2024-10-21 00:00:00.000 | 51.0011103053 | 50.980549461 | 0.04 |
12 | 2024-10-14 00:00:00.000 | 50.980549461 | 49.0480581974 | 3.94 |
13 | 2024-10-07 00:00:00.000 | 49.0480581974 | 44.1957955993 | 10.98 |
14 | 2024-09-30 00:00:00.000 | 44.1957955993 | 42.6602632725 | 3.6 |
15 | 2024-09-23 00:00:00.000 | 42.6602632725 | 27.3400639555 | 56.04 |
16 | 2024-09-16 00:00:00.000 | 27.3400639555 | 28.4314156138 | -3.84 |
17 | 2024-09-09 00:00:00.000 | 28.4314156138 | 25.6038112837 | 11.04 |
18 | 2024-09-02 00:00:00.000 | 25.6038112837 | 27.0792399394 | -5.45 |
19 | 2024-08-26 00:00:00.000 | 27.0792399394 | 22.7930162525 | 18.8 |
20 | 2024-08-19 00:00:00.000 | 22.7930162525 | 19.3267007465 | 17.94 |
Mrftivictorious-purple
Updated 2025-02-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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
berachain.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 1 month ago
31
2KB
4s