DATE_TRUNC('day', block_timestamp) as date,

count(distinct signers[0]) as user_count,

case when ADDRESS_NAME in ('Raydium Stake', 'Raydium Liquidity Pool V4', 'Raydium Stake V5', 'SOLfarm Vault', 'ORCA Aquafarm', 'Aldrin Staking') then 'STAKE'

when ADDRESS_NAME in ('Solsea NFT Marketplace', 'Solanart NFT Marketplace', 'Metaplex Token Metadata', 'Magic Eden Marketplace') then 'NFT'

when ADDRESS_NAME in ('SERUM DEX V3', 'Jupiter Aggregator v2', 'ORCA Token Swap V2', 'Aldrin AMM', 'SERUM Swap', 'Saber Stable Swap') then 'SWAP'

else 'OTHER' end as Type,

count(b.label) as COUNT

from solana.core.fact_transactions a

inner join solana.core.dim_labels b

on a.instructions[0]:programId = b.address

and a.block_timestamp::date >= CURRENT_DATE - 30

and b.label_subtype != 'token_contract'

and b.label != 'solana'

group by date, type