SELECT transactions.tx_hash, origin_function_signature AS contract_address

FROM blast.core.fact_traces traces

JOIN blast.core.fact_transactions transactions

ON traces.tx_hash = transactions.tx_hash

WHERE type ilike '%CREATE%'

AND tx_status = 'SUCCESS'

AND trace_status = 'SUCCESS'

AND origin_function_signature IN (

'0x2ad26a04','0x9ab4a98c','0x1688f0b9','0x5d28560a','0x4af63f02','0x11b804ab',

'0x64e03087','0xc9c65396','0xcdcb760a','0xe75b3c82','0x404afe76','0x0582823a',

'0xe93e5094','0x66cfa057','0x9ae06c84','0xa1671295','0x2b85ba38','0x9dca362f',

'0x4314f120','0x4314f120','0x478be160','0xb5bf2cc7','0xf425a3ce','0x9af2297c',

'0xf4ddaef3','0x36bf95a0','0x9c4ae2d0','0x583c15b5','0x60806040','0x60e06040',

'0x0bce3117','0x60e03462','0x60a06040','0x60803461','0x6101a060','0x60803462',

'0x60c03462', '0xccf0af29', '0x60406080'

)

),

t2 as (

select tx_hash, to_address, origin_function_signature

from blast.core.fact_traces

join blast.core.fact_transactions

using (tx_hash)

where data:to = to_address

and data:from = from_address

and data:type = 'CREATE'

and tx_status = 'SUCCESS'

select * from t2