with projectsTb as (

select

address,

project_name as project,

label_type

from

near.core.dim_address_labels

where

project_name is not null

and label_type not in ('chadmin', 'cex', 'token', 'fungible_token')

and project_name != 'Exchanges'

),

near_new_users as (

select

tx_signer,

min(BLOCK_TIMESTAMP) as min_date

from

near.core.fact_transactions

where

tx_signer not in (

select

address

from

projectsTb

)

GROUP BY

1

),

all_near_new_users as (

select

count(distinct tx_signer) as n_near_users

from

near_new_users

),

new_usersTb as (