PapasotPopular Algorand Assets To Swap On DEXes top 10
    Updated 2022-03-21
    select
    swap_to_asset_id as ASA_id,
    asset_name as ASA_name,
    count(swap_to_asset_id) as Swaps
    from algorand.swaps a
    left join algorand.asset b on b.asset_id = a.swap_to_asset_id

    where block_timestamp >= '2022-01-01' AND
    swap_from_amount > 1 AND
    swap_to_asset_id <> 0
    group by swap_to_asset_id,asset_name
    order by Swaps DESC
    LIMIT 10
    Run a query to Download Data