With "SWIM PROTOCOL" AS (
SELECT TX_ID as ID
FROM solana.core.fact_events
WHERE PROGRAM_ID = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
)
SELECT SUM(INNER_INSTRUCTIONS[0]:instructions[1]:parsed:info:amount::FLOAT / 1E8) AS "TOTAL VOLUME"
FROM "SWIM PROTOCOL" JOIN solana.core.fact_transactions ON ID=TX_ID