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