SELECT date(block_timestamp) as day,swap_program, count(DISTINCT swapper) as number_of_wallets_swapping,
avg(number_of_wallets_swapping) over (partition by swap_program order by day) as avg_number_of_wallets_swapping,
sum(swap_from_amount) as total_vol, avg(total_vol) over (partition by swap_program order by day) as avg_vol
from algorand.swaps
where block_timestamp < '2022-04-01' and block_timestamp >= '2022-01-01' and swap_from_asset_id = '0'
GROUP by 1,2
limit 1000