🌱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 polygon_zkevm.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.	0xf215243cd4e3b01f29f51d3ea1fc93fe52eee915
block_hash	The hash of the block that this contract was created in.	0xbd391372f7771f82752a963b03a0a00290e9ac083376874865ff370630b5fbc3
block_number	The number of the block that this contract was created in.	9073387
block_timestamp	The timestamp of the block that this contract was created in.	2024-01-08 05:12:32+00:00
bytecode_creation	The bytecode data of this contract (Traces input).	0x608060405260008054.....
bytecode_runtime	The bytecode data of this contract (Traces output).	0x608060405234801560.....
deployer	Address of the contract deployer.	0x69155e7ca2e688ccdc247f6c4ddf374b3ae77bd6
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_0x59acf83bcc13fc7a9077422508b23cc7bf27949fa4c6e7dac22018d646f6f6c6_
subtraces	Number of children traces.	0
trace_address	The address of the trace within the call graph. More detail to come soon.
transaction_hash	Unique identifier of the transaction that contains this trace.	0x59acf83bcc13fc7a9077422508b23cc7bf27949fa4c6e7dac22018d646f6f6c6
transaction_index	The position of this transaction in the block that it belongs to. The first transaction has index 0.	0
_updated_at	Timestamp of the entry creation.	2024-01-08 06:10:39.701000+00:00
_created_at	Timestamp of the entry update.	2024-01-08 06:10:39.701000+00:00

Column Name

Description

Example

address

Contract address.

0xf215243cd4e3b01f29f51d3ea1fc93fe52eee915

block_hash

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

0xbd391372f7771f82752a963b03a0a00290e9ac083376874865ff370630b5fbc3

block_number

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

9073387

block_timestamp

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

2024-01-08 05:12:32+00:00

bytecode_creation

The bytecode data of this contract (Traces input).

0x608060405260008054.....

bytecode_runtime

The bytecode data of this contract (Traces output).

0x608060405234801560.....

deployer

Address of the contract deployer.

0x69155e7ca2e688ccdc247f6c4ddf374b3ae77bd6

trace_type

Timestamp of the entry creation.

create

status

Timestamp of the entry update.

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_0x59acf83bcc13fc7a9077422508b23cc7bf27949fa4c6e7dac22018d646f6f6c6_

subtraces

Number of children traces.

trace_address

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

transaction_hash

Unique identifier of the transaction that contains this trace.

0x59acf83bcc13fc7a9077422508b23cc7bf27949fa4c6e7dac22018d646f6f6c6

transaction_index

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

_updated_at

Timestamp of the entry creation.

2024-01-08 06:10:39.701000+00:00

_created_at

Timestamp of the entry update.

2024-01-08 06:10:39.701000+00:00

Last updated 1 month ago