connext_v2_base

Tables

ConnextDiamond_Executed_event

Cross-chain bridge transfer completion records from Connext v2 protocol on Base. Tracks executed transfers with token amounts, recipient addresses, router signatures, and origin/destination domain identifiers for analyzing bridge volume and cross-chain asset 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_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_args`	`STRUCT<params STRUCT<originDomain STRING, destinationDomain STRING, canonicalDomain STRING,` to `STRING, delegate STRING, receiveLocal BOOL, callData STRING, slippage STRING, originSender STRING, bridgedAmt STRING, normalizedIn STRING, nonce STRING, canonicalId STRING>, routers ARRAY<STRING>, routerSignatures ARRAY<STRING>, sequencer STRING, sequencerSignature STRING>`	Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed.
`in_local`	`STRING`	Contract address of the local representation of the bridged asset on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	in_args	removed	in_asset	in_local	in_amount	in_caller	log_index	block_number	in_transferId	block_timestamp	transaction_hash
0xd6ee4683c8b9691235060b3326c29342dc423212	0xb8448c6f7f7887d36dca487370778e419e9ebe3f	{“params”:{“to”:“0xd6ee4683c8b9691235060b3326c29342dc423212”,“nonce”:“188547”,“callData”:“0x”,“delegate”:“0xd6ee4683c8b9691235060b3326c29342dc423212”,“slippage”:“50”,“bridgedAmt”:“993281”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“993000000000000000”,“originDomain”:“1886350457”,“originSender”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“1650553709”},“routers”:[“0x6fd84ba95525c4ccd218f2f16f646a08b4b0a598”],“sequencer”:“0x4ffa5968857a6c8242e4a6ded2418155d33e82e7”,“routerSignatures”:[“0x5af5a0d7817cd8a5d37cfd00ce811ab34a52fc365c9e361dcf3dd0bb80398eb920a4603f300a7cdf44ba2426833ecb9f743790189e621b71a6f3dd2cee41a3391c”],“sequencerSignature”:“0x7d2e79a0fe516f95fe28aec4bf2d999a444cf6c242f140bca6baa50785de0f2823de58db66be97cbe78481649e09af15fb8d61cf4a7be347af91c80b30c8dbe61c”}	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x1ede59e0d39b14c038698b1036bde9a4819c86d4	990267	0xf9d64d54d32ee2bdceaabfa60c4c438e224427d0	99	12233157	0xdb0082077dcf8eb40f5b42971cbcdbeb7131e8decd8bc63b9c656fd58f55a59e	2024-03-24T04:47:41.000Z	0xf4820c1a16218eaf76a109e82b4cc5dfbac4aee98c8942ba8c88eeb5c1d97869
0x84f0cee6916d7bdceb696ff8d8dd6f1ef0d18e9f	0xb8448c6f7f7887d36dca487370778e419e9ebe3f	{“params”:{“to”:“0x84f0cee6916d7bdceb696ff8d8dd6f1ef0d18e9f”,“nonce”:“4685”,“callData”:“0x”,“delegate”:“0x84f0cee6916d7bdceb696ff8d8dd6f1ef0d18e9f”,“slippage”:“50”,“bridgedAmt”:“999446”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“1000000000000000000”,“originDomain”:“1818848877”,“originSender”:“0xde1e598b81620773454588b85d6b5d4eec32573e”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“1650553709”},“routers”:[“0x6fd84ba95525c4ccd218f2f16f646a08b4b0a598”],“sequencer”:“0x4ffa5968857a6c8242e4a6ded2418155d33e82e7”,“routerSignatures”:[“0xc18c313791870c672ad4c70bfc5874a00508cb513737aec4bef79b0a3e6a62bb6bf4950eaf2230a0729abb18dc0604adae4320020aad45da14d1538c6d42c7e91c”],“sequencerSignature”:“0xeceeed3d81ba853fbf62ec045700a70a93547611f881bedad554e207fe6c21fb67b4bc1bd32af12b18101b83a88a0bf0932a452cc18f859fc30ae3a5617a99ae1c”}	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x1ede59e0d39b14c038698b1036bde9a4819c86d4	996610	0xf9d64d54d32ee2bdceaabfa60c4c438e224427d0	58	12233801	0x04041cfd3dee4100f3ff11a562768299355bf0558f66afa757d7245e1888d3d4	2024-03-24T05:09:09.000Z	0x7e132635cd3a63c4af5b51b40f8965512e85dc4920cf87827dd31ccdeba147f1
0x9c00833cba0159f36b5b08a36d2678621d6e86cb	0xb8448c6f7f7887d36dca487370778e419e9ebe3f	{“params”:{“to”:“0x9c00833cba0159f36b5b08a36d2678621d6e86cb”,“nonce”:“43232”,“callData”:“0x”,“delegate”:“0x9c00833cba0159f36b5b08a36d2678621d6e86cb”,“slippage”:“50”,“bridgedAmt”:“3006060”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“3000410000000000000”,“originDomain”:“6778479”,“originSender”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“1650553709”},“routers”:[“0x6fd84ba95525c4ccd218f2f16f646a08b4b0a598”],“sequencer”:“0x4ffa5968857a6c8242e4a6ded2418155d33e82e7”,“routerSignatures”:[“0x0c64c5b7a71b5f4a14dea284b0349b62d032316daf4504a0bbab7a504ec441542ae025814bd61c3aea1850363a2f5314399009134f5ddbe0c577e403c2b873881b”],“sequencerSignature”:“0x971b8c7f28a1a9e001f246fc2eac433e74b091f46943170879736571894a7f7279eb8992faadfea62df1da69a4afcdac61fd3e09f93b50a972d95b5a8e273cfc1b”}	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x1ede59e0d39b14c038698b1036bde9a4819c86d4	2999636	0xf9d64d54d32ee2bdceaabfa60c4c438e224427d0	54	12240620	0x25530c4a317f6821583ebfb6db5d545d78ed14fa4c25b6c345e83f8a3de31350	2024-03-24T08:56:27.000Z	0x2f22a73e055b03bb8898ff9af1225e00204574e68dae6f6e0e7b9a032b8981fb

Example Query

Query with partition filter

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

ConnextDiamond_XCalled_event

Cross-chain transfer initiation events emitted by Connext Diamond contracts when an xcall operation is executed. Records complete transfer context including origin/destination domains, asset addresses, amounts, message hashes, and execution parameters for tracking bridge operations across supported blockchain 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_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_messageHash`	`STRING`	Hash of the cross-chain message data being transmitted. 66-character hex string including 0x prefix.
`in_params`	`STRUCT<originDomain STRING, destinationDomain STRING, canonicalDomain STRING,` to `STRING, delegate STRING, receiveLocal BOOL, callData STRING, slippage STRING, originSender STRING, bridgedAmt STRING, normalizedIn STRING, nonce STRING, canonicalId STRING>`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_local`	`STRING`	Contract address of the local representation of the bridged asset on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_messageBody`	`STRING`	Encoded cross-chain message payload containing routing and transaction data. Hex-encoded string starting with 0x prefix.

Sample Data

address	removed	in_asset	in_local	in_nonce	in_amount	in_params	log_index	block_number	in_transferId	in_messageBody	in_messageHash	block_timestamp	transaction_hash
0xb8448c6f7f7887d36dca487370778e419e9ebe3f	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x1ede59e0d39b14c038698b1036bde9a4819c86d4	3292	35431	{“to”:“0x97ab1268650ae04d2fd69d7a93f0ce9addffdd16”,“nonce”:“3292”,“callData”:“0x”,“delegate”:“0x97ab1268650ae04d2fd69d7a93f0ce9addffdd16”,“slippage”:“50”,“bridgedAmt”:“35511”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“35431000000000000”,“originDomain”:“1650553709”,“originSender”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“6450786”}	91	11999180	0x9568ce933cb51a62d75556277e141fadfa2d5a1300429eb3f522f21be0b28d80	0x6261736d000000000000000000000000b8448c6f7f7887d36dca487370778e419e9ebe3f000004b700626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce00657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48030000000000000000000000000000000000000000000000000000000000008ab79568ce933cb51a62d75556277e141fadfa2d5a1300429eb3f522f21be0b28d80	0xb7f4b05aea62bf10b2fb1e68cd92d2f79795ad3c79ace9a9e9729d5bebc559a1	2024-03-18T18:48:27.000Z	0x8d12ad69a01c06a6d2ea52a696ca2e38f0ee2365f92095ec004c7b62cf4e2f92
0xb8448c6f7f7887d36dca487370778e419e9ebe3f	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x1ede59e0d39b14c038698b1036bde9a4819c86d4	3269	354603	{“to”:“0x050e198e36a73a1e32f15c3afc58c4506d82f657”,“nonce”:“3269”,“callData”:“0x000000000000000000000000000000000000000000000000000000000000004000000000000000000000000075de852c387bc3ca0e57c1e6f30bed3e6c8be50400000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000def1c0ded9bec7f1a1670819833240f027b25eff000000000000000000000000def1c0ded9bec7f1a1670819833240f027b25eff0000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004e2085576d48b0b00000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000128c43c9ef6000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000004e2085576d48b0b0000000000000000000000000000000000000000000000000002421d6acd52fd000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000020000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee869584cd00000000000000000000000026c16b6926637cf5eb62c42991b4166add66ff9e00000000000000000000000000000000b1107f21a659d5f6fee6036919e80d21000000000000000000000000000000000000000000000000”,“delegate”:“0x75de852c387bc3ca0e57c1e6f30bed3e6c8be504”,“slippage”:“50”,“bridgedAmt”:“355065”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“354603000000000000”,“originDomain”:“1650553709”,“originSender”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“6450786”}	94	11995029	0x505466cdbd06f6b29cfc273b25ed9cf69556a325517143040adb99e7adcb0a3a	0x6261736d000000000000000000000000b8448c6f7f7887d36dca487370778e419e9ebe3f000004aa00626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce00657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48030000000000000000000000000000000000000000000000000000000000056af9505466cdbd06f6b29cfc273b25ed9cf69556a325517143040adb99e7adcb0a3a	0x4c03becdc95d92ab703349fb5efaf66667979b9d2d64b08c07af1998de1b51b1	2024-03-18T16:30:05.000Z	0x2d59eddcd8fc996ee65f010c85c92a51bfa8a5fb4352d6295d06c2f52f3603c8
0xb8448c6f7f7887d36dca487370778e419e9ebe3f	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x1ede59e0d39b14c038698b1036bde9a4819c86d4	3325	9912500	{“to”:“0x050e198e36a73a1e32f15c3afc58c4506d82f657”,“nonce”:“3325”,“callData”:“0x0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000e6c4f718e96d031c7bda2d9325dc61b4b1e055c400000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000def1c0ded9bec7f1a1670819833240f027b25eff000000000000000000000000def1c0ded9bec7f1a1670819833240f027b25eff0000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000088dd3c965fc5093f00000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000006e8415565b00000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000000000000000000000000000088dd3c965fc5093f000000000000000000000000000000000000000000000000003f1304c00edc6900000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000042000000000000000000000000000000000000000000000000000000000000004c0000000000000000000000000000000000000000000000000000000000000000f00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000360000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c00000000000000000000000000000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000320000000000000000000000000000000000000000000000000000000000000032000000000000000000000000000000000000000000000000000000000000002e000000000000000000000000000000000000000000000000088dd3c965fc5093f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000012556e697377617056330000000000000000000000000000000000000000000000000000000000000088dd3c965fc5093f000000000000000000000000000000000000000000000000003f1304c00edc69000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000b971ef87ede563556b2ed4b1c0b0019111dd85d200000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000002b8ac76a51cc950d9822d68b83fe1ad97b32cd580d000064bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095cffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000010000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d0000000000000000000000000000000000000000000000000000000000000000869584cd00000000000000000000000026c16b6926637cf5eb62c42991b4166add66ff9e00000000000000000000000000000000dea50b149b9eec4792a848756a68cfad000000000000000000000000000000000000000000000000”,“delegate”:“0xe6c4f718e96d031c7bda2d9325dc61b4b1e055c4”,“slippage”:“50”,“bridgedAmt”:“9932036”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“9912500000000000000”,“originDomain”:“1650553709”,“originSender”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“6450786”}	63	12004750	0xb79d533329c050780a88a1c700514c4c763e064e0f3f070f8c2b45946c567dfc	0x6261736d000000000000000000000000b8448c6f7f7887d36dca487370778e419e9ebe3f000004bf00626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce00657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48030000000000000000000000000000000000000000000000000000000000978d04b79d533329c050780a88a1c700514c4c763e064e0f3f070f8c2b45946c567dfc	0x0255a9daf4a6ced2117ebb286fb1ffa6b0323e8758310ce1ddcef60645ed84ce	2024-03-18T21:54:07.000Z	0x4217892a527afa353de67e2bbde93b7d863c156baf9fe43187f6446922f1c1e3

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ConnextDiamond_Executed_event

ConnextDiamond_XCalled_event

​Tables

​ConnextDiamond_Executed_event

​ConnextDiamond_XCalled_event

Tables

ConnextDiamond_Executed_event

ConnextDiamond_XCalled_event