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

AVG(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as AVG_block_time_defference

FROM ethereum.core.fact_blocks a

JOIN ethereum.core.fact_blocks b

on a.BLOCK_NUMBER= b.BLOCK_NUMBER - 1

where day >= '2022-06-01'

group by 1