--*

date_trunc('day', block_timestamp::date) as date,

----------------------------------------------------

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'HzUBawF9xxTy4mTuvSkk1a4voJcm65tSHZz6voCDUB33' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) end) AS cs1_atlas_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'HzUBawF9xxTy4mTuvSkk1a4voJcm65tSHZz6voCDUB33' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) end) AS cs1_usdc_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'HzUBawF9xxTy4mTuvSkk1a4voJcm65tSHZz6voCDUB33' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount end) AS cs1_amount,

----------------------------------------------------

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '2piSPCxbuibsraBnnK4M5rGeHSraNe2oiD8hDw42bPKq' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) end) AS cs2_atlas_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '2piSPCxbuibsraBnnK4M5rGeHSraNe2oiD8hDw42bPKq' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) end) AS cs2_usdc_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = '2piSPCxbuibsraBnnK4M5rGeHSraNe2oiD8hDw42bPKq' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount end) AS cs2_amount,

----------------------------------------------------

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'C2uF4fECabWryVCV1bDuxP7jMspbf2gei3YAP2UBn292' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) end) AS cs3_atlas_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'C2uF4fECabWryVCV1bDuxP7jMspbf2gei3YAP2UBn292' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) end) AS cs3_usdc_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'C2uF4fECabWryVCV1bDuxP7jMspbf2gei3YAP2UBn292' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount end) AS cs3_amount,

------------------------------------------------------

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'EBEJj1LKuo1k1J2ZvNJxsXATdGYnfaLWzqxck5p4PXSz' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) end) AS cs4_atlas_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = 'EBEJj1LKuo1k1J2ZvNJxsXATdGYnfaLWzqxck5p4PXSz' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) end) AS cs4_usdc_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'EBEJj1LKuo1k1J2ZvNJxsXATdGYnfaLWzqxck5p4PXSz' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount end) AS cs4_amount,

------------------------------------------------------

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '3aTW9zvPz5f7vt2Mfnr5zWA2RcgNTtDSSrBwaxyZ6t7d' AND inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) end) AS cs5_atlas_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '3aTW9zvPz5f7vt2Mfnr5zWA2RcgNTtDSSrBwaxyZ6t7d' AND inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) end) AS cs5_usdc_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = '3aTW9zvPz5f7vt2Mfnr5zWA2RcgNTtDSSrBwaxyZ6t7d' then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount end) AS cs5_amount

from solana.core.fact_events

WHERE program_id = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'

AND succeeded = 'true'

--AND inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount >= 0

AND inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount != 0

AND inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount != 0

--AND inner_instruction[0]:instructions[2]:parsed:info:mint::string = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim'

--AND log_messages::string LIKE '%ProcessExchange%'

--AND tx_id = 'yVyU5pWLe5Uh8gMj2nwMSWZp1G8sGFdhpurG9mirgNNHTm8kG6Benk7m1gPParfZJvY8W8vTiaZWZchkDZKmVjL'

--AND inner_instructions[0]:instructions[1]:parsed:info:mint::string = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'