select BLOCK_TIMESTAMP::date day ,sum(tx_message:dt:itx[0]:txn:aamt/pow(10,6)) amnt
from algorand.application_call_transaction
where day between '2022-04-07' and '2022-04-20'
and TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING)='m'
group by day