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

Query	Creator	Created
flow blocto fees flow	thegreatestpunk	Jul 13, 2022
nba top shots daily flow topshot nft	thegreatestpunk	Jul 26, 2022
blocks flow arbitrum ethereum optimism polygon	thegreatestpunk	Jul 28, 2022
flow l1 users flow ethereum solana evm	thegreatestpunk	Jul 20, 2022
blocto fees total stats flow	thegreatestpunk	Jul 13, 2022

thegreatestpunk