date_trunc('{{granularity}}', a.block_timestamp) as date,

'Base' as chain,

avg(datediff(second, a.block_timestamp,b.block_timestamp)) as avg_time_diff

FROM base.core.fact_blocks a, base.core.fact_blocks b

WHERE a.block_number = b.block_number-1

AND date < CURRENT_DATE

AND date >= dateadd(day, -{{past_days}}, current_date())

GROUP BY date

UNION all

SELECT

date_trunc('{{granularity}}', a.block_timestamp) as date,

'Arbitrum' as chain,

avg(datediff(second, a.block_timestamp,b.block_timestamp)) as avg_time_diff

FROM arbitrum.core.fact_blocks a, arbitrum.core.fact_blocks b

WHERE a.block_number = b.block_number-1

AND date < CURRENT_DATE

AND date >= dateadd(day, -{{past_days}}, current_date())

GROUP BY date