Skip to main content

​
Tables

​
TransactionManager_TransactionFulfilled_event

Cross-chain transaction fulfillment events emitted by Connext TransactionManager contracts. Records completion attempts of bridged transactions with router execution details, relayer fees, user signatures, and success status across multiple blockchain networks.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_routerSTRINGAddress of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_transactionIdSTRINGUnique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
in_argsSTRUCT<txData STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>, relayerFee STRING, signature STRING, callData STRING, encodedMeta STRING>Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed.
in_successBOOLBoolean flag indicating whether the operation completed successfully.
in_isContractBOOLBoolean flag indicating whether the caller address is a smart contract.
in_returnDataSTRINGData returned from an external contract call executed during transaction fulfillment. Hex-encoded byte string prefixed with 0x.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
addressin_argsin_userremovedin_callerin_routerlog_indexin_successblock_numberin_isContractin_returnDatablock_timestampin_transactionIdtransaction_hash
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09{“txData”:{“user”:“0x59514b67b8fd2ae952fcb81fbb1d5da3d0c55a0d”,“amount”:“294500438”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1646712575”,“router”:“0x1370c680f2a2ae22f711b30b917a57f052816485”,“initiator”:“0x59514b67b8fd2ae952fcb81fbb1d5da3d0c55a0d”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x0e0aebe7c0e778c3d6c6557acc534e37b887b16ebe82da305d3bd63f3d9120c5”,“sendingAssetId”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“sendingChainId”:“137”,“receivingAddress”:“0x59514b67b8fd2ae952fcb81fbb1d5da3d0c55a0d”,“receivingAssetId”:“0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664”,“receivingChainId”:“43114”,“preparedBlockNumber”:“11745505”,“sendingChainFallback”:“0x59514b67b8fd2ae952fcb81fbb1d5da3d0c55a0d”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”},“callData”:“0x”,“signature”:“0x9d94230e4122c438e411430ed962585649c16b421a430b70672dc57aff7cda8966027fced7ba0a1b5d6272f7fa335d26c2bee5295b7f6bca890421b1faebcb891b”,“relayerFee”:“480330”,“encodedMeta”:“0x”}0x59514b67b8fd2ae952fcb81fbb1d5da3d0c55a0dfalse0x4efaee0fad71a451c6ca621df5aefc5c01668a260x1370c680f2a2ae22f711b30b917a57f05281648529false11745517false0x2022-03-06T04:13:00.000Z0x0e0aebe7c0e778c3d6c6557acc534e37b887b16ebe82da305d3bd63f3d9120c50x19eb93f29cd14bbc70a3cc3dab77b247749fe93b63a1ebd0c6b6fddec435440f
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09{“txData”:{“user”:“0xd727ac3d7f6498146fa493c360fd63f1ded8eb70”,“amount”:“250416387”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1646728182”,“router”:“0x1370c680f2a2ae22f711b30b917a57f052816485”,“initiator”:“0xd727ac3d7f6498146fa493c360fd63f1ded8eb70”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x055e7a24eaacc3e4621ee1889b0892a1b9681b2c3c0df8b104ab4051f9a272c6”,“sendingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“sendingChainId”:“56”,“receivingAddress”:“0xd727ac3d7f6498146fa493c360fd63f1ded8eb70”,“receivingAssetId”:“0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664”,“receivingChainId”:“43114”,“preparedBlockNumber”:“11753733”,“sendingChainFallback”:“0xd727ac3d7f6498146fa493c360fd63f1ded8eb70”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”},“callData”:“0x”,“signature”:“0x39979470f20e0226c19f31033445e416586bdf9030f4e55efa3eafd285421f43004078ce6bc067d1d9348adc3663a4203e2fac5d818677cc4d84fba283e5b86a1b”,“relayerFee”:“393172”,“encodedMeta”:“0x”}0xd727ac3d7f6498146fa493c360fd63f1ded8eb70false0x4efaee0fad71a451c6ca621df5aefc5c01668a260x1370c680f2a2ae22f711b30b917a57f05281648579false11753815false0x2022-03-06T08:47:22.000Z0x055e7a24eaacc3e4621ee1889b0892a1b9681b2c3c0df8b104ab4051f9a272c60x7dc59aff90d228844dbe9cd1d43b2ba5db10343cef66b2b1eda6d12734eb9439
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09{“txData”:{“user”:“0xd377cffcc52c16bf6e9840e77f78f42ddb946568”,“amount”:“687162280”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1646816147”,“router”:“0x1370c680f2a2ae22f711b30b917a57f052816485”,“initiator”:“0xd377cffcc52c16bf6e9840e77f78f42ddb946568”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x1afb5e72821cedfee1aeedd6708693be6aaaf6a161474f7827415876fc703521”,“sendingAssetId”:“0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664”,“sendingChainId”:“43114”,“receivingAddress”:“0xd377cffcc52c16bf6e9840e77f78f42ddb946568”,“receivingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“receivingChainId”:“56”,“preparedBlockNumber”:“11754095”,“sendingChainFallback”:“0xd377cffcc52c16bf6e9840e77f78f42ddb946568”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”},“callData”:“0x”,“signature”:“0x7f1dd5f7bd06a5c1a5bf0cc607eb11ad95058ce316cc4c22ca61c81f2e15b5f459c2b6538e225a654eb15d19364d9c066a8b5c6e60a4e244433bd2824a9a10621b”,“relayerFee”:“421450595272200000”,“encodedMeta”:“0x”}0xd377cffcc52c16bf6e9840e77f78f42ddb946568false0x1370c680f2a2ae22f711b30b917a57f0528164850x1370c680f2a2ae22f711b30b917a57f05281648548false11754177false0x2022-03-06T08:59:10.000Z0x1afb5e72821cedfee1aeedd6708693be6aaaf6a161474f7827415876fc7035210x654fcda0d3927d24a8d64a04c605835c0ac707cd83b782950c3443641b801a27
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v1_avalanche.TransactionManager_TransactionFulfilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
TransactionManager_TransactionPrepared_event

Cross-chain transaction preparation events emitted by the Connext v1 TransactionManager contract containing user addresses, router addresses, asset identifiers, chain identifiers, transfer amounts, expiry timestamps, and cryptographic signatures for cross-chain bridge operations.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_routerSTRINGAddress of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_transactionIdSTRINGUnique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
in_txDataSTRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, callDataHash STRING, transactionId STRING, sendingChainId STRING, receivingChainId STRING, amount STRING, expiry STRING, preparedBlockNumber STRING>Structured transaction data for cross-chain operations in the Connext protocol. Contains addresses for transaction managers, users, routers, and initiators, asset identifiers for sending and receiving chains, fallback and receiving addresses, call target and call data hash, unique transaction identifier, chain identifiers, transfer amount, expiration timestamp, and prepared block number.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_argsSTRUCT<invariantData STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, sendingChainId STRING, receivingChainId STRING, callDataHash STRING, transactionId STRING>, amount STRING, expiry STRING, encryptedCallData STRING, encodedBid STRING, bidSignature STRING, encodedMeta STRING>Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed.
addressin_argsin_userremovedin_callerin_routerin_txDatalog_indexblock_numberblock_timestampin_transactionIdtransaction_hash
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09{“amount”:“276331447”,“expiry”:“1645203339”,“encodedBid”:“0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000002249c19d04794e64e907de39d829bb2265b5b8230000000000000000000000001370c680f2a2ae22f711b30b917a57f0528164850000000000000000000000002249c19d04794e64e907de39d829bb2265b5b823000000000000000000000000000000000000000000000000000000000000a86a000000000000000000000000a7d7079b0fead91f3e65f86e8915cb59c1a4c6640000000000000000000000000000000000000000000000000000000010787bb700000000000000000000000000000000000000000000000000000000000000890000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa8417400000000000000000000000000000000000000000000000000000000106714060000000000000000000000002249c19d04794e64e907de39d829bb2265b5b823933c0bad818639aad42e0a785e7782fea68c3637333576c612be0ae7918cfeaa00000000000000000000000000000000000000000000000000000000620fcf8bc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000024000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090000000000000000000000006090de2ec76eb1dc3b5d632734415c93c44fd11300000000000000000000000000000000000000000000000000000000620bdc390000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0xe27e9bf77bc11f6b052b9247ab2ccbc81755ff5f67fdae7c9a2669fa307270b859632a0a1f8dacea46a9e2dccaf4b5442a0669412c457a5e7b4e25f62a0f2d5f1b”,“invariantData”:{“user”:“0x2249c19d04794e64e907de39d829bb2265b5b823”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0x1370c680f2a2ae22f711b30b917a57f052816485”,“initiator”:“0x2249c19d04794e64e907de39d829bb2265b5b823”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x933c0bad818639aad42e0a785e7782fea68c3637333576c612be0ae7918cfeaa”,“sendingAssetId”:“0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664”,“sendingChainId”:“43114”,“receivingAddress”:“0x2249c19d04794e64e907de39d829bb2265b5b823”,“receivingAssetId”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“receivingChainId”:“137”,“sendingChainFallback”:“0x2249c19d04794e64e907de39d829bb2265b5b823”,“receivingChainTxManagerAddress”:“0x6090de2ec76eb1dc3b5d632734415c93c44fd113”},“encryptedCallData”:“0x”}0x2249c19d04794e64e907de39d829bb2265b5b823false0x2249c19d04794e64e907de39d829bb2265b5b8230x1370c680f2a2ae22f711b30b917a57f052816485{“user”:“0x2249c19d04794e64e907de39d829bb2265b5b823”,“amount”:“276331447”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1645203339”,“router”:“0x1370c680f2a2ae22f711b30b917a57f052816485”,“initiator”:“0x2249c19d04794e64e907de39d829bb2265b5b823”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x933c0bad818639aad42e0a785e7782fea68c3637333576c612be0ae7918cfeaa”,“sendingAssetId”:“0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664”,“sendingChainId”:“43114”,“receivingAddress”:“0x2249c19d04794e64e907de39d829bb2265b5b823”,“receivingAssetId”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“receivingChainId”:“137”,“preparedBlockNumber”:“10960978”,“sendingChainFallback”:“0x2249c19d04794e64e907de39d829bb2265b5b823”,“receivingChainTxManagerAddress”:“0x6090de2ec76eb1dc3b5d632734415c93c44fd113”}82109609782022-02-15T16:56:03.000Z0x933c0bad818639aad42e0a785e7782fea68c3637333576c612be0ae7918cfeaa0xea872c2eb51393e80f3b19c26ee6139afea8690b06d75693fc5f6af430c10b00
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09{“amount”:“95200436”,“expiry”:“1645212540”,“encodedBid”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000fb51e4764e020f6ed618c76102dd9335825c83280000000000000000000000001370c680f2a2ae22f711b30b917a57f052816485000000000000000000000000fb51e4764e020f6ed618c76102dd9335825c8328000000000000000000000000000000000000000000000000000000000000a86a000000000000000000000000a7d7079b0fead91f3e65f86e8915cb59c1a4c6640000000000000000000000000000000000000000000000000000000005aca4b400000000000000000000000000000000000000000000000000000000000000380000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d00000000000000000000000000000000000000000000000517b8cf62367172e5000000000000000000000000fb51e4764e020f6ed618c76102dd9335825c8328f617af6d8691e5c4de7e802c373b149d2620bf9f54ae6c423b2f099b56adb74100000000000000000000000000000000000000000000000000000000620ff37cc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000024000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090000000000000000000000002a9ea5e8cddf40730f4f4f839f673a51600c314e00000000000000000000000000000000000000000000000000000000620c00240000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0xc466b9c8901b3381d593f66158e05e034debca1f1d0d63f5b004411a6eca2b620c989cdb9a043fe33892af64aedc700dde3864e8afbef80c87ce74c72dcb67531b”,“invariantData”:{“user”:“0xfb51e4764e020f6ed618c76102dd9335825c8328”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0x1370c680f2a2ae22f711b30b917a57f052816485”,“initiator”:“0xfb51e4764e020f6ed618c76102dd9335825c8328”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xf617af6d8691e5c4de7e802c373b149d2620bf9f54ae6c423b2f099b56adb741”,“sendingAssetId”:“0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664”,“sendingChainId”:“43114”,“receivingAddress”:“0xfb51e4764e020f6ed618c76102dd9335825c8328”,“receivingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“receivingChainId”:“56”,“sendingChainFallback”:“0xfb51e4764e020f6ed618c76102dd9335825c8328”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”},“encryptedCallData”:“0x”}0xfb51e4764e020f6ed618c76102dd9335825c8328false0xfb51e4764e020f6ed618c76102dd9335825c83280x1370c680f2a2ae22f711b30b917a57f052816485{“user”:“0xfb51e4764e020f6ed618c76102dd9335825c8328”,“amount”:“95200436”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1645212540”,“router”:“0x1370c680f2a2ae22f711b30b917a57f052816485”,“initiator”:“0xfb51e4764e020f6ed618c76102dd9335825c8328”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0xf617af6d8691e5c4de7e802c373b149d2620bf9f54ae6c423b2f099b56adb741”,“sendingAssetId”:“0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664”,“sendingChainId”:“43114”,“receivingAddress”:“0xfb51e4764e020f6ed618c76102dd9335825c8328”,“receivingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“receivingChainId”:“56”,“preparedBlockNumber”:“10965450”,“sendingChainFallback”:“0xfb51e4764e020f6ed618c76102dd9335825c8328”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”}70109654502022-02-15T19:29:50.000Z0xf617af6d8691e5c4de7e802c373b149d2620bf9f54ae6c423b2f099b56adb7410x242187e5f304a13228a35f2df2a4bab5b48abe3b62aec8bd22dd92f0de440328
0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09{“amount”:“52753294”,“expiry”:“1645202183”,“encodedBid”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000026f3b313f7ed3feb71c2af5d8468cd536e32a4df0000000000000000000000001370c680f2a2ae22f711b30b917a57f05281648500000000000000000000000026f3b313f7ed3feb71c2af5d8468cd536e32a4df000000000000000000000000000000000000000000000000000000000000a86a000000000000000000000000a7d7079b0fead91f3e65f86e8915cb59c1a4c664000000000000000000000000000000000000000000000000000000000324f38e00000000000000000000000000000000000000000000000000000000000000380000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000000000000000000000000002c60a7c54a8c29a5300000000000000000000000026f3b313f7ed3feb71c2af5d8468cd536e32a4df439e183c799b69f43b3ddf80bbd17497cf01545de5986425298eaa4a37198ff500000000000000000000000000000000000000000000000000000000620fcb07c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000024000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090000000000000000000000002a9ea5e8cddf40730f4f4f839f673a51600c314e00000000000000000000000000000000000000000000000000000000620bd7b30000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0x856653544689c1b32470f4f48491521045a180f2c3dedb4114be7a99bf5e864814e901c4098fc5e7713fdf4569abbb3d3f4852b4bb498bf7eaefcbb5d0edb5521c”,“invariantData”:{“user”:“0x26f3b313f7ed3feb71c2af5d8468cd536e32a4df”,“callTo”:“0x0000000000000000000000000000000000000000”,“router”:“0x1370c680f2a2ae22f711b30b917a57f052816485”,“initiator”:“0x26f3b313f7ed3feb71c2af5d8468cd536e32a4df”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x439e183c799b69f43b3ddf80bbd17497cf01545de5986425298eaa4a37198ff5”,“sendingAssetId”:“0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664”,“sendingChainId”:“43114”,“receivingAddress”:“0x26f3b313f7ed3feb71c2af5d8468cd536e32a4df”,“receivingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“receivingChainId”:“56”,“sendingChainFallback”:“0x26f3b313f7ed3feb71c2af5d8468cd536e32a4df”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”},“encryptedCallData”:“0x”}0x26f3b313f7ed3feb71c2af5d8468cd536e32a4dffalse0x26f3b313f7ed3feb71c2af5d8468cd536e32a4df0x1370c680f2a2ae22f711b30b917a57f052816485{“user”:“0x26f3b313f7ed3feb71c2af5d8468cd536e32a4df”,“amount”:“52753294”,“callTo”:“0x0000000000000000000000000000000000000000”,“expiry”:“1645202183”,“router”:“0x1370c680f2a2ae22f711b30b917a57f052816485”,“initiator”:“0x26f3b313f7ed3feb71c2af5d8468cd536e32a4df”,“callDataHash”:“0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470”,“transactionId”:“0x439e183c799b69f43b3ddf80bbd17497cf01545de5986425298eaa4a37198ff5”,“sendingAssetId”:“0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664”,“sendingChainId”:“43114”,“receivingAddress”:“0x26f3b313f7ed3feb71c2af5d8468cd536e32a4df”,“receivingAssetId”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“receivingChainId”:“56”,“preparedBlockNumber”:“10960432”,“sendingChainFallback”:“0x26f3b313f7ed3feb71c2af5d8468cd536e32a4df”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”}29109604322022-02-15T16:37:04.000Z0x439e183c799b69f43b3ddf80bbd17497cf01545de5986425298eaa4a37198ff50xccb4002bc786db352321a0c027cb345a4526e8a43081750e5543f21505f3ee8e
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v1_avalanche.TransactionManager_TransactionPrepared_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100