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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_router`	`STRING`	Address of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_args`	`STRUCT<txData STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>, relayerFee STRING, signature STRING, callData STRING, encodedMeta STRING>`	Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed.
`in_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.
`in_isContract`	`BOOL`	Boolean flag indicating whether the caller address is a smart contract.
`in_returnData`	`STRING`	Data returned from an external contract call executed during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_args	in_user	removed	in_caller	in_router	log_index	in_success	block_number	in_isContract	in_returnData	block_timestamp	in_transactionId	transaction_hash
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

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_router`	`STRING`	Address of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_txData`	`STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>`	Structured transaction data for cross-chain operations in the Connext protocol. Contains addresses for transaction managers, users, routers, and initiators, asset identifiers for sending and receiving chains, fallback and receiving addresses, call target and call data hash, unique transaction identifier, chain identifiers, transfer amount, expiration timestamp, and prepared block number.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_args`	`STRUCT<invariantData STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, sendingChainId STRING, receivingChainId STRING, callDataHash STRING, transactionId STRING>, amount STRING, expiry STRING, encryptedCallData STRING, encodedBid STRING, bidSignature STRING, encodedMeta STRING>`	Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed.

Sample Data

address	in_args	in_user	removed	in_caller	in_router	in_txData	log_index	block_number	block_timestamp	in_transactionId	transaction_hash
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

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_router`	`STRING`	Address of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_txData`	`STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>`	Structured transaction data for cross-chain operations in the Connext protocol. Contains addresses for transaction managers, users, routers, and initiators, asset identifiers for sending and receiving chains, fallback and receiving addresses, call target and call data hash, unique transaction identifier, chain identifiers, transfer amount, expiration timestamp, and prepared block number.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_callData`	`STRING`	Encoded data to be passed to an external contract call during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
`in_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.
`in_returnData`	`STRING`	Data returned from an external contract call executed during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_caller	in_router	in_txData	log_index	in_success	in_callData	block_number	in_signature	in_returnData	block_timestamp	in_transactionId	transaction_hash
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09	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	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	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	0x	2021-09-18T08:12:17.000Z	0x17b005f2909a6713d92e44e04ff30307fe7f06fe4e5448fbd640fb7187644448	0xa22972c833d473d56579a90fb249f6d683c2dc7916e48f74445dbf4a8197c186

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_router`	`STRING`	Address of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_txData`	`STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>`	Structured transaction data for cross-chain operations in the Connext protocol. Contains addresses for transaction managers, users, routers, and initiators, asset identifiers for sending and receiving chains, fallback and receiving addresses, call target and call data hash, unique transaction identifier, chain identifiers, transfer amount, expiration timestamp, and prepared block number.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_encryptedCallData`	`STRING`	Encrypted call data for contract execution on the destination chain. Hex-encoded, 0x-prefixed string, empty (0x) when no encrypted call data is provided.
`in_encodedBid`	`STRING`	ABI-encoded bid data submitted by the router for the cross-chain transaction. Hex-encoded, 0x-prefixed string containing the encoded representation of bid parameters including user address and transaction details.
`in_bidSignature`	`STRING`	Cryptographic signature from the router attesting to their bid to facilitate the cross-chain transaction. Hex-encoded, 0x-prefixed, 132-character string representing the ECDSA signature.

Sample Data

address	in_user	removed	in_caller	in_router	in_txData	log_index	block_number	in_encodedBid	block_timestamp	in_bidSignature	in_transactionId	transaction_hash	in_encryptedCallData
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09	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

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

TransactionManager_TransactionFulfilled_event

TransactionManager_TransactionPrepared_event

TransactionManagerV2_TransactionFulfilled_event

TransactionManagerV2_TransactionPrepared_event

​Tables

​TransactionManager_TransactionFulfilled_event

​TransactionManager_TransactionPrepared_event

​TransactionManagerV2_TransactionFulfilled_event

​TransactionManagerV2_TransactionPrepared_event

Tables

TransactionManager_TransactionFulfilled_event

TransactionManager_TransactionPrepared_event

TransactionManagerV2_TransactionFulfilled_event

TransactionManagerV2_TransactionPrepared_event