with final as (select date(a.block_timestamp) as date,'Sei' as chain, avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time

from sei.core.fact_blocks a, sei.core.fact_blocks b

where a.block_id = b.block_id-1

and a.block_timestamp::date >= '2023-08-15'

and b.block_timestamp::date >= '2023-08-15'

group by 1,2

select date(a.block_timestamp) as date,'Osmosis' as chain, avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time

from osmosis.core.fact_blocks a, osmosis.core.fact_blocks b

where a.block_id = b.block_id-1

and a.block_timestamp::date >= '2023-08-15'

and b.block_timestamp::date >= '2023-08-15'

group by 1,2

select date(a.block_timestamp) as date,'Cosmos' as chain, avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time

from cosmos.core.fact_blocks a, cosmos.core.fact_blocks b

where a.block_id = b.block_id-1

and a.block_timestamp::date >= '2023-08-15'

and b.block_timestamp::date >= '2023-08-15'

group by 1,2

select date(a.block_timestamp) as date,'Avlanche' as chain, avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time

from avalanche.core.fact_blocks a, avalanche.core.fact_blocks b

where a.block_number = b.block_number-1

and a.block_timestamp::date >= '2023-08-15'

and b.block_timestamp::date >= '2023-08-15'

group by 1,2

select date(a.block_timestamp) as date,'Arbitrum' as chain, avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time

from arbitrum.core.fact_blocks a, arbitrum.core.fact_blocks b

where a.block_number = b.block_number-1

and a.block_timestamp::date >= '2023-08-15'

and b.block_timestamp::date >= '2023-08-15'

group by 1,2