LABEL_TYPE,

COUNT(DISTINCT tx_id) as "total transaction count",

COUNT(DISTINCT TX_FROM) as "total user count",

sum(amount) as "total volume",

avg(amount) as "average volume"

FROM solana.core.fact_transfers a LEFT OUTER JOIN solana.core.dim_labels b on a.TX_FROM = b.address

WHERE block_timestamp >= CURRENT_DATE - 31

and block_timestamp <= CURRENT_DATE - 1

and MINT ilike 'So11111111111111111111111111111111111111112'

and LABEL_TYPE is not null

GROUP by 1