Or do they only check to see for a to address to be blank in a transaction.

Does it find all CREATE/CREATE2 opcodes -> meaning an EoA or contract deployment?

1 Answer 1


Yes, it seems that creation_traces includes all contract creations from EOAs as well as from contracts.

Every entry in creation_traces has a corresponding entry in traces table. In this query, if trace_address is not empty it means it's and internal call to CREATE/CREATE2 from a contract, otherwise it's a direct deployment from an EOA.

SELECT ct.block_time, ct.tx_hash, tr.trace_address, tr.type, ct."from", tr.to, ct.address
FROM ethereum.creation_traces AS ct, ethereum.traces AS tr
WHERE ct.block_number > 16500000
AND tr.tx_hash = ct.tx_hash
AND tr.address = ct.address
ORDER BY ct.block_number, tr.tx_index, tr.trace_address

Example: https://dune.com/queries/2833121/4729239

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.