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)