block_timestamp as block_timestamp,

block_number,lag(block_timestamp,1) over( order by block_timestamp) as scnds,

datediff(second,scnds,block_timestamp) as seconds

from polygon.core.fact_blocks

group by 1,2)

select

block_timestamp::date as date,

max(seconds) as max_seconds,

min(seconds) as min_seconds,

avg(seconds) as avg_seconds

from times where seconds>0

group by 1