PapasotpNetwork Bridge Launch stablecoin top wallets by volume
    Updated 2023-01-03
    with pUSDC AS

    (select
    *
    from flipside_prod_db.algorand.application_call_transaction
    where
    base64_decode_string(tx_message:txn:apaa[0]::String) = 'swap' and
    app_id = 770103640
    or app_id = 770102986)

    SELECT
    a.block_timestamp,
    asset_sender,
    asset_receiver,
    a.asset_amount/1e6 as stablecoin_inflow,
    a.asset_id
    from algorand.asset_transfer_transaction a
    inner join pUSDC b on b.tx_id = a.tx_id
    where asset_id = 748211185 or asset_id = 748208047
    and asset_amount > 400

    order by stablecoin_inflow desc
    limit 5


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