t1 as (

select

distinct tx_signer as user,

min(block_timestamp) as date1

from near.core.fact_transactions

where tx_status = 'Success'

group by 1

)

select

count(user) as "Number of New Users"

from t1

where date1 BETWEEN '{{From}}' and DATEADD(DAY, 7, '{{From}}')