with polygon as (select max(timediff) as max_time_between_blocks, min(timediff) as min_time_between_blocks, avg(timediff) as avg_time_between_blocks from (select block_timestamp, datediff('second', lag(block_timestamp) over (order by block_timestamp), block_timestamp) as timediff from polygon.core.fact_blocks where block_timestamp >= '2022-05-01' and block_timestamp < '2022-07-28' order by 1) where timediff < 300), arb as (select max(timediff) as max_time_between_blocks, min(timediff) as min_time_between_blocks, avg(timediff) as avg_time_between_blocks from (select block_timestamp, datediff('second', lag(block_timestamp) over (order by block_timestamp), block_timestamp) as timediff from arbitrum.core.fact_blocks where block_timestamp >= '2022-05-01' and block_timestamp < '2022-07-28' order by 1) where timediff < 300), op as (select max(timediff) as max_time_between_blocks, min(timediff) as min_time_between_blocks, avg(timediff) as avg_time_between_blocks from (select block_timestamp, datediff('second', lag(block_timestamp) over (order by block_timestamp), block_timestamp) as timediff from optimism.core.fact_blocks where block_timestamp >= '2022-05-01' and block_timestamp < '2022-07-28' order by 1) where timediff < 300), near as (select max(timediff) as max_time_between_blocks, min(timediff) as min_time_between_blocks, avg(timediff) as avg_time_between_blocks from (select block_timestamp, datediff('second', lag(block_timestamp) over (order by block_timestamp), block_timestamp) as timediff from flipside_prod_db.mdao_near.blocks where block_timestamp >= '2022-05-01' and block_timestamp < '2022-07-28' order by 1) where timediff < 300), flow as (select max(timediff) as max_time_between_blocks, min(timediff) as min_time_between_blocks, avg(timediff) as avg_time_between_blocks from (select block_timestamp, datediff('second', lag(block_timestamp) over (order by block_timestamp), block_timestamp) as timediff from flow.core.fact_blocks where block_timestamp >= '2022-05-01' and block_timestamp < '2022-07-28' order by 1) where timediff < 300), eth as (select max(timediff) as max_time_between_blocks, min(timediff) as min_time_between_blocks, avg(timediff) as avg_time_between_blocks from (select block_timestamp, datediff('second', lag(block_timestamp) over (order by block_timestamp), block_timestamp) as timediff from ethereum.core.fact_blocks where block_timestamp >= '2022-05-01' and block_timestamp < '2022-07-28' order by 1) where timediff < 300) select 'polygon' as blockchain, max_time_between_blocks, min_time_between_blocks, avg_time_between_blocks from polygon union select 'arbitrum' as blockchain, max_time_between_blocks, min_time_between_blocks, avg_time_between_blocks from arb union select 'optimism' as blockchain, max_time_between_blocks, min_time_between_blocks, avg_time_between_blocks from op union select 'near' as blockchain, max_time_between_blocks, min_time_between_blocks, avg_time_between_blocks from near union select 'flow' as blockchain, max_time_between_blocks, min_time_between_blocks, avg_time_between_blocks from flow union select 'ethereum' as blockchain, max_time_between_blocks, min_time_between_blocks, avg_time_between_blocks from eth

thegreatestpunk