shadilPopular Algorand Assets To Swap On DEXes - top 10 most popular assets users have swapped to
    Updated 2022-03-20
    select lb.asset_name, count(DISTINCT sw.tx_group_id) as swapped_count
    from algorand.swaps sw
    join algorand.account_asset lb on lb.asset_id = sw.swap_to_asset_id
    where date(block_timestamp) >= '2022-01-01'
    and sw.swap_from_amount > 0
    group by lb.asset_name
    order by swapped_count DESC
    limit 10
    Run a query to Download Data