--date(block_timestamp) as day,

swap_program,

count(DISTINCT swapper) as swappers

FROM solana.defi.fact_swaps

WHERE (swap_to_mint LIKE 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

OR swap_from_mint LIKE 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263')

AND block_timestamp > current_date - 30

GROUP by swap_program