SELECT

DISTINCT tx_id

FROM solana.core.fact_events

WHERE INSTRUCTION:parsed:info:mint::string='6UA3yn28XecAHLTwoCtjfzy3WcyQj1x13bxnH8urUiKt'

AND INDEX=0

AND SUCCEEDED =TRUE)

INSTRUCTION:accounts[0]::string AS address,

Sum(CASE

WHEN INNER_INSTRUCTION:instruction[1]:parsed:info:amount IS NOT NULL THEN INNER_INSTRUCTION:instruction[1]:parsed:info:amount /1e6

WHEN INNER_INSTRUCTION:instruction[1]:parsed:info:amount IS NULL THEN INNER_INSTRUCTION:instruction[0]:parsed:info:amount /1e6

END) AS mSOL_AMOUNT

FROM solana.core.fact_events E INNER JOIN txns T ON E.tx_id = T.tx_id

WHERE INDEX = 1

AND inner_instruction IS NOT NULL

GROUP BY 1

ORDER BY 2 DESC

LIMIT 50