--fact_events.*

--/*

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

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

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '4Rrcj4MArUcMtHPp6amTy3SUXbCGYG3n8sf8KgMKjRnr'

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 sa_a1e1_atlas_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint = '4Rrcj4MArUcMtHPp6amTy3SUXbCGYG3n8sf8KgMKjRnr'

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 sa_a1e1_usdc_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = '4Rrcj4MArUcMtHPp6amTy3SUXbCGYG3n8sf8KgMKjRnr'

AND (inner_instruction:instructions[0]:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' OR inner_instruction:instructions[0]:parsed:info:mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')

then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount

end) as sa_a1e1_amount

--*/

from solana.core.fact_events--, lateral flatten(input => inner_instruction)

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:instructions[2]:parsed:info:mint = '4Rrcj4MArUcMtHPp6amTy3SUXbCGYG3n8sf8KgMKjRnr'

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

--AND tx_id = 'hDvVJEP55NRmAFpKR1Mx2Dsi2V2ZayAEv36ABUrHuV2F7k7qMr92HkdzNRfcbcm2vvXuYVTgiU9ua16dzxuZCxc'

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

AND block_timestamp > '2022-11-01'