sum(AMOUNT_USDC) as total_amount

FROM

((SELECT

SUM (INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:amount)/POW(10,6) as amount_usdc

from solana.core.fact_transactions

where INSTRUCTIONS[1]:programId in ( 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC' , 'SWimmSE5hgWsEruwPBLBVAFi3KyVfe8URU2pb4w7GZs')

and SUCCEEDED = 'TRUE'

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

and (INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:destination) = '5uBU2zUG8xTLA6XwwcTFWib1p7EjCBzWbiy44eVASTfV'

--or (INNER_INSTRUCTION:instructions[1]:parsed:info:destination) = '5uBU2zUG8xTLA6XwwcTFWib1p7EjCBzWbiy44eVASTfV'

union

select SUM (INNER_INSTRUCTIONs[0]:instructions[0]:parsed:info:amount)/POW(10,6) as amount_usdt

from solana.core.fact_transactions

where INSTRUCTIONS[1]:programId in ( 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC' , 'SWimmSE5hgWsEruwPBLBVAFi3KyVfe8URU2pb4w7GZs')

and SUCCEEDED = 'TRUE'

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

and (INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:destination) = 'Hv7yPYnGs6fpN3o1NZvkima9mKDrRDJtNxf23oKLCjau'

--or (INNER_INSTRUCTION:instructions[1]:parsed:info:destination) = 'Hv7yPYnGs6fpN3o1NZvkima9mKDrRDJtNxf23oKLCjau'

select SUM (INNER_INSTRUCTIONs[0]:instructions[0]:parsed:info:amount)/POW(10,8) as amount_usdtbs

from solana.core.fact_transactions

where INSTRUCTIONS[1]:programId in ( 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC' , 'SWimmSE5hgWsEruwPBLBVAFi3KyVfe8URU2pb4w7GZs')

and SUCCEEDED = 'TRUE'

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

and (INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:destination) = '9KMH3p8cUocvQRbJfKRAStKG52xCCWNmEPsJm5gc8fzw'

-- or (INNER_INSTRUCTION:instructions[1]:parsed:info:destination) = '9KMH3p8cUocvQRbJfKRAStKG52xCCWNmEPsJm5gc8fzw'

)