flipside

    conscious-aqua
    Echo5577conscious-aqua
    Updated 2025-05-12
    SELECT
    TO_CHAR(DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR), 'Month YYYY') AS month_name,
    SUM(UNIQUE_PAYLOAD_FUNCTION_COUNT) AS unique_payload_functions
    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: 20 days ago
    MONTH_NAME
    UNIQUE_PAYLOAD_FUNCTIONS
    1
    		Janth 2025225898
    2
    		Febth 2025203906
    3
    		Marth 2025234797
    4
    		Aprth 2025221039
    5
    		Mayth 202585726
    5
    110B
    3s