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
0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b{“txData”:{“user”:“0x52b12817cab124a515c7c714a7df44aa2e0bc799”,“amount”:“29908493”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1671006004”,“router”:“0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d”,“initiator”:“0x52b12817cab124a515c7c714a7df44aa2e0bc799”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xbd275833c4a920e2fec39206dee928cbb2860310ed844d56afeb521dc4ed1fa1”,“sendingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“sendingChainId”:“250”,“receivingAddress”:“0x52b12817cab124a515c7c714a7df44aa2e0bc799”,“receivingAssetId”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“receivingChainId”:“137”,“preparedBlockNumber”:“52152440”,“sendingChainFallback”:“0x52b12817cab124a515c7c714a7df44aa2e0bc799”,“receivingChainTxManagerAddress”:“0x6090de2ec76eb1dc3b5d632734415c93c44fd113”},“callData”:“0x”,“signature”:“0x2ed56e720084621a040302be699a1eaec4201adfe9575b4f8afa661994a715735dc7fdce754ed23d5fbf4dcce2ded06ee51557667be287ebe05fe04401035e0c1b”,“relayerFee”:“6656”,“encodedMeta”:“0x”}0x52b12817cab124a515c7c714a7df44aa2e0bc799false0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d121false52152586false0x2022-12-11T08:25:22.000Z0xbd275833c4a920e2fec39206dee928cbb2860310ed844d56afeb521dc4ed1fa10xdcc236237b246ed6d53eb26e58cb202c0af9238d4726be6c4715366d7f3f6fdf
0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b{“txData”:{“user”:“0xee98bb8614689f3d4f96dd7a0038a98b81441ed2”,“amount”:“4345535”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1671022415”,“router”:“0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d”,“initiator”:“0xee98bb8614689f3d4f96dd7a0038a98b81441ed2”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x92c1992adf1c082867409d4b4616bb186b25684a2b147422b8afd2e13b56e474”,“sendingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“sendingChainId”:“250”,“receivingAddress”:“0xee98bb8614689f3d4f96dd7a0038a98b81441ed2”,“receivingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“receivingChainId”:“56”,“preparedBlockNumber”:“52161671”,“sendingChainFallback”:“0xee98bb8614689f3d4f96dd7a0038a98b81441ed2”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”},“callData”:“0x”,“signature”:“0x54ccfda1c7a8663f8fda7dddc16dddbfc1274a97913b230c2330c756652e5915752206d7d8380f55a212ec0ed2a5e559b999f9fc5ffba2d418db1b5ef05513491b”,“relayerFee”:“298328681298973862”,“encodedMeta”:“0x”}0xee98bb8614689f3d4f96dd7a0038a98b81441ed2false0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d17false52161747false0x2022-12-11T12:56:39.000Z0x92c1992adf1c082867409d4b4616bb186b25684a2b147422b8afd2e13b56e4740xa2a4198b31aac97b47da7306bf9bf397b9d363909d11875e3a6aa20f99255ad5
0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b{“txData”:{“user”:“0xcde81fe71d14d5530e2763a83b8aea92acab295e”,“amount”:“2042895941”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1670990547”,“router”:“0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d”,“initiator”:“0xcde81fe71d14d5530e2763a83b8aea92acab295e”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x347f70b61fcb6efe60c030f608e4bb16779162782c89ab78b0b31dafd49a392a”,“sendingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“sendingChainId”:“250”,“receivingAddress”:“0xcde81fe71d14d5530e2763a83b8aea92acab295e”,“receivingAssetId”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“receivingChainId”:“42161”,“preparedBlockNumber”:“52144108”,“sendingChainFallback”:“0xcde81fe71d14d5530e2763a83b8aea92acab295e”,“receivingChainTxManagerAddress”:“0xcf4d2994088a8cde52fb584fe29608b63ec063b2”},“callData”:“0x”,“signature”:“0xe34655337527763cd760e48d320b4358e99472d5796a02ad5d06b10111cdbbd41029dd3a4c05f9885cca5f93a52d9d80ed15b5b2578c678ec162af06767beb5e1c”,“relayerFee”:“229081”,“encodedMeta”:“0x”}0xcde81fe71d14d5530e2763a83b8aea92acab295efalse0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d13false52144228false0x2022-12-11T04:30:29.000Z0x347f70b61fcb6efe60c030f608e4bb16779162782c89ab78b0b31dafd49a392a0x57bda2b538846a174f33b23253b3d4377433bf151e43ca2a9128032b7fb04750
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v1_fantom.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
0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b{“amount”:“3582552”,“expiry”:“1676639703”,“encodedBid”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000010fbff9b9450d3a2d9d1612d6de3726facd8809e0000000000000000000000006db8506a7454c5a83b9e68dfc89fd7413ce97a5d0000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae000000000000000000000000000000000000000000000000000000000000a86a000000000000000000000000a7d7079b0fead91f3e65f86e8915cb59c1a4c664000000000000000000000000000000000000000000000000000000000038386700000000000000000000000000000000000000000000000000000000000000fa00000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000000000000000000000000000000000000000369ba20000000000000000000000008ab8226e45224cd2330934d0cc5cc25dcab0b7ba3de86dac274cd9798648e84102a299dc6ef67895d2ea82d42b5f333e3486ae2f0000000000000000000000000000000000000000000000000000000063f0cf4d0b5f45e6ba819b93314c22610410c34ac1619c0385d5d8274907902f30fd5ca40000000000000000000000000baee5700179d87fabad13022447bd4e160374dd000000000000000000000000000000000000000000000000000000000000024000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090000000000000000000000000d29d9fa94a23e0d2f06efc79c25144a8f51fc4b0000000000000000000000000000000000000000000000000000000063ecdbfc00000000000000000000000000000000000000000000000000000000000003044f91bc2b1aebd0f7eb416b69d67ced95e9b345761e97b91c07b8453129161dd8fba934b6000000000000000000000000000000000000000000000000000000000000008000000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000008ab8226e45224cd2330934d0cc5cc25dcab0b7ba000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000006d0176c5ea1e44b08d3dd001b0784ce42f47a3a70000000000000000000000006d0176c5ea1e44b08d3dd001b0784ce42f47a3a700000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000035965100000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012418cbafe500000000000000000000000000000000000000000000000000000000003596510000000000000000000000000000000000000000000000005a8d0ede9dbc3ead00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000dd1305150d27aecc60c066630105db419977e3670000000000000000000000000000000000000000000000000000000063ece8dd000000000000000000000000000000000000000000000000000000000000000300000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000006c021ae822bea943b2e66552bde1d2696a53fbb700000000000000000000000021be370d5312f44cb42ce377bc9b8a0cef1a4c830000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0x2c2a109ca6307464216d2aba4569773143a138a29fb5f66bf23718cc1f288cf04e8c3bdbe327f775d703b0075d46b6b14b03add57d252937e113e8b417df45561c”,“invariantData”:{“user”:“0x10fbff9b9450d3a2d9d1612d6de3726facd8809e”,“callTo”:“0x0baee5700179d87fabad13022447bd4e160374dd”,“router”:“0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d”,“initiator”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“callDataHash”:“0x0b5f45e6ba819b93314c22610410c34ac1619c0385d5d8274907902f30fd5ca4”,“transactionId”:“0x3de86dac274cd9798648e84102a299dc6ef67895d2ea82d42b5f333e3486ae2f”,“sendingAssetId”:“0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664”,“sendingChainId”:“43114”,“receivingAddress”:“0x8ab8226e45224cd2330934d0cc5cc25dcab0b7ba”,“receivingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“receivingChainId”:“250”,“sendingChainFallback”:“0x8ab8226e45224cd2330934d0cc5cc25dcab0b7ba”,“receivingChainTxManagerAddress”:“0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b”},“encryptedCallData”:“0x4f91bc2b1aebd0f7eb416b69d67ced95e9b345761e97b91c07b8453129161dd8fba934b6000000000000000000000000000000000000000000000000000000000000008000000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000008ab8226e45224cd2330934d0cc5cc25dcab0b7ba000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000006d0176c5ea1e44b08d3dd001b0784ce42f47a3a70000000000000000000000006d0176c5ea1e44b08d3dd001b0784ce42f47a3a700000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000035965100000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012418cbafe500000000000000000000000000000000000000000000000000000000003596510000000000000000000000000000000000000000000000005a8d0ede9dbc3ead00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000dd1305150d27aecc60c066630105db419977e3670000000000000000000000000000000000000000000000000000000063ece8dd000000000000000000000000000000000000000000000000000000000000000300000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000006c021ae822bea943b2e66552bde1d2696a53fbb700000000000000000000000021be370d5312f44cb42ce377bc9b8a0cef1a4c8300000000000000000000000000000000000000000000000000000000”}0x10fbff9b9450d3a2d9d1612d6de3726facd8809efalse0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d{“user”:“0x10fbff9b9450d3a2d9d1612d6de3726facd8809e”,“amount”:“3582552”,“callTo”:“0x0baee5700179d87fabad13022447bd4e160374dd”,“expiry”:“1676639703”,“router”:“0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d”,“initiator”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“callDataHash”:“0x0b5f45e6ba819b93314c22610410c34ac1619c0385d5d8274907902f30fd5ca4”,“transactionId”:“0x3de86dac274cd9798648e84102a299dc6ef67895d2ea82d42b5f333e3486ae2f”,“sendingAssetId”:“0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664”,“sendingChainId”:“43114”,“receivingAddress”:“0x8ab8226e45224cd2330934d0cc5cc25dcab0b7ba”,“receivingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“receivingChainId”:“250”,“preparedBlockNumber”:“55843028”,“sendingChainFallback”:“0x8ab8226e45224cd2330934d0cc5cc25dcab0b7ba”,“receivingChainTxManagerAddress”:“0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b”}69558430282023-02-15T13:15:48.000Z0x3de86dac274cd9798648e84102a299dc6ef67895d2ea82d42b5f333e3486ae2f0xd339d71d12713c0f4b3828b079e289a951bc331b73e10c422e282fece4b61ed4
0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b{“amount”:“26460293551160371756”,“expiry”:“1676675118”,“encodedBid”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000010fbff9b9450d3a2d9d1612d6de3726facd8809e000000000000000000000000e4747a26b941ebdbc7ef67de7580f700e3dbf6d50000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016fc2e998d3da000000000000000000000000000000000000000000000000000000000000000000fa0000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e0000000000000000000000000000000000000000000000016f4de5f4d513bd5d00000000000000000000000079a074122be96e1fc9bdd32dba04759421d12f900ad19913e7c78596da0b26a4dde7bfe07cefcc6d65f96a8f97b3141c451b15780000000000000000000000000000000000000000000000000000000063f159a5a2ec9462d312ab5dc3c3fec9b711e92c2459c4098c0593f8ac6ed430b6651c900000000000000000000000000baee5700179d87fabad13022447bd4e160374dd0000000000000000000000000000000000000000000000000000000000000240000000000000000000000000115909bdcbab21954beb4ab65fc2abee9866fa930000000000000000000000000d29d9fa94a23e0d2f06efc79c25144a8f51fc4b0000000000000000000000000000000000000000000000000000000063ed665600000000000000000000000000000000000000000000000000000000000008a44f91bc2b215c66d57ba3495b0c8478aa2295c2cfba8c9cb84fa432937f0225bd5fcff47c00000000000000000000000000000000000000000000000000000000000000800000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e00000000000000000000000079a074122be96e1fc9bdd32dba04759421d12f9000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000def189deaef76e379df891899eb5a00a94cbc250000000000000000000000000def189deaef76e379df891899eb5a00a94cbc2500000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016cd8edc997b6c79d00000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006c8415565b00000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000016cd8edc997b6c79d00000000000000000000000000000000000000000000000286a3e6745347fef200000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000004a0000000000000000000000000000000000000000000000000000000000000001100000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000340000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e00000000000000000000000021be370d5312f44cb42ce377bc9b8a0cef1a4c8300000000000000000000000000000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000002c00000000000000000000000000000000000000000000000016cd8edc997b6c79d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000253706f6f6b79537761700000000000000000000000000000000000000000000000000000000000016cd8edc997b6c79d00000000000000000000000000000000000000000000000286a3e6745347fef2000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000f491e7b69e4244ad4002bc14e878a34207e38c29000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000020000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e00000000000000000000000021be370d5312f44cb42ce377bc9b8a0cef1a4c8300000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000004000000000000000000000000021be370d5312f44cb42ce377bc9b8a0cef1a4c83ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000d000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000010000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e0000000000000000000000000000000000000000000000000000000000000000869584cd00000000000000000000000010000000000000000000000000000000000000110000000000000000000000000000000000000000000000cb1db8de2e63ed652500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0xb6822d06c64b2e319fd79a733312cb019605826df38d55494dceb25e889f12dc176140146a710e599dd6afb9c74f756a8830744b0b5827cd1d127ff7312974201c”,“invariantData”:{“user”:“0x10fbff9b9450d3a2d9d1612d6de3726facd8809e”,“callTo”:“0x0baee5700179d87fabad13022447bd4e160374dd”,“router”:“0xe4747a26b941ebdbc7ef67de7580f700e3dbf6d5”,“initiator”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“callDataHash”:“0xa2ec9462d312ab5dc3c3fec9b711e92c2459c4098c0593f8ac6ed430b6651c90”,“transactionId”:“0x0ad19913e7c78596da0b26a4dde7bfe07cefcc6d65f96a8f97b3141c451b1578”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0x79a074122be96e1fc9bdd32dba04759421d12f90”,“receivingAssetId”:“0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e”,“receivingChainId”:“250”,“sendingChainFallback”:“0x79a074122be96e1fc9bdd32dba04759421d12f90”,“receivingChainTxManagerAddress”:“0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b”},“encryptedCallData”:“0x4f91bc2b215c66d57ba3495b0c8478aa2295c2cfba8c9cb84fa432937f0225bd5fcff47c00000000000000000000000000000000000000000000000000000000000000800000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e00000000000000000000000079a074122be96e1fc9bdd32dba04759421d12f9000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000def189deaef76e379df891899eb5a00a94cbc250000000000000000000000000def189deaef76e379df891899eb5a00a94cbc2500000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016cd8edc997b6c79d00000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006c8415565b00000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000016cd8edc997b6c79d00000000000000000000000000000000000000000000000286a3e6745347fef200000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000004a0000000000000000000000000000000000000000000000000000000000000001100000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000340000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e00000000000000000000000021be370d5312f44cb42ce377bc9b8a0cef1a4c8300000000000000000000000000000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000002c00000000000000000000000000000000000000000000000016cd8edc997b6c79d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000253706f6f6b79537761700000000000000000000000000000000000000000000000000000000000016cd8edc997b6c79d00000000000000000000000000000000000000000000000286a3e6745347fef2000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000f491e7b69e4244ad4002bc14e878a34207e38c29000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000020000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e00000000000000000000000021be370d5312f44cb42ce377bc9b8a0cef1a4c8300000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000004000000000000000000000000021be370d5312f44cb42ce377bc9b8a0cef1a4c83ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000d000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000010000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e0000000000000000000000000000000000000000000000000000000000000000869584cd00000000000000000000000010000000000000000000000000000000000000110000000000000000000000000000000000000000000000cb1db8de2e63ed6525000000000000000000000000000000000000000000000000”}0x10fbff9b9450d3a2d9d1612d6de3726facd8809efalse0xe4747a26b941ebdbc7ef67de7580f700e3dbf6d50xe4747a26b941ebdbc7ef67de7580f700e3dbf6d5{“user”:“0x10fbff9b9450d3a2d9d1612d6de3726facd8809e”,“amount”:“26460293551160371756”,“callTo”:“0x0baee5700179d87fabad13022447bd4e160374dd”,“expiry”:“1676675118”,“router”:“0xe4747a26b941ebdbc7ef67de7580f700e3dbf6d5”,“initiator”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“callDataHash”:“0xa2ec9462d312ab5dc3c3fec9b711e92c2459c4098c0593f8ac6ed430b6651c90”,“transactionId”:“0x0ad19913e7c78596da0b26a4dde7bfe07cefcc6d65f96a8f97b3141c451b1578”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0x79a074122be96e1fc9bdd32dba04759421d12f90”,“receivingAssetId”:“0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e”,“receivingChainId”:“250”,“preparedBlockNumber”:“55875504”,“sendingChainFallback”:“0x79a074122be96e1fc9bdd32dba04759421d12f90”,“receivingChainTxManagerAddress”:“0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b”}3558755042023-02-15T23:07:20.000Z0x0ad19913e7c78596da0b26a4dde7bfe07cefcc6d65f96a8f97b3141c451b15780xe2db94601d19a3d4cf0ba0f80599f7f2375c5b751b0a378e11718333702dd04a
0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b{“amount”:“79946029730843213686”,“expiry”:“1676646115”,“encodedBid”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000007a97eee4395463b9ed8e5c67e638e4febe7e10b000000000000000000000000f410f49c547115567f4209bae3dd2dbd855ddac000000000000000000000000007a97eee4395463b9ed8e5c67e638e4febe7e10b00000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004563918244f40000000000000000000000000000000000000000000000000000000000000000000fa0000000000000000000000008d11ec38a3eb5e956b052f67da8bdc9bef8abf3e000000000000000000000000000000000000000000000004556a5d03af849fd100000000000000000000000007a97eee4395463b9ed8e5c67e638e4febe7e10b9fda60653e994530b920a1073ccbe503619ab38029f2483fbfff667db3cfdaa70000000000000000000000000000000000000000000000000000000063f0e863c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a47000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000240000000000000000000000000115909bdcbab21954beb4ab65fc2abee9866fa930000000000000000000000000d29d9fa94a23e0d2f06efc79c25144a8f51fc4b0000000000000000000000000000000000000000000000000000000063ecf50f0000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0xf128c870864779e463011d5faac15eb9742ef3e091fe0d62e2766656293e682039a58469ea43491fef76c66d5793bc609305c693496126128a50602feadb4a431c”,“invariantData”:{“user”:“0x07a97eee4395463b9ed8e5c67e638e4febe7e10b”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0xf410f49c547115567f4209bae3dd2dbd855ddac0”,“initiator”:“0x07a97eee4395463b9ed8e5c67e638e4febe7e10b”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x9fda60653e994530b920a1073ccbe503619ab38029f2483fbfff667db3cfdaa7”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0x07a97eee4395463b9ed8e5c67e638e4febe7e10b”,“receivingAssetId”:“0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e”,“receivingChainId”:“250”,“sendingChainFallback”:“0x07a97eee4395463b9ed8e5c67e638e4febe7e10b”,“receivingChainTxManagerAddress”:“0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b”},“encryptedCallData”:“0x”}0x07a97eee4395463b9ed8e5c67e638e4febe7e10bfalse0xf410f49c547115567f4209bae3dd2dbd855ddac00xf410f49c547115567f4209bae3dd2dbd855ddac0{“user”:“0x07a97eee4395463b9ed8e5c67e638e4febe7e10b”,“amount”:“79946029730843213686”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1676646115”,“router”:“0xf410f49c547115567f4209bae3dd2dbd855ddac0”,“initiator”:“0x07a97eee4395463b9ed8e5c67e638e4febe7e10b”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x9fda60653e994530b920a1073ccbe503619ab38029f2483fbfff667db3cfdaa7”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0x07a97eee4395463b9ed8e5c67e638e4febe7e10b”,“receivingAssetId”:“0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e”,“receivingChainId”:“250”,“preparedBlockNumber”:“55848757”,“sendingChainFallback”:“0x07a97eee4395463b9ed8e5c67e638e4febe7e10b”,“receivingChainTxManagerAddress”:“0x0d29d9fa94a23e0d2f06efc79c25144a8f51fc4b”}1558487572023-02-15T15:04:16.000Z0x9fda60653e994530b920a1073ccbe503619ab38029f2483fbfff667db3cfdaa70x11770908a18858a025891f8ce82df16690d239535532478839cda169d939dc96
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v1_fantom.TransactionManager_TransactionPrepared_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
TransactionManagerV2_TransactionFulfilled_event

Connext V1 cross-chain bridge transaction fulfillment events on Fantom, capturing completed asset transfers from Binance Smart Chain (chain ID 56) to Fantom (chain ID 250) with router execution details, signatures, and success indicators.
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
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090x4b1a8dc4256a26306dc1bb069cc7ff6ec04a6418false0x29a519e21d6a97cdb82270b69c98bac6426cdcf90x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0x4b1a8dc4256a26306dc1bb069cc7ff6ec04a6418”,“amount”:“169850379”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632131998”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x0c537592ea581982e36bb2a431ec57417b35fce8d29a52711606731830dc1517”,“sendingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“sendingChainId”:“56”,“receivingAddress”:“0x4b1a8dc4256a26306dc1bb069cc7ff6ec04a6418”,“receivingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“receivingChainId”:“250”,“preparedBlockNumber”:“17231803”,“sendingChainFallback”:“0x4b1a8dc4256a26306dc1bb069cc7ff6ec04a6418”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}35false0x172318290x65213dd0d10fa52bebc6190ba20f566c66e1307a3203b3494b8579540fbe948f26059070f975c9412734c96d76ad39aad382b175cf59c9fe0ab37b46095e648e1b00x2021-09-18T10:02:56.000Z0x0c537592ea581982e36bb2a431ec57417b35fce8d29a52711606731830dc15170x0c12d3fd1dfa1c424703699c0688c553eea83ca7c129b595cc7e368c0259a697
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090xceae06e7d4aee7d00224e9c31a7f4cefed5b4ac9false0x29a519e21d6a97cdb82270b69c98bac6426cdcf90x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0xceae06e7d4aee7d00224e9c31a7f4cefed5b4ac9”,“amount”:“221889000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632152619”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x3703081d012dc6924e670adf500a1f76656701fee76988a6d51a1b4dc15c4cc7”,“sendingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“sendingChainId”:“56”,“receivingAddress”:“0xceae06e7d4aee7d00224e9c31a7f4cefed5b4ac9”,“receivingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“receivingChainId”:“250”,“preparedBlockNumber”:“17243885”,“sendingChainFallback”:“0xceae06e7d4aee7d00224e9c31a7f4cefed5b4ac9”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}39false0x172438950xfbd316928966d5e3b714b07c60e064bd2a00898d25f6fa5f4621f223f7f017375c68043358af6d768d8af9078042fb41d395a5afca3f51986b6738a7035965671c00x2021-09-18T15:45:01.000Z0x3703081d012dc6924e670adf500a1f76656701fee76988a6d51a1b4dc15c4cc70x999dd836eae9723126708c49c2f58b343daee8d54249dda9488c655bf2d10b4d
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090xcc8a8db32ca9fb50c6602b4d1bca1118c57b5accfalse0x29a519e21d6a97cdb82270b69c98bac6426cdcf90x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0xcc8a8db32ca9fb50c6602b4d1bca1118c57b5acc”,“amount”:“999500000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632125400”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x17b005f2909a6713d92e44e04ff30307fe7f06fe4e5448fbd640fb7187644448”,“sendingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“sendingChainId”:“56”,“receivingAddress”:“0xcc8a8db32ca9fb50c6602b4d1bca1118c57b5acc”,“receivingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“receivingChainId”:“250”,“preparedBlockNumber”:“17228209”,“sendingChainFallback”:“0xcc8a8db32ca9fb50c6602b4d1bca1118c57b5acc”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}88false0x172282260x38c39f91122361ee034cf937d8e476f0936ac312753e45a1615591685617f66064db96691a890b39c057831f4b1aab7b629bfa2f333579137954ebe7ca530a401c00x2021-09-18T08:12:17.000Z0x17b005f2909a6713d92e44e04ff30307fe7f06fe4e5448fbd640fb71876444480xa22972c833d473d56579a90fb249f6d683c2dc7916e48f74445dbf4a8197c186
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v1_fantom.TransactionManagerV2_TransactionFulfilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
TransactionManagerV2_TransactionPrepared_event

Cross-chain transaction preparation events from Connext V1 bridge on Fantom, capturing router bids and transaction parameters for asset transfers between Fantom (chain 250) and Binance Smart Chain (chain 56). Used for tracking bridge transfer initiation and router liquidity provision.
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
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090xccbb6be6bf73dbb88a7412a1f38e8de8c363c93dfalse0xccbb6be6bf73dbb88a7412a1f38e8de8c363c93d0x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0xccbb6be6bf73dbb88a7412a1f38e8de8c363c93d”,“amount”:“1169055102”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632138022”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x276561c912ed7091b1695ff70360e9088b0e9346023ff6ceb62a78979cf7fd47”,“sendingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“sendingChainId”:“250”,“receivingAddress”:“0xccbb6be6bf73dbb88a7412a1f38e8de8c363c93d”,“receivingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“receivingChainId”:“56”,“preparedBlockNumber”:“17185303”,“sendingChainFallback”:“0xccbb6be6bf73dbb88a7412a1f38e8de8c363c93d”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}43171853030x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000ccbb6be6bf73dbb88a7412a1f38e8de8c363c93d00000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000fa00000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000000000000000000000000000000000000045ae5d7e00000000000000000000000000000000000000000000000000000000000000380000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d00000000000000000000000000000000000000000000003f57c964a391452a00000000000000000000000000ccbb6be6bf73dbb88a7412a1f38e8de8c363c93d276561c912ed7091b1695ff70360e9088b0e9346023ff6ceb62a78979cf7fd470000000000000000000000000000000000000000000000000000000061487326c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090000000000000000000000000000000000000000000000000000000061447fd200000000000000000000000000000000000000000000000000000000000000002021-09-17T11:41:35.000Z0x403af866b84182d62b9ddb4d685202159507c515df73d3f49f8a46fa0d3f290059fb59cb68aa114fb78d5daec8f04edf0a32cb49a7aa4c14825126b09c3ed87b1c0x276561c912ed7091b1695ff70360e9088b0e9346023ff6ceb62a78979cf7fd470x927ea671be6146138dab1c38999f190ed3a9bbd6e45e90e55ded57ae8b86b16a0x
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090x3c90512e64c795c180479fa7bed62cb6b953f46dfalse0x3c90512e64c795c180479fa7bed62cb6b953f46d0x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0x3c90512e64c795c180479fa7bed62cb6b953f46d”,“amount”:“14321437”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632117949”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x1df24eeb9595de21a68318041bc76a7a9aecf9d86c527feccc857cb29568a078”,“sendingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“sendingChainId”:“250”,“receivingAddress”:“0x3c90512e64c795c180479fa7bed62cb6b953f46d”,“receivingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“receivingChainId”:“56”,“preparedBlockNumber”:“17175431”,“sendingChainFallback”:“0x3c90512e64c795c180479fa7bed62cb6b953f46d”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}2171754310x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000003c90512e64c795c180479fa7bed62cb6b953f46d00000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000fa00000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000000000000000000000000000000000000000da871d00000000000000000000000000000000000000000000000000000000000000380000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000000000000000000000000000c6a686700f9b5f000000000000000000000000003c90512e64c795c180479fa7bed62cb6b953f46d1df24eeb9595de21a68318041bc76a7a9aecf9d86c527feccc857cb29568a07800000000000000000000000000000000000000000000000000000000614824bdc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09000000000000000000000000000000000000000000000000000000006144316900000000000000000000000000000000000000000000000000000000000000002021-09-17T06:06:46.000Z0x559e76ac7c7ac68c0a0a511cf3e171f8178057220cb10ddb724cd5169d87bb4853c312cc5e157736f0c828780eb8c168c33eb8f8f91fd4b652bfecbf4a7b342b1c0x1df24eeb9595de21a68318041bc76a7a9aecf9d86c527feccc857cb29568a0780xfc6e770eebb4124601d22bdf97cb51d3781208751fb35027ac95495341f1e7220x
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090x4250cf8bea1ceca2196bdf7b556d8651ad45376afalse0x4250cf8bea1ceca2196bdf7b556d8651ad45376a0x29a519e21d6a97cdb82270b69c98bac6426cdcf9{“user”:“0x4250cf8bea1ceca2196bdf7b556d8651ad45376a”,“amount”:“207613615”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1632123261”,“router”:“0x29a519e21d6a97cdb82270b69c98bac6426cdcf9”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xba80d3a572b824e8329d1e894caf4c3606dddc6606a49e9dbb65ddd8a8e09e74”,“sendingAssetId”:“0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“sendingChainId”:“250”,“receivingAddress”:“0x4250cf8bea1ceca2196bdf7b556d8651ad45376a”,“receivingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“receivingChainId”:“56”,“preparedBlockNumber”:“17177757”,“sendingChainFallback”:“0x4250cf8bea1ceca2196bdf7b556d8651ad45376a”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}4171777570x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000004250cf8bea1ceca2196bdf7b556d8651ad45376a00000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000fa00000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b75000000000000000000000000000000000000000000000000000000000c5feeaf00000000000000000000000000000000000000000000000000000000000000380000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d00000000000000000000000000000000000000000000000b3fc6ef1df367e5000000000000000000000000004250cf8bea1ceca2196bdf7b556d8651ad45376aba80d3a572b824e8329d1e894caf4c3606dddc6606a49e9dbb65ddd8a8e09e74000000000000000000000000000000000000000000000000000000006148397dc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09000000000000000000000000000000000000000000000000000000006144462800000000000000000000000000000000000000000000000000000000000000002021-09-17T07:35:57.000Z0xc8b88596832b6f1f98e432fec92d02a2b04d1242f179a32a540a29c3b305baa61908b88923adeef764d65ab306167b423da8b0952e864be5406b9355abaf2d151c0xba80d3a572b824e8329d1e894caf4c3606dddc6606a49e9dbb65ddd8a8e09e740x08b3046d6d7fd82ccc56f634f4de79671e2d99ac2a6a0d6db59ba5ef9175966b0x
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v1_fantom.TransactionManagerV2_TransactionPrepared_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100