CUBE3contract creation with 0x0 to_address
Updated 2025-02-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
⌄
SELECT
*
/*
TO_ADDRESS as address,
BLOCK_NUMBER as block_number,
'constant' as blockchain_id,
BLOCK_TIMESTAMP as block_time,
OUTPUT as bytecode,
'calculated' as bytecode_hash,
FROM_ADDRESS as creator_address,
'?' as creator_address_tx,
INPUT as creator_bytecode,
'calculated' as creator_bytecode_hash,
'calculated' as received_at,
TX_HASH as transaction_hash,
'flipside' as source
*/
FROM
ethereum.core.fact_traces
WHERE
-- TO_ADDRESS = '0x0000000000000000000000000000000000000000'
--AND
TYPE IN ('CREATE2', 'CREATE')
AND
TX_STATUS = 'SUCCESS'
AND
TRACE_STATUS = 'SUCCESS'
AND
ERROR_REASON <> ''
LIMIT 16
QueryRunArchived: QueryRun has been archived