select

block_number,

block_timestamp

from polygon.core.fact_blocks

where mod(block_number::int, 2) = 1

and block_timestamp::date <= current_date - 1

order by block_number desc

limit 1000000

),

polygon_even_block as (

select

block_number,

block_timestamp

from polygon.core.fact_blocks

where mod(block_number::int, 2) = 0

and block_timestamp::date <= current_date - 1

order by block_number desc

limit 1000000

),

polygon_block_time_difference as (

select

odd.block_number as block_odd,

odd.block_timestamp as time_odd,

even.block_number as block_even,

even.block_timestamp time_even,

datediff('second', time_odd, time_even) as block_time_difference

from polygon_odd_block odd

join polygon_even_block even

on (even.block_number::int) = ((odd.block_number::int) + 1)

where time_odd <= time_even

),

ethereum_odd_block as (

select

block_number,

block_timestamp