Query editor
with users_transaction as (select `from` as account, block_timefrom arbitrum.transactionsunionselect `to` as account, block_timefrom arbitrum.transactions),new_users_date as (select account,min(block_time) as min_block_timefrom users_transactiongroup by accountorder by 2),new_users_weekly as (select date_trunc('week', min_block_time) as block_date,count(distinct account) as new_users_countfrom new_users_dategroup by 1order by 1)select block_date,new_users_count,sum(new_users_count) over (order by block_date) as accumulate_new_users_countfrom new_users_weeklyorder by block_date