sum(INNER_INSTRUCTION:instructions[0]:parsed:info:amount)/pow(10,6) as volume

FROM solana.core.fact_events

where program_id = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'

and (INNER_INSTRUCTION:instructions[0]:parsed:info:amount) is not null