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