with monthly_new_users as (

select

date_trunc('month', block_timestamp) as time,

label_type as category,

project_name as protocol,

count(distinct from_address) as new_users,

from arbitrum.core.fact_transactions as transactions

left join arbitrum.core.dim_labels labels on transactions.to_address = labels.address

where block_timestamp >= dateadd(month, -1, date_trunc('month',current_date()))

and block_timestamp < date_trunc('month', current_date())

and nonce = 0

and category in ('cex')

and status = 'SUCCESS'

group by 1,2,3

)

select

from monthly_new_users

order by 4 desc