select tx_sender as New_User,

min (date_trunc('week', block_timestamp)) as week

from terra.core.fact_transactions

group by 1),

new_users as (select week,

count (distinct new_user) as New_Users,

sum (new_users) over (order by week) as Total_Users

from newtable t2

group by 1

order by 1),

active as (select

date_trunc('week', block_timestamp) as week,

count(distinct(tx_sender)) as active_users

from terra.core.fact_transactions

group by week

select * from new_users

join active using (week)