flipside

    enchanting-silver
    Echo5577enchanting-silver
    Updated 2025-05-12
    SELECT
    TO_CHAR(DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR), 'Month YYYY') AS month_name,
    CASE
    WHEN SUM(TRANSACTION_COUNT) > 0 THEN
    SUM(TOTAL_FEES_NATIVE) / SUM(TRANSACTION_COUNT)
    ELSE 0
    END AS average_transaction_fee
    FROM
    aptos.stats.ez_core_metrics_hourly
    WHERE
    YEAR(BLOCK_TIMESTAMP_HOUR) = YEAR(CURRENT_DATE())
    AND MONTH(BLOCK_TIMESTAMP_HOUR) <= 9 -- To include only months up to September

    GROUP BY
    DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR), -- Group by the same expression used in the SELECT
    month_name
    ORDER BY
    DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR); -- Order by the same expression


    Last run: 21 days ago
    MONTH_NAME
    AVERAGE_TRANSACTION_FEE
    1
    		Janth 202515131.878753
    2
    		Febth 202516728.764039
    3
    		Marth 202515246.876643
    4
    		Aprth 202510993.304702
    5
    		Mayth 20258780.132378
    5
    140B
    3s