connext_v1_gnosis

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
0x115909bdcbab21954beb4ab65fc2abee9866fa93	{“txData”:{“user”:“0xe0892003b381610cf7dd83bc3123010eab47350c”,“amount”:“220000000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1684425815”,“router”:“0xe4747a26b941ebdbc7ef67de7580f700e3dbf6d5”,“initiator”:“0xe0892003b381610cf7dd83bc3123010eab47350c”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x4defaa180cc7990e276863a07a58b7c9ea0731fe0f317f6969393ec7396ea0b8”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0xe0892003b381610cf7dd83bc3123010eab47350c”,“receivingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“receivingChainId”:“137”,“preparedBlockNumber”:“27956061”,“sendingChainFallback”:“0xe0892003b381610cf7dd83bc3123010eab47350c”,“receivingChainTxManagerAddress”:“0x6090de2ec76eb1dc3b5d632734415c93c44fd113”},“callData”:“0x”,“signature”:“0x834720145f0ae35a0e7689aab654aaeb8021ff71c816595bbf4759395cd11edb592c6c87534f4bd4f1404fc954407984fd3686adef7d10d7f36cc99710d6ed271b”,“relayerFee”:“0”,“encodedMeta”:“0x”}	0xe0892003b381610cf7dd83bc3123010eab47350c	false	0xe4747a26b941ebdbc7ef67de7580f700e3dbf6d5	0xe4747a26b941ebdbc7ef67de7580f700e3dbf6d5	1	false	27957271	false	0x	2023-05-15T14:49:40.000Z	0x4defaa180cc7990e276863a07a58b7c9ea0731fe0f317f6969393ec7396ea0b8	0x6b924680cc7fef8c0f58983e5a6971975c19aed01a354cff564698c67f313dc1
0x115909bdcbab21954beb4ab65fc2abee9866fa93	{“txData”:{“user”:“0x87593e56063d0f4a5ec70278ab86a22277938e59”,“amount”:“6900000000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1671317729”,“router”:“0x1eab42ce26873e6365bd3fffea23e59591f660e0”,“initiator”:“0x87593e56063d0f4a5ec70278ab86a22277938e59”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x3db226706c93d96471824158ffa8524d6699d57c44e3b00c7d828f3fa80376b6”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0x87593e56063d0f4a5ec70278ab86a22277938e59”,“receivingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“receivingChainId”:“56”,“preparedBlockNumber”:“25451808”,“sendingChainFallback”:“0x87593e56063d0f4a5ec70278ab86a22277938e59”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”},“callData”:“0x”,“signature”:“0x8b09052973c7bcbc80574fbfbaae10ee5077fd37071db4376a0a880b4bd15a2631a1a5be204ca8a6c74df4b5b097f2218213a06d538c634922bc889ec293bde81b”,“relayerFee”:“0”,“encodedMeta”:“0x”}	0x87593e56063d0f4a5ec70278ab86a22277938e59	false	0x1eab42ce26873e6365bd3fffea23e59591f660e0	0x1eab42ce26873e6365bd3fffea23e59591f660e0	8	false	25452400	false	0x	2022-12-14T23:48:30.000Z	0x3db226706c93d96471824158ffa8524d6699d57c44e3b00c7d828f3fa80376b6	0xc5f299b2b1f1d5e886e4aade10a31ad0c9b176e220980516bf794ff92598037e
0x115909bdcbab21954beb4ab65fc2abee9866fa93	{“txData”:{“user”:“0x8aa9a3a726612aca2af0d86f469292281cd39e0d”,“amount”:“50000000000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1671273301”,“router”:“0xee2ef40f688607cb23618d9312d62392786d13eb”,“initiator”:“0x8aa9a3a726612aca2af0d86f469292281cd39e0d”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xc4381e22dc72ac161ccb9dbb719c5cc34ee1da466d3bf7b66dcf00c92d6ad8eb”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“100”,“receivingAddress”:“0x8aa9a3a726612aca2af0d86f469292281cd39e0d”,“receivingAssetId”:“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”,“receivingChainId”:“56”,“preparedBlockNumber”:“25443238”,“sendingChainFallback”:“0x8aa9a3a726612aca2af0d86f469292281cd39e0d”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”},“callData”:“0x”,“signature”:“0xd6761f3b24c44680014b5cb3191470ed1eac092263a2452c0d5012437592de2f54d2982ebe12402f4f17e102fb4b8cfd8f8d79a1330133c4c7303cb85ab6ae071b”,“relayerFee”:“0”,“encodedMeta”:“0x”}	0x8aa9a3a726612aca2af0d86f469292281cd39e0d	false	0xee2ef40f688607cb23618d9312d62392786d13eb	0xee2ef40f688607cb23618d9312d62392786d13eb	0	false	25443680	false	0x	2022-12-14T11:14:30.000Z	0xc4381e22dc72ac161ccb9dbb719c5cc34ee1da466d3bf7b66dcf00c92d6ad8eb	0xffc36d4d8812aa74f67e3e47917451ac741912a659085a725198da78e16ad211

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.connext_v1_gnosis.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
0x115909bdcbab21954beb4ab65fc2abee9866fa93	{“amount”:“230000000000000000”,“expiry”:“1646896931”,“encodedBid”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000d7b26011e6eb5857a6251da1f77e9f3d8aac448900000000000000000000000075ee04316185200a51e995779f381ef63d39f7f9000000000000000000000000d7b26011e6eb5857a6251da1f77e9f3d8aac448900000000000000000000000000000000000000000000000000000000000000640000000000000000000000006a023ccd1ff6f2045c3309768ead9e68f978f6e100000000000000000000000000000000000000000000000003311fc80a570000000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000330b6bde6f063c3000000000000000000000000d7b26011e6eb5857a6251da1f77e9f3d8aac44891a487174453e7047c64e0b588fd496f947423ed8996939ae48baa4fa69b56799000000000000000000000000000000000000000000000000000000006229a723c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a47000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000240000000000000000000000000115909bdcbab21954beb4ab65fc2abee9866fa9300000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09000000000000000000000000000000000000000000000000000000006225b3cf0000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0xb143ab269090fd00a66319291ead6998b7173935cec9783932e51133ee5638ee3d27fd69d04da453fc3bb96081932761608546e8522ed79524ca863973d4dab31b”,“invariantData”:{“user”:“0xd7b26011e6eb5857a6251da1f77e9f3d8aac4489”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0x75ee04316185200a51e995779f381ef63d39f7f9”,“initiator”:“0xd7b26011e6eb5857a6251da1f77e9f3d8aac4489”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x1a487174453e7047c64e0b588fd496f947423ed8996939ae48baa4fa69b56799”,“sendingAssetId”:“0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1”,“sendingChainId”:“100”,“receivingAddress”:“0xd7b26011e6eb5857a6251da1f77e9f3d8aac4489”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“10”,“sendingChainFallback”:“0xd7b26011e6eb5857a6251da1f77e9f3d8aac4489”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”},“encryptedCallData”:“0x”}	0xd7b26011e6eb5857a6251da1f77e9f3d8aac4489	false	0xd7b26011e6eb5857a6251da1f77e9f3d8aac4489	0x75ee04316185200a51e995779f381ef63d39f7f9	{“user”:“0xd7b26011e6eb5857a6251da1f77e9f3d8aac4489”,“amount”:“230000000000000000”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1646896931”,“router”:“0x75ee04316185200a51e995779f381ef63d39f7f9”,“initiator”:“0xd7b26011e6eb5857a6251da1f77e9f3d8aac4489”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x1a487174453e7047c64e0b588fd496f947423ed8996939ae48baa4fa69b56799”,“sendingAssetId”:“0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1”,“sendingChainId”:“100”,“receivingAddress”:“0xd7b26011e6eb5857a6251da1f77e9f3d8aac4489”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“10”,“preparedBlockNumber”:“20981960”,“sendingChainFallback”:“0xd7b26011e6eb5857a6251da1f77e9f3d8aac4489”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”}	7	20981960	2022-03-07T07:23:05.000Z	0x1a487174453e7047c64e0b588fd496f947423ed8996939ae48baa4fa69b56799	0x7207ed4f668833f26f557230eb57ee72627d94934914733e5ee8791ea0e65285
0x115909bdcbab21954beb4ab65fc2abee9866fa93	{“amount”:“11567446446661224468”,“expiry”:“1646803839”,“encodedBid”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000bf7cfacce582d518da34f98fdcc8ad16475ce6f60000000000000000000000001eab42ce26873e6365bd3fffea23e59591f660e0000000000000000000000000bf7cfacce582d518da34f98fdcc8ad16475ce6f600000000000000000000000000000000000000000000000000000000000000890000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a063000000000000000000000000000000000000000000000000a0d7f397f2c7000000000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a085c0b1df9d0c20000000000000000000000000bf7cfacce582d518da34f98fdcc8ad16475ce6f64e3c85a42afdbf316c1ab0a67b44c13e234ba1a8f30893a71c1ff2bc640ffd910000000000000000000000000000000000000000000000000000000062298cffc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002400000000000000000000000006090de2ec76eb1dc3b5d632734415c93c44fd113000000000000000000000000115909bdcbab21954beb4ab65fc2abee9866fa9300000000000000000000000000000000000000000000000000000000622599ab0000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0xb6abb36af62a221cd2cd81514a38b724ebfb977332146c0436505ea40503bee009bf75cb69a931c5b2f76a6a00206fea7e81af2436f9adb2e14626bf7b167a0d1b”,“invariantData”:{“user”:“0xbf7cfacce582d518da34f98fdcc8ad16475ce6f6”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0x1eab42ce26873e6365bd3fffea23e59591f660e0”,“initiator”:“0xbf7cfacce582d518da34f98fdcc8ad16475ce6f6”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x4e3c85a42afdbf316c1ab0a67b44c13e234ba1a8f30893a71c1ff2bc640ffd91”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0xbf7cfacce582d518da34f98fdcc8ad16475ce6f6”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“sendingChainFallback”:“0xbf7cfacce582d518da34f98fdcc8ad16475ce6f6”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”},“encryptedCallData”:“0x”}	0xbf7cfacce582d518da34f98fdcc8ad16475ce6f6	false	0x1eab42ce26873e6365bd3fffea23e59591f660e0	0x1eab42ce26873e6365bd3fffea23e59591f660e0	{“user”:“0xbf7cfacce582d518da34f98fdcc8ad16475ce6f6”,“amount”:“11567446446661224468”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1646803839”,“router”:“0x1eab42ce26873e6365bd3fffea23e59591f660e0”,“initiator”:“0xbf7cfacce582d518da34f98fdcc8ad16475ce6f6”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x4e3c85a42afdbf316c1ab0a67b44c13e234ba1a8f30893a71c1ff2bc640ffd91”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0xbf7cfacce582d518da34f98fdcc8ad16475ce6f6”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“20980632”,“sendingChainFallback”:“0xbf7cfacce582d518da34f98fdcc8ad16475ce6f6”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”}	1	20980632	2022-03-07T05:32:15.000Z	0x4e3c85a42afdbf316c1ab0a67b44c13e234ba1a8f30893a71c1ff2bc640ffd91	0x1404b275bf08bde062ba62598d456475f1f79ea504590f9153d500fab521ecd6
0x115909bdcbab21954beb4ab65fc2abee9866fa93	{“amount”:“102900302648609628235”,“expiry”:“1646840552”,“encodedBid”:“0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000005f151f0e6ffe36dc7282fffbaa77d52437b0710900000000000000000000000075ee04316185200a51e995779f381ef63d39f7f90000000000000000000000005f151f0e6ffe36dc7282fffbaa77d52437b0710900000000000000000000000000000000000000000000000000000000000000890000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a06300000000000000000000000000000000000000000000000594dc3fdd2051f0000000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000594059ff69bcd6a3a0000000000000000000000005f151f0e6ffe36dc7282fffbaa77d52437b07109d4260f69c9aafdc65fe4d965de666c9cee3cc70050afacf3ffa9dc96e508188f00000000000000000000000000000000000000000000000000000000622a1c68c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002400000000000000000000000006090de2ec76eb1dc3b5d632734415c93c44fd113000000000000000000000000115909bdcbab21954beb4ab65fc2abee9866fa9300000000000000000000000000000000000000000000000000000000622629200000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0xf9fab091261b8df47906cd4088df3fb7561501b1788958392614f4263e9e2978364d4a094462feee19b78a03473befcf30d79334b2f9ea9c8b56005aa27dea621c”,“invariantData”:{“user”:“0x5f151f0e6ffe36dc7282fffbaa77d52437b07109”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0x75ee04316185200a51e995779f381ef63d39f7f9”,“initiator”:“0x5f151f0e6ffe36dc7282fffbaa77d52437b07109”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xd4260f69c9aafdc65fe4d965de666c9cee3cc70050afacf3ffa9dc96e508188f”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x5f151f0e6ffe36dc7282fffbaa77d52437b07109”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“sendingChainFallback”:“0x5f151f0e6ffe36dc7282fffbaa77d52437b07109”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”},“encryptedCallData”:“0x”}	0x5f151f0e6ffe36dc7282fffbaa77d52437b07109	false	0x75ee04316185200a51e995779f381ef63d39f7f9	0x75ee04316185200a51e995779f381ef63d39f7f9	{“user”:“0x5f151f0e6ffe36dc7282fffbaa77d52437b07109”,“amount”:“102900302648609628235”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1646840552”,“router”:“0x75ee04316185200a51e995779f381ef63d39f7f9”,“initiator”:“0x5f151f0e6ffe36dc7282fffbaa77d52437b07109”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xd4260f69c9aafdc65fe4d965de666c9cee3cc70050afacf3ffa9dc96e508188f”,“sendingAssetId”:“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”,“sendingChainId”:“137”,“receivingAddress”:“0x5f151f0e6ffe36dc7282fffbaa77d52437b07109”,“receivingAssetId”:“0x0000000000000000000000000000000000000000”,“receivingChainId”:“100”,“preparedBlockNumber”:“20988046”,“sendingChainFallback”:“0x5f151f0e6ffe36dc7282fffbaa77d52437b07109”,“receivingChainTxManagerAddress”:“0x115909bdcbab21954beb4ab65fc2abee9866fa93”}	31	20988046	2022-03-07T15:50:30.000Z	0xd4260f69c9aafdc65fe4d965de666c9cee3cc70050afacf3ffa9dc96e508188f	0x0f8a2d50cbd29782607eff0c1324978a677d67603a3a21ef184d4f5b7a56094d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.connext_v1_gnosis.TransactionManager_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

​Tables

​TransactionManager_TransactionFulfilled_event

​TransactionManager_TransactionPrepared_event

Tables

TransactionManager_TransactionFulfilled_event

TransactionManager_TransactionPrepared_event