Mrftivictorious-purple
    Updated 2025-02-05
    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
    Date
    Average Block Utilization (%)
    LAG_UTILIZATION
    Block Utilization Change %
    1
    2024-12-30 00:00:00.00051.382174933851.1978118530.36
    2
    2024-12-23 00:00:00.00051.19781185351.4181312774-0.43
    3
    2024-12-16 00:00:00.00051.418131277451.36444950530.1
    4
    2024-12-09 00:00:00.00051.364449505350.73739460851.24
    5
    2024-12-02 00:00:00.00050.737394608551.2185124304-0.94
    6
    2024-11-25 00:00:00.00051.218512430451.4759746245-0.5
    7
    2024-11-18 00:00:00.00051.475974624550.98210497390.97
    8
    2024-11-11 00:00:00.00050.982104973950.88499424090.19
    9
    2024-11-04 00:00:00.00050.884994240948.11568517865.76
    10
    2024-10-28 00:00:00.00048.115685178651.0011103053-5.66
    11
    2024-10-21 00:00:00.00051.001110305350.9805494610.04
    12
    2024-10-14 00:00:00.00050.98054946149.04805819743.94
    13
    2024-10-07 00:00:00.00049.048058197444.195795599310.98
    14
    2024-09-30 00:00:00.00044.195795599342.66026327253.6
    15
    2024-09-23 00:00:00.00042.660263272527.340063955556.04
    16
    2024-09-16 00:00:00.00027.340063955528.4314156138-3.84
    17
    2024-09-09 00:00:00.00028.431415613825.603811283711.04
    18
    2024-09-02 00:00:00.00025.603811283727.0792399394-5.45
    19
    2024-08-26 00:00:00.00027.079239939422.793016252518.8
    20
    2024-08-19 00:00:00.00022.793016252519.326700746517.94
    31
    2KB
    4s