select tx_id from solana.core.fact_events

where program_id = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'

and succeeded = true

)

select date(block_timestamp) as day, count(distinct signers) as unique_users

from solana.core.fact_transactions

where tx_id in (select tx_id from swim_txns)

group by day

order by day desc