> ## Documentation Index > Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # connext_v1_fantom > Tables in tt-contracts.connext_v1_fantom ## 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. | 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, 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. | | 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 | | ------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | -------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | | 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"} | 0x52b12817cab124a515c7c714a7df44aa2e0bc799 | false | 0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d | 0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d | 121 | false | 52152586 | false | 0x | 2022-12-11T08:25:22.000Z | 0xbd275833c4a920e2fec39206dee928cbb2860310ed844d56afeb521dc4ed1fa1 | 0xdcc236237b246ed6d53eb26e58cb202c0af9238d4726be6c4715366d7f3f6fdf | | 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"} | 0xee98bb8614689f3d4f96dd7a0038a98b81441ed2 | false | 0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d | 0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d | 17 | false | 52161747 | false | 0x | 2022-12-11T12:56:39.000Z | 0x92c1992adf1c082867409d4b4616bb186b25684a2b147422b8afd2e13b56e474 | 0xa2a4198b31aac97b47da7306bf9bf397b9d363909d11875e3a6aa20f99255ad5 | | 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"} | 0xcde81fe71d14d5530e2763a83b8aea92acab295e | false | 0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d | 0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d | 13 | false | 52144228 | false | 0x | 2022-12-11T04:30:29.000Z | 0x347f70b61fcb6efe60c030f608e4bb16779162782c89ab78b0b31dafd49a392a | 0x57bda2b538846a174f33b23253b3d4377433bf151e43ca2a9128032b7fb04750 | **Query with partition filter** ```sql theme={null} 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. | 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` | 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, 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. | | address | in\_args | in\_user | removed | in\_caller | in\_router | in\_txData | log\_index | block\_number | block\_timestamp | in\_transactionId | transaction\_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"} | 0x10fbff9b9450d3a2d9d1612d6de3726facd8809e | false | 0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d | 0x6db8506a7454c5a83b9e68dfc89fd7413ce97a5d | \{"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"} | 69 | 55843028 | 2023-02-15T13:15:48.000Z | 0x3de86dac274cd9798648e84102a299dc6ef67895d2ea82d42b5f333e3486ae2f | 0xd339d71d12713c0f4b3828b079e289a951bc331b73e10c422e282fece4b61ed4 | | 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"} | 0x10fbff9b9450d3a2d9d1612d6de3726facd8809e | false | 0xe4747a26b941ebdbc7ef67de7580f700e3dbf6d5 | 0xe4747a26b941ebdbc7ef67de7580f700e3dbf6d5 | \{"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"} | 3 | 55875504 | 2023-02-15T23:07:20.000Z | 0x0ad19913e7c78596da0b26a4dde7bfe07cefcc6d65f96a8f97b3141c451b1578 | 0xe2db94601d19a3d4cf0ba0f80599f7f2375c5b751b0a378e11718333702dd04a | | 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"} | 0x07a97eee4395463b9ed8e5c67e638e4febe7e10b | false | 0xf410f49c547115567f4209bae3dd2dbd855ddac0 | 0xf410f49c547115567f4209bae3dd2dbd855ddac0 | \{"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"} | 1 | 55848757 | 2023-02-15T15:04:16.000Z | 0x9fda60653e994530b920a1073ccbe503619ab38029f2483fbfff667db3cfdaa7 | 0x11770908a18858a025891f8ce82df16690d239535532478839cda169d939dc96 | **Query with partition filter** ```sql theme={null} 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. | 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` | 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. | | address | in\_user | removed | in\_caller | in\_router | in\_txData | log\_index | in\_success | in\_callData | block\_number | in\_signature | in\_relayerFee | in\_returnData | block\_timestamp | in\_transactionId | transaction\_hash | | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ----------- | ------------ | ------------- | ------------------------------------------------------------------------------------------------------------------------------------ | -------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | | 0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09 | 0x4b1a8dc4256a26306dc1bb069cc7ff6ec04a6418 | false | 0x29a519e21d6a97cdb82270b69c98bac6426cdcf9 | 0x29a519e21d6a97cdb82270b69c98bac6426cdcf9 | \{"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"} | 35 | false | 0x | 17231829 | 0x65213dd0d10fa52bebc6190ba20f566c66e1307a3203b3494b8579540fbe948f26059070f975c9412734c96d76ad39aad382b175cf59c9fe0ab37b46095e648e1b | 0 | 0x | 2021-09-18T10:02:56.000Z | 0x0c537592ea581982e36bb2a431ec57417b35fce8d29a52711606731830dc1517 | 0x0c12d3fd1dfa1c424703699c0688c553eea83ca7c129b595cc7e368c0259a697 | | 0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09 | 0xceae06e7d4aee7d00224e9c31a7f4cefed5b4ac9 | false | 0x29a519e21d6a97cdb82270b69c98bac6426cdcf9 | 0x29a519e21d6a97cdb82270b69c98bac6426cdcf9 | \{"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"} | 39 | false | 0x | 17243895 | 0xfbd316928966d5e3b714b07c60e064bd2a00898d25f6fa5f4621f223f7f017375c68043358af6d768d8af9078042fb41d395a5afca3f51986b6738a7035965671c | 0 | 0x | 2021-09-18T15:45:01.000Z | 0x3703081d012dc6924e670adf500a1f76656701fee76988a6d51a1b4dc15c4cc7 | 0x999dd836eae9723126708c49c2f58b343daee8d54249dda9488c655bf2d10b4d | | 0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09 | 0xcc8a8db32ca9fb50c6602b4d1bca1118c57b5acc | false | 0x29a519e21d6a97cdb82270b69c98bac6426cdcf9 | 0x29a519e21d6a97cdb82270b69c98bac6426cdcf9 | \{"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"} | 88 | false | 0x | 17228226 | 0x38c39f91122361ee034cf937d8e476f0936ac312753e45a1615591685617f66064db96691a890b39c057831f4b1aab7b629bfa2f333579137954ebe7ca530a401c | 0 | 0x | 2021-09-18T08:12:17.000Z | 0x17b005f2909a6713d92e44e04ff30307fe7f06fe4e5448fbd640fb7187644448 | 0xa22972c833d473d56579a90fb249f6d683c2dc7916e48f74445dbf4a8197c186 | **Query with partition filter** ```sql theme={null} 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. | 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` | 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. | | 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 | 0xccbb6be6bf73dbb88a7412a1f38e8de8c363c93d | false | 0xccbb6be6bf73dbb88a7412a1f38e8de8c363c93d | 0x29a519e21d6a97cdb82270b69c98bac6426cdcf9 | \{"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"} | 43 | 17185303 | 0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000ccbb6be6bf73dbb88a7412a1f38e8de8c363c93d00000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000fa00000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000000000000000000000000000000000000045ae5d7e00000000000000000000000000000000000000000000000000000000000000380000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d00000000000000000000000000000000000000000000003f57c964a391452a00000000000000000000000000ccbb6be6bf73dbb88a7412a1f38e8de8c363c93d276561c912ed7091b1695ff70360e9088b0e9346023ff6ceb62a78979cf7fd470000000000000000000000000000000000000000000000000000000061487326c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090000000000000000000000000000000000000000000000000000000061447fd20000000000000000000000000000000000000000000000000000000000000000 | 2021-09-17T11:41:35.000Z | 0x403af866b84182d62b9ddb4d685202159507c515df73d3f49f8a46fa0d3f290059fb59cb68aa114fb78d5daec8f04edf0a32cb49a7aa4c14825126b09c3ed87b1c | 0x276561c912ed7091b1695ff70360e9088b0e9346023ff6ceb62a78979cf7fd47 | 0x927ea671be6146138dab1c38999f190ed3a9bbd6e45e90e55ded57ae8b86b16a | 0x | | 0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09 | 0x3c90512e64c795c180479fa7bed62cb6b953f46d | false | 0x3c90512e64c795c180479fa7bed62cb6b953f46d | 0x29a519e21d6a97cdb82270b69c98bac6426cdcf9 | \{"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"} | 2 | 17175431 | 0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000003c90512e64c795c180479fa7bed62cb6b953f46d00000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000fa00000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000000000000000000000000000000000000000da871d00000000000000000000000000000000000000000000000000000000000000380000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000000000000000000000000000c6a686700f9b5f000000000000000000000000003c90512e64c795c180479fa7bed62cb6b953f46d1df24eeb9595de21a68318041bc76a7a9aecf9d86c527feccc857cb29568a07800000000000000000000000000000000000000000000000000000000614824bdc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000000000000000000000000000000000000614431690000000000000000000000000000000000000000000000000000000000000000 | 2021-09-17T06:06:46.000Z | 0x559e76ac7c7ac68c0a0a511cf3e171f8178057220cb10ddb724cd5169d87bb4853c312cc5e157736f0c828780eb8c168c33eb8f8f91fd4b652bfecbf4a7b342b1c | 0x1df24eeb9595de21a68318041bc76a7a9aecf9d86c527feccc857cb29568a078 | 0xfc6e770eebb4124601d22bdf97cb51d3781208751fb35027ac95495341f1e722 | 0x | | 0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09 | 0x4250cf8bea1ceca2196bdf7b556d8651ad45376a | false | 0x4250cf8bea1ceca2196bdf7b556d8651ad45376a | 0x29a519e21d6a97cdb82270b69c98bac6426cdcf9 | \{"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"} | 4 | 17177757 | 0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000004250cf8bea1ceca2196bdf7b556d8651ad45376a00000000000000000000000029a519e21d6a97cdb82270b69c98bac6426cdcf900000000000000000000000000000000000000000000000000000000000000fa00000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b75000000000000000000000000000000000000000000000000000000000c5feeaf00000000000000000000000000000000000000000000000000000000000000380000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d00000000000000000000000000000000000000000000000b3fc6ef1df367e5000000000000000000000000004250cf8bea1ceca2196bdf7b556d8651ad45376aba80d3a572b824e8329d1e894caf4c3606dddc6606a49e9dbb65ddd8a8e09e74000000000000000000000000000000000000000000000000000000006148397dc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000022000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000000000000000000000000000000000000614446280000000000000000000000000000000000000000000000000000000000000000 | 2021-09-17T07:35:57.000Z | 0xc8b88596832b6f1f98e432fec92d02a2b04d1242f179a32a540a29c3b305baa61908b88923adeef764d65ab306167b423da8b0952e864be5406b9355abaf2d151c | 0xba80d3a572b824e8329d1e894caf4c3606dddc6606a49e9dbb65ddd8a8e09e74 | 0x08b3046d6d7fd82ccc56f634f4de79671e2d99ac2a6a0d6db59ba5ef9175966b | 0x | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.connext_v1_fantom.TransactionManagerV2_TransactionPrepared_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` ***