with tx_ids as (select
tx_id
from algorand.application_call_transaction
where date_trunc('hour',block_timestamp) between date_trunc('hour',to_timestamp('2022-03-31 12:00:00.000'))
and date_trunc('hour',to_timestamp('2022-04-14 18:00:00.000'))
and TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING) = 'm'
group by 1
)
select
block_timestamp::date as date ,
sum(asset_amount/1e6 )as minted_amount
from algorand.asset_transfer_transaction
where asset_id = 694432641
and tx_id in (select * from tx_ids )
and inner_tx = true
group by 1