Crazy_KidStaking Sol on Marinade Finance 2
Updated 2022-03-09
9
1
2
3
4
5
6
7
8
9
›
⌄
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