PapasotSTBL swaps
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
asset_name as ASA_name,
swap_to_asset_id as ASA_id,
count(swap_to_asset_id) as Swaps,
swap_program as DEX,
count(DISTINCT(swapper)) as Users
from algorand.swaps a
left join algorand.asset b on b.asset_id = a.swap_to_asset_id
where block_timestamp >= '2022-01-19' AND
swap_from_amount > 1 AND
swap_to_asset_id = '465865291'
group by swap_to_asset_id,asset_name,swap_program
order by Swaps DESC
Run a query to Download Data