SELECT

ADDRESS AS address,

CREATED_BLOCK_NUMBER AS block_number,

CREATED_BLOCK_TIMESTAMP AS block_time,

CREATED_TX_HASH AS transaction_hash,

CREATOR_ADDRESS AS creator_address_tx

FROM

optimism.core.dim_contracts

SELECT

cd.address,

cd.block_number,

cd.block_time,

cd.transaction_hash,

cd.creator_address_tx,

ft.FROM_ADDRESS AS creator_address,

ft.INPUT AS creator_bytecode,

ft.TX_STATUS AS status,

ft.OUTPUT AS bytecode,

ft.TYPE AS opcode

FROM

contract_data cd

JOIN

optimism.core.fact_traces ft

ON

cd.transaction_hash = ft.TX_HASH

AND

cd.address = ft.TO_ADDRESS

LIMIT 5;