SELECT date(block_timestamp) as day, count(DISTINCT tx_id) as total_txs,
count(DISTINCT inner_instruction:instructions[0]:parsed:info:source) as participants
from solana.fact_events
where
instruction:accounts[3] ilike '86nx2WyrdC6VuWyfdG1gMLiiBduktBTJgToKZAYwcbct'
-- program_id ilike 'VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp'
GROUP by 1
limit 1000