chainlink_v1_ethereum

Tables

AccessControlledOffchainAggregator_AnswerUpdated_event

Chainlink oracle price feed update events emitted when off-chain aggregators submit new data on-chain. Contains the updated answer value, round identifier, and timestamp for tracking oracle price movements and data freshness across decentralized oracle networks.

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_current`	`STRING`	Current oracle data value reported in the price feed update. Numeric string representing the latest aggregated data point from the oracle network.
`in_roundId`	`STRING`	Sequential identifier for the oracle price update round. Numeric string that increments with each new data submission to the aggregator contract.
`in_updatedAt`	`STRING`	Unix timestamp when the oracle data was last updated. Numeric string representing seconds since epoch.

Sample Data

address	removed	log_index	in_current	in_roundId	block_number	in_updatedAt	block_timestamp	transaction_hash
0x5c3d1309d8b6e37eff9fd6c258e1544549b39d22	false	34	174469670062211	560	13285098	1632441619	2021-09-24T00:00:19.000Z	0x30a1ad1dc0b90f78c28db87c88eee8a2dcf4e818330d57e8b19331053fc3f63d
0x7089d4567bdfb5b61594af477dacc3d29b2769a2	false	75	143463709225000000	385	13285098	1632441619	2021-09-24T00:00:19.000Z	0xe5036168c645187b5499e7f688d8ccc01ce14bc260894ea8ee964e8b56cf2aa5
0x0ed1bcc400acd34593451e76f854992198995f52	false	97	143463709225000000	249	13285098	1632441619	2021-09-24T00:00:19.000Z	0x1805b19b51f8204cff267cc5d7c0c9ad7213b992133ef19590854ed54bc66a3f

Example Query

Query with partition filter

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

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
0xcc19bc4d43d17eb6859f0d22ba300967c97780b0	false	546	{“data”:“0x6e6577206d65737361676520776974682049642031”,“nonce”:“528”,“sender”:“0x7a0a06735e41dc59f90228686f44bf2e13cc1724”,“strict”:false,“feeToken”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0x5416869bd7732b4cdaf1b4f51382c17b85cfa7cfe06d238f4e13f2a8ac2e903b”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“1”}],“feeTokenAmount”:“144580860390931956”,“sequenceNumber”:“539”,“sourceChainSelector”:“5009297550715157269”}	17823024	2023-08-01T22:05:11.000Z	0x39be20667025bd4e23808a0b2f2523d3f4d84a610617e51e18b3aaafddc65b87
0xcc19bc4d43d17eb6859f0d22ba300967c97780b0	false	545	{“data”:“0x6e6577206d65737361676520776974682049642033”,“nonce”:“529”,“sender”:“0x7a0a06735e41dc59f90228686f44bf2e13cc1724”,“strict”:false,“feeToken”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0x33dc071f1326fa3bc1244d5c7df0b9fcb46659d2d1f7bb37c037278e9292290a”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“1”}],“feeTokenAmount”:“144801781567562046”,“sequenceNumber”:“540”,“sourceChainSelector”:“5009297550715157269”}	17823323	2023-08-01T23:05:23.000Z	0xdabef81bc35c743da9a03000a39ab72cdc052843fb33043c06ba339936c2c9ec
0xcc19bc4d43d17eb6859f0d22ba300967c97780b0	false	567	{“data”:“0x6e6577206d65737361676520776974682049642032”,“nonce”:“530”,“sender”:“0x7a0a06735e41dc59f90228686f44bf2e13cc1724”,“strict”:false,“feeToken”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0xc84e1b0f85bc01aeba58264af65856bccf9ef6ebae1b967e66061893ca80c59d”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“1”}],“feeTokenAmount”:“144801781567562046”,“sequenceNumber”:“541”,“sourceChainSelector”:“5009297550715157269”}	17823323	2023-08-01T23:05:23.000Z	0x6e56ba991e75bfd74769dad5c4a5726f432f2edd36e5ad5d896151ed46bf5744

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_ethereum.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
0x5b0c089abf23b9f078a59c683abf015773f25f66	false	263	{“data”:“0x6d73672031”,“nonce”:“1”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“gasLimit”:“100000”,“receiver”:“0xefa0d1b10f9e2ec379494d5ae68615a0aa3f9a9c”,“messageId”:“0xc1239fc8f95e5cd3ace28ae5f4d9a7c1382d9c18daaff359f2ef8277453a0496”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“500000000000000000”}],“feeTokenAmount”:“103100000000000000”,“sequenceNumber”:“1”,“sourceChainSelector”:“5009297550715157269”}	17387653	2023-06-01T18:11:11.000Z	0xb051a4d088f170783ee0799c9085245d1b9b359bd7cba07280f8468add6cfec7
0xe5c9121cc3f796a8446b9d35b0d53b67eb4c1ab2	false	283	{“data”:“0x6d73672031”,“nonce”:“3”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“gasLimit”:“100000”,“receiver”:“0x16673cfb93dc33de90830eaf856e557ca18bf897”,“messageId”:“0xb8e713db583a56664fa26bd87f5eeb2a631b0418a5abc88942fd887c845e5165”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“100000000000000”}],“feeTokenAmount”:“551828358618315”,“sequenceNumber”:“3”,“sourceChainSelector”:“5009297550715157269”}	17395946	2023-06-02T22:16:59.000Z	0x455207539c90911f4fee860e0b2b4309e7de860034695e9cd9809c225c5986c2
0xe5c9121cc3f796a8446b9d35b0d53b67eb4c1ab2	false	356	{“data”:“0x6d73672031”,“nonce”:“1”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“gasLimit”:“100000”,“receiver”:“0x16673cfb93dc33de90830eaf856e557ca18bf897”,“messageId”:“0x465e4302b8afc3da092556ed2e50bde4334afe8414e8939703678d983b2932c4”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“100000000000000”}],“feeTokenAmount”:“103100000000000000”,“sequenceNumber”:“1”,“sourceChainSelector”:“5009297550715157269”}	17393729	2023-06-02T14:46:47.000Z	0x308450728825fb5e6369397bb9cf2f384be18c86121f158be7b6951f3e13ca73

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_ethereum.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
0xe94b16e0fa1f6ff0a28e1dece4946ffb5748c595	false	275	{“data”:“0x6d65737361676520776974682049642032”,“nonce”:“3”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“gasLimit”:“100000”,“receiver”:“0x236034bbb418a269f0d160b16087af11931eba71”,“messageId”:“0x09e60604555cf4911ad187ab7809d2aa88c480bdb83851842df1818743060dd2”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“1”}],“feeTokenAmount”:“166392108082322899”,“sequenceNumber”:“3”,“sourceChainSelector”:“5009297550715157269”}	17545584	2023-06-23T23:39:11.000Z	0x809ee390dd6fdb71dc59e9c4874af80323c6372fd3cbd13b352cfd1a5af18cd2
0xe94b16e0fa1f6ff0a28e1dece4946ffb5748c595	false	377	{“data”:“0x6d65737361676520776974682049642031”,“nonce”:“2”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“gasLimit”:“100000”,“receiver”:“0x236034bbb418a269f0d160b16087af11931eba71”,“messageId”:“0x1143dc2a8feda4fc2a02ec3f16d335858c7eb53df02ce38ef42695c56272630b”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“1”}],“feeTokenAmount”:“166392108082322899”,“sequenceNumber”:“2”,“sourceChainSelector”:“5009297550715157269”}	17545581	2023-06-23T23:38:35.000Z	0xab47b33553cecbb326f37e06921874f39db7658b838b6acd7d1cf906a40d7427
0xe94b16e0fa1f6ff0a28e1dece4946ffb5748c595	false	358	{“data”:“0x6d65737361676520776974682049642033”,“nonce”:“4”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“gasLimit”:“100000”,“receiver”:“0x236034bbb418a269f0d160b16087af11931eba71”,“messageId”:“0xdaa23db7765d8086664d718baaa89c81dd2113634166959da5afec1fefe8542c”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“1”}],“feeTokenAmount”:“166392108082322899”,“sequenceNumber”:“4”,“sourceChainSelector”:“5009297550715157269”}	17545589	2023-06-23T23:40:11.000Z	0x5eedf94860baaf91bba71dbc445fd753ef4e97abb611ed44770251787599e98d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_ethereum.EVM2EVMOnRampPreLaunchV2_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
0xe2c2ab221aa0b957805f229d2aa57fbe2f4dadf7	false	332	{“data”:“0x6e6577206d65737361676520776974682049642034”,“nonce”:“13”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0xfde83161cab1e79fa404c506f2813ac1243227151816d1ec8ef87234595e0592”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“1”}],“feeTokenAmount”:“1018963416116886”,“sequenceNumber”:“15”,“sourceTokenData”:[“0x”],“sourceChainSelector”:“5009297550715157269”}	18985797	2024-01-11T19:35:35.000Z	0x1c43f6da9b554e2d8e130fefd9edf5a070520ca87190a174eba7fb66463dcd7d
0xe2c2ab221aa0b957805f229d2aa57fbe2f4dadf7	false	200	{“data”:“0x6e6577206d65737361676520776974682049642035”,“nonce”:“14”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0x3ad2c8569222fe6214e6d347f4c8c7c316c22a6e9bd38cf4169fb8f092e62075”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“1”}],“feeTokenAmount”:“1018963416116886”,“sequenceNumber”:“16”,“sourceTokenData”:[“0x”],“sourceChainSelector”:“5009297550715157269”}	18985871	2024-01-11T19:50:35.000Z	0x912dc917f5a5de9d2e3ccdf230f3502e841ac5d98fb98786aabe4c66c7a2dcc7
0xe2c2ab221aa0b957805f229d2aa57fbe2f4dadf7	false	241	{“data”:“0x6e6577206d65737361676520776974682049642031”,“nonce”:“10”,“sender”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“strict”:false,“feeToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0xfd5bfd37677e2cc0dffab9f24c9f79d940adce30b2a7be8ba8c48127715bfd6b”,“tokenAmounts”:[{“token”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“amount”:“1”}],“feeTokenAmount”:“1460343160536496”,“sequenceNumber”:“12”,“sourceTokenData”:[“0x”],“sourceChainSelector”:“5009297550715157269”}	18985576	2024-01-11T18:50:35.000Z	0x218ba9bc059409e9a6553309b72544e24740980eb5bd22531ecc933b758a7bbe

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_ethereum.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
0xe561d5e02207fb5eb32cca20a699e0d8919a1476	false	287	0x61135e701a2214c170c5f596d0067798fefbaae4	18138350	2023-09-15T01:25:47.000Z	0x97a6f978b99cfe71fe36373716001554637c79ba8ee01c0cc269417a0f628cfb	4949039107694359620
0xe561d5e02207fb5eb32cca20a699e0d8919a1476	false	288	0xc7176620daf49a39a17ff9a6c2de1eaa6033ee94	18138350	2023-09-15T01:25:47.000Z	0x97a6f978b99cfe71fe36373716001554637c79ba8ee01c0cc269417a0f628cfb	11344663589394136015
0xe561d5e02207fb5eb32cca20a699e0d8919a1476	false	289	0xff51c00546aa3d9051a4b96ae81346e14709cd24	18138350	2023-09-15T01:25:47.000Z	0x97a6f978b99cfe71fe36373716001554637c79ba8ee01c0cc269417a0f628cfb	15971525489660198786

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_ethereum.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
0xe561d5e02207fb5eb32cca20a699e0d8919a1476	false	0xe2eb229e88f56691e96bb98256707bc62160fe73	131	18151618	2023-09-16T22:22:11.000Z	0x4442bf8c8da8f8df35b95e78dc40378d79fb992cd806638ae6a867e1561471d4	15971525489660198786
0xe561d5e02207fb5eb32cca20a699e0d8919a1476	false	0xdf1d7fd22ac3ab5171e275796f123224039f3b24	130	18151618	2023-09-16T22:22:11.000Z	0x4442bf8c8da8f8df35b95e78dc40378d79fb992cd806638ae6a867e1561471d4	11344663589394136015
0xe561d5e02207fb5eb32cca20a699e0d8919a1476	false	0x333f976915195ba9044fd0cd603cece936f6264e	129	18151618	2023-09-16T22:22:11.000Z	0x4442bf8c8da8f8df35b95e78dc40378d79fb992cd806638ae6a867e1561471d4	4949039107694359620

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_ethereum.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
0x879fbe2c7943fdbdd4c14d71aed9ff65959addb9	false	0xe5c9121cc3f796a8446b9d35b0d53b67eb4c1ab2	241	17324746	2023-05-23T21:58:11.000Z	0x3a85e180b3f70d75c0fbc51dc6c34db94d5a9f9e88646934314e034fcc7c3e5a	4949039107694359620
0x879fbe2c7943fdbdd4c14d71aed9ff65959addb9	false	0x5b0c089abf23b9f078a59c683abf015773f25f66	255	17324603	2023-05-23T21:29:23.000Z	0x81185ca8d9b8b9dd7e67122bb1f868857c47dea3e51dd62e0f03c5c4086329a4	6433500567565415381
0x879fbe2c7943fdbdd4c14d71aed9ff65959addb9	false	0x1c0c7858c7ad7a6b3f4aa813ee81e56d7405c712	299	17330062	2023-05-24T15:53:47.000Z	0x7ecc55d68424bbdf94457b1ee47e52712350e2ccc21f8f914f87eb5d0a1058f7	3734403246176062136

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_ethereum.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
0x40f20d1fb901dced9d1a29a5d225511dee62de26	false	0x181314cec446cd372e555a26fc3bff3c714cd838	272	17530216	2023-06-21T19:47:59.000Z	0x0cc0876e9eddd94a2cabe6634f1ab3f414f8ae8c39404cad82b9bfd580afb8f1	6433500567565415381
0x40f20d1fb901dced9d1a29a5d225511dee62de26	false	0xf1e3d79b19b1c810812cc0ce991e6421511f2824	469	17530261	2023-06-21T19:57:11.000Z	0x6569afc0c227a40792f881b9c8621715b00a1d7416274b9ece9a5100eb8c74d8	4051577828743386545
0x40f20d1fb901dced9d1a29a5d225511dee62de26	false	0xe94b16e0fa1f6ff0a28e1dece4946ffb5748c595	307	17530241	2023-06-21T19:52:59.000Z	0x5e1bbe31f6fb3e1c98c202a6db0c35a02ee640a34f979f4187d7f7d4e515fc24	3734403246176062136

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_ethereum.RouterPreLaunchV2_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
0x80226fc0ee2b096224eeac085bb9a8cba1146f7d	false	430	0x569940e02d4425eac61a7601632ec00d69f75c17	18725506	2023-12-06T06:30:11.000Z	0x7da7da016dcd2142e93d97edddf9700efb18cd167e6508b98a0697962dae703b	6433500567565415381
0x80226fc0ee2b096224eeac085bb9a8cba1146f7d	false	429	0xefc4a18af59398ff23bfe7325f2401ad44286f4d	18725506	2023-12-06T06:30:11.000Z	0x7da7da016dcd2142e93d97edddf9700efb18cd167e6508b98a0697962dae703b	4949039107694359620
0x80226fc0ee2b096224eeac085bb9a8cba1146f7d	false	428	0x0af338f0e314c7551bce0ef516d46d855b0ee395	18725506	2023-12-06T06:30:11.000Z	0x7da7da016dcd2142e93d97edddf9700efb18cd167e6508b98a0697962dae703b	4051577828743386545

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_ethereum.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
0x80226fc0ee2b096224eeac085bb9a8cba1146f7d	false	0x35f0ca9be776e4b38659944c257bdd0ba75f1b8b	522	18736819	2023-12-07T20:34:11.000Z	0x257652a7f8442b718ee15c18703ad74729e60ffd896a37b9de8c13e510ecf50b	4051577828743386545
0x80226fc0ee2b096224eeac085bb9a8cba1146f7d	false	0x91d25a56db77ad5147437d8b83eb563d46ebfa69	525	18736819	2023-12-07T20:34:11.000Z	0x257652a7f8442b718ee15c18703ad74729e60ffd896a37b9de8c13e510ecf50b	11344663589394136015
0x80226fc0ee2b096224eeac085bb9a8cba1146f7d	false	0xe2c2ab221aa0b957805f229d2aa57fbe2f4dadf7	526	18736819	2023-12-07T20:34:11.000Z	0x257652a7f8442b718ee15c18703ad74729e60ffd896a37b9de8c13e510ecf50b	15971525489660198786

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AccessControlledOffchainAggregator_AnswerUpdated_event

EVM2EVMOnRamp_CCIPSendRequested_event

EVM2EVMOnRampPreLaunchV1_CCIPSendRequested_event

EVM2EVMOnRampPreLaunchV2_CCIPSendRequested_event

EVM2EVMOnRampV2_CCIPSendRequested_event

Router_OffRampAdded_event

Router_OnRampSet_event

RouterPreLaunchV1_OnRampSet_event

RouterPreLaunchV2_OnRampSet_event

RouterV2_OffRampAdded_event

RouterV2_OnRampSet_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AccessControlledOffchainAggregator_AnswerUpdated_event

​EVM2EVMOnRamp_CCIPSendRequested_event

​EVM2EVMOnRampPreLaunchV1_CCIPSendRequested_event

​EVM2EVMOnRampPreLaunchV2_CCIPSendRequested_event

​EVM2EVMOnRampV2_CCIPSendRequested_event

​Router_OffRampAdded_event

​Router_OnRampSet_event

​RouterPreLaunchV1_OnRampSet_event

​RouterPreLaunchV2_OnRampSet_event

​RouterV2_OffRampAdded_event

​RouterV2_OnRampSet_event

Tables

AccessControlledOffchainAggregator_AnswerUpdated_event

EVM2EVMOnRamp_CCIPSendRequested_event

EVM2EVMOnRampPreLaunchV1_CCIPSendRequested_event

EVM2EVMOnRampPreLaunchV2_CCIPSendRequested_event

EVM2EVMOnRampV2_CCIPSendRequested_event

Router_OffRampAdded_event

Router_OnRampSet_event

RouterPreLaunchV1_OnRampSet_event

RouterPreLaunchV2_OnRampSet_event

RouterV2_OffRampAdded_event

RouterV2_OnRampSet_event