itsxenuxTop 5 ASAs that these wallets swapping goETH and goBTC for
    Updated 2022-05-18
    with query_table1 as
    (select flipside_prod_db.algorand.asset.asset_name AS asset,
    count(distinct swapper) AS total_wallets,
    swap_to_asset_id
    from flipside_prod_db.algorand.swaps join flipside_prod_db.algorand.asset
    on flipside_prod_db.algorand.swaps.swap_to_asset_id = flipside_prod_db.algorand.asset.asset_id
    where (swap_from_asset_id = 386192725
    or swap_from_asset_id = 386195940)
    group by swap_to_asset_id, asset
    order by total_wallets desc
    limit 5)

    select asset, total_wallets
    from query_table1
    order by total_wallets
    Run a query to Download Data