Updated 2022-03-11
9
1
2
3
4
5
6
7
›
⌄
-- Answer
select count(distinct(inner_instruction:instructions[0]:parsed:info:destination)),block_timestamp::date
from solana.events where
instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'
and inner_instruction:instructions[0]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE' and block_timestamp::date >= '2022-03-01'
group by 2