SELECT date_trunc('month',block_timestamp) as date,

label_type,

project_name,

count (DISTINCT TX_SIGNER) as active_users,

count(DISTINCT tx_hash) as txs

from near.core.fact_transactions a join near.core.dim_address_labels b on a.TX_RECEIVER=b.address

where date <'2024-08-01'

group by 1,2,3