iboo-jbj2MVList of ASAs including ALGO swap volume and average amount of ALGOs involved in a swap
    Updated 2022-04-14
    select
    s.swap_to_asset_id,
    b.asset_name as ASA,
    sum(swap_from_amount) as total_ALGO_swap_volume,
    count(tx_group_id) as swap_count,
    total_ALGO_swap_volume/swap_count as average_ALGO,
    count(distinct swapper) as distinct_swapper_count
    from algorand.swaps s LEFT OUTER JOIN algorand.asset b ON s.swap_to_asset_id= b.asset_id
    where block_timestamp >= '2022-01-01'
    and swap_from_asset_id='0'
    group by 1,2
    order by 3 desc limit 10
    Run a query to Download Data