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 b on b.asset_id = swap_to_asset_id
where block_timestamp >= '2022-01-01' AND
swap_from_amount > 1 AND
swap_to_asset_id <> 0 AND
DEX = 'tinyman'
group by swap_to_asset_id,swap_program,asset_name
order by Swaps DESC
LIMIT 10