/*
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! */