select b.block_timestamp

, b.lag(block_timestamp,1) over(order by block_timestamp) as block_timestamp_lag

, b.timediff(second, block_timestamp_lag, block_timestamp) as block_timediff

, t.(TX_HASH)

from polygon.core.fact_blocks

JOIN polygon.core.fact_transactions on

b.BLOCK_NUMBER = t.BLOCK_NUMBER

order by block_timestamp

select

avg(block_timediff)

, max(block_timediff) as max_block_time

, min(block_timediff) as min_block_time

from block_time

GROUP by block_timestamp