CASE when signers[0] = 'FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr'

then signers[1] else signers[0] end AS WALLET

,ROUND(zeroifnull(sum(CASE when value:parsed:info:destination = '5XJei3jBZi8WuqDGUQ5KCe8t72vMRMTWLr6ok3hhXE2R'

AND value:parsed:type = 'transfer'

then value:parsed:info:amount / POW(10,8)

end)),2) AS ATLAS

FROM solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)

WHERE program_id IN ('SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE')

AND block_timestamp > '2024-07-01' AND block_timestamp < '2024-08-01'

AND wallet != 'FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr'

GROUP BY 1

ORDER BY 2 DESC