select count(distinct tx_id) as swap_count , count(distinct swapper) as swapper_count , swap_program ,block_timestamp::date as swap_date
from solana.core.fact_swaps
where SUCCEEDED='TRUE' and block_timestamp::date >='2022-10-11'
group by swap_program,swap_date