PeimanFirst Time Deposits at Mango Markets-SOL transferred into Mango Markets
    Updated 2022-05-03
    select block_timestamp::date as date,
    sum(inner_instruction:instructions[0]:parsed:info:amount / 1e9) as "Total amount",
    AVG(inner_instruction:instructions[0]:parsed:info:amount / 1e9) as "Avgerage amount"
    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 date
    Run a query to Download Data