tx_id

from solana.core.fact_events

WHERE program_id = 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL'

--program_id = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'

AND succeeded = 'true'

AND instruction:parsed:info:mint = 'FMWKb7YJA5upZHbu5FjVRRoxdDw2FYFAu284VqUGF9C2'

--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 = '4bT5WLggMqyt9BzFUfg3WZgdQcNPSX7q8zYUodSrwDnHzNPZ6WtEZGZT4Cvtnq4RfgecqJU5UzJNHhp8unnmDEhf'

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

AND block_timestamp > current_date-14 AND block_timestamp < current_date

,accounts AS (

distinct instruction:accounts[4] as accounts

--value:parsed:info:amount as

from solana.core.fact_events

, lateral flatten(input => inner_instruction:instructions)

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 IN (SELECT tx_id FROM txs)

AND instruction:accounts[3] = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'