Papasotmost popular ASAs to swap to by DEX (Algofi)
    Updated 2023-01-03
    select
    swap_to_asset_id as ASA,
    asset_name as ASA_name,
    swap_program as DEX,
    count(swap_to_asset_id) as Swaps
    from algorand.swaps
    left join algorand.asset on asset_id = swap_to_asset_id
    where block_timestamp >= '2022-01-01' AND
    swap_from_amount > 1 AND
    DEX = 'algofi' AND
    ASA <> 0
    group by swap_to_asset_id,swap_program, asset_name
    order by Swaps DESC
    LIMIT 10
    Run a query to Download Data