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 BETWEEN '2022-03-01' AND '2022-03-31'
AND
instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'
AND
inner_instruction:instructions[0]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE'
GROUP BY
date
ORDER BY
date