SELECT
date_trunc('day',a.block_timestamp) as date,
-- a. block_id,
Avg(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as time_between_blocks
-- a.block_timestamp as T1,
-- b.block_timestamp as T2
FROM polygon.core.fact_blocks a
JOIN polygon.core.fact_blocks b
on a.block_number = b.block_number - 1
--where a.block_timestamp >= '2019-06-13'
group by date
--Order by between_block_date DESC
order by date
Limit 10