poly_base1 as (select first_block_number + 1 as second_block_number, block_timestamp from poly_base),

poly_info as (select ft.block_number as bn, timestampdiff('SECOND', poly_base1.BLOCK_TIMESTAMP, poly_base.block_timestamp) AS time_diff

from polygon.core.fact_transactions ft

inner join poly_base on poly_base.first_block_number = ft.block_number

inner join poly_base1 on poly_base1.second_block_number = ft.block_number),

arbi_base as (select block_number as first_block_number, block_timestamp from arbitrum.core.fact_transactions),

arbi_base1 as (select first_block_number + 1 as second_block_number, block_timestamp from arbi_base),

arbi_info as (select ft.block_number as bn, timestampdiff('SECOND', arbi_base1.BLOCK_TIMESTAMP, arbi_base.block_timestamp) AS time_diff

from arbitrum.core.fact_transactions ft

inner join arbi_base on arbi_base.first_block_number = ft.block_number

inner join arbi_base1 on arbi_base1.second_block_number = ft.block_number),

opti_base as (select block_number as first_block_number, block_timestamp from optimism.core.fact_transactions),

opti_base1 as (select first_block_number + 1 as second_block_number, block_timestamp from opti_base),

opti_info as (select ft.block_number as bn, timestampdiff('SECOND', opti_base1.BLOCK_TIMESTAMP, opti_base.block_timestamp) AS time_diff

from optimism.core.fact_transactions ft

inner join opti_base on opti_base.first_block_number = ft.block_number

inner join opti_base1 on opti_base1.second_block_number = ft.block_number),

avalanche_base as (select block_number as first_block_number, block_timestamp from avalanche.core.fact_transactions),

avalanche_base1 as (select first_block_number + 1 as second_block_number, block_timestamp from avalanche_base),

avalanche_info as (select ft.block_number as bn, timestampdiff('SECOND', avalanche_base1.BLOCK_TIMESTAMP, avalanche_base.block_timestamp) AS time_diff

from avalanche.core.fact_transactions ft

inner join avalanche_base on avalanche_base.first_block_number = ft.block_number

inner join avalanche_base1 on avalanche_base1.second_block_number = ft.block_number),

Flow_base as (select block_height as first_block_number, block_timestamp from flow.core.fact_transactions),

Flow_base1 as (select first_block_number + 1 as second_block_number, block_timestamp from Flow_base),

Flow_info as (select ft.block_height as bn, timestampdiff('SECOND', Flow_base1.BLOCK_TIMESTAMP, Flow_base.block_timestamp) AS time_diff

from flow.core.fact_transactions ft

inner join Flow_base on Flow_base.first_block_number = ft.block_height

inner join Flow_base1 on Flow_base1.second_block_number = ft.block_height),

BSC_base as (select block_number as first_block_number, block_timestamp from bsc.core.fact_transactions),