strawbettyAlgo swap to other assets
    Updated 2022-06-09
    with table1 as (
    select
    sw.swap_to_asset_id as asset_id,
    sum(sw.swap_from_amount) as algo_volume,
    avg(sw.swap_from_amount) as average_algorand
    from algorand.swaps sw
    where date(sw.block_timestamp) >= '2022-05-11'
    and date(sw.block_timestamp) <= '2022-05-12'
    and sw.swap_from_asset_id = '0'
    and sw.swap_from_amount > 0

    group by asset_id
    order by algo_volume DESC
    limit 10
    )

    SELECT
    lb.asset_name as name,
    algo_volume,
    average_algorand
    FROM table1 res
    left join algorand.account_asset lb on lb.asset_id = res.asset_id
    group by name,algo_volume, average_algorand
    order by algo_volume DESC
    Run a query to Download Data