SELECT

INNER_INSTRUCTION:instructions [0] :parsed:info:newAccount :: string as token_mint_id

FROM

solana.core.fact_events ev

WHERE

program_id = 'degenhbmsyzLpJUwwrzjsPyhPNvLurBFB4k1pBWSoxs'

and INNER_INSTRUCTION:instructions [0] :parsed:type :: string = 'createAccount'

and INNER_INSTRUCTION:instructions [1] :parsed:type :: string = 'initializeMint2'

and SUCCEEDED = 'TRUE'

and block_Timestamp >= '2024-05-17 01:15:51.000'

),

first_dex_swap as (

SELECT

CASE

when SWAP_TO_MINT in (

SELECT

token_mint_id

FROM

all_launch

) then SWAP_TO_MINT

else SWAP_from_MINT

end as mint_id,

min(block_timestamp) as fisrt_stamp

FROM

solana.defi.fact_swaps

WHERE

(

SWAP_FROM_MINT in (

SELECT

token_mint_id

FROM

all_launch

)

or SWAP_TO_MINT in (

SELECT