block_id,

block_timestamp,

LAG(block_timestamp) over (order by block_id) as previous_block_time

FROM algorand.block

where block_id > 0 )

Select

block_id,

block_timestamp,

previous_block_time,

min(datediff('seconds', previous_block_time, block_timestamp)) as seconds_between_blocks

from block_times

group by 1,2,3

order by 4 asc

limit 100