select

min(block_timestamp) as arriving_day

,from_address

from optimism.core.fact_transactions

group by 2

),

cum_optimism as (

select

date_trunc('day',arriving_day) as arrival

,count(from_address) as new_users

from op_arrive

group by 1

),

optimism as (

select

arrival

,new_users

,sum(new_users) over (order by arrival asc rows between unbounded preceding and current row) as users_overtime

,'Optimism' as Blockchain

from cum_optimism

),

pol_arrive as (

select

min(block_timestamp) as arriving_day

,from_address

from polygon.core.fact_transactions

group by 2

),

cum_polygon as (

select

date_trunc('day',arriving_day) as arrival