'eth' as chain

, min(block_timestamp) as first_block

, max(block_timestamp) as last_block

from ethereum.core.fact_blocks

union all

select

'arb' as chain

, min(block_timestamp) as first_block

, max(block_timestamp) as last_block

from arbitrum.core.fact_blocks

union all

select

'avax' as chain

, min(block_timestamp) as first_block

, max(block_timestamp) as last_block

from avalanche.core.fact_blocks

union all

select

'bsc' as chain

, min(block_timestamp) as first_block

, max(block_timestamp) as last_block

from bsc.core.fact_blocks

union all

select

'opt' as chain

, min(block_timestamp) as first_block

, max(block_timestamp) as last_block

from optimism.core.fact_blocks

union all

select

'polygon' as chain

, min(block_timestamp) as first_block

, max(block_timestamp) as last_block

from polygon.core.fact_blocks

union all