mSOL deposited into the MNDE pool in March

mr_sami7-pmCkDGmSOL deposited into the MNDE pool in March

Updated 2022-06-15

select block_timestamp::date as date, sum(inner_instruction:instructions[0]:parsed:info:amount/POW(10,9)) as mSOLamount

from solana.fact_events

where date_trunc('day', block_timestamp) >= '2022-03-01'

and date_trunc('day', block_timestamp) <= '2022-03-31'

and instruction:programId = 'QMNeHCGYnLVDn1icRAfQZpjPLBNkfGbSKRB83G5d8KB'

and instruction:accounts[2] = 'Hs2XmWQFw3ExawMQkCsBGQGX73JG1n2Qpjm8G7dYRw7m'

and instruction:accounts[6] = 'J829VB5Fi7DMoMLK7bsVGFM82cRU61BKtiPz9PNFdL7b'

group by date

order by date

Run a query to Download Data

flipside