select
date(block_timestamp) as date,
swap_program,
count(distinct swapper) as daily_swappers
from solana.fact_swaps
where
date >= current_date()-30
and
succeeded = 'TRUE'
and (swap_from_mint = 'poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk' or swap_to_mint = 'poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk')
group by 1,2