select
date_trunc('day',block_timestamp) as block_day,
date_trunc('month',block_timestamp) as block_month,
sum(inner_instruction:instructions[0]:parsed:info:amount/POW(10,9)) AS deposited_msol
from
solana.events
where
block_day >= '2022-03-01'
and
block_day <= '2022-03-31'
and
instruction:programId = 'QMNeHCGYnLVDn1icRAfQZpjPLBNkfGbSKRB83G5d8KB'
and
instruction:accounts[2] = 'Hs2XmWQFw3ExawMQkCsBGQGX73JG1n2Qpjm8G7dYRw7m'
and
instruction:accounts[6] = 'J829VB5Fi7DMoMLK7bsVGFM82cRU61BKtiPz9PNFdL7b'
group by block_month, block_day
order by block_day