PapasotSTBL swaps
Updated 2022-05-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
a.swap_to_asset_id as ASA,
count(ASA) as Swaps,
sum(a.swap_from_amount) as STBL_volume
from algorand.swaps a
--left join algorand.account_asset on asset_id = swap_to_asset_id
where
swap_from_asset_id = '465865291'
and block_timestamp > '2022-05-07'
and block_timestamp < '2022-05-15'
group by ASA
order by STBL_volume desc
limit 20
Run a query to Download Data