select date(block_timestamp) as date, sw.swap_program, count(DISTINCT sw.tx_group_id) as swapped_count, count(DISTINCT sw.swapper) as swapper_count
from flipside_prod_db.algorand.swaps sw
where date(block_timestamp) BETWEEN '2022-01-01' and CURRENT_DATE - 1
and sw.swap_from_amount > 0
group by date, sw.swap_program
order by date