SELECT
AVG(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as AVG_block_time,
MAX(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as MAX_block_time,
MIN(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as MIN_block_time, date_trunc('day', a.block_timestamp) as day
FROM polygon.core.fact_transactions a
JOIN polygon.core.fact_transactions b
on a.block_number = b.block_number - 1
GROUP BY 4