connext_v1_bsc

Tables

TransactionManager_TransactionFulfilled_event

Cross-chain transaction fulfillment events emitted by Connext TransactionManager contracts. Records completion attempts of bridged transactions with router execution details, relayer fees, user signatures, and success status across multiple 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_router`	`STRING`	Address of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_args`	`STRUCT<txData STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>, relayerFee STRING, signature STRING, callData STRING, encodedMeta STRING>`	Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed.
`in_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.
`in_isContract`	`BOOL`	Boolean flag indicating whether the caller address is a smart contract.
`in_returnData`	`STRING`	Data returned from an external contract call executed during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_args	in_user	removed	in_caller	in_router	log_index	in_success	block_number	in_isContract	in_returnData	block_timestamp	in_transactionId	transaction_hash
0x2a9ea5e8cddf40730f4f4f839f673a51600c314e	{“txData”:{“user”:“0x7567e696922eb3f140ebdd1770054c634b7bf708”,“amount”:“41339101894844450332426”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1645278790”,“router”:“0x2a3248456464a19fa913bd5dfa952999365b31ce”,“initiator”:“0x7567e696922eb3f140ebdd1770054c634b7bf708”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x4b340886f2ef71182b079627c0711602a7c712a3a3d3147bc1819c5a3e12db9a”,“sendingAssetId”:“0xabc6790673a60b8a7f588450f59d2d256b1aef7f”,“sendingChainId”:“56”,“receivingAddress”:“0x7567e696922eb3f140ebdd1770054c634b7bf708”,“receivingAssetId”:“0xabc6790673a60b8a7f588450f59d2d256b1aef7f”,“receivingChainId”:“137”,“preparedBlockNumber”:“15307873”,“sendingChainFallback”:“0x7567e696922eb3f140ebdd1770054c634b7bf708”,“receivingChainTxManagerAddress”:“0x6090de2ec76eb1dc3b5d632734415c93c44fd113”},“callData”:“0x”,“signature”:“0x9866237d9ba671a9c7b34ac0b2dc8a8cc0f1f63d8f1ac85c8eb1034e93d9c41f5c216b41cfef3d51796d0238ff5ad877ff03a38aef25c288f210760029fa53201c”,“relayerFee”:“0”,“encodedMeta”:“0x”}	0x7567e696922eb3f140ebdd1770054c634b7bf708	false	0x2a3248456464a19fa913bd5dfa952999365b31ce	0x2a3248456464a19fa913bd5dfa952999365b31ce	75	false	15308067	false	0x	2022-02-16T14:03:11.000Z	0x4b340886f2ef71182b079627c0711602a7c712a3a3d3147bc1819c5a3e12db9a	0xf44b57a8bbaffd26e375944d1df973426624618a441aeb5f8e790500e84d1a03
0x2a9ea5e8cddf40730f4f4f839f673a51600c314e	{“txData”:{“user”:“0x5f307aae5c1498f5d4634d4f19e965bfb47776d5”,“amount”:“200000000000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1645255479”,“router”:“0x56723283704c7f8ea3e13650413af102d4572e48”,“initiator”:“0x5f307aae5c1498f5d4634d4f19e965bfb47776d5”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xcc19e249b1b6f7f62193b36c526a46da361495baa9c7a3702972bc917da3e8e8”,“sendingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“sendingChainId”:“56”,“receivingAddress”:“0x5f307aae5c1498f5d4634d4f19e965bfb47776d5”,“receivingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“receivingChainId”:“250”,“preparedBlockNumber”:“15300142”,“sendingChainFallback”:“0x5f307aae5c1498f5d4634d4f19e965bfb47776d5”,“receivingChainTxManagerAddress”:“0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b”},“callData”:“0x”,“signature”:“0xdec65567bebc13550387f0a8f63e33dabeee7059fb38844c5c1c78c03754c74f7fc80a3706e3ac858956cec2065caa1a0e24f0f51027fb38f6499749bf3a7d561c”,“relayerFee”:“96043”,“encodedMeta”:“0x”}	0x5f307aae5c1498f5d4634d4f19e965bfb47776d5	false	0x56723283704c7f8ea3e13650413af102d4572e48	0x56723283704c7f8ea3e13650413af102d4572e48	206	false	15300226	false	0x	2022-02-16T07:30:22.000Z	0xcc19e249b1b6f7f62193b36c526a46da361495baa9c7a3702972bc917da3e8e8	0x35c63808a1e5c757902966c27fb0b12bb3b8fba6bfbd2dca85e943fb310b1c6b
0x2a9ea5e8cddf40730f4f4f839f673a51600c314e	{“txData”:{“user”:“0xd3f8d4322d18f7320912c18c88c55b3c8cd9d83f”,“amount”:“60138029000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1645273395”,“router”:“0x56723283704c7f8ea3e13650413af102d4572e48”,“initiator”:“0xd3f8d4322d18f7320912c18c88c55b3c8cd9d83f”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x0ea0efdaf7d07ead6ea013032d83f1b8ace854144f44adda51ea968471e2641b”,“sendingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“sendingChainId”:“56”,“receivingAddress”:“0xd3f8d4322d18f7320912c18c88c55b3c8cd9d83f”,“receivingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“receivingChainId”:“250”,“preparedBlockNumber”:“15306088”,“sendingChainFallback”:“0xd3f8d4322d18f7320912c18c88c55b3c8cd9d83f”,“receivingChainTxManagerAddress”:“0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b”},“callData”:“0x”,“signature”:“0x329ec23e9c18f82fa97839cf18e4ffc5453a382cdb0b0684929e3370ee8d40833a3d9750e8abfac8ac6672c3ef6bdde1bafa498a2919486bf78d048e3d04e39e1c”,“relayerFee”:“101154”,“encodedMeta”:“0x”}	0xd3f8d4322d18f7320912c18c88c55b3c8cd9d83f	false	0x56723283704c7f8ea3e13650413af102d4572e48	0x56723283704c7f8ea3e13650413af102d4572e48	159	false	15306195	false	0x	2022-02-16T12:29:30.000Z	0x0ea0efdaf7d07ead6ea013032d83f1b8ace854144f44adda51ea968471e2641b	0xc039e0c56fa21980a4e81297b05a62eecf0436110ee1ec671a76bd65535d1d85

Example Query

Query with partition filter

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

TransactionManager_TransactionPrepared_event

Cross-chain transaction preparation events emitted by the Connext v1 TransactionManager contract containing user addresses, router addresses, asset identifiers, chain identifiers, transfer amounts, expiry timestamps, and cryptographic signatures for cross-chain bridge operations.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_router`	`STRING`	Address of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_txData`	`STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>`	Structured transaction data for cross-chain operations in the Connext protocol. Contains addresses for transaction managers, users, routers, and initiators, asset identifiers for sending and receiving chains, fallback and receiving addresses, call target and call data hash, unique transaction identifier, chain identifiers, transfer amount, expiration timestamp, and prepared block number.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_args`	`STRUCT<invariantData STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, sendingChainId STRING, receivingChainId STRING, callDataHash STRING, transactionId STRING>, amount STRING, expiry STRING, encryptedCallData STRING, encodedBid STRING, bidSignature STRING, encodedMeta STRING>`	Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed.

Sample Data

address	in_args	in_user	removed	in_caller	in_router	in_txData	log_index	block_number	block_timestamp	in_transactionId	transaction_hash
0x2a9ea5e8cddf40730f4f4f839f673a51600c314e	{“amount”:“33830892292991220754”,“expiry”:“1674522727”,“encodedBid”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000b22981ba3fe1de2325935c91a3b717168fb8671400000000000000000000000095829c9acfecaec0ee594a377311b0937c4a2882000000000000000000000000b22981ba3fe1de2325935c91a3b717168fb8671400000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001da9ececcf65c000000000000000000000000000000000000000000000000000000000000000000380000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc3000000000000000000000000000000000000000000000001d57f794bf63dfc12000000000000000000000000b22981ba3fe1de2325935c91a3b717168fb86714b49bb9530a959230819fc6c1cc6f362eabbe06e1893426a5180515c00a74d5150000000000000000000000000000000000000000000000000000000063d081e7c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a47000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000240000000000000000000000000115909bdcbab21954beb4ab65fc2abee9866fa930000000000000000000000002a9ea5e8cddf40730f4f4f839f673a51600c314e0000000000000000000000000000000000000000000000000000000063cc8e940000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0x0034505a67be1d2ee8f807a90cc83e4dd1eb6fea95e70eea7507a8bc65e630987944e2c91663c339842189c8263af677f4e80b91f5a8e2bffb72f7293698aa0c1c”,“invariantData”:{“user”:“0xb22981ba3fe1de2325935c91a3b717168fb86714”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0x95829c9acfecaec0ee594a377311b0937c4a2882”,“initiator”:“0xb22981ba3fe1de2325935c91a3b717168fb86714”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xb49bb9530a959230819fc6c1cc6f362eabbe06e1893426a5180515c00a74d515”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0xb22981ba3fe1de2325935c91a3b717168fb86714”,“receivingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“receivingChainId”:“56”,“sendingChainFallback”:“0xb22981ba3fe1de2325935c91a3b717168fb86714”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”},“encryptedCallData”:“0x”}	0xb22981ba3fe1de2325935c91a3b717168fb86714	false	0x95829c9acfecaec0ee594a377311b0937c4a2882	0x95829c9acfecaec0ee594a377311b0937c4a2882	{“user”:“0xb22981ba3fe1de2325935c91a3b717168fb86714”,“amount”:“33830892292991220754”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1674522727”,“router”:“0x95829c9acfecaec0ee594a377311b0937c4a2882”,“initiator”:“0xb22981ba3fe1de2325935c91a3b717168fb86714”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xb49bb9530a959230819fc6c1cc6f362eabbe06e1893426a5180515c00a74d515”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0xb22981ba3fe1de2325935c91a3b717168fb86714”,“receivingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“receivingChainId”:“56”,“preparedBlockNumber”:“24993576”,“sendingChainFallback”:“0xb22981ba3fe1de2325935c91a3b717168fb86714”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”}	1	24993576	2023-01-22T01:13:35.000Z	0xb49bb9530a959230819fc6c1cc6f362eabbe06e1893426a5180515c00a74d515	0x9aa39d5ebcff9f03557a1774ad190a69f012ad122d90e04964d5581a69f3c46e
0x2a9ea5e8cddf40730f4f4f839f673a51600c314e	{“amount”:“203530664376051928307”,“expiry”:“1674590573”,“encodedBid”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000aa155507f6afbe966acb85fa077acf7e1c761a7f000000000000000000000000f410f49c547115567f4209bae3dd2dbd855ddac0000000000000000000000000aa155507f6afbe966acb85fa077acf7e1c761a7f0000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b0eee1036f3ef000000000000000000000000000000000000000000000000000000000000000000380000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc300000000000000000000000000000000000000000000000b088e7d038fc09473000000000000000000000000aa155507f6afbe966acb85fa077acf7e1c761a7f152c4ef0d72a12cd52aa02c33a650fbd34f80d743d1102c753404ff13508a2a40000000000000000000000000000000000000000000000000000000063d18aedc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a47000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000240000000000000000000000000115909bdcbab21954beb4ab65fc2abee9866fa930000000000000000000000002a9ea5e8cddf40730f4f4f839f673a51600c314e0000000000000000000000000000000000000000000000000000000063cd97970000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0x886476d6f21954f268f65202b964250f88251a027e1205a46c1c3eee660d5954761084af867595a8d8af97da37ef3b5851606d831c87ca073c96dc96192cc9331b”,“invariantData”:{“user”:“0xaa155507f6afbe966acb85fa077acf7e1c761a7f”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0xf410f49c547115567f4209bae3dd2dbd855ddac0”,“initiator”:“0xaa155507f6afbe966acb85fa077acf7e1c761a7f”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x152c4ef0d72a12cd52aa02c33a650fbd34f80d743d1102c753404ff13508a2a4”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0xaa155507f6afbe966acb85fa077acf7e1c761a7f”,“receivingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“receivingChainId”:“56”,“sendingChainFallback”:“0xaa155507f6afbe966acb85fa077acf7e1c761a7f”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”},“encryptedCallData”:“0x”}	0xaa155507f6afbe966acb85fa077acf7e1c761a7f	false	0xf410f49c547115567f4209bae3dd2dbd855ddac0	0xf410f49c547115567f4209bae3dd2dbd855ddac0	{“user”:“0xaa155507f6afbe966acb85fa077acf7e1c761a7f”,“amount”:“203530664376051928307”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1674590573”,“router”:“0xf410f49c547115567f4209bae3dd2dbd855ddac0”,“initiator”:“0xaa155507f6afbe966acb85fa077acf7e1c761a7f”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x152c4ef0d72a12cd52aa02c33a650fbd34f80d743d1102c753404ff13508a2a4”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0xaa155507f6afbe966acb85fa077acf7e1c761a7f”,“receivingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“receivingChainId”:“56”,“preparedBlockNumber”:“25015930”,“sendingChainFallback”:“0xaa155507f6afbe966acb85fa077acf7e1c761a7f”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”}	12	25015930	2023-01-22T20:04:38.000Z	0x152c4ef0d72a12cd52aa02c33a650fbd34f80d743d1102c753404ff13508a2a4	0xc6fa8ebf0f87b3fd250821467257de79c50736045da02f358dead99d7f98d238
0x2a9ea5e8cddf40730f4f4f839f673a51600c314e	{“amount”:“61165577175725193792”,“expiry”:“1674569820”,“encodedBid”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000633e21e97a916d69a4d18807a01543267fde0184000000000000000000000000ee2ef40f688607cb23618d9312d62392786d13eb000000000000000000000000633e21e97a916d69a4d18807a01543267fde0184000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000035633cdf8a49c700000000000000000000000000000000000000000000000000000000000000000380000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc300000000000000000000000000000000000000000000000350d7c85f48d73a4000000000000000000000000053e336158b66a33c5560a0554fffc99f7e072803efa10bc00a044344c1805d322452dc7d10aa4f95ff0ca59365986c478e78e0540000000000000000000000000000000000000000000000000000000063d139dcc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a47000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000240000000000000000000000000115909bdcbab21954beb4ab65fc2abee9866fa930000000000000000000000002a9ea5e8cddf40730f4f4f839f673a51600c314e0000000000000000000000000000000000000000000000000000000063cd46890000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0x6b305a436bf1d28ab3d8fc119e37020f242c0dfcb295ecf8a0ade85afd52db672415cc6b1456b0ebddd3825d7b3f4964aed1177f37aa8d8b0b3a8e324be3ba161c”,“invariantData”:{“user”:“0x633e21e97a916d69a4d18807a01543267fde0184”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0xee2ef40f688607cb23618d9312d62392786d13eb”,“initiator”:“0x633e21e97a916d69a4d18807a01543267fde0184”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xefa10bc00a044344c1805d322452dc7d10aa4f95ff0ca59365986c478e78e054”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0x53e336158b66a33c5560a0554fffc99f7e072803”,“receivingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“receivingChainId”:“56”,“sendingChainFallback”:“0x633e21e97a916d69a4d18807a01543267fde0184”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”},“encryptedCallData”:“0x”}	0x633e21e97a916d69a4d18807a01543267fde0184	false	0xee2ef40f688607cb23618d9312d62392786d13eb	0xee2ef40f688607cb23618d9312d62392786d13eb	{“user”:“0x633e21e97a916d69a4d18807a01543267fde0184”,“amount”:“61165577175725193792”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1674569820”,“router”:“0xee2ef40f688607cb23618d9312d62392786d13eb”,“initiator”:“0x633e21e97a916d69a4d18807a01543267fde0184”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xefa10bc00a044344c1805d322452dc7d10aa4f95ff0ca59365986c478e78e054”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0x53e336158b66a33c5560a0554fffc99f7e072803”,“receivingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“receivingChainId”:“56”,“preparedBlockNumber”:“25009063”,“sendingChainFallback”:“0x633e21e97a916d69a4d18807a01543267fde0184”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”}	26	25009063	2023-01-22T14:18:27.000Z	0xefa10bc00a044344c1805d322452dc7d10aa4f95ff0ca59365986c478e78e054	0xe9fc033588d705cecaad8b4cea358b3c46df4f97cd3fe3bec0623e39a6c91f40

Example Query

Query with partition filter

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

TransactionManagerV2_TransactionFulfilled_event

Fulfilled cross-chain transaction records from Connext V1 bridge on BSC, tracking completed token transfers with user addresses, router details, relayer fees, and transaction signatures. Used for analyzing bridge completion rates and router performance between BSC and destination chains (primarily Gnosis Chain and Fantom).

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_router`	`STRING`	Address of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_txData`	`STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>`	Structured transaction data for cross-chain operations in the Connext protocol. Contains addresses for transaction managers, users, routers, and initiators, asset identifiers for sending and receiving chains, fallback and receiving addresses, call target and call data hash, unique transaction identifier, chain identifiers, transfer amount, expiration timestamp, and prepared block number.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_callData`	`STRING`	Encoded data to be passed to an external contract call during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
`in_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.
`in_returnData`	`STRING`	Data returned from an external contract call executed during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_caller	in_router	in_txData	log_index	in_success	in_callData	block_number	in_signature	in_returnData	block_timestamp	in_transactionId	transaction_hash
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09	0x0bcb30ae6a56ded3dcbfa1f735a72f466e5d2043	false	0x29a519e21d6a97cdb82270b69c98bac6426cdcf9	0x29a519e21d6a97cdb82270b69c98bac6426cdcf9	{“user”:“0x0bcb30ae6a56ded3dcbfa1f735a72f466e5d2043”,“amount”:“1600000000000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632608875”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x6f87e2855e7cd6bdf864eaa4b04570f1a211f4b632d8904c74649043f0d1b7ab”,“sendingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“sendingChainId”:“56”,“receivingAddress”:“0x0bcb30ae6a56ded3dcbfa1f735a72f466e5d2043”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“11148167”,“sendingChainFallback”:“0x0bcb30ae6a56ded3dcbfa1f735a72f466e5d2043”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}	61	false	0x	11148287	0x900ad08fe479a84ba60940f2856497a974a65ad4f839323710b3294840e2af421bffa3961f1c54406d0aeaadc6a841034308f7b1e5ce3d5fc2c2dd20cdf779451c	0x	2021-09-22T22:34:15.000Z	0x6f87e2855e7cd6bdf864eaa4b04570f1a211f4b632d8904c74649043f0d1b7ab	0xb2f8fd3ca2dff2c34830ad07f78dd2dc40aa77d5136c1affc6c91b49b9c352f3
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09	0xb4c3da2873a9fdb77ddb66c11a0bf26931bccb14	false	0x29a519e21d6a97cdb82270b69c98bac6426cdcf9	0x29a519e21d6a97cdb82270b69c98bac6426cdcf9	{“user”:“0xb4c3da2873a9fdb77ddb66c11a0bf26931bccb14”,“amount”:“56068421840000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632600029”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x2cfb7d9efd1e282af9a61ad333e486a1168ecd8a0d0b88a4ad6b92b60bdecaae”,“sendingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“sendingChainId”:“56”,“receivingAddress”:“0xb4c3da2873a9fdb77ddb66c11a0bf26931bccb14”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“11145262”,“sendingChainFallback”:“0xb4c3da2873a9fdb77ddb66c11a0bf26931bccb14”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}	39	false	0x	11145313	0x70838ce45a884d47f4ab67e424670180faf0a905972f87886d2871243bfb721359c16e837bee304c3e8b44ff1d595c60097706a98b7f1d9b38500ecdff3319e21c	0x	2021-09-22T20:04:07.000Z	0x2cfb7d9efd1e282af9a61ad333e486a1168ecd8a0d0b88a4ad6b92b60bdecaae	0x9711749dffe69be85030f505c1a39f9d4ff64a2909c60de93f3d5228e81f39c7
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09	0x4d6ced2b273d768dd7521d17cc3b5a7af33c59d1	false	0x29a519e21d6a97cdb82270b69c98bac6426cdcf9	0x29a519e21d6a97cdb82270b69c98bac6426cdcf9	{“user”:“0x4d6ced2b273d768dd7521d17cc3b5a7af33c59d1”,“amount”:“2231321625268060000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632592763”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xd87d0f0db36ca7c54f08d3c434c449d02f2ed76d0662c12dd57f69ec5e2be4c1”,“sendingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“sendingChainId”:“56”,“receivingAddress”:“0x4d6ced2b273d768dd7521d17cc3b5a7af33c59d1”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“11142842”,“sendingChainFallback”:“0x4d6ced2b273d768dd7521d17cc3b5a7af33c59d1”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}	125	false	0x	11142885	0x94486ebd686afed37269b97f6131fd7f339fd1aaa65c65ef5d781165fe523fb8014f1906b2baff26ac1fc92add05122a017430226f8c8e8ed44e9c0b2255d3501c	0x	2021-09-22T18:02:02.000Z	0xd87d0f0db36ca7c54f08d3c434c449d02f2ed76d0662c12dd57f69ec5e2be4c1	0xc3f3c9b67038b115b55d25dbd9dbf629fbe7a4dd389e7b6fd3c7b1eea2f217d7

Example Query

Query with partition filter

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

TransactionManagerV2_TransactionPrepared_event

Cross-chain bridge transaction preparation events from Connext v1 protocol on BSC, capturing user-initiated transfers with router bids, transaction details, and destination chain parameters. Used for tracking bridge transaction lifecycle and analyzing cross-chain asset flow between BSC and chains like Gnosis (100) and Fantom (250).

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_router`	`STRING`	Address of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_txData`	`STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>`	Structured transaction data for cross-chain operations in the Connext protocol. Contains addresses for transaction managers, users, routers, and initiators, asset identifiers for sending and receiving chains, fallback and receiving addresses, call target and call data hash, unique transaction identifier, chain identifiers, transfer amount, expiration timestamp, and prepared block number.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_encryptedCallData`	`STRING`	Encrypted call data for contract execution on the destination chain. Hex-encoded, 0x-prefixed string, empty (0x) when no encrypted call data is provided.
`in_encodedBid`	`STRING`	ABI-encoded bid data submitted by the router for the cross-chain transaction. Hex-encoded, 0x-prefixed string containing the encoded representation of bid parameters including user address and transaction details.
`in_bidSignature`	`STRING`	Cryptographic signature from the router attesting to their bid to facilitate the cross-chain transaction. Hex-encoded, 0x-prefixed, 132-character string representing the ECDSA signature.

Sample Data

address	in_user	removed	in_caller	in_router	in_txData	log_index	block_number	in_encodedBid	block_timestamp	in_bidSignature	in_transactionId	transaction_hash	in_encryptedCallData
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09	0xf08e242722af03f5575a50e8bfba0c56eff6d134	false	0xf08e242722af03f5575a50e8bfba0c56eff6d134	0x29a519e21d6a97cdb82270b69c98bac6426cdcf9	{“user”:“0xf08e242722af03f5575a50e8bfba0c56eff6d134”,“amount”:“2073925973861213709”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1633350825”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xbcc9d90024a8ab97a937acf66ddf23ab6d5f2dc4e8aecf6e4544fc1a45b33892”,“sendingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“sendingChainId”:“56”,“receivingAddress”:“0xf08e242722af03f5575a50e8bfba0c56eff6d134”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“11393481”,“sendingChainFallback”:“0xf08e242722af03f5575a50e8bfba0c56eff6d134”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}	184	11393481	0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000f08e242722af03f5575a50e8bfba0c56eff6d13400000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000380000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc30000000000000000000000000000000000000000000000001cc810af6274260d000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001cc461929ff8f45e000000000000000000000000f08e242722af03f5575a50e8bfba0c56eff6d134bcc9d90024a8ab97a937acf66ddf23ab6d5f2dc4e8aecf6e4544fc1a45b3389200000000000000000000000000000000000000000000000000000000615af4a9c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000000000000000000000000000000000000615701560000000000000000000000000000000000000000000000000000000000000000	2021-10-01T12:35:15.000Z	0x1f848c6fa99ada2808a1f8212540a638e35006c3b6dd98dafe6f3e9ca79da25a5f362b50e5157ddc52775a04002e57b62fa67409c1bb52e4e66b4019f4ef75931b	0xbcc9d90024a8ab97a937acf66ddf23ab6d5f2dc4e8aecf6e4544fc1a45b33892	0xee9b8aaf75b073f5f5f1128b45911e2c95e58edbb1bd0a94c4c37d556e052d88	0x
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09	0xa3512dc497d5074be263accf539ea38abbde678f	false	0xa3512dc497d5074be263accf539ea38abbde678f	0x29a519e21d6a97cdb82270b69c98bac6426cdcf9	{“user”:“0xa3512dc497d5074be263accf539ea38abbde678f”,“amount”:“9689500000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1633381866”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x401f318497dc3a10329aac6839c9346c8f09e5c5a8c664ab1e94549a60551c71”,“sendingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“sendingChainId”:“56”,“receivingAddress”:“0xa3512dc497d5074be263accf539ea38abbde678f”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“11403638”,“sendingChainFallback”:“0xa3512dc497d5074be263accf539ea38abbde678f”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}	264	11403638	0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000a3512dc497d5074be263accf539ea38abbde678f00000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000380000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc3000000000000000000000000000000000000000000000000867804e9af25c000000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008666cea36c5f3400000000000000000000000000a3512dc497d5074be263accf539ea38abbde678f401f318497dc3a10329aac6839c9346c8f09e5c5a8c664ab1e94549a60551c7100000000000000000000000000000000000000000000000000000000615b6deac5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090000000000000000000000000000000000000000000000000000000061577a980000000000000000000000000000000000000000000000000000000000000000	2021-10-01T21:11:58.000Z	0x55f765740b0f38a52acaf1147791e360c7331fb8d179683939d773f247a6c95d18566c8c1cc056e35d6c9ae068a1a5e130134de8b96a499c2b63005a1d0e216e1c	0x401f318497dc3a10329aac6839c9346c8f09e5c5a8c664ab1e94549a60551c71	0x84afe44dfc24af5f59f2729a83889c206c19919bba7e1b9b9d7bd4bbd13c8bba	0x
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09	0x4b935a52a887bf017b4e5e0151b71f518d0810a8	false	0x4b935a52a887bf017b4e5e0151b71f518d0810a8	0x29a519e21d6a97cdb82270b69c98bac6426cdcf9	{“user”:“0x4b935a52a887bf017b4e5e0151b71f518d0810a8”,“amount”:“35000000000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1633355368”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x0668f90fde22247d38d33866b890c37a3ef684d18952571c1ca30c7e26d76840”,“sendingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“sendingChainId”:“56”,“receivingAddress”:“0x4b935a52a887bf017b4e5e0151b71f518d0810a8”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“11394960”,“sendingChainFallback”:“0x4b935a52a887bf017b4e5e0151b71f518d0810a8”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}	527	11394960	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000004b935a52a887bf017b4e5e0151b71f518d0810a800000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000380000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc3000000000000000000000000000000000000000000000001e5b8fa8fe2ac000000000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e57ace679f1a40000000000000000000000000004b935a52a887bf017b4e5e0151b71f518d0810a80668f90fde22247d38d33866b890c37a3ef684d18952571c1ca30c7e26d7684000000000000000000000000000000000000000000000000000000000615b0668c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000000000000000000000000000000000000615713160000000000000000000000000000000000000000000000000000000000000000	2021-10-01T13:51:07.000Z	0x8f567c6193e4c472e08308decabd6282d0a781afb10ca54aff17cf3bac9f7f13445123c315e9aaa39e04fc7ac4d1d7d99569125564d3c3d4612329f07b50c8d11b	0x0668f90fde22247d38d33866b890c37a3ef684d18952571c1ca30c7e26d76840	0xc3999c85fb9b52aaadceb38a98f7047550691a06151b35b86437da66024cef50	0x

Example Query

Query with partition filter

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

TransactionManagerV3_TransactionFulfilled_event

No description available.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_router`	`STRING`	Address of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_txData`	`STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>`	Structured transaction data for cross-chain operations in the Connext protocol. Contains addresses for transaction managers, users, routers, and initiators, asset identifiers for sending and receiving chains, fallback and receiving addresses, call target and call data hash, unique transaction identifier, chain identifiers, transfer amount, expiration timestamp, and prepared block number.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_callData`	`STRING`	Encoded data to be passed to an external contract call during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
`in_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.
`in_isContract`	`BOOL`	Boolean flag indicating whether the caller address is a smart contract.
`in_returnData`	`STRING`	Data returned from an external contract call executed during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

TransactionManagerV3_TransactionPrepared_event

No description available.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_router`	`STRING`	Address of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_txData`	`STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>`	Structured transaction data for cross-chain operations in the Connext protocol. Contains addresses for transaction managers, users, routers, and initiators, asset identifiers for sending and receiving chains, fallback and receiving addresses, call target and call data hash, unique transaction identifier, chain identifiers, transfer amount, expiration timestamp, and prepared block number.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_encryptedCallData`	`STRING`	Encrypted call data for contract execution on the destination chain. Hex-encoded, 0x-prefixed string, empty (0x) when no encrypted call data is provided.
`in_encodedBid`	`STRING`	ABI-encoded bid data submitted by the router for the cross-chain transaction. Hex-encoded, 0x-prefixed string containing the encoded representation of bid parameters including user address and transaction details.
`in_bidSignature`	`STRING`	Cryptographic signature from the router attesting to their bid to facilitate the cross-chain transaction. Hex-encoded, 0x-prefixed, 132-character string representing the ECDSA signature.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

TransactionManager_TransactionFulfilled_event

TransactionManager_TransactionPrepared_event

TransactionManagerV2_TransactionFulfilled_event

TransactionManagerV2_TransactionPrepared_event

TransactionManagerV3_TransactionFulfilled_event

TransactionManagerV3_TransactionPrepared_event

​Tables

​TransactionManager_TransactionFulfilled_event

​TransactionManager_TransactionPrepared_event

​TransactionManagerV2_TransactionFulfilled_event

​TransactionManagerV2_TransactionPrepared_event

​TransactionManagerV3_TransactionFulfilled_event

​TransactionManagerV3_TransactionPrepared_event

Tables

TransactionManager_TransactionFulfilled_event

TransactionManager_TransactionPrepared_event

TransactionManagerV2_TransactionFulfilled_event

TransactionManagerV2_TransactionPrepared_event

TransactionManagerV3_TransactionFulfilled_event

TransactionManagerV3_TransactionPrepared_event