SELECT date(block_timestamp) as day,

INNER_INSTRUCTION:instructions[0]:parsed:info:amount /1e6 AS volume,

INNER_INSTRUCTION:instructions[0]:parsed:info:destination AS destination,

INNER_INSTRUCTION:instructions[0]:parsed:info:source source

FROM solana.core.fact_events

WHERE program_id = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'

AND INNER_INSTRUCTION:instructions[0]:parsed:info:destination IS NOT NULL

AND INNER_INSTRUCTION:instructions[0]:parsed:info:amount > 0

AND succeeded = true

)

SELECT round(sum(volume),2) AS total_volume

FROM swim_dtls