select sum(post_token_balances[0] - pre_token_balances[0]) as total_tx_amount from solana.core.fact_events a
join solana.core.fact_transactions b on a.tx_id = b.tx_id
where program_id = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
and a.succeeded = 1