sarathgalgo 4
Updated 2022-04-29
9
1
2
3
4
5
6
7
›
⌄
SELECT swap_to_asset_id, CASE WHEN swap_to_asset_id = 0 THEN 'ALGO' WHEN swap_to_asset_id = 226701642 THEN 'Yieldly Token' END AS swap_to_asset_name,
COUNT(tx_group_id) as swap_count
FROM algorand.swaps
WHERE swap_from_asset_id = '694432641'
GROUP BY swap_to_asset_id
ORDER BY swap_count DESC
LIMIT 10
Run a query to Download Data