adambalaGetting Started With Marinade Finance Bounties
    Updated 2022-03-15
    select date_trunc('day', block_timestamp) as day,
    sum(inner_instruction:instructions[0]:parsed:info:amount/POW(10,9)) as mSOL_deposited
    from solana.events
    where block_timestamp >= '2022-03-01'
    and instruction:programId = 'QMNeHCGYnLVDn1icRAfQZpjPLBNkfGbSKRB83G5d8KB'
    and instruction:accounts[2] = 'Hs2XmWQFw3ExawMQkCsBGQGX73JG1n2Qpjm8G7dYRw7m'
    and instruction:accounts[6] = 'J829VB5Fi7DMoMLK7bsVGFM82cRU61BKtiPz9PNFdL7b'
    and succeeded = 'TRUE'
    --and tx_id = 'FP8fzsDZqcvU8KbJuzb5nugP26qgbn4tF1yE7ys3SoHyra8UyN74Tk4VTQzHVxktKBi9pHiVGS9fU2R8wA3PHxU'
    group by 1
    order by 1
    Run a query to Download Data