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

date_trunc('day', date1) as date,

count(user) as "Number of Daily New Users"

from t1

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

GROUP by 1

ORDER by 1