SELECT

DISTINCT Decoded_instruction:accounts[0]:pubkey::string AS token_address,

decoded_instruction:args:symbol::varchar AS symbol

FROM

solana.core.ez_events_decoded

WHERE

program_id = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'

AND event_type = 'create'

SELECT

DISTINCT

pt.symbol AS "Token Name",

ds.swapper AS "Trader Address",

ds.swap_from_amount_usd AS "Sell Amount",

ds.swap_to_amount_usd AS "Buy Amount",

ds.block_timestamp AS "Transaction Time"

FROM

solana.defi.ez_dex_swaps ds

JOIN

pump_tokens pt ON ds.swap_from_mint = pt.token_address

WHERE

ds.swap_from_mint IN (SELECT token_address FROM pump_tokens)

AND ds.swap_program = 'Raydium Liquidity Pool V4'

AND ds.swap_from_amount_usd IS NOT NULL

AND ds.swap_to_amount_usd IS NOT NULL

AND ds.block_timestamp BETWEEN '2024-04-Token Name Trader Address Sell Amount Buy Amount Transaction Time