pNetwork Bridge Launch (Algorand Bounty)
Q106. pNetwork is the first decentralized bridge to launch on algorand- it supports wrapped USDC, BTC, and USDT -Look at inflows and outflows by volume and number of transactions for each pUSDT , pBTC, and pUSDC by day Show the top 10 wallets that have bridge in each assets Tips: pUSDT, pUSDC, pBTC https://algoexplorer.io/asset/748208047 https://algoexplorer.io/asset/744665252 https://algoexplorer.io/asset/748211185 pBTC swap-appID 770103640 https://algoexplorer.io/tx/group/oh5fhauY39SE%2BDTMw6FIPPv8w2poW1y6oCc%2FgrzE87c%3D pUSDC swap-appID 770102986 https://algoexplorer.io/tx/group/ZH5NGfl3X3fyxkBt9bnKHglpuOzguPg8S7jtQF6s3wA%3D pUSDT swap-appID 770102986 https://algoexplorer.io/tx/group/uYvXusw1LW%2FcjwD%2FKdWw7uxbGgRc%2BlgcjzgvuZ6Y3aQ%3D Example of argument text to filter on: select distinct base64_decode_string(tx_message:txn:apaa[0]::String) from algorand.application_call_transaction where app_id = 770102986 -For pUSDT and pUSDC you will have a “swap” to signify bridging in and “withdraw” bridge out in the argument For pBTC you will have “issue to signify bridging in