flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
.
amiroza
.
Updated 2022-07-08
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
case
swap_from_asset_id
when
0
then
'ALGO'
when
226701642
then
'Yieldly'
end
as
asset_name
,
count
(
*
)
asset_count
from
algorand
.
swaps
s
where
swap_to_asset_id
=
694432641
group
by
swap_from_asset_id
order
by
asset_count
desc
limit
10
Results
Run a query to Download Data