SELECT

sum (inner_instruction:instructions[0]:parsed:info:amount/pow(10,9)) AS volume,

DATE (block_timestamp) AS DATE

FROM solana.core.fact_events

WHERE instruction:programId = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'

AND succeeded = TRUE

GROUP BY 2

ORDER BY 2

SELECT

sum(volume) AS total_volume

FROM swim_volumes