with lst_new_user as (
select
TX_SENDER
,min(BLOCK_TIMESTAMP) as min_date
from terra.core.fact_transactions
where block_timestamp::date>='2022-12-25' and block_timestamp::date<='2022-12-31'
and TX_SUCCEEDED=true
group by 1
)
select
count(tx_sender) as new_users
,count(tx_sender)/7 as avg_new_user_week
from lst_new_user