with all_launch as (

SELECT

ev.TX_ID,

ev.BLOCK_TIMESTAMP,

ev.SIGNERS [0] as signer_id,

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

ev.INNER_INSTRUCTION:instructions [2] :parsed:info:newAccount :: string as sol_owner

FROM

solana.core.fact_events ev

WHERE

ev.program_id = 'degenhbmsyzLpJUwwrzjsPyhPNvLurBFB4k1pBWSoxs'

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

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

and ev.SUCCEEDED = 'TRUE'

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

and block_timestamp >= TIMESTAMPADD(

day,

- {{past_x_days}},

CURRENT_TIMESTAMP

)

),

launch_final as (

SELECT

al.TX_ID,

al.BLOCK_TIMESTAMP,

signer_id,

token_mint_id,

sol_owner,

AMOUNT

from

solana.core.fact_transfers tr

INNER join all_launch al on tr.tx_id = al.tx_id

where

tr.tx_id in (

SELECT