keshanMango markets 2
Updated 2022-02-19
9
1
2
3
4
5
6
7
8
9
›
⌄
select date, sum(amount)
(SELECT inner_instruction:instructions[0]:parsed:info:authority as user, min(block_timestamp::date) as date, sum(inner_instruction:instructions[0]:parsed:info:amount)/1e9 as amount, 1 as count
FROM solana.events
WHERE block_timestamp::date >= '2022-02-10'
AND Succeeded = 'TRUE' AND Index = 3
AND instruction:programId = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
AND inner_instruction:instructions[0]:parsed:info:destination = 'AVn3JRGhifPCxjxZsU3tQuo4U4dTHizHzBDGW983tx47'
Group By user)
Run a query to Download Data