iboo-jbj2MVThe most swapped
    Updated 2022-05-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