nitspNetwork Bridge
    Updated 2022-06-24
    with pUSDC as
    (SELECT sender, amt, 'pUSDC' as type
    from
    (select *, base64_decode_string(tx_message:txn:apaa[0]::String ) as action_
    ,tx_message:dt:itx[0]:txn:aamt / pow(10,6) as amt,
    case when action_ = 'withdraw' then amt*(-1) else amt end as amt_net
    from algorand.application_call_transaction where app_id = 770102986
    and (action_ = 'withdraw' or action_ = 'swap') and tx_message:dt:itx[0]:txn:xaid = '748211185'
    )order by 2 desc limit 10 ),
    pUSDT as
    (SELECT sender, amt, 'USDT' as type
    from
    (select *, base64_decode_string(tx_message:txn:apaa[0]::String ) as action_
    ,tx_message:dt:itx[0]:txn:aamt / pow(10,6) as amt,
    case when action_ = 'withdraw' then amt*(-1) else amt end as amt_net
    from algorand.application_call_transaction
    where app_id = 770102986
    and (action_ = 'withdraw' or action_ = 'swap') and tx_message:dt:itx[0]:txn:xaid = '748208047')
    order by 2 desc limit 10 )


    ,
    pBTC as
    (SELECT sender, amt , 'pBTC' as type from
    (select *, base64_decode_string(tx_message:txn:apaa[0]::String ) as action_
    ,tx_message:dt:itx[0]:txn:aamt*21000 / pow(10,8) as amt,
    case when action_ = 'withdraw' then amt*(-1) else amt end as amt_net
    from algorand.application_call_transaction
    where app_id = 770103640
    and (action_ = 'withdraw' or action_ ilike 'Issue')and tx_message:dt:itx[0]:txn:xaid = '744665252')
    )

    SELECT * from pBTC
    UNION ALL
    SELECT * from pUSDC
    Run a query to Download Data