chainlink_v1_arbitrum

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
0x5e4c65194f6f33a8bf7e9b95f1d0ca9d611f6d62	false	2	1948186	413	4513530	1641766356	2022-01-09T22:12:36.000Z	0xf34a0e157e760938cefebd02d1d8c7316a41217a209e08d40cb672281712da2a
0x1a2b9e570fe9032562f0e200d03cd29dcf082268	false	2	61285997793	79	4504236	1641702644	2022-01-09T04:30:44.000Z	0xc42f761ad719bee7741a095d97eb1904b3f708f4a8b3276291d003e7851b18e2
0x3c8f2d5af2e0f5ef7c23a08df6ad168ece071d4b	false	2	13407222563784824000	603	4500639	1641689656	2022-01-09T00:54:16.000Z	0xf9d84f44be12ef7e120ef8330fed8270407119f63bd2d96e85cafc84178db806

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_arbitrum.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
0x98dd9e9b8ae458225119ab5b8c947a9d1cd0b648	false	2	{“data”:“0x6e6577206d6573736167652077697468204964203535”,“nonce”:“264”,“sender”:“0x31f8f44196d57ea2bc9a4e6cacbfcaf7868f55c6”,“strict”:false,“feeToken”:“0xf97f4df75117a78c1a5a0dbb814af92458539fb4”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0x7f6dc4e8076a61e9a9e0c38e08df9de10a0a224918e786b4dd6be57ac39b75ce”,“tokenAmounts”:[],“feeTokenAmount”:“837013616781065140”,“sequenceNumber”:“266”,“sourceChainSelector”:“4949039107694359620”}	135301960	2023-09-28T02:59:52.000Z	0x6dc7b0f68e349dc875dbbb59382b48a8f52895c0342d1ec13ae4113ebbbdbe84
0x98dd9e9b8ae458225119ab5b8c947a9d1cd0b648	false	2	{“data”:“0x6e6577206d6573736167652077697468204964203534”,“nonce”:“263”,“sender”:“0x31f8f44196d57ea2bc9a4e6cacbfcaf7868f55c6”,“strict”:false,“feeToken”:“0xf97f4df75117a78c1a5a0dbb814af92458539fb4”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0x3415d9828a502b9950df15e76f0aa0acaffefbff91bf79bf38fa1d1b757f725a”,“tokenAmounts”:[],“feeTokenAmount”:“731325133590147181”,“sequenceNumber”:“265”,“sourceChainSelector”:“4949039107694359620”}	135287985	2023-09-28T01:59:52.000Z	0x08157f96bdb0361b8db0c20b98f247696f29b3b97b89fab06a2479cc114764b8
0x98dd9e9b8ae458225119ab5b8c947a9d1cd0b648	false	2	{“data”:“0x6e6577206d6573736167652077697468204964203736”,“nonce”:“285”,“sender”:“0x31f8f44196d57ea2bc9a4e6cacbfcaf7868f55c6”,“strict”:false,“feeToken”:“0xf97f4df75117a78c1a5a0dbb814af92458539fb4”,“gasLimit”:“100000”,“receiver”:“0xafa2c441a83bbcedc2e8c5c6f66248afd8b9af3d”,“messageId”:“0x91e6c4d6005215b1c891f54a8aac92945dee97738247cc99a2844c3d5da292e1”,“tokenAmounts”:[],“feeTokenAmount”:“670861983140752882”,“sequenceNumber”:“287”,“sourceChainSelector”:“4949039107694359620”}	135597371	2023-09-28T23:59:52.000Z	0x6ba720fee2266079c597cd83b907d0f6114d3b6b0cc47d8fac3226ec3dc3cce6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_arbitrum.EVM2EVMOnRamp_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
0x67761742ac8a21ec4d76ca18cbd701e5a6f3bef3	false	4	{“data”:“0x000000000000000000000000eafe0cecf97073f5d3d7dffe2204ad079d3642d00000000000000000000000000000000000000000000004d7fb5534a9aaba1567”,“nonce”:“12”,“sender”:“0x3b6bb5de93a6de47cc9cbc06310c8a0b0a6ca9f1”,“strict”:false,“feeToken”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“gasLimit”:“140000”,“receiver”:“0x14163d7019595dc1a76e9d88ef13f66dc220577e”,“messageId”:“0xb16227434f740c9f5088541c614d357ce223546b6091b10f61bdb6a1d75ab92c”,“tokenAmounts”:[],“feeTokenAmount”:“4584052969219400”,“sequenceNumber”:“447”,“sourceTokenData”:[],“sourceChainSelector”:“4949039107694359620”}	285098475	2024-12-15T18:31:22.000Z	0xa64e1f9e17eca46d799c561bba32177491d4d1092678d4b4f792036a780fdec4
0xc1b6287a3292d6469f2d8545877e40a2f75ca9a6	false	16	{“data”:“0x0000000000000000000000009342cf58ab62c8dcc140e55aad0730ae1bf8fbee00000000000000000000000000000000000000000000009b02481cb7bb1d9397”,“nonce”:“156”,“sender”:“0x3b6bb5de93a6de47cc9cbc06310c8a0b0a6ca9f1”,“strict”:false,“feeToken”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“gasLimit”:“140000”,“receiver”:“0x3b6bb5de93a6de47cc9cbc06310c8a0b0a6ca9f1”,“messageId”:“0xfa78e16ea04a5da30c4da7a75c76deddd5e4e4305cfa79656cffeca8e071b3ef”,“tokenAmounts”:[],“feeTokenAmount”:“57419323105302”,“sequenceNumber”:“1531”,“sourceTokenData”:[],“sourceChainSelector”:“4949039107694359620”}	285056549	2024-12-15T15:36:34.000Z	0xa96f8b656f4f0420dd59c2d62618bd84da52d0b324ce1db0ae24ebf7324c5a43
0xc1b6287a3292d6469f2d8545877e40a2f75ca9a6	false	29	{“data”:“0x0000000000000000000000009342cf58ab62c8dcc140e55aad0730ae1bf8fbee00000000000000000000000000000000000000000000018757728ff2c8711c2f”,“nonce”:“157”,“sender”:“0x3b6bb5de93a6de47cc9cbc06310c8a0b0a6ca9f1”,“strict”:false,“feeToken”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“gasLimit”:“140000”,“receiver”:“0x3b6bb5de93a6de47cc9cbc06310c8a0b0a6ca9f1”,“messageId”:“0x981ece9d54ffb19d0764b067ecf57ba4970f1c2baedb9ec32b5e354878ac549c”,“tokenAmounts”:[],“feeTokenAmount”:“75850047663356”,“sequenceNumber”:“1535”,“sourceTokenData”:[],“sourceChainSelector”:“4949039107694359620”}	285069638	2024-12-15T16:31:12.000Z	0xd3e7d33e6533c1efa6e72ecf760eb1366823b1bd6cd706ab740188dcb6a656da

Example Query

Query with partition filter

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

KeeperRegistry_UpkeepPerformed_event

Execution records of automated maintenance tasks (upkeeps) performed by Chainlink Keepers on Arbitrum, including payment amounts in wei, executor addresses, and success status. Used for analyzing keeper network activity, operational costs, and automation reliability.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_payment`	`STRING`	Amount paid by the buyer in the transaction. Numeric string representation in smallest token denomination.
`in_performData`	`STRING`	Encoded data payload passed to the upkeep contract during execution, containing the parameters needed to perform the automated task. Hex-encoded byte string that varies by upkeep configuration and execution context.

Sample Data

in_id	address	in_from	removed	log_index	in_payment	in_success	block_number	in_performData	block_timestamp	transaction_hash
105231757085919987571512717234536276172704620941164111136499052440036255902080	0x75c0530885f385721fdda23c539af3701d6183d4	0x26b0421f47110d8791015afbb65a3c62c32f5317	false	1	38723179497254483	true	97380284	0x000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001	2023-06-03T14:00:02.000Z	0xa071aec11521ae96eeb1bedcb49a08ddb4c99d0c652cf67ea7aa30430ad591fa
105231757085919987571512717234536276172704620941164111136499052440036255902080	0x75c0530885f385721fdda23c539af3701d6183d4	0x26b0421f47110d8791015afbb65a3c62c32f5317	false	1	37317972771926510	true	97237214	0x000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001	2023-06-03T04:00:27.000Z	0xa67a787090fbef44a29f89872bb3bea98286e138575b6a1ebad4ddaeaa61f623
104222309140268588138532862864319460298553361789390988911733396803901070067596	0x75c0530885f385721fdda23c539af3701d6183d4	0x26b0421f47110d8791015afbb65a3c62c32f5317	false	2	211442953588548424	true	97438022	0x000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000647b7fa00000000000000000000000005ba0828a5488c20a9c6521a90ecc9c49e539060400000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000004b9f412b000000000000000000000000000000000000000000000000000000000	2023-06-03T18:00:14.000Z	0x0b99f2857b6c7eb3994d3ec5366c2e01e57d4d1fd406149da473940f8659e282

Example Query

Query with partition filter

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

Router_MessageExecuted_event

Chainlink Cross-Chain Interoperability Protocol (CCIP) message execution records on Arbitrum, tracking cross-chain messages delivered by off-ramp contracts from source chains. Used for monitoring CCIP bridge activity, message delivery status, and cross-chain communication 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_messageId`	`STRING`	Unique identifier for the cross-chain message being executed via Chainlink CCIP (Cross-Chain Interoperability Protocol). Hex-encoded, 0x-prefixed 64-character hash that tracks the message from source chain through execution on Arbitrum.
`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.
`in_calldataHash`	`STRING`	Keccak256 hash of the calldata payload for the cross-chain message being executed. Used to verify message integrity during Chainlink CCIP (Cross-Chain Interoperability Protocol) message execution on Arbitrum.

Sample Data

address	removed	log_index	in_offRamp	block_number	in_messageId	block_timestamp	in_calldataHash	transaction_hash	in_sourceChainSelector
0xe92634289a1841a979c11c2f618b33d376e4ba85	false	1	0x7b1f908cebf41d5829d0134c7dfd6aa0f163c97d	172461744	0xc1b5f8979a0cf16a4a74c9fe8177e7aab9eb9ffa4cf3bb7fa949287149432363	2024-01-20T20:40:22.000Z	0xefe64288ac50f5010c9795f6c71a7ca6531e6b7dadfb228c3c20cba4817613b0	0xe0dc52d59043d99c122c3ca18f4d724b501de92e62adf8a883bf49ecf2a60fe6	5009297550715157269
0xe92634289a1841a979c11c2f618b33d376e4ba85	false	1	0x7b1f908cebf41d5829d0134c7dfd6aa0f163c97d	172347886	0x5eb7272b403f595e482c6e5a5d77b6e86403c296563b97aa3c295a6de2dd3784	2024-01-20T12:33:20.000Z	0xe1eca42c69a47f8003906b758d7979309a31eb4fb3d2ca330016390c4315c68a	0x11a7099d6f142128dd459ce6a5e759f7ed4a59743606521ea61921150318a44f	5009297550715157269
0xe92634289a1841a979c11c2f618b33d376e4ba85	false	1	0x7b1f908cebf41d5829d0134c7dfd6aa0f163c97d	172236544	0x9b96b1ee026c03fbe4f48784ed66f8f3d085ee633c3aca8a87641f5ce69b03cf	2024-01-20T04:43:19.000Z	0x5e8607ddf4719d706cd2c04bf201c152450bf116d42e17fa7c48813aed84c72d	0xd6d6b24cfbd2b3653a57c5fa709ccd16cbf16b00760455861e5b7d935e24b1d6	5009297550715157269

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_arbitrum.Router_MessageExecuted_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
0xe92634289a1841a979c11c2f618b33d376e4ba85	false	0x98dd9e9b8ae458225119ab5b8c947a9d1cd0b648	0	131743481	2023-09-16T22:18:56.000Z	0xd33a7de3b4827c42f7eb2211e0ff3daf3802524cc35e999198059c066c83fde0	5009297550715157269
0xe92634289a1841a979c11c2f618b33d376e4ba85	false	0x590791aa846ec4d2aa2b8697edeb6158f6054839	1	136562492	2023-10-01T21:07:39.000Z	0xa463febaf55f8625445297d0a3dddf5cb37cae34d3e54f3bf25fd321be909c1f	15971525489660198786
0xe92634289a1841a979c11c2f618b33d376e4ba85	false	0x0000000000000000000000000000000000000000	7	213631265	2024-05-21T19:45:03.000Z	0x720d50d7dacf5f59e4c5a55ec3fb29317f86bb9b9bd76996536c263b2b3d5b4c	5009297550715157269

Example Query

Query with partition filter

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

RouterV2_MessageExecuted_event

Cross-chain message execution records from Chainlink CCIP (Cross-Chain Interoperability Protocol) RouterV2 on Arbitrum. Tracks completed message deliveries with source chain selectors, off-ramp addresses, and calldata hashes for analyzing cross-chain messaging 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_messageId`	`STRING`	Unique identifier for the cross-chain message being executed via Chainlink CCIP. Hex-encoded, 0x-prefixed 64-character string that tracks the message from source to destination chain.
`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.
`in_calldataHash`	`STRING`	Hash of the calldata payload included in the cross-chain message. Hex-encoded, 0x-prefixed 64-character identifier used to verify message content integrity during execution.

Sample Data

address	removed	log_index	in_offRamp	block_number	in_messageId	block_timestamp	in_calldataHash	transaction_hash	in_sourceChainSelector
0x141fa059441e0ca23ce184b6a78bafd2a517dde8	false	20	0xeeed4d86f3e0e6d32a6ad29d8de6a0dc91963a5f	189245073	0xf73101f958fc3c6ae9fe6e45c8a662e1627a31048146701d10d93c933ec74720	2024-03-11T08:59:29.000Z	0xa0945786e0d2fd451a6dc8e00e0b0179a04cfc0596d611413f8c70c0119432ce	0xd6796860d32409dd8b87028970ee80db6e5bdcbbffec216ae681b39ff164f7f9	3734403246176062136
0x141fa059441e0ca23ce184b6a78bafd2a517dde8	false	2	0xeeed4d86f3e0e6d32a6ad29d8de6a0dc91963a5f	189400612	0x7bb8c053bf55801ff694fe5582ee5d3f4f6467daa68ad4f46b8a8eb80794681e	2024-03-11T20:15:18.000Z	0x3812ab609de5343303a2fa1c51808b60e36db3ae908382cb725e8a55205ac569	0x1d28b3b12b4373222b7b590ce7896471e2f19f4d2ae0ac185017d8d3d4705a94	3734403246176062136
0x141fa059441e0ca23ce184b6a78bafd2a517dde8	false	8	0xeeed4d86f3e0e6d32a6ad29d8de6a0dc91963a5f	189235407	0x1205e21b8f026601563faa62863bf649acf9c912d9c736d29bcfb3128fa046c1	2024-03-11T08:18:27.000Z	0xc05b4e0b1af28b689865fd124646d6ca3e53dadea5b8e2abf187bca6be0ec5ef	0xa7453f9e539b97a335ae3738bc94008b1843fd5b926905b8fb4632da9dcbb1a7	3734403246176062136

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_arbitrum.RouterV2_MessageExecuted_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
0x141fa059441e0ca23ce184b6a78bafd2a517dde8	false	0x77b60f85b25fd501e3dded6c1fe7bf565c08a22a	52	155920609	2023-12-01T17:31:56.000Z	0xf861f36d8bc66bb9a631ea1a2bc6bbab5c4f6dbfea3af555f63f55945cf41f01	15971525489660198786
0x141fa059441e0ca23ce184b6a78bafd2a517dde8	false	0x6087d6c33946670232df09fe93eecbaea3d6864d	74	274406827	2024-11-14T14:27:03.000Z	0x943e0a0fc9e4d0c16c0d7bfa1b0596371b33ad8489489c4e0426c6739b5778c0	4051577828743386545
0x141fa059441e0ca23ce184b6a78bafd2a517dde8	false	0xc1b6287a3292d6469f2d8545877e40a2f75ca9a6	69	274406827	2024-11-14T14:27:03.000Z	0x943e0a0fc9e4d0c16c0d7bfa1b0596371b33ad8489489c4e0426c6739b5778c0	15971525489660198786

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_arbitrum.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

EVM2EVMOnRampV2_CCIPSendRequested_event

KeeperRegistry_UpkeepPerformed_event

Router_MessageExecuted_event

Router_OnRampSet_event

RouterV2_MessageExecuted_event

RouterV2_OnRampSet_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AccessControlledOffchainAggregator_AnswerUpdated_event

​EVM2EVMOnRamp_CCIPSendRequested_event

​EVM2EVMOnRampV2_CCIPSendRequested_event

​KeeperRegistry_UpkeepPerformed_event

​Router_MessageExecuted_event

​Router_OnRampSet_event

​RouterV2_MessageExecuted_event

​RouterV2_OnRampSet_event

Tables

AccessControlledOffchainAggregator_AnswerUpdated_event

EVM2EVMOnRamp_CCIPSendRequested_event

EVM2EVMOnRampV2_CCIPSendRequested_event

KeeperRegistry_UpkeepPerformed_event

Router_MessageExecuted_event

Router_OnRampSet_event

RouterV2_MessageExecuted_event

RouterV2_OnRampSet_event