2844POPULAR ASSETS FOR SWAP
    Updated 2022-07-07
    select
    a.asset_name,
    count(b.swap_to_asset_id) as N_swap
    from flipside_prod_db.algorand.swaps B
    join flipside_prod_db.algorand.asset A
    on b.swap_to_asset_id = a.asset_id
    where B.block_timestamp>= '2022-05-01' and B.block_timestamp <'2022-07-01'

    and b.swap_from_amount > 0
    group by asset_name
    order by N_swap DESC
    LIMIT 10

    Run a query to Download Data