Updated 2025-01-26
    WITH fee_data AS (
    SELECT
    DAYNAME(BLOCK_TIMESTAMP) AS day,
    HOUR(BLOCK_TIMESTAMP) AS hour,
    AVG(TX_FEE) AS avg_fee,
    MAX(TX_FEE) - MIN(TX_FEE) AS fee_volatility
    FROM
    flow.core_evm.fact_transactions
    GROUP BY
    day, hour
    )

    SELECT
    day AS "DAY",
    hour AS "HOUR",
    avg_fee AS "AVG FEE",
    fee_volatility AS " fee volatility"
    FROM
    fee_data
    ORDER BY
    CASE day
    WHEN 'Sun' THEN 1
    WHEN 'Mon' THEN 2
    WHEN 'Tue' THEN 3
    WHEN 'Wed' THEN 4
    WHEN 'Thu' THEN 5
    WHEN 'Fri' THEN 6
    WHEN 'Sat' THEN 7
    END, hour;







    Last run: 20 days ago
    DAY
    HOUR
    AVG FEE
    fee volatility
    1
    Sun00.00010151696640.01209505
    2
    Sun10.00009928659980.007198675
    3
    Sun20.00010223929790.010378995
    4
    Sun30.000080959274660.00631279
    5
    Sun40.000063878996960.01209505
    6
    Sun50.000096135426510.0086469435
    7
    Sun60.000083296134580.010378995
    8
    Sun70.00012022125520.007198015
    9
    Sun80.000068297172140.010378995
    10
    Sun90.000067929511010.01077208
    11
    Sun100.00009302880880.00631345
    12
    Sun110.000088907068320.01209505
    13
    Sun120.00004834860060.007198675
    14
    Sun130.000048678547950.002658106
    15
    Sun140.000042740852650.002536446
    16
    Sun150.000048845431990.002658106
    17
    Sun160.000053524571890.002536446
    18
    Sun170.000059106458250.004579585
    19
    Sun180.000061197623360.002658106
    20
    Sun190.000061317110160.002658106
    ...
    168
    6KB
    2s