SELECT

MIN(block_timestamp) AS creation_date,

signers[0] AS creator,

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'

GROUP BY

decoded_instruction:accounts[0]:pubkey,

decoded_instruction:args:symbol,

signers[0]

),

launch_times AS (

SELECT

swap_from_mint AS token_address,

MIN(block_timestamp) AS launch_date

FROM

solana.defi.ez_dex_swaps

WHERE

swap_from_mint IN (SELECT token_address FROM pump_tokens)

AND swap_program = 'Raydium Liquidity Pool V4'

GROUP BY

swap_from_mint

SELECT

pt.creation_date AS "Creation Date",

lt.launch_date AS "Launch Date",

pt.symbol AS "Symbol",

lt.token_address as "Token Address",

pt.creator AS "Creator"