flipside

    How much mSOL has been deposited into the single-side MNDE pool in the month of March? Create a visualization using Velocity that shows mSOL deposits per day in March.
    mohammad23 How much mSOL has been deposited into the single-side MNDE pool in the month of March? Create a visualization using Velocity that shows mSOL deposits per day in March.
    Updated 2022-03-12
    select block_timestamp::date as date, sum(inner_instruction:instructions[0]:parsed:info:amount/POW(10,9)) as mSOLamount
    from solana.events
    where block_timestamp::date >= '2022-03-01'
    and instruction:programId = 'QMNeHCGYnLVDn1icRAfQZpjPLBNkfGbSKRB83G5d8KB'
    and instruction:accounts[2] = 'Hs2XmWQFw3ExawMQkCsBGQGX73JG1n2Qpjm8G7dYRw7m'
    and instruction:accounts[6] = 'J829VB5Fi7DMoMLK7bsVGFM82cRU61BKtiPz9PNFdL7b'
    group by date
    order by date desc
    Run a query to Download Data