garlicPolygon Daily Block Time
    Updated 2022-07-25
    SELECT

    DATE(a.block_timestamp) as date,
    AVG(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as avg_block_time

    FROM polygon.core.fact_transactions a
    JOIN polygon.core.fact_transactions b
    ON a.block_number = b.block_number-1
    GROUP BY DATE(a.block_timestamp)
    Run a query to Download Data