flipside

    shaky-tomato
    Echo5577shaky-tomato
    Updated 2025-05-12
    WITH monthly_data AS (
    SELECT
    DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR) AS month_block_time,
    TO_CHAR(DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR), 'Month YYYY') AS month_name,
    SUM(TRANSACTION_COUNT) AS total_transactions
    FROM
    aptos.stats.ez_core_metrics_hourly
    WHERE
    YEAR(BLOCK_TIMESTAMP_HOUR) = YEAR(CURRENT_DATE()) AND
    MONTH(BLOCK_TIMESTAMP_HOUR) <= 9 -- Filter for months up to September
    GROUP BY
    month_block_time
    )

    SELECT
    month_name,
    total_transactions
    FROM
    monthly_data
    ORDER BY
    month_block_time; -- Ordering by the truncated month time



    Last run: 19 days ago
    MONTH_NAME
    TOTAL_TRANSACTIONS
    1
    		Janth 2025169950601
    2
    		Febth 2025116981743
    3
    		Marth 2025125327245
    4
    		Aprth 2025121741359
    5
    		Mayth 202542676852
    5
    125B
    3s