chainlink_v1_base

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
0x04030d2f38bc799af9b0aab5757adc98000d7ded	false	19	1135393584252167825	12	2475290	1691739927	2023-08-11T07:45:27.000Z	0x943f93a2ed27fc2618030fed1abb33284a09b46d2eb582b480eaef3b369cd699
0x08f9654349b33b955133b28e35dbecce9950c219	false	4	1046000000000000000	13	2475301	1691739949	2023-08-11T07:45:49.000Z	0x9a102342650f558b0ed3dab0f5ba6816e7bba6e90f30fc7b41498ef4ded612b8
0x0ee7145e1370653533e2f2e824424be2aa95a4aa	false	16	100000000	12	2475295	1691739937	2023-08-11T07:45:37.000Z	0x7a0e55446d9b6f96353f1e34ce76cee347a21fba650cd465cc1ef372b7049f03

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_base.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
0xd44371bfde87f2db3ea6df242091351a06c2e181	false	36	{“data”:“0x”,“nonce”:“1”,“sender”:“0xe6d29ada21574c1fcb02bd49ad2347b19766cbc9”,“strict”:false,“feeToken”:“0x4200000000000000000000000000000000000006”,“gasLimit”:“0”,“receiver”:“0xb785aadeb7c3e7cd8450c21da0ca327b35eea9ca”,“messageId”:“0xfa42d4f2c6434cf3b0a7cec186eae2a97a11d69552a8e424a047213a64087855”,“tokenAmounts”:[{“token”:“0xafb2820316e7bc5ef78d295ab9b8bb2257534576”,“amount”:“1000000000000000000”}],“feeTokenAmount”:“4531573196826001”,“sequenceNumber”:“225”,“sourceChainSelector”:“15971525489660198786”}	4510393	2023-09-27T10:22:13.000Z	0x53e9ff76267169cf535a2464defa4d6e5b7a274e0907c8d77011a2b599611f03
0xd44371bfde87f2db3ea6df242091351a06c2e181	false	17	{“data”:“0x”,“nonce”:“2”,“sender”:“0xe6d29ada21574c1fcb02bd49ad2347b19766cbc9”,“strict”:false,“feeToken”:“0x4200000000000000000000000000000000000006”,“gasLimit”:“0”,“receiver”:“0x8808aa2786f4fec9e9dd25feb504808935b6453d”,“messageId”:“0xf4c71c9076ad0157c86a490377a9950add341c982f2c71d05d47d15bbf0d543a”,“tokenAmounts”:[{“token”:“0xafb2820316e7bc5ef78d295ab9b8bb2257534576”,“amount”:“7360533520540649386867”}],“feeTokenAmount”:“10127096201881048”,“sequenceNumber”:“226”,“sourceChainSelector”:“15971525489660198786”}	4520158	2023-09-27T15:47:43.000Z	0x447341b67b26fe9356c93711abdaa79191c402e146559dd41ea93d150f567464
0xe96563b8a6b4ea245e7fcefaba813104fc889c6c	false	10	{“data”:“0x0000000000000000000000003999f3f4f4698935d69e3c8d55f963a65e70d9fd000000000000000000000000000000000000000000000000dda641cfe44aff8200000000000000000000000000000000000000000000000033d343f77863cab800000000000000000000000000000000000000000000000000000000000001200000000000000000000000003999f3f4f4698935d69e3c8d55f963a65e70d9fd0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000001e84800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000130000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“nonce”:“42”,“sender”:“0xef3c8e083de1ae85afecdaf5d6abc15427f5abcb”,“strict”:false,“feeToken”:“0x4200000000000000000000000000000000000006”,“gasLimit”:“2000000”,“receiver”:“0xef3c8e083de1ae85afecdaf5d6abc15427f5abcb”,“messageId”:“0x93dbe0eb6eebc52297912407faa9a16f9beada34b2e07b90a0fbced1dc8c11ef”,“tokenAmounts”:[],“feeTokenAmount”:“22431921039581”,“sequenceNumber”:“110”,“sourceChainSelector”:“15971525489660198786”}	8164218	2023-12-21T00:16:23.000Z	0x822e658bf717a0d5a0ebdbc61ae15565971786a61cfc9123402833886d62ea17

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_base.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
0xd952feacdd5919cc5e9454b53bf45d4e73dd6457	false	83	{“data”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000f5652f712867ead6c824e6b242796d7d5ccae405000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005ab2feb86a7f00000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000032000000000000000000000000000000000000000000000000000000000000004a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000006423b872dd000000000000000000000000e1c14b9f065dead2e89ee35382f8bd42bdb87a040000000000000000000000006d7bd5c0c207cba1377f58048aa5f8c5cd933613000000000000000000000000000000000000000000000000000000000005cf7200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000001200000000000000000000000000000000000000000000000000000000000000044095ea7b3000000000000000000000000111111125421ca6dc452d289314280a0f8842a65000000000000000000000000000000000000000000000000000000000005cf720000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000111111125421ca6dc452d289314280a0f8842a65000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000160000000000000000000000000000000000000000000000000000000000000008883800a8e0000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85000000000000000000000000000000000000000000000000000000000005cf7200000000000000000000000000000000000000000000000000005956b5c791db3880000000000000000000001fb3cf6e48f1e7b10213e7b6d87d4c073c7fdb7b66e0bbe300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000f5652f712867ead6c824e6b242796d7d5ccae405000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“nonce”:“15563”,“sender”:“0xe1c14b9f065dead2e89ee35382f8bd42bdb87a04”,“strict”:false,“feeToken”:“0x4200000000000000000000000000000000000006”,“gasLimit”:“607107”,“receiver”:“0xe1c14b9f065dead2e89ee35382f8bd42bdb87a04”,“messageId”:“0x7b6802561bdb37ae5e87987d16bc13b91d3b70f850f2659709ba79a53c97c9a3”,“tokenAmounts”:[{“token”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“amount”:“380786”}],“feeTokenAmount”:“69462375632694”,“sequenceNumber”:“17205”,“sourceTokenData”:[“0x000000000000000000000000000000000000000000000000000000000002ae380000000000000000000000000000000000000000000000000000000000000006”],“sourceChainSelector”:“15971525489660198786”}	15249186	2024-06-02T00:21:59.000Z	0x8570f566fff09bb0367f2a5d78ef321e878ee760d1c7f99848ce509ed63ad269
0xd952feacdd5919cc5e9454b53bf45d4e73dd6457	false	208	{“data”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000dfc88dcdcaaab27d50ed9502c74a5d6b3b2a08160000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000051f806ac09cc50900000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000032000000000000000000000000000000000000000000000000000000000000009e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000006423b872dd000000000000000000000000e1c14b9f065dead2e89ee35382f8bd42bdb87a040000000000000000000000006d7bd5c0c207cba1377f58048aa5f8c5cd93361300000000000000000000000000000000000000000000000000000000536a557f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000001200000000000000000000000000000000000000000000000000000000000000044095ea7b3000000000000000000000000111111125421ca6dc452d289314280a0f8842a6500000000000000000000000000000000000000000000000000000000536a557f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000111111125421ca6dc452d289314280a0f8842a65000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000006a000000000000000000000000000000000000000000000000000000000000005c807ed2379000000000000000000000000b63aae6c353636d66df13b89ba4425cfe13d10ba0000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000b63aae6c353636d66df13b89ba4425cfe13d10ba0000000000000000000000006d7bd5c0c207cba1377f58048aa5f8c5cd93361300000000000000000000000000000000000000000000000000000000536a557f000000000000000000000000000000000000000000000000050bd44030ec568f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000046f0000000000000000000000000000000000000004510004370004210003d700a0c9e75c48000000000000050202010000000000000000000000000000000000000003a90002fa0001fc0000fe00a007e5c0d20000000000000000000000000000000000000000000000da00009e00004f02a00000000000000000000000000000000000000000000000077994818956b09b77ee63c1e501d28f71e383e93c570d3edfe82ebbceb35ec6c4120b2c639c533813f4aa9d7837caf62653d097ff8502a0000000000000000000000000000000000000000000000000008130e6907dde9cee63c1e50095d9d28606ee55de7667f0f176ebfc3215cfd9c0da10009cbd5d07dd0cecc66161fc93d7c9000da14101420000000000000000000000000000000000000600042e1a7d4d000000000000000000000000000000000000000000000000000000000000000000a007e5c0d20000000000000000000000000000000000000000000000da00009e00004f00a0fbb7cd06009da11ff60bfc5af527f58fd61679c3ac98d040d90000000000000000000001000b2c639c533813f4aa9d7837caf62653d097ff857f5c764cbc14f9669b88837ca1490cca17c3160702a000000000000000000000000000000000000000000000000001025cbb853f2d38ee63c1e50085149247691df622eaf1a8bd0cafd40bc45154a97f5c764cbc14f9669b88837ca1490cca17c316074101420000000000000000000000000000000000000600042e1a7d4d000000000000000000000000000000000000000000000000000000000000000000a007e5c0d20000000000000000000000000000000000000000000000da00009e00004f02a00000000000000000000000000000000000000000000000000000000010725da6ee63c1e501a73c628eaf6e283e26a7b1f8001cf186aa4c0e8e0b2c639c533813f4aa9d7837caf62653d097ff8502a000000000000000000000000000000000000000000000000001025eda2976f069ee63c1e500c858a329bf053be78d6239c4a4343b8fbd21472b94b008aa00579c1307b0ef2c499ad98a8ce58e584101420000000000000000000000000000000000000600042e1a7d4d000000000000000000000000000000000000000000000000000000000000000000a007e5c0d200000000000000000000000000000000000000000000000000008b00004f02a00000000000000000000000000000000000000000000000000285e7c3f1b85a51ee63c1e5011fb3cf6e48f1e7b10213e7b6d87d4c073c7fdb7b0b2c639c533813f4aa9d7837caf62653d097ff854101420000000000000000000000000000000000000600042e1a7d4d000000000000000000000000000000000000000000000000000000000000000000a0f2fa6b66eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000000000000000000000051f806ac09cc50900000000000000000004b0a9e1720ff2c061111111125421ca6dc452d289314280a0f8842a6500206b4be0b9111111125421ca6dc452d289314280a0f8842a65000000000000000000000000000000000066e0bbe300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000dfc88dcdcaaab27d50ed9502c74a5d6b3b2a0816000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“nonce”:“15656”,“sender”:“0xe1c14b9f065dead2e89ee35382f8bd42bdb87a04”,“strict”:false,“feeToken”:“0x4200000000000000000000000000000000000006”,“gasLimit”:“1174513”,“receiver”:“0xe1c14b9f065dead2e89ee35382f8bd42bdb87a04”,“messageId”:“0xe19ac9275763668e6b8c3761e267d7984f53a67937842aaa57e40e85a5815f71”,“tokenAmounts”:[{“token”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“amount”:“1399477631”}],“feeTokenAmount”:“69957652517727”,“sequenceNumber”:“17298”,“sourceTokenData”:[“0x000000000000000000000000000000000000000000000000000000000002b10f0000000000000000000000000000000000000000000000000000000000000006”],“sourceChainSelector”:“15971525489660198786”}	15273278	2024-06-02T13:45:03.000Z	0x108841e407cb3e6e4151543799e643fb3c88ba7ea17c432a32ba84ccdde990b9
0xd952feacdd5919cc5e9454b53bf45d4e73dd6457	false	96	{“data”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000ce5abfa37e36e93de24a20864ce4a3ce470e180400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001c5addac462e000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000032000000000000000000000000000000000000000000000000000000000000004a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000006423b872dd000000000000000000000000e1c14b9f065dead2e89ee35382f8bd42bdb87a040000000000000000000000006d7bd5c0c207cba1377f58048aa5f8c5cd93361300000000000000000000000000000000000000000000000000000000001cd43d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000001200000000000000000000000000000000000000000000000000000000000000044095ea7b3000000000000000000000000111111125421ca6dc452d289314280a0f8842a6500000000000000000000000000000000000000000000000000000000001cd43d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000111111125421ca6dc452d289314280a0f8842a65000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000160000000000000000000000000000000000000000000000000000000000000008883800a8e0000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff8500000000000000000000000000000000000000000000000000000000001cd43d0000000000000000000000000000000000000000000000000001c36925317bfb388000000000000000000000c1738d90e2e26c35784a0d3e3d8a9f795074bca466e0bbe300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000ce5abfa37e36e93de24a20864ce4a3ce470e1804000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“nonce”:“15701”,“sender”:“0xe1c14b9f065dead2e89ee35382f8bd42bdb87a04”,“strict”:false,“feeToken”:“0x4200000000000000000000000000000000000006”,“gasLimit”:“607069”,“receiver”:“0xe1c14b9f065dead2e89ee35382f8bd42bdb87a04”,“messageId”:“0xedfaec4a48b26caf5a6148db885c2c6b7fec94cd5199a6aa4418de2d90011cdf”,“tokenAmounts”:[{“token”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“amount”:“1889341”}],“feeTokenAmount”:“70374205410087”,“sequenceNumber”:“17343”,“sourceTokenData”:[“0x000000000000000000000000000000000000000000000000000000000002b29a0000000000000000000000000000000000000000000000000000000000000006”],“sourceChainSelector”:“15971525489660198786”}	15286699	2024-06-02T21:12:25.000Z	0x7cfbdc931dd7207c879e79b44305ff0e737bf04e4683c20802aee141774c0d27

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_base.EVM2EVMOnRampV2_CCIPSendRequested_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
0x673aa85efd75080031d44fca061575d1da427a28	false	0xd44371bfde87f2db3ea6df242091351a06c2e181	3	4056435	2023-09-16T22:10:17.000Z	0xf450960283d0303c49e71118ebc81cd6b2331bb2e2a62f9870f5cbd0bbc58c78	5009297550715157269
0x673aa85efd75080031d44fca061575d1da427a28	false	0x064f0960ab66f44a5e6c7d2335b19de4bb75aa0d	4	4702261	2023-10-01T20:57:49.000Z	0x6c635c8f6ef66a1dfc34b781ccb18341489e52a75e2df70f993665db48c16efc	11344663589394136015
0x673aa85efd75080031d44fca061575d1da427a28	false	0x223953db4e0a4c33bac1b17b0df1c22919984c60	6	4702261	2023-10-01T20:57:49.000Z	0x6c635c8f6ef66a1dfc34b781ccb18341489e52a75e2df70f993665db48c16efc	4949039107694359620

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.chainlink_v1_base.Router_OnRampSet_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
0x881e3a65b4d4a04dd529061dd0071cf975f58bcd	false	0xdd4fb402d41beb0eeef6cfb1bf445f50bdc8c981	3	7595531	2023-12-07T20:20:09.000Z	0x3acd8092fa5e37695ef6262bfd279b273f3782cee4397578dbba157c67c992fd	11344663589394136015
0x881e3a65b4d4a04dd529061dd0071cf975f58bcd	false	0xdea286dc0e01cb4755650a6cf8d1076b454ea1cb	2	7595531	2023-12-07T20:20:09.000Z	0x3acd8092fa5e37695ef6262bfd279b273f3782cee4397578dbba157c67c992fd	5009297550715157269
0x881e3a65b4d4a04dd529061dd0071cf975f58bcd	false	0xd952feacdd5919cc5e9454b53bf45d4e73dd6457	1	7595531	2023-12-07T20:20:09.000Z	0x3acd8092fa5e37695ef6262bfd279b273f3782cee4397578dbba157c67c992fd	3734403246176062136

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AccessControlledOffchainAggregator_AnswerUpdated_event

EVM2EVMOnRamp_CCIPSendRequested_event

EVM2EVMOnRampV2_CCIPSendRequested_event

Router_OnRampSet_event

RouterV2_OnRampSet_event

​Tables

​AccessControlledOffchainAggregator_AnswerUpdated_event

​EVM2EVMOnRamp_CCIPSendRequested_event

​EVM2EVMOnRampV2_CCIPSendRequested_event

​Router_OnRampSet_event

​RouterV2_OnRampSet_event

Tables

AccessControlledOffchainAggregator_AnswerUpdated_event

EVM2EVMOnRamp_CCIPSendRequested_event

EVM2EVMOnRampV2_CCIPSendRequested_event

Router_OnRampSet_event

RouterV2_OnRampSet_event