Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_routerSTRINGAddress of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_transactionIdSTRINGUnique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
in_argsSTRUCT<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_successBOOLBoolean flag indicating whether the operation completed successfully.
in_isContractBOOLBoolean flag indicating whether the caller address is a smart contract.
in_returnDataSTRINGData returned from an external contract call executed during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
addressin_argsin_userremovedin_callerin_routerlog_indexin_successblock_numberin_isContractin_returnDatablock_timestampin_transactionIdtransaction_hash
0x6090de2ec76eb1dc3b5d632734415c93c44fd113{“txData”:{“user”:“0x5cd874072646f0d8c07c74c69b91b1fecdeed251”,“amount”:“619597”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1681399653”,“router”:“0xe4747a26b941ebdbc7ef67de7580f700e3dbf6d5”,“initiator”:“0x5cd874072646f0d8c07c74c69b91b1fecdeed251”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x1f843f73c223c5549224569708e2fd957369cda5dd3a822c8e4afa96048ca8a3”,“sendingAssetId”:“0x4ecaba5870353805a9f068101a40e0f32ed605c6”,“sendingChainId”:“100”,“receivingAddress”:“0x5cd874072646f0d8c07c74c69b91b1fecdeed251”,“receivingAssetId”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“receivingChainId”:“137”,“preparedBlockNumber”:“41406347”,“sendingChainFallback”:“0x5cd874072646f0d8c07c74c69b91b1fecdeed251”,“receivingChainTxManagerAddress”:“0x6090de2ec76eb1dc3b5d632734415c93c44fd113”},“callData”:“0x”,“signature”:“0x9ecb49276dc7b16714fc9b3252b4422d8da83969399f9d97ca0fa924843bbe383718fca51e963c69038296e748313240c46d73c8fc42c2f6f8c284ad24504e831c”,“relayerFee”:“0”,“encodedMeta”:“0x”}0x5cd874072646f0d8c07c74c69b91b1fecdeed251false0x5cd874072646f0d8c07c74c69b91b1fecdeed2510xe4747a26b941ebdbc7ef67de7580f700e3dbf6d5192false41407474false0x2023-04-11T13:11:14.000Z0x1f843f73c223c5549224569708e2fd957369cda5dd3a822c8e4afa96048ca8a30x045a1af8e7a5a683b0f9a030354d3ffc520225bcd29a3496cb5f0f2146b359ff
0x6090de2ec76eb1dc3b5d632734415c93c44fd113{“txData”:{“user”:“0x06c502217d14d755a0ac3a7362a28adfe217069a”,“amount”:“10000000000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1634858448”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“initiator”:“0x06c502217d14d755a0ac3a7362a28adfe217069a”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xa4037faea408ced6a236533bfe40eab98bebda6a2b682941cc5673789d423deb”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x06c502217d14d755a0ac3a7362a28adfe217069a”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“20360723”,“sendingChainFallback”:“0x06c502217d14d755a0ac3a7362a28adfe217069a”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”},“callData”:“0x”,“signature”:“0xfcccd41352d811dc71e64dbcb19889e183601063ce6b0e4ef5d09a7256f2076d63a872b8a921876fd4911ec4e2e15b54d7d06b81abb48493f064425acedf090e1c”,“relayerFee”:“0”,“encodedMeta”:“0x”}0x06c502217d14d755a0ac3a7362a28adfe217069afalse0x29a519e21d6a97cdb82270b69c98bac6426cdcf90x29a519e21d6a97cdb82270b69c98bac6426cdcf9402false20360832false0x2021-10-18T23:24:52.000Z0xa4037faea408ced6a236533bfe40eab98bebda6a2b682941cc5673789d423deb0x9209252fa2a0069131022c41b20dd564eb99d88a7e041fa935abe3f239cedb48
0x6090de2ec76eb1dc3b5d632734415c93c44fd113{“txData”:{“user”:“0x15ede8da3eb4108c8b40dbe30934e10e8bc2e318”,“amount”:“387112418762576340000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1634824936”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“initiator”:“0x15ede8da3eb4108c8b40dbe30934e10e8bc2e318”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xf175f5faf04ed4c3a3e422e29500d397d1b121c94d8012b2f66695e41d65da7e”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x15ede8da3eb4108c8b40dbe30934e10e8bc2e318”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“20348605”,“sendingChainFallback”:“0x15ede8da3eb4108c8b40dbe30934e10e8bc2e318”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”},“callData”:“0x”,“signature”:“0xe068cc8b1c440b6ecbda32781f9d6fa62fdf34f33caad0606038975bf64718c440693070990a5277acee982b5a7075727dbd5daa0106f4c8be159675dfc06a371b”,“relayerFee”:“0”,“encodedMeta”:“0x”}0x15ede8da3eb4108c8b40dbe30934e10e8bc2e318false0x29a519e21d6a97cdb82270b69c98bac6426cdcf90x29a519e21d6a97cdb82270b69c98bac6426cdcf9342false20349501false0x2021-10-18T14:47:05.000Z0xf175f5faf04ed4c3a3e422e29500d397d1b121c94d8012b2f66695e41d65da7e0xc6a3e4a652617db05c0faa9bbd38523e1163520f8f2030ca7d986626594b7a96
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v1_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_routerSTRINGAddress of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_transactionIdSTRINGUnique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
in_txDataSTRUCT<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_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_argsSTRUCT<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.
addressin_argsin_userremovedin_callerin_routerin_txDatalog_indexblock_numberblock_timestampin_transactionIdtransaction_hash
0x6090de2ec76eb1dc3b5d632734415c93c44fd113{“amount”:“211211492000000000000”,“expiry”:“1649486593”,“encodedBid”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000649c44f3503c98befeb28741a0dc8610df457f00000000000000000000000092495600b72ef0e1fa22453b58938a9af49918ae00000000000000000000000000649c44f3503c98befeb28741a0dc8610df457f00000000000000000000000000000000000000000000000000000000000000890000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a06300000000000000000000000000000000000000000000000b7325f4ed744240000000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b718d9d8787e5ee0500000000000000000000000000649c44f3503c98befeb28741a0dc8610df457f460e2a57ffb87b8b3c41d646fae6d8ab7a3b991e2a3df5ecbc27fc9e757eb1940000000000000000000000000000000000000000000000000000000062512b01c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002400000000000000000000000006090de2ec76eb1dc3b5d632734415c93c44fd113000000000000000000000000115909bdcbab21954beb4ab65fc2abee9866fa9300000000000000000000000000000000000000000000000000000000624d37ad0000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0x2c4be55f239e3529e45b9967ac7c7d10f5c9bb51d7b30d28afe0bb319f901844352df58cebf009576f676ec71112d129eb7c7739441fe1e7a520113937f5b8da1c”,“invariantData”:{“user”:“0x00649c44f3503c98befeb28741a0dc8610df457f”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0x92495600b72ef0e1fa22453b58938a9af49918ae”,“initiator”:“0x00649c44f3503c98befeb28741a0dc8610df457f”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x460e2a57ffb87b8b3c41d646fae6d8ab7a3b991e2a3df5ecbc27fc9e757eb194”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x00649c44f3503c98befeb28741a0dc8610df457f”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“sendingChainFallback”:“0x00649c44f3503c98befeb28741a0dc8610df457f”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”},“encryptedCallData”:“0x”}0x00649c44f3503c98befeb28741a0dc8610df457ffalse0x00649c44f3503c98befeb28741a0dc8610df457f0x92495600b72ef0e1fa22453b58938a9af49918ae{“user”:“0x00649c44f3503c98befeb28741a0dc8610df457f”,“amount”:“211211492000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1649486593”,“router”:“0x92495600b72ef0e1fa22453b58938a9af49918ae”,“initiator”:“0x00649c44f3503c98befeb28741a0dc8610df457f”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x460e2a57ffb87b8b3c41d646fae6d8ab7a3b991e2a3df5ecbc27fc9e757eb194”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x00649c44f3503c98befeb28741a0dc8610df457f”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“26803541”,“sendingChainFallback”:“0x00649c44f3503c98befeb28741a0dc8610df457f”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”}240268035412022-04-06T06:44:16.000Z0x460e2a57ffb87b8b3c41d646fae6d8ab7a3b991e2a3df5ecbc27fc9e757eb1940xc2d3ab17060c13e4ca31447c6be58f3ce82b71f6613105b2c81a5defdb6c6541
0x6090de2ec76eb1dc3b5d632734415c93c44fd113{“amount”:“233482998000000000000”,“expiry”:“1649494100”,“encodedBid”:“0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000ddbb3ba9747dac58ea4ef23bfe659883d8734c600000000000000000000000092495600b72ef0e1fa22453b58938a9af49918ae0000000000000000000000000ddbb3ba9747dac58ea4ef23bfe659883d8734c600000000000000000000000000000000000000000000000000000000000000890000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a06300000000000000000000000000000000000000000000000ca83a3da2933d60000000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ca67b7d5b630cdec80000000000000000000000000ddbb3ba9747dac58ea4ef23bfe659883d8734c6b5bb8ee4ea713990eace87ff39bb8666e43ab3c7f4ba1b6e184d407e76585b530000000000000000000000000000000000000000000000000000000062514854c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002400000000000000000000000006090de2ec76eb1dc3b5d632734415c93c44fd113000000000000000000000000115909bdcbab21954beb4ab65fc2abee9866fa9300000000000000000000000000000000000000000000000000000000624d55010000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0x91c51bc5086c0ed95e5d2d5c5e145891138f3afc46d5d0300f498fcb2e8bd5252b49bf596d54c549b9f66a3f4f01ce4d93e84af267398847067291d44d49055a1b”,“invariantData”:{“user”:“0x0ddbb3ba9747dac58ea4ef23bfe659883d8734c6”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0x92495600b72ef0e1fa22453b58938a9af49918ae”,“initiator”:“0x0ddbb3ba9747dac58ea4ef23bfe659883d8734c6”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xb5bb8ee4ea713990eace87ff39bb8666e43ab3c7f4ba1b6e184d407e76585b53”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x0ddbb3ba9747dac58ea4ef23bfe659883d8734c6”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“sendingChainFallback”:“0x0ddbb3ba9747dac58ea4ef23bfe659883d8734c6”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”},“encryptedCallData”:“0x”}0x0ddbb3ba9747dac58ea4ef23bfe659883d8734c6false0x0ddbb3ba9747dac58ea4ef23bfe659883d8734c60x92495600b72ef0e1fa22453b58938a9af49918ae{“user”:“0x0ddbb3ba9747dac58ea4ef23bfe659883d8734c6”,“amount”:“233482998000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1649494100”,“router”:“0x92495600b72ef0e1fa22453b58938a9af49918ae”,“initiator”:“0x0ddbb3ba9747dac58ea4ef23bfe659883d8734c6”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xb5bb8ee4ea713990eace87ff39bb8666e43ab3c7f4ba1b6e184d407e76585b53”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x0ddbb3ba9747dac58ea4ef23bfe659883d8734c6”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“26807165”,“sendingChainFallback”:“0x0ddbb3ba9747dac58ea4ef23bfe659883d8734c6”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”}28268071652022-04-06T08:49:27.000Z0xb5bb8ee4ea713990eace87ff39bb8666e43ab3c7f4ba1b6e184d407e76585b530x5d29426ce5ce93a24047b5230f8101bd2508e6490e572d52f380eb76fd18e6a7
0x6090de2ec76eb1dc3b5d632734415c93c44fd113{“amount”:“104234668000000000000”,“expiry”:“1649503301”,“encodedBid”:“0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000001f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e00000000000000000000000000095ce8b1c273af612cd895e6b0c633039c35728270000000000000000000000001f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e00000000000000000000000000000000000000000000000000000000000000000890000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a063000000000000000000000000000000000000000000000005a68bee497cc6c00000000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005a5b3cf109ff49bfe0000000000000000000000001f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e000813f54306625b82729612a9ce9fe112bf3e8becdd3d5652cc35683b46819b2040000000000000000000000000000000000000000000000000000000062516c45c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002400000000000000000000000006090de2ec76eb1dc3b5d632734415c93c44fd113000000000000000000000000115909bdcbab21954beb4ab65fc2abee9866fa9300000000000000000000000000000000000000000000000000000000624d78f60000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0x1bcd6eb805fde92c51384d8c7f1447ae80b5b7a0d74987ac64cc0d5f0d9414cc11181698fc9a8e110442994c63c77307bd8137ebc27df24cb582f6dd784cee491b”,“invariantData”:{“user”:“0x1f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e000”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0x95ce8b1c273af612cd895e6b0c633039c3572827”,“initiator”:“0x1f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e000”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x813f54306625b82729612a9ce9fe112bf3e8becdd3d5652cc35683b46819b204”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x1f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e000”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“sendingChainFallback”:“0x1f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e000”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”},“encryptedCallData”:“0x”}0x1f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e000false0x1f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e0000x95ce8b1c273af612cd895e6b0c633039c3572827{“user”:“0x1f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e000”,“amount”:“104234668000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1649503301”,“router”:“0x95ce8b1c273af612cd895e6b0c633039c3572827”,“initiator”:“0x1f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e000”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x813f54306625b82729612a9ce9fe112bf3e8becdd3d5652cc35683b46819b204”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x1f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e000”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“26811568”,“sendingChainFallback”:“0x1f4bf2c65ff1f4a3e4ea6ab3b725af1e40c1e000”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”}172268115682022-04-06T11:25:26.000Z0x813f54306625b82729612a9ce9fe112bf3e8becdd3d5652cc35683b46819b2040xecaf6885fb405c71a739f848c37557e4a54fd629331724f9d069e66abfecd416
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v1_polygon.TransactionManager_TransactionPrepared_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

TransactionManagerV2_TransactionFulfilled_event

Transaction fulfillment events from Connext V1 cross-chain bridge on Polygon, capturing completed transfers between chains with user addresses, asset amounts, router signatures, and success status for analyzing bridge throughput and router performance.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_routerSTRINGAddress of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_transactionIdSTRINGUnique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
in_txDataSTRUCT<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_relayerFeeSTRINGFee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.
in_signatureSTRINGCryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
in_callDataSTRINGEncoded data to be passed to an external contract call during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
in_successBOOLBoolean flag indicating whether the operation completed successfully.
in_returnDataSTRINGData returned from an external contract call executed during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
addressin_userremovedin_callerin_routerin_txDatalog_indexin_successin_callDatablock_numberin_signaturein_relayerFeein_returnDatablock_timestampin_transactionIdtransaction_hash
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090xe7d265ef989b05ac848b90fbebc1231b7fa43bc6false0x29a519e21d6a97cdb82270b69c98bac6426cdcf90x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0xe7d265ef989b05ac848b90fbebc1231b7fa43bc6”,“amount”:“595030568414934100000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632063717”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x95850e359db174d97a1ff368a60725887c5e4c68fca80f9a8c08e31348b1fe02”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0xe7d265ef989b05ac848b90fbebc1231b7fa43bc6”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“19174267”,“sendingChainFallback”:“0xe7d265ef989b05ac848b90fbebc1231b7fa43bc6”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}276false0x191744480x02ac204549e686c4939414550163f8ae18db106a341e2a127af3f4cd0be64eaa2bc69dff3e05d5d7c6f759e30e9da1cb51c33877129b2fcdf7573f9a5dc59e781c00x2021-09-16T15:08:31.000Z0x95850e359db174d97a1ff368a60725887c5e4c68fca80f9a8c08e31348b1fe020xce1b05d152442ecaeca257177ba8d74a6fd8a4b2a7682d5e73f7c6a93bc33b30
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090x1dc846c79b1aa953846f59e44ea0e94ea8fbbcd5false0x29a519e21d6a97cdb82270b69c98bac6426cdcf90x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0x1dc846c79b1aa953846f59e44ea0e94ea8fbbcd5”,“amount”:“40558143608720954000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632080363”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xb9a7b6624d675d63d324ce287ef6c22684baa37f744a786cf963cc18cfc700ef”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x1dc846c79b1aa953846f59e44ea0e94ea8fbbcd5”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“19180284”,“sendingChainFallback”:“0x1dc846c79b1aa953846f59e44ea0e94ea8fbbcd5”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}474false0x191804150x229456e46d7f99af416c0cab79efe46151c1a6b40e9c2b2328767dadaa9616af013a6cb04443f9b71eef3f5d03c097fafcc35eff6a96a90bd041c37919871b101b00x2021-09-16T19:47:20.000Z0xb9a7b6624d675d63d324ce287ef6c22684baa37f744a786cf963cc18cfc700ef0xd37bde6d3d745343801d37663cf27afb9693feaf4f6c8e328c1745303095f9f2
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090xcea4e535d03086dbaa04c71675129654e92cc055false0x29a519e21d6a97cdb82270b69c98bac6426cdcf90x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0xcea4e535d03086dbaa04c71675129654e92cc055”,“amount”:“5400000000000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632081583”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x1843b65db36c884c1fd8d8d934ddfa5e2ab4db0770c9bd0f3c12a18ac7e31d12”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0xcea4e535d03086dbaa04c71675129654e92cc055”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“19180735”,“sendingChainFallback”:“0xcea4e535d03086dbaa04c71675129654e92cc055”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}336false0x191809300x3881d005ff81926a168942b6abf27239dec5a9229ea4f49986867aa4a8606122726d5f83afe8481fc19715ed302de6000221159f8ef3f25e699bd010552f5f9b1b00x2021-09-16T20:07:14.000Z0x1843b65db36c884c1fd8d8d934ddfa5e2ab4db0770c9bd0f3c12a18ac7e31d120x3739ab216da758a331eab4472d589e2245bc2f339855a77232ff1cc63735bc2a
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v1_polygon.TransactionManagerV2_TransactionFulfilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

TransactionManagerV2_TransactionPrepared_event

TransactionPrepared events from Connext V1 cross-chain bridge on Polygon, capturing initial preparation phase of token transfers between Polygon (chain ID 137) and Gnosis Chain (chain ID 100). Used for tracking cross-chain transaction lifecycle, router participation, and asset flow analysis.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_routerSTRINGAddress of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_transactionIdSTRINGUnique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
in_txDataSTRUCT<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_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_encryptedCallDataSTRINGEncrypted call data for contract execution on the destination chain. Hex-encoded, 0x-prefixed string, empty (0x) when no encrypted call data is provided.
in_encodedBidSTRINGABI-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_bidSignatureSTRINGCryptographic 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.
addressin_userremovedin_callerin_routerin_txDatalog_indexblock_numberin_encodedBidblock_timestampin_bidSignaturein_transactionIdtransaction_hashin_encryptedCallData
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090x876b71aa426fad5127910d3cc792e818b8229cf1false0x876b71aa426fad5127910d3cc792e818b8229cf10x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0x876b71aa426fad5127910d3cc792e818b8229cf1”,“amount”:“816479776995567200000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632209097”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xf1a397141deb1831c5af47a62505cb172b639cce1226423525180b5f42b52a23”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x876b71aa426fad5127910d3cc792e818b8229cf1”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“19231448”,“sendingChainFallback”:“0x876b71aa426fad5127910d3cc792e818b8229cf1”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}182192314480x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000876b71aa426fad5127910d3cc792e818b8229cf100000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000890000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a06300000000000000000000000000000000000000000000002c42eedf483eefe7000000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c3d4483443de1b3d0000000000000000000000000876b71aa426fad5127910d3cc792e818b8229cf1f1a397141deb1831c5af47a62505cb172b639cce1226423525180b5f42b52a2300000000000000000000000000000000000000000000000000000000614988c9c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09000000000000000000000000000000000000000000000000000000006145957400000000000000000000000000000000000000000000000000000000000000002021-09-18T07:25:26.000Z0x28412b1745fcd6b6dda71fc32c2d05fe16ed32910ac6fbfd05af6677f974588a5724afd9f9d9c1ae817a0b7619aff713abb0cdd5c8b457d06ee58c6fb3c6d0b51c0xf1a397141deb1831c5af47a62505cb172b639cce1226423525180b5f42b52a230xf06723a745b020ec595d06d7a7165f6ab7bee6088aee3c39a5209d8c585eaf910x
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090xf66d2a66ccddc3f705d0f0a576d8c796bd74a34bfalse0xf66d2a66ccddc3f705d0f0a576d8c796bd74a34b0x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0xf66d2a66ccddc3f705d0f0a576d8c796bd74a34b”,“amount”:“70000000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632194803”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x852d4adf01e818f24dc0453fe4e06fd775b384c75c640cab5cd1288e0489b47d”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0xf66d2a66ccddc3f705d0f0a576d8c796bd74a34b”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“19226186”,“sendingChainFallback”:“0xf66d2a66ccddc3f705d0f0a576d8c796bd74a34b”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}477192261860x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000f66d2a66ccddc3f705d0f0a576d8c796bd74a34b00000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000890000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a06300000000000000000000000000000000000000000000000000f8b0a10e4700000000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f890cbfbb5d000000000000000000000000000f66d2a66ccddc3f705d0f0a576d8c796bd74a34b852d4adf01e818f24dc0453fe4e06fd775b384c75c640cab5cd1288e0489b47d00000000000000000000000000000000000000000000000000000000614950f3c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090000000000000000000000000000000000000000000000000000000061455da000000000000000000000000000000000000000000000000000000000000000002021-09-18T03:28:14.000Z0xe3b1e38ab5ad7bcde79b73009a2049514fe4abced5112a439313a004dfd2883427e46fd9b2a885d0a17e66364a782596ee1ade3a1b60a23073d5e6415e35b79c1c0x852d4adf01e818f24dc0453fe4e06fd775b384c75c640cab5cd1288e0489b47d0x4265b68743e0aa9ee0bcb5fb40feb2ca3b9fae04896dc891729aee0add797de70x
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090x5a09aee17016b0e1319a274882ba3886e339cd16false0x5a09aee17016b0e1319a274882ba3886e339cd160x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0x5a09aee17016b0e1319a274882ba3886e339cd16”,“amount”:“50000000000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632227543”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x5e9d253270d33ba507570e5f0bf953b55b51ddaac5909e9eca03d38fbd2ce19c”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x5a09aee17016b0e1319a274882ba3886e339cd16”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“19238949”,“sendingChainFallback”:“0x5a09aee17016b0e1319a274882ba3886e339cd16”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}381192389490x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000005a09aee17016b0e1319a274882ba3886e339cd1600000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000890000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a063000000000000000000000000000000000000000000000002b5e3af16b188000000000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002b58addb89a2580000000000000000000000000005a09aee17016b0e1319a274882ba3886e339cd165e9d253270d33ba507570e5f0bf953b55b51ddaac5909e9eca03d38fbd2ce19c000000000000000000000000000000000000000000000000000000006149d0d7c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09000000000000000000000000000000000000000000000000000000006145dd8500000000000000000000000000000000000000000000000000000000000000002021-09-18T12:42:05.000Z0x5deee447c2abb5a43d8f67dbfe6a25bfcf1cf436ff04264be38dd2c766ede5e507b7a0f43dca83354dfd24588d51acc48c1fbbca5b831620dc359a2a0338bfa91b0x5e9d253270d33ba507570e5f0bf953b55b51ddaac5909e9eca03d38fbd2ce19c0xb9d8351ed73ff5fc15b0732a73f1f92be0424120c16fa807763ab0fbf5dbb2570x
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v1_polygon.TransactionManagerV2_TransactionPrepared_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100