date_trunc('month', block_timestamp) as month,

project_name,

count(distinct(tx_hash)) as tx_num,

count(distinct(tx_signer)) as signers_num,

count(distinct(tx_receiver)) as receivers_num

from near.core.fact_transactions a

join near.core.dim_address_labels b

on a.tx_receiver = b.address

where l2_label in ('distributor_cex_satellite', 'distributor_cex')

and tx_status = 'Success'

group by 1, 2

order by 3 desc