date_trunc('day',a.block_timestamp) as date,

avg(datediff(second, a.block_timestamp,b.block_timestamp)) as avg_time_diff

FROM flow.core.fact_blocks a, flow.core.fact_blocks b

WHERE a.block_height = b.block_height -1

AND date <= CURRENT_DATE-1

AND datediff(second, a.block_timestamp,b.block_timestamp) >0 --AND date != '2021-03-10'

GROUP BY date

ORDER by date