select tx_sender,

min (date_trunc(week, blocK_timestamp))::date as min_date

from terra.core.fact_transactions

group by 1

),

t2 as (

select min_date as week,

count (distinct tx_sender) as new_users_count

from t1

group by 1

select avg (new_users_count) as average_new_users_count

from t2