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