block_timestamp::date as day,

count(distinct(instruction:accounts[6])) as users_count

from solana.fact_events

where block_timestamp::date >= '2022-03-01' and block_timestamp::date <= '2022-03-30'

and instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'

and inner_instruction:instructions[0]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE'

group by day

order by day