Heminunique wallet stake Marinade
    Updated 2022-03-12
    select
    count(DISTINCT(inner_instruction:instructions[0]:parsed:info:destination) ) as coun,
    date_trunc('day', block_timestamp) as day

    from solana.events
    where date_trunc('day', block_timestamp) BETWEEN '2022-03-01 00:00:00.000' and '2022-03-11 00:00:00.000'
    and instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'
    and inner_instruction:instructions[0]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE'
    GROUP BY day
    ORDER BY day

    Run a query to Download Data