select tx_id

from solana.core.fact_events

where program_id='SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'

AND succeeded = true

select

date_trunc('day', block_timestamp) as date,

count(DISTINCT signers) as user

from solana.core.fact_transactions inner join swim on swim.tx_id=solana.core.fact_transactions.tx_id

group by DATE

order by date DESC