date(block_timestamp) as dates,

COUNT(DISTINCT block_number) as number_of_blocks,

AVG(tx_count) as average_tx_count,

AVG(gas_used) as average_gas_used,

24 * 60 * 60 / number_of_blocks as average_blocks_per_second

FROM polygon.core.fact_blocks

WHERE network = 'mainnet'

GROUP BY dates

ORDER BY dates ASC

LIMIT 1000