select
date_trunc('day',block_timestamp) as days,
sender,
count(base64_decode_string(tx_message:txn:apaa[0]::String))as inflows
from algorand.application_call_transaction
where app_id = 770102986
and base64_decode_string(tx_message:txn:apaa[0]::String) ='swap'
group by 1,2