AndyCoolTop 10 ASA volume query
Updated 2022-05-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH top_asa as (
select asset_name, sum(volume_usd_in_hour)as volume
from algorand.prices_swap
where block_hour between '2022-02-12' and '2022-05-12'
and volume_usd_in_hour is not NULL
group by asset_name
order by volume DESC
limit 10
)
select avg(volatility_measure), sum(swaps_in_hour), top_asa.asset_name
from top_asa
inner join algorand.prices_swap on algorand.prices_swap.asset_name = top_asa.asset_name
where block_hour between '2022-02-12' and '2022-05-12'
group by top_asa.asset_name