PapasotpNetwork Bridge Launch USDC/USDT inflows
    Updated 2023-01-02
    select
    -- (base64_decode_string (tx_message:txn:apaa[0]::String))
    date_trunc('day',block_timestamp) as block_day,
    app_id,
    count (tx_message) as inflow_transactions,
    sum (tx_message:dt:itx[0]:txn:aamt::number / 1e6) as inflow_volume
    from flipside_prod_db.algorand.application_call_transaction
    where
    base64_decode_string(tx_message:txn:apaa[0]::String) = 'swap'
    AND
    app_id = 770102986 -- USDC,USDT
    group by block_day,app_id
    order by block_day



    -- Query tips
    -- select distinct base64_decode_string(tx_message:txn:apaa[0]::String) from algorand.application_call_transaction where app_id = 770102986
    Run a query to Download Data