AndyCoolTop 10 ASA volume query
    Updated 2022-05-15
    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