SELECT

ft.block_timestamp,

ft.tx_hash,

ft.tx_position,

ft.trace_index,

ft.from_address,

ft.origin_from_address,

ft.to_address,

ft.origin_to_address,

el.topic_3 AS token_id, -- NFT ID

ROW_NUMBER() OVER (PARTITION BY el.topic_3 ORDER BY ft.block_timestamp ASC, ft.tx_position ASC, ft.trace_index ASC) AS rn,

COUNT(*) OVER (PARTITION BY el.topic_3) AS transfer_count -- Total number of transfers per token

FROM monad.testnet.fact_traces ft

INNER JOIN monad.testnet.fact_event_logs el

ON ft.tx_hash = el.tx_hash

INNER JOIN monad.testnet.fact_transactions ftr

ON ft.tx_hash = ftr.tx_hash

WHERE el.contract_address = LOWER('0xE8F0635591190Fb626F9D13C49b60626561Ed145')

AND ft.TX_SUCCEEDED = 'TRUE'

AND ft.TRACE_SUCCEEDED = 'TRUE'

SELECT DISTINCT origin_from_address

FROM ranked_data

WHERE transfer_count > 2 -- Only select tokens that have exactly 2 transfers

AND rn > 2; -- Get the second transfer