select
date_trunc('day',block_timestamp) as date,
swap_program as Dex,
--count(distinct(swapper)) as Swapppers
sum(swap_from_amount) as Algo_sales
from algorand.swaps
where
date >= '2022-04-01' AND
swap_program != 'wagmiswap'
AND
swap_from_asset_id = 0
group by date,swap_program
order by date