from arbitrum.core.fact_transactions where from_address != '0x0000000000000000000000000000000000000000'

union

select to_address as user , block_timestamp

from arbitrum.core.fact_transactions where to_address != '0x0000000000000000000000000000000000000000'),

new_users as

(select user, min(block_timestamp) as min_time

from users_tx group by 1 having min(block_timestamp) >= '2022-07-01'

order by 2),

new_users_daily as (select date_trunc('day', min_time) as day , count(distinct user) as new_users_count

from new_users group by 1 order by 1)

select day, new_users_count as Number_of_New_Wallets,

sum(new_users_count) over (order by day) as CUM_Number_of_New_Wallets

from new_users_daily order by day