with mint as (
SELECT
DATE_TRUNC('day', algorand.application_call_transaction.block_timestamp) AS date,
algorand.application_call_transaction.tx_id AS Tr_ID,
algorand.application_call_transaction.SENDER AS snd ,
algorand.application_call_transaction.TX_GROUP_ID AS GROUP_ID,
algorand.application_call_transaction.tx_message:dt:itx[0]:txn:aamt/pow(10,6) AS amount
FROM algorand.application_call_transaction JOIN algorand.asset_transfer_transaction
ON algorand.application_call_transaction.tx_id = algorand.asset_transfer_transaction.tx_id
WHERE date >= '2022-3-31 0:00:00' AND date <= '2022-4-14 6:00:00'
AND ASSET_ID = '694432641'
AND algorand.asset_transfer_transaction.inner_tx = 'true'
AND TRY_BASE64_DECODE_STRING(algorand.application_call_transaction.tx_message :txn :apaa [0] :: STRING)='m'
)
SELECT
sum(amount) as Amount,
date
from mint
GROUP BY date