PapasotSelling goBTC, goETH (april 2022)
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
asset_name as ASA_name,
swap_from_asset_id as ASA_id,
count(swap_from_asset_id) as Swaps,
swap_program as DEX,
count(DISTINCT(swapper)) as Users,
sum(swap_from_amount) as Selling_Volume
from algorand.swaps a
left join algorand.asset b on b.asset_id = a.swap_from_asset_id
where block_timestamp >= '2022-04-01' AND
swap_to_amount > 1 AND
(swap_from_asset_id = '386192725' OR
swap_from_asset_id = '386195940')
group by swap_from_asset_id,asset_name,swap_program
order by Swaps DESC
Run a query to Download Data