Pmisha-bmlMdxDeposit.Mango.markets
    Updated 2022-02-21
    with dep as (select block_timestamp::date as d1,
    sum(inner_instruction:instructions[0]:parsed:info:amount/1e9) as amountDeposited
    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 1),

    wl as (select block_timestamp::date as d2,
    count(distinct instruction:parsed:info:newAccount) as acconts
    from solana.events
    Where block_timestamp::date >='2022-02-10'
    AND Succeeded = 'True'
    and event_type = 'createAccount'
    and index=1
    group by 1)

    select
    dep.d1 as day,
    amountDeposited,
    acconts
    from DEP
    inner join wl on dep.d1=wl.d2
    Run a query to Download Data