chainlink_v1_optimism

Tables

EVM2EVMOnRamp_CCIPSendRequested_event

CCIP (Cross-Chain Interoperability Protocol) send request events emitted by EVM2EVMOnRamp contracts when cross-chain messages are initiated. Contains message metadata including source/destination chain selectors, sender/receiver addresses, sequence numbers, gas limits, fee token details, and optional token transfer amounts for tracking cross-chain message flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_message`	`STRUCT<sourceChainSelector STRING, sequenceNumber STRING, feeTokenAmount STRING, sender STRING, nonce STRING, gasLimit STRING, strict BOOL, receiver STRING, data STRING, tokenAmounts ARRAY<STRUCT<token STRING, amount STRING>>, feeToken STRING, messageId STRING>`	Optional arbitrary data payload for the cross-chain transfer. Hex-encoded byte string with 0x prefix.

Sample Data

address	removed	log_index	in_message	block_number	block_timestamp	transaction_hash
0xad1b1f2a6dd55627e3893b771a00cd43f69dce35	false	7	{“data”:“0x6e6577206d6573736167652077697468204964203131”,“nonce”:“375”,“sender”:“0x7a0a06735e41dc59f90228686f44bf2e13cc1724”,“strict”:false,“feeToken”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0xc6d106b0174a49f0c145e86b74e9159c817958be34338fe2f65befff5a90a4b7”,“tokenAmounts”:[{“token”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“amount”:“1”}],“feeTokenAmount”:“2381119502921941755”,“sequenceNumber”:“381”,“sourceChainSelector”:“3734403246176062136”}	107367912	2023-07-26T01:23:21.000Z	0x39803d7041705c795cdba5285afee5fce03f584fdbfe97b8598afe0f7938cc6a
0xad1b1f2a6dd55627e3893b771a00cd43f69dce35	false	7	{“data”:“0x6e6577206d6573736167652077697468204964203233”,“nonce”:“387”,“sender”:“0x7a0a06735e41dc59f90228686f44bf2e13cc1724”,“strict”:false,“feeToken”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0xa5a6a99f5f9b8ee8b2f541d912a5b9a815dc390d0a22a84c10efc96b74cc27db”,“tokenAmounts”:[{“token”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“amount”:“1”}],“feeTokenAmount”:“3666547614531538518”,“sequenceNumber”:“393”,“sourceChainSelector”:“3734403246176062136”}	107389512	2023-07-26T13:23:21.000Z	0x1d182e920a340bde2c73cf63a5fb7d826078113eff9dd5dc222d295bd6f98623
0xad1b1f2a6dd55627e3893b771a00cd43f69dce35	false	7	{“data”:“0x6e6577206d6573736167652077697468204964203234”,“nonce”:“388”,“sender”:“0x7a0a06735e41dc59f90228686f44bf2e13cc1724”,“strict”:false,“feeToken”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0xcec9a4d408379d78d59bc05a096bdee41b0184029b3944decca82bc854461f0d”,“tokenAmounts”:[{“token”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“amount”:“1”}],“feeTokenAmount”:“4352540576195325325”,“sequenceNumber”:“394”,“sourceChainSelector”:“3734403246176062136”}	107391313	2023-07-26T14:23:23.000Z	0xd5b4ff01454d8b821424626a1fe0e466f2ce4a9222eff1a6ce93f28fc131382b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.EVM2EVMOnRamp_CCIPSendRequested_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EVM2EVMOnRampPreLaunchV1_CCIPSendRequested_event

Chainlink Cross-Chain Interoperability Protocol (CCIP) send request events emitted by EVM2EVM OnRamp contracts during the pre-launch phase. Contains complete message details including source chain selector, sender/receiver addresses, token transfers, gas limits, fees, and unique message identifiers for tracking cross-chain message routing.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_message`	`STRUCT<sourceChainSelector STRING, sequenceNumber STRING, feeTokenAmount STRING, sender STRING, nonce STRING, gasLimit STRING, strict BOOL, receiver STRING, data STRING, tokenAmounts ARRAY<STRUCT<token STRING, amount STRING>>, feeToken STRING, messageId STRING>`	Optional arbitrary data payload for the cross-chain transfer. Hex-encoded byte string with 0x prefix.

Sample Data

address	removed	log_index	in_message	block_number	block_timestamp	transaction_hash
0x872f782a861519b3fdfb1060649f4c8343d806fe	false	33	{“data”:“0x6d73672031”,“nonce”:“1”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“gasLimit”:“100000”,“receiver”:“0xe54e8e4813c2bcbb91e875a33bc73a2c3fbe03e0”,“messageId”:“0x096b9da5bc6ba5c5ad19e4520d3c349309865bebb1d57191d739bf986ff5f7c3”,“tokenAmounts”:[{“token”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“amount”:“100000000000000”}],“feeTokenAmount”:“103100000000000000”,“sequenceNumber”:“1”,“sourceChainSelector”:“3734403246176062136”}	105369111	2023-06-09T18:56:39.000Z	0xc6d25ce50a1997a10a04a45929d961d95797996489c3ac5d0e5e70a2909b9915

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.EVM2EVMOnRampPreLaunchV1_CCIPSendRequested_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EVM2EVMOnRampPreLaunchV2_CCIPSendRequested_event

Cross-Chain Interoperability Protocol (CCIP) send request events emitted by EVM2EVM OnRamp contracts during the pre-launch V2 phase. Contains message details including source chain selector, sequence number, sender/receiver addresses, token amounts, fee token information, gas limits, and unique message identifiers for tracking cross-chain message initiation.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_message`	`STRUCT<sourceChainSelector STRING, sequenceNumber STRING, feeTokenAmount STRING, sender STRING, nonce STRING, gasLimit STRING, strict BOOL, receiver STRING, data STRING, tokenAmounts ARRAY<STRUCT<token STRING, amount STRING>>, feeToken STRING, messageId STRING>`	Optional arbitrary data payload for the cross-chain transfer. Hex-encoded byte string with 0x prefix.

Sample Data

address	removed	log_index	in_message	block_number	block_timestamp	transaction_hash
0xd9fb89196c902d46c07ca91e492d3e0c77a5bf93	false	28	{“data”:“0x6d73672031”,“nonce”:“1”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“gasLimit”:“100000”,“receiver”:“0xc96aedd80da0e5c204fa52446b00624817c8718b”,“messageId”:“0xc7469283e3e8652fc81d99c8e6e7c2896d91667445e2506f987b8fae57deb6d6”,“tokenAmounts”:[{“token”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“amount”:“100000000000000”}],“feeTokenAmount”:“5467132786755126969”,“sequenceNumber”:“1”,“sourceChainSelector”:“3734403246176062136”}	105933398	2023-06-22T20:26:13.000Z	0x5aabe3596fa76fbb33e0e7f305dd21ab131435bd3faf66fbec944dc3e7629adf
0xd9fb89196c902d46c07ca91e492d3e0c77a5bf93	false	21	{“data”:“0x6d65737361676520776974682049642032”,“nonce”:“7”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“gasLimit”:“100000”,“receiver”:“0xc96aedd80da0e5c204fa52446b00624817c8718b”,“messageId”:“0xb05bf355448851749165116624121f1091bd9c0a1e1eba873cae254c9b090463”,“tokenAmounts”:[{“token”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“amount”:“1”}],“feeTokenAmount”:“11804513487621871007”,“sequenceNumber”:“7”,“sourceChainSelector”:“3734403246176062136”}	106147519	2023-06-27T19:23:35.000Z	0xb9d9444ffeeb66518fbd1a64d63d8acfb84cf7114bfdcc5bcd70a84aaf00ac1e
0xd9fb89196c902d46c07ca91e492d3e0c77a5bf93	false	14	{“data”:“0x6d65737361676520776974682049642031”,“nonce”:“6”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“gasLimit”:“100000”,“receiver”:“0xc96aedd80da0e5c204fa52446b00624817c8718b”,“messageId”:“0x2c8ccc4197eb97b4cd97a685d01f281144ee52ef518187e88365ef05a7189846”,“tokenAmounts”:[{“token”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“amount”:“1”}],“feeTokenAmount”:“11804513487621871007”,“sequenceNumber”:“6”,“sourceChainSelector”:“3734403246176062136”}	106147489	2023-06-27T19:22:35.000Z	0xaf503e434b7d6f77400ed0af552b7bea0b72186b245cd09d14fb80aa9a316379

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.EVM2EVMOnRampPreLaunchV2_CCIPSendRequested_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EVM2EVMOnRampPreLaunchV3_CCIPSendRequested_event

Cross-chain message send requests initiated through Chainlink CCIP (Cross-Chain Interoperability Protocol) on Optimism. Captures outbound cross-chain transfers including message data, token amounts, fees, gas limits, and destination chain selectors for analyzing CCIP bridge activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_message`	`STRUCT<sourceChainSelector STRING, sequenceNumber STRING, feeTokenAmount STRING, sender STRING, nonce STRING, gasLimit STRING, strict BOOL, receiver STRING, data STRING, tokenAmounts ARRAY<STRUCT<token STRING, amount STRING>>, feeToken STRING, messageId STRING>`	Optional arbitrary data payload for the cross-chain transfer. Hex-encoded byte string with 0x prefix.

Sample Data

address	removed	log_index	in_message	block_number	block_timestamp	transaction_hash
0xf06a2e32477363bcacae5b86479e176ca83d3f9d	false	2	{“data”:“0x”,“nonce”:“1”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x4200000000000000000000000000000000000006”,“gasLimit”:“200000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0x772367f5bae187f27e3fb598a49b14710ac1eaa037afbfe5705851401d11af1a”,“tokenAmounts”:[],“feeTokenAmount”:“280000000000000”,“sequenceNumber”:“1”,“sourceChainSelector”:“3734403246176062136”}	103429297	2023-06-01T01:39:22.000Z	0x04185f0e29062919b832df7e8d5aa1ce5ca4bde4aaf52314c5645c2b1e1182ae
0xf06a2e32477363bcacae5b86479e176ca83d3f9d	false	5	{“data”:“0x”,“nonce”:“2”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x4200000000000000000000000000000000000006”,“gasLimit”:“200000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0xdcb22d3d886e246a1abd0d58487adb65a83fa189db4a650d537a6fb8421640e5”,“tokenAmounts”:[{“token”:“0x4200000000000000000000000000000000000006”,“amount”:“100”}],“feeTokenAmount”:“946666666666666”,“sequenceNumber”:“2”,“sourceChainSelector”:“3734403246176062136”}	103442734	2023-06-01T03:00:56.000Z	0xb73a6a402aa5684aa3e967af4925fc432fb732c63df428020d3482d4e0d6de18
0xf06a2e32477363bcacae5b86479e176ca83d3f9d	false	6	{“data”:“0x6d73672031”,“nonce”:“3”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“gasLimit”:“100000”,“receiver”:“0xc96aedd80da0e5c204fa52446b00624817c8718b”,“messageId”:“0x9028b41c08ef4aa4f1b8a7bbd98ad184babbaaf450267e9947fbac6d5866fd20”,“tokenAmounts”:[{“token”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“amount”:“100000000000000”}],“feeTokenAmount”:“369672546108721942”,“sequenceNumber”:“3”,“sourceChainSelector”:“3734403246176062136”}	103949010	2023-06-02T19:04:46.000Z	0x0a5feadb0669381a624ee0d7848d352db6d31829c61d33ebabcfbfd7cf62b528

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.EVM2EVMOnRampPreLaunchV3_CCIPSendRequested_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EVM2EVMOnRampV2_CCIPSendRequested_event

Chainlink Cross-Chain Interoperability Protocol (CCIP) send request events emitted when messages are initiated on the source chain. Contains message metadata including sender, receiver, destination chain selector, fee details, optional token transfers, and unique message identifier for tracking cross-chain transfers.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_message`	`STRUCT<sourceChainSelector STRING, sender STRING, receiver STRING, sequenceNumber STRING, gasLimit STRING, strict BOOL, nonce STRING, feeToken STRING, feeTokenAmount STRING, data STRING, tokenAmounts ARRAY<STRUCT<token STRING, amount STRING>>, sourceTokenData ARRAY<STRING>, messageId STRING>`	Optional arbitrary data payload for the cross-chain transfer. Hex-encoded byte string with 0x prefix.

Sample Data

address	removed	log_index	in_message	block_number	block_timestamp	transaction_hash
0x55183db1d2ae0b63e4c92a64bef2cbfc2032b127	false	32	{“data”:“0x”,“nonce”:“1”,“sender”:“0x8772e82fb8842f160a685a992585cebf5f97930d”,“strict”:false,“feeToken”:“0x4200000000000000000000000000000000000006”,“gasLimit”:“0”,“receiver”:“0x8772e82fb8842f160a685a992585cebf5f97930d”,“messageId”:“0xce8679ab2e8f7f221268fc2bbcf4b382118152617de5a4f4f7c92621c9af0b6a”,“tokenAmounts”:[{“token”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“amount”:“30000000”}],“feeTokenAmount”:“16383013138334374”,“sequenceNumber”:“98”,“sourceTokenData”:[“0x0000000000000000000000000000000000000000000000000000000000009b3d0000000000000000000000000000000000000000000000000000000000000002”],“sourceChainSelector”:“3734403246176062136”}	115290935	2024-01-25T11:04:07.000Z	0x5d5be0a9a83bc1ae1679f534b1ed78b0217a4ecca3fe4069412b30ce9a7234d3
0x0c9be7cfd12c735e5aae047c1dcb845d54e518c3	false	21	{“data”:“0x”,“nonce”:“1”,“sender”:“0x5edf0ee99c44ef9d19d7d0183769a788af67afb0”,“strict”:false,“feeToken”:“0x4200000000000000000000000000000000000006”,“gasLimit”:“0”,“receiver”:“0x5edf0ee99c44ef9d19d7d0183769a788af67afb0”,“messageId”:“0x2a1c75901bf2aed2f8b6342539b545372bdae8c18268df3b34fe20d92874c379”,“tokenAmounts”:[{“token”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“amount”:“1628450511”}],“feeTokenAmount”:“88991323551294”,“sequenceNumber”:“18958”,“sourceTokenData”:[“0x00000000000000000000000000000000000000000000000000000000000273aa0000000000000000000000000000000000000000000000000000000000000002”],“sourceChainSelector”:“3734403246176062136”}	121513929	2024-06-17T12:17:15.000Z	0xf8a8d7e66b937d9f5755547103e5da607d9c6b1f0ed83f66b6f0a9e3608620ff
0x0b1760a8112183303c5526c6b24569fd3a274f3b	false	23	{“data”:“0x”,“nonce”:“1”,“sender”:“0x9e5a57470a2a136a3d4de39e1996e05944c4b1fb”,“strict”:false,“feeToken”:“0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6”,“gasLimit”:“0”,“receiver”:“0x9e5a57470a2a136a3d4de39e1996e05944c4b1fb”,“messageId”:“0xaf2c3c1d668e4f4ecfc26f61e0ed16158b919d6c68c4bee4af1e570e0607fe48”,“tokenAmounts”:[{“token”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“amount”:“316586861”}],“feeTokenAmount”:“16254104486369445”,“sequenceNumber”:“16661”,“sourceTokenData”:[“0x00000000000000000000000000000000000000000000000000000000000273280000000000000000000000000000000000000000000000000000000000000002”],“sourceChainSelector”:“3734403246176062136”}	121506071	2024-06-17T07:55:19.000Z	0xb6827676e23f8959070c23d9ed67802b28b68dc17ae09e29fb0cf071b8bf677f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.EVM2EVMOnRampV2_CCIPSendRequested_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Router_OffRampAdded_event

Chainlink Cross-Chain Interoperability Protocol (CCIP) Router event emitted when an OffRamp contract is registered for a specific source chain. Records the mapping between source chain selectors and their corresponding OffRamp contract addresses for routing cross-chain messages.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sourceChainSelector`	`STRING`	Chainlink CCIP source chain selector identifier. Numeric string representing the originating blockchain in cross-chain communication protocol operations.
`in_offRamp`	`STRING`	Contract address of the Chainlink CCIP OffRamp contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_offRamp	block_number	block_timestamp	transaction_hash	in_sourceChainSelector
0x261c05167db67b2b619f9d312e0753f3721ad6e8	false	21	0x704df5613166f552b80ed5a27f3559daa30eb8c8	110245479	2023-09-30T16:02:15.000Z	0x7ef6a478e4d771cca75cb7380e3b6a18a29f8eae3846517a35dfcbe595b353e4	15971525489660198786
0x261c05167db67b2b619f9d312e0753f3721ad6e8	false	22	0x43a2df743aac63eeb7da430ac0bbff0579311b84	110245479	2023-09-30T16:02:15.000Z	0x7ef6a478e4d771cca75cb7380e3b6a18a29f8eae3846517a35dfcbe595b353e4	4051577828743386545
0x261c05167db67b2b619f9d312e0753f3721ad6e8	false	122	0x032f957bfbb8c535a1b2048f8b4fa27e1f2018fd	106535143	2023-07-06T18:44:23.000Z	0x7371edb2a14ffbe0cb0386bce7e57f1df6a76720d98155410ca14298439cfed5	5009297550715157269

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.Router_OffRampAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Router_OnRampSet_event

Chainlink CCIP (Cross-Chain Interoperability Protocol) router configuration events recording the assignment of OnRamp contracts to destination chain selectors. Used for tracking cross-chain routing topology changes and CCIP infrastructure deployment.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destChainSelector`	`STRING`	Chainlink CCIP destination chain identifier. Numeric string representing the target blockchain for cross-chain message routing.
`in_onRamp`	`STRING`	Contract address of the Chainlink CCIP OnRamp contract for the specified destination chain. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_onRamp	log_index	block_number	block_timestamp	transaction_hash	in_destChainSelector
0x261c05167db67b2b619f9d312e0753f3721ad6e8	false	0xad1b1f2a6dd55627e3893b771a00cd43f69dce35	16	106535112	2023-07-06T18:43:21.000Z	0x5e09d40a90482221a82aa644b4848902dcc3bc4d332f17273874421c1a16fcb8	5009297550715157269
0x261c05167db67b2b619f9d312e0753f3721ad6e8	false	0xc40f7c8763e35fb64ab968dc812c2d24c6f8404c	10	110297539	2023-10-01T20:57:35.000Z	0xb67f470dc65c1bf80e997a3f211a27a75c5992ea207e967586e00ede9f79b35b	15971525489660198786
0x261c05167db67b2b619f9d312e0753f3721ad6e8	false	0xb188bd6cc347299eebb3ae93f57d90f580536b3a	11	110297539	2023-10-01T20:57:35.000Z	0xb67f470dc65c1bf80e997a3f211a27a75c5992ea207e967586e00ede9f79b35b	4051577828743386545

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.Router_OnRampSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

RouterPreLaunchV1_OnRampSet_event

Chainlink CCIP (Cross-Chain Interoperability Protocol) router configuration events recording OnRamp contract assignments for destination chains. Tracks routing infrastructure setup for cross-chain messaging by mapping chain selectors to their corresponding OnRamp contract addresses.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destChainSelector`	`STRING`	Chainlink CCIP destination chain identifier. Numeric string representing the target blockchain for cross-chain message routing.
`in_onRamp`	`STRING`	Contract address of the Chainlink CCIP OnRamp contract for the specified destination chain. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_onRamp	log_index	block_number	block_timestamp	transaction_hash	in_destChainSelector
0x738237f8af45b1b83c83e63bdfbadcbf29abdad9	false	0x872f782a861519b3fdfb1060649f4c8343d806fe	65	105360726	2023-06-09T14:17:09.000Z	0xb43edb0d94afd7cf5fc02fe35cb428c3855c84128a575b34e13b81c86f63860a	4949039107694359620

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.RouterPreLaunchV1_OnRampSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

RouterPreLaunchV2_OnRampSet_event

Chainlink CCIP (Cross-Chain Interoperability Protocol) router configuration event emitted when an OnRamp contract address is registered for a destination chain. Records the mapping between destination chain selectors and their corresponding OnRamp contract addresses for cross-chain message routing.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destChainSelector`	`STRING`	Chainlink CCIP destination chain identifier. Numeric string representing the target blockchain for cross-chain message routing.
`in_onRamp`	`STRING`	Contract address of the Chainlink CCIP OnRamp contract for the specified destination chain. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_onRamp	log_index	block_number	block_timestamp	transaction_hash	in_destChainSelector
0x3035ddcd17297bd0ad3282fd15fb58fedfa8e498	false	0xd9fb89196c902d46c07ca91e492d3e0c77a5bf93	29	105889226	2023-06-21T19:53:49.000Z	0x6d8bc129de07c66555cf6ab92136d251ec1a082aca426818a3f49793e9afe76a	5009297550715157269

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.RouterPreLaunchV2_OnRampSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

RouterPreLaunchV3_OnRampSet_event

Chainlink CCIP router configuration events on Optimism recording when onRamp contracts are added or removed for specific destination chains. Used to track cross-chain messaging route availability and router configuration changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destChainSelector`	`STRING`	Chainlink CCIP destination chain identifier. Numeric string representing the target blockchain for cross-chain message routing.
`in_onRamp`	`STRING`	Contract address of the Chainlink CCIP OnRamp contract for the specified destination chain. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_onRamp	log_index	block_number	block_timestamp	transaction_hash	in_destChainSelector
0xddfdfe69fd50ad26d3c7377623c04676cdb87555	false	0xf06a2e32477363bcacae5b86479e176ca83d3f9d	0	101118847	2023-05-24T15:54:42.000Z	0xce108b92d4cf5d6b0c7890bfd2912a6565c92aadee6f23cadc93e5278f04b69b	5009297550715157269

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.RouterPreLaunchV3_OnRampSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

RouterV2_OffRampAdded_event

Chainlink CCIP (Cross-Chain Interoperability Protocol) router event emitted when an OffRamp contract is registered for a source chain. Records the OffRamp contract address and source chain selector, enabling cross-chain message routing configuration tracking.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sourceChainSelector`	`STRING`	Chainlink CCIP source chain selector identifier. Numeric string representing the originating blockchain in cross-chain communication protocol operations.
`in_offRamp`	`STRING`	Contract address of the Chainlink CCIP OffRamp contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_offRamp	block_number	block_timestamp	transaction_hash	in_sourceChainSelector
0x3206695cae29952f4b0c22a169725a865bc8ce0f	false	5	0xac8c94242aa8234bf89682abcddf805ae8cff61d	115361479	2024-01-27T02:15:35.000Z	0xddc2a676a950e6277656fa655cad726bb23287fee4f96908c7d78b14fbe48361	4949039107694359620
0x3206695cae29952f4b0c22a169725a865bc8ce0f	false	3	0xe14501f2838f2fa1ceb52e78abda289ece1705ea	116003328	2024-02-10T22:50:33.000Z	0x5d41a82400b4db99a02e5e2a75bf7307d1b8ca076dab7ed4f7ba4581d9342e5c	11344663589394136015
0x3206695cae29952f4b0c22a169725a865bc8ce0f	false	2	0x8dc6490a6204df846babe809cb695ba17df1f9b1	116003328	2024-02-10T22:50:33.000Z	0x5d41a82400b4db99a02e5e2a75bf7307d1b8ca076dab7ed4f7ba4581d9342e5c	6433500567565415381

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.RouterV2_OffRampAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

RouterV2_OnRampSet_event

Chainlink CCIP (Cross-Chain Interoperability Protocol) router configuration events recording OnRamp contract assignments to destination chain selectors. Emitted when the router establishes or updates the OnRamp contract address for cross-chain message routing to a specific blockchain.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destChainSelector`	`STRING`	Chainlink CCIP destination chain identifier. Numeric string representing the target blockchain for cross-chain message routing.
`in_onRamp`	`STRING`	Contract address of the Chainlink CCIP OnRamp contract for the specified destination chain. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_onRamp	log_index	block_number	block_timestamp	transaction_hash	in_destChainSelector
0x3206695cae29952f4b0c22a169725a865bc8ce0f	false	0x14aa3cc03583aa557dbca4ce72288cc5f37dde34	59	120302015	2024-05-20T11:00:07.000Z	0x08de13702e1fe6c350a6b6567e80043bfaad3653799ef2c84e8d8f21510c955c	465200170687744372
0x3206695cae29952f4b0c22a169725a865bc8ce0f	false	0xd0d3e757bfbce7ae1881ddd7f6d798ddce588445	4	116129316	2024-02-13T20:50:09.000Z	0x897f45795b12dc96a31b8c49ed54e2a210cf3f4a40bf9728499eebabcbdec550	6433500567565415381
0x3206695cae29952f4b0c22a169725a865bc8ce0f	false	0xa3c9544b82846c45be37593d5d9acffbe61bf3a6	5	116129316	2024-02-13T20:50:09.000Z	0x897f45795b12dc96a31b8c49ed54e2a210cf3f4a40bf9728499eebabcbdec550	11344663589394136015

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_optimism.RouterV2_OnRampSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

EVM2EVMOnRamp_CCIPSendRequested_event

EVM2EVMOnRampPreLaunchV1_CCIPSendRequested_event

EVM2EVMOnRampPreLaunchV2_CCIPSendRequested_event

EVM2EVMOnRampPreLaunchV3_CCIPSendRequested_event

EVM2EVMOnRampV2_CCIPSendRequested_event

Router_OffRampAdded_event

Router_OnRampSet_event

RouterPreLaunchV1_OnRampSet_event

RouterPreLaunchV2_OnRampSet_event

RouterPreLaunchV3_OnRampSet_event

RouterV2_OffRampAdded_event

RouterV2_OnRampSet_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​EVM2EVMOnRamp_CCIPSendRequested_event

​EVM2EVMOnRampPreLaunchV1_CCIPSendRequested_event

​EVM2EVMOnRampPreLaunchV2_CCIPSendRequested_event

​EVM2EVMOnRampPreLaunchV3_CCIPSendRequested_event

​EVM2EVMOnRampV2_CCIPSendRequested_event

​Router_OffRampAdded_event

​Router_OnRampSet_event

​RouterPreLaunchV1_OnRampSet_event

​RouterPreLaunchV2_OnRampSet_event

​RouterPreLaunchV3_OnRampSet_event

​RouterV2_OffRampAdded_event

​RouterV2_OnRampSet_event

Tables

EVM2EVMOnRamp_CCIPSendRequested_event

EVM2EVMOnRampPreLaunchV1_CCIPSendRequested_event

EVM2EVMOnRampPreLaunchV2_CCIPSendRequested_event

EVM2EVMOnRampPreLaunchV3_CCIPSendRequested_event

EVM2EVMOnRampV2_CCIPSendRequested_event

Router_OffRampAdded_event

Router_OnRampSet_event

RouterPreLaunchV1_OnRampSet_event

RouterPreLaunchV2_OnRampSet_event

RouterPreLaunchV3_OnRampSet_event

RouterV2_OffRampAdded_event

RouterV2_OnRampSet_event