piperPolygon - Polygon Block Performance: Average Number of TX per day (All)
    Updated 2022-07-24
    /*
    Polygon - Polygon Block Performance

    What is the average time between blocks on Polygon?

    What was the maximum and minimum recorded time between two blocks?
    How many transactions are done in a block on average? How do these
    numbers compare to L1 such as Flow or Solana, or other L2 such as
    Arbitrum or Optimism?

    */

    WITH all_blocks AS (
    SELECT
    block_timestamp::date AS date,
    block_number,
    count(tx_hash) AS number_of_tx
    FROM
    polygon.core.fact_transactions
    WHERE
    block_timestamp BETWEEN '2022-06-23' AND '2022-07-23'
    GROUP BY date, block_number
    )

    SELECT
    date,
    count(block_number) AS number_of_blocks,
    avg(number_of_tx) AS avg_number_of_tx
    FROM
    all_blocks
    GROUP BY date
    ORDER BY date ASC

    /* The End! */
    Run a query to Download Data