date_trunc('day',block_timestamp) as days,

count(base64_decode_string(tx_message:txn:apaa[0]::String))as actions,

sender

from algorand.application_call_transaction

where app_id = 770103640

and base64_decode_string(tx_message:txn:apaa[0]::String)='issue'

group by 1,3