majidgholamiTotal Volume
    Updated 2022-07-27
    select (sum(INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:amount))/10e8 as total_from ,
    (sum(INNER_INSTRUCTIONS[0]:instructions[1]:parsed:info:amount))/10e8 as total_to,
    (total_from + total_to) as total_volume
    from solana.core.fact_transactions
    where instructions[1]:programId = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
    or instructions[1]:programId = 'SWimmSE5hgWsEruwPBLBVAFi3KyVfe8URU2pb4w7GZs'
    and succeeded ='true'

    Run a query to Download Data