PapasotSwaps to gAlgo3
Updated 2022-04-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- What are the top 10 most popular to swap from to get gALGO3?
select
swap_from_asset_id as ASA,
asset_name as ASA_name,
count(swap_from_asset_id) as Swaps
from algorand.swaps
left join algorand.asset on asset_id = swap_from_asset_id
where block_timestamp >= '2022-01-01' AND
swap_to_asset_id = '694432641' -- gAlgo3 asset id
group by swap_from_asset_id, asset_name
order by Swaps DESC
Run a query to Download Data