count(case when try_base64_decode_string(tx_message:txn:apaa[0]::string) = 'd' then 1 else NULL end) as mint_actions,

count(case when try_base64_decode_string(tx_message:txn:apaa[0]::string) = 'r' then 1 else NULL end) as burn_actions,

mint_actions + burn_actions as total_actions

from algorand.application_call_transaction ap

where app_id = '686501760' --goBTC

--where app_id = '694405065' --goETH

and date(block_timestamp) >= '2022-01-01'

group by date