Mrftieager-gray copy
    Updated 2025-02-07
    -- forked from eager-gray @ https://flipsidecrypto.xyz/studio/queries/8658df2c-0149-48f2-9194-1d048e1ffba2

    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 swell.core.fact_blocks
    GROUP BY 1
    )
    SELECT
    day,
    daily_avg_block_utilization AS "Daily Average Block Utilization (%)"
    FROM daily_block_data
    ORDER BY 1


    Last run: about 1 month ago
    DAY
    Daily Average Block Utilization (%)
    1
    2024-11-27 00:00:00.0000.0762393627
    2
    2024-11-28 00:00:00.0000.0794080625
    3
    2024-11-29 00:00:00.0000.0758533403
    4
    2024-11-30 00:00:00.0000.0762345394
    5
    2024-12-01 00:00:00.0000.0762729167
    6
    2024-12-02 00:00:00.0000.0822555671
    7
    2024-12-03 00:00:00.0000.0878299282
    8
    2024-12-04 00:00:00.0000.0827010903
    9
    2024-12-05 00:00:00.0000.0806627292
    10
    2024-12-06 00:00:00.0000.0813585486
    11
    2024-12-07 00:00:00.0000.0788123495
    12
    2024-12-08 00:00:00.0000.0819435509
    13
    2024-12-09 00:00:00.0000.0857210139
    14
    2024-12-10 00:00:00.0000.0851575116
    15
    2024-12-11 00:00:00.0000.0837540231
    16
    2024-12-12 00:00:00.0000.0803979444
    17
    2024-12-13 00:00:00.0000.080874912
    18
    2024-12-14 00:00:00.0000.0793641435
    19
    2024-12-15 00:00:00.0000.0790732153
    20
    2024-12-16 00:00:00.0000.0827602199
    73
    3KB
    2s