shadilPricing ASAs - volume
    Updated 2022-05-08
    SELECT asset_id, asset_name, sum(volume_usd_in_hour) as vol_usd, avg(volatility_measure) as avg_volatility, sum(swaps_in_hour) as vol_swaps
    from algorand.prices_swap
    where date(block_hour) >= CURRENT_DATE - 90
    GROUP by asset_id, asset_name HAVING vol_usd > 0
    order by vol_usd DESC
    limit 10
    Run a query to Download Data