trunc(block_timestamp,'day') as days,

label_type,

count(distinct tx_to) as number_contracts, --tx_to to count # programs

count(distinct tx_id) as number_tx

from solana.core.fact_transfers a left join solana.core.dim_labels b on (a.tx_to = b.address)

where

trunc(block_timestamp,'day') >= '2022-01-01'

and trunc(block_timestamp,'day') < CURRENT_DATE

and label_type !=''

and label_type !='nft'

group by 1, 2

order by 1