drone-mostafaNumber of unique wallets that staked SOL per day in March
    Updated 2022-05-07
    select
    block_timestamp::date as day,
    count(distinct(instruction:accounts[6])) as users_count
    from solana.fact_events
    where date_trunc('day', block_timestamp) >= '2022-03-01' and block_timestamp < '2022-03-30'
    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