2844most popular assets users have swapped on tinyman
    Updated 2022-03-24
    select
    a.asset_name,
    count(b.swap_to_asset_id) as N_swap
    from algorand.swaps b
    join algorand.account_asset a
    on b.swap_to_asset_id = a.asset_id
    where b.block_timestamp >= '2022-01-01' and swap_program like '%tinyman%'
    and b.swap_from_amount > 0
    group by asset_name
    order by N_swap DESC
    limit 10
    Run a query to Download Data