iboo-jbj2MVThe most swapped
Updated 2022-05-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with table1 AS
(select asset_name,
SUM(swaps_in_hour)
AS total_swaps,
SUM(volume_usd_in_hour)
AS usd_volume
from algorand.prices_swap
where block_hour::date >= current_date - 90 -- Last 90 days
group by asset_name,
asset_name having usd_volume >= 1
order by usd_volume desc
limit 10)
select asset_name,
total_swaps
from table1
Run a query to Download Data