-- (base64_decode_string (tx_message:txn:apaa[0]::String))

date_trunc('day',block_timestamp) as block_day,

app_id,

count (tx_message) as btc_inflow_transactions,

sum (tx_message:dt:itx[0]:txn:aamt::number / 1e8) as btc_inflow_volume

from flipside_prod_db.algorand.application_call_transaction

where

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

AND

app_id = 770103640 -- BTC

group by block_day,app_id

order by block_day