with near_txs as (SELECT MAX(timediff) as "Maximum recorded seconds between two blocks", MIN(timediff) as "Minimum recorded seconds between two blocks", AVG(timediff) as "Average recorded seconds between two 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-06-01' AND block_timestamp <= '2022-07-28' ORDER BY 1) WHERE timediff < 1000), flow_txs as (SELECT MAX(timediff) as "Maximum recorded seconds between two blocks", MIN(timediff) as "Minimum recorded seconds between two blocks", AVG(timediff) as "Average recorded seconds between two 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-06-01' AND block_timestamp <= '2022-07-28' ORDER BY 1) WHERE timediff < 1000), -- solana_txs as (SELECT MAX(timediff) as "Maximum recorded seconds between two blocks", MIN(timediff) as "Minimum recorded seconds between two blocks" FROM -- (SELECT block_timestamp, DATEDIFF('second', block_timestamp, LAG(block_timestamp) OVER (ORDER BY block_timestamp)) as timediff FROM solana.core.fact_blocks WHERE block_timestamp >= '2022-06-01' AND block_timestamp >= '2022-07-28' ORDER BY 1) WHERE timediff < 1000 AND timediff IS NOT NULL ), eth_txs as (SELECT MAX(timediff) as "Maximum recorded seconds between two blocks", MIN(timediff) as "Minimum recorded seconds between two blocks", AVG(timediff) as "Average recorded seconds between two 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-06-01' AND block_timestamp <= '2022-07-28' ORDER BY 1) WHERE timediff < 1000), polygon_txs as (SELECT MAX(timediff) as "Maximum recorded seconds between two blocks", MIN(timediff) as "Minimum recorded seconds between two blocks", AVG(timediff) as "Average recorded seconds between two 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-06-01' AND block_timestamp <= '2022-07-28' ORDER BY 1) WHERE timediff < 1000), avax_txs as (SELECT MAX(timediff) as "Maximum recorded seconds between two blocks", MIN(timediff) as "Minimum recorded seconds between two blocks", AVG(timediff) as "Average recorded seconds between two blocks" FROM (SELECT block_timestamp, DATEDIFF('second', LAG(block_timestamp) OVER (ORDER BY block_timestamp), block_timestamp) as timediff FROM avalanche.core.fact_blocks WHERE block_timestamp >= '2022-06-01' AND block_timestamp <= '2022-07-28' ORDER BY 1) WHERE timediff < 1000), arb_txs as (SELECT MAX(timediff) as "Maximum recorded seconds between two blocks", MIN(timediff) as "Minimum recorded seconds between two blocks", AVG(timediff) as "Average recorded seconds between two 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-06-01' AND block_timestamp <= '2022-07-28' ORDER BY 1) WHERE timediff < 1000), op_txs as (SELECT MAX(timediff) as "Maximum recorded seconds between two blocks", MIN(timediff) as "Minimum recorded seconds between two blocks", AVG(timediff) as "Average recorded seconds between two 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-06-01' AND block_timestamp <= '2022-07-28' ORDER BY 1) WHERE timediff < 1000) SELECT 'Near' as name, "Maximum recorded seconds between two blocks", "Minimum recorded seconds between two blocks", "Average recorded seconds between two blocks" FROM near_txs UNION SELECT 'Flow' as name, "Maximum recorded seconds between two blocks", "Minimum recorded seconds between two blocks", "Average recorded seconds between two blocks" FROM flow_txs UNION SELECT 'Ethereum' as name, "Maximum recorded seconds between two blocks", "Minimum recorded seconds between two blocks", "Average recorded seconds between two blocks" FROM eth_txs UNION SELECT 'Polygon' as name, "Maximum recorded seconds between two blocks", "Minimum recorded seconds between two blocks", "Average recorded seconds between two blocks" FROM polygon_txs UNION SELECT 'Avax' as name, "Maximum recorded seconds between two blocks", "Minimum recorded seconds between two blocks", "Average recorded seconds between two blocks" FROM avax_txs UNION -- SELECT 'Solana' as name, "Maximum recorded seconds between two blocks", "Minimum recorded seconds between two blocks" FROM solana_txs -- UNION SELECT 'Arbitrum' as name, "Maximum recorded seconds between two blocks", "Minimum recorded seconds between two blocks", "Average recorded seconds between two blocks" FROM arb_txs UNION SELECT 'Optimism' as name, "Maximum recorded seconds between two blocks", "Minimum recorded seconds between two blocks", "Average recorded seconds between two blocks" FROM op_txs

Time recorded between blocks