iboo-jbj2MVTop 10 ASAs by volume in the last (90 days)
    Updated 2022-05-16
    with table1 AS
    (select asset_name,
    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)

    select asset_name,
    usd_volume
    from table1
    limit 10
    Run a query to Download Data