Crazy_KidStaking Sol on Marinade Finance 2
    Updated 2022-03-09
    SELECT date(block_timestamp) as date, tx_id, inner_instruction:instructions[1]:parsed:info:source as sender,
    inner_instruction:instructions[1]:parsed:info:lamports/1000000000 as sol_staked,
    inner_instruction:instructions[0]:parsed:info:amount/1000000000 as msol_received
    FROM solana.events
    WHERE date BETWEEN '2022-02-01' AND CURRENT_DATE-1 AND instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'
    AND inner_instruction:instructions[0]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE' -- Token Account
    AND succeeded = 'TRUE'
    ORDER BY sol_staked DESC
    LIMIT 10
    Run a query to Download Data