select
date_trunc('day',block_timestamp) as block_day,
date_trunc('month',block_timestamp) as block_month,
count(distinct(instruction:accounts[6])) as new_wallets
from
solana.events
where
block_day >= '2022-03-01'
and
block_day <= '2022-03-31'
and
instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'
and
inner_instruction:instructions[0]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE'
group by block_month, block_day
order by block_day