flipside

    How many unique wallets have staked SOL on Marinade in the month of March? Create a visualization using Velocity to show user adoption per day in March.
    mohammad23 How many unique wallets have staked SOL on Marinade in the month of March? Create a visualization using Velocity to show user adoption per day in March.
    Updated 2022-03-12
    select
    block_timestamp::date as day,
    count(distinct(instruction:accounts[6])) as users_count
    from solana.events
    where date_trunc('day', block_timestamp) >= '2022-03-01'
    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