select

trunc(block_timestamp,'day') as date,

label_type as sector,

count(distinct signers[0]) as active_users,

sum(1) as transactions

from solana.core.fact_events x

join solana.core.dim_labels y on x.program_id=y.address

where block_timestamp>=current_date - interval '1 MONTH'

group by 1,2 order by 1 asc