SELECT 'GLeWRGNtMZibkf9zTSEjfssnaN2WCnKiBcZDiYe3pump' AS token_address -- paperclip

),

profitable_traders AS (

-- No changes here

SELECT

DISTINCT t.swapper

FROM solana.defi.ez_dex_swaps AS t

CROSS JOIN token_info AS ti

WHERE (swap_from_mint = ti.token_address OR swap_to_mint = ti.token_address)

GROUP BY t.swapper

HAVING (SUM(CASE WHEN swap_to_mint = ti.token_address THEN swap_from_amount_usd ELSE 0 END) / NULLIF(COUNT(CASE WHEN swap_to_mint = ti.token_address THEN 1 END), 0)) >= 50

),

relevant_trades AS (

-- Select token amounts

SELECT

t.swapper,

t.block_timestamp,

t.swap_to_mint AS token_mint,

t.swap_from_amount_usd AS amount_usd,

t.swap_to_amount, -- Amount of token_mint received

0 as swap_from_amount, -- Placeholder for UNION ALL structure

'buy' AS trade_type

FROM solana.defi.ez_dex_swaps AS t

INNER JOIN profitable_traders AS pt ON t.swapper = pt.swapper

WHERE t.block_timestamp >= DATE_TRUNC('day', CURRENT_TIMESTAMP() - interval '7 day')

AND t.swap_to_mint IS NOT NULL

AND t.swap_to_mint NOT IN (

'So11111111111111111111111111111111111111112', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN',

'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn', 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So',

'3NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh', '27G8MtK7VtTcCHkpASjSDdkWWYfoqT6ggEuKidVJidD4'

)