date_trunc('week', first_tx) as date,

project,

count(DISTINCT tx_signer) as new_users

FROM (

SELECT

tx_signer,

b.project_name as project,

min(block_timestamp) as first_tx

FROM near.core.fact_transactions a

LEFT JOIN near.core.dim_address_labels b

ON a.tx_receiver = b.address

WHERE b.project_name is not null

GROUP BY 1 , 2 )

WHERE date > dateadd('month', -{{last_n_month}}, current_date)

AND date < current_date

GROUP BY 2 , 1

ORDER BY 1 DESC