Contract Events

The contract events table contains all contract deployment (trace type = create, create2) and destruction (trace type = suicide) events from internal transactions (traces).

This table contains both failed (error messaged and/or status = 1) and successful (status = 1 and no error message) events are included in this dataset.

Example

Finding all successful contract deployment.

select * from optimism.raw.contract_events 
where 1=1 
and status = 1 and error is null 
and trace_type in ('create', 'create2')
limit 100

Table Columns

Column Name
Description
Example

address

Contract address.

0xbc65e9982b09ed8c725fdf62931eeb45b0e010d5

block_hash

The hash of the block that this contract was created in.

0x65c3765ddfe55a7287d85ad453f5af2bafcb8ff5e316218fab0361601bc4925a

block_number

The number of the block that this contract was created in.

111020336

block_timestamp

The timestamp of the block that this contract was created in.

2023-10-18 14:30:49+00:00

bytecode_creation

The bytecode data of this contract (Traces input).

0x3d602d80600a3d3981.....

bytecode_runtime

The bytecode data of this contract (Traces output).

0x363d3d373d3d3d363d.....

deployer

Address of the contract deployer.

0x795ba11d575e6703282b1db0cb849a15e304115d

trace_type

Timestamp of the entry creation.

create

status

Timestamp of the entry update.

1

error

Human readable developer error message. Examples: "Out of gas", "Reverted", "Bad instruction", "Bad jump destination".

trace_id

Unique identifier for this trace. Generated by combining the trace_type, transaction_hash and trace_address.

create_0xf1f68b6a76e9040a37c17cb972a8b6c20f54fbd9f3d6b4d0ef26a980d6dccf42_0_7_0_4_0_0_0_2

subtraces

Number of children traces.

0

trace_address

The address of the trace within the call graph. More detail to come soon.

0,7,0,4,0,0,0,2

transaction_hash

Unique identifier of the transaction that contains this trace.

0xf1f68b6a76e9040a37c17cb972a8b6c20f54fbd9f3d6b4d0ef26a980d6dccf42

transaction_index

The position of this transaction in the block that it belongs to. The first transaction has index 0.

8

_updated_at

Timestamp of the entry creation.

2023-12-19 13:54:50.363000+00:00

_created_at

Timestamp of the entry update.

2023-12-19 13:54:50.363000+00:00

Last updated