keshanMango markets 2
    Updated 2022-02-19
    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