tx_id,

signers[0] as user,

decoded_instruction as raw,

from solana.core.ez_events_decoded

where program_id = 'dRiftyHA39MWEi3m9aunc5MzRF1JYuBsbn6VPcn33UH'

select date_trunc('day',block_timestamp) as date,

raw:name as type,

count(DISTINCT tx_id) as txs,

count(DISTINCT user) as users

from base

group by 1,2