select block_timestamp as date1,

lag (block_timestamp) over (order by block_timestamp) as date2,

datediff (second,date2,date1) as Diff

from blast.core.fact_blocks

where block_timestamp >= '2024-02-29 00:00:00.000')

select avg(Diff),

min(Diff),

max(Diff)

from t1