SELECT DISTINCT SWAPPER

FROM solana.defi.ez_dex_swaps

WHERE SWAP_TO_MINT = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

),

RankedtradesofTrumpBuyers AS (

SELECT

SWAPPER,

block_timestamp,

SWAP_TO_MINT AS tokenCA,

SWAP_TO_SYMBOL,

ROW_NUMBER() OVER (PARTITION BY SWAPPER ORDER BY block_timestamp ASC) AS rk

FROM solana.defi.ez_dex_swaps

WHERE SWAPPER IN (SELECT SWAPPER FROM ALLTrumpbuyers)

),

Celebrity_first_traders AS (

SELECT

SWAPPER,

block_timestamp,

tokenCA,

SWAP_TO_SYMBOL

FROM RankedtradesofTrumpBuyers

WHERE rk = 1

AND tokenCA = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

),

First_transfers AS (

SELECT

TX_TO AS SWAPPER,

TX_FROM,

block_timestamp,

ROW_NUMBER() OVER (PARTITION BY TX_TO ORDER BY block_timestamp ASC) AS first_transfer_rank

FROM solana.core.fact_transfers

),