alessio9567Hourly number of Polygon transactions since January 1st 2023
    Updated 2023-02-20
    SELECT date_trunc('hour',block_timestamp) hourt
    ,COUNT(DISTINCT tx_hash) hourly_transactions
    ,AVG(hourly_transactions) OVER(ORDER BY hourt) AS hourly_moving_average
    FROM polygon.core.fact_transactions
    WHERE block_timestamp >= '2023-01-01'
    GROUP BY 1

    Run a query to Download Data