date_trunc('day', first_transaction_stamp) as date,

type,

count (distinct sender) as new_users,

sum(new_users) over (partition by type order by date) as cum_new_users

from (

select

distinct t.signers[0] as sender,

l.LABEL_TYPE as type,

min(block_timestamp) as first_transaction_stamp

from solana.core.fact_events t join solana.core.dim_labels l on t.PROGRAM_ID = l.address

where t.block_timestamp>='2023-01-01'

and l.label_subtype != 'token_contract'

and l.LABEL_TYPE in ('defi','nft','dex')

and l.label != 'solana'

and t.succeeded = TRUE

group by 1,2

)

group by 1,2