Skip to main content

​
Tables

​
ConnextDiamond_TokenSwap_event

Token swap events emitted by Connext Diamond contracts containing buyer address, pool identifier, token indices, and swap amounts. Used for tracking cross-chain liquidity pool activity and analyzing token exchange flows within the Connext protocol.
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_keySTRINGUnique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
in_buyerSTRINGAddress of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokensSoldSTRINGQuantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
in_tokensBoughtSTRINGQuantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
in_soldIdSTRINGIndex identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
in_boughtIdSTRINGIndex identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.
in_keyaddressremovedin_buyerin_soldIdlog_indexin_boughtIdblock_numberin_tokensSoldblock_timestampin_tokensBoughttransaction_hash
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0x8f7492de823025b4cfaab1d34c58963f2af5dedafalse0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae165011198964720000000000000002023-11-10T01:01:11.000Z20003587816979830xa1d21bff3a2fae473a665551fd11b6da35badc7a4b64d8b3d2267c6dd23583d2
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0x8f7492de823025b4cfaab1d34c58963f2af5dedafalse0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae11401120257334746292840437882023-11-10T21:04:03.000Z4744590779568790x687a52dc8a33374a7857cb15a5311be9ba5ceb86e1c231a853c23d3b5eb4cb5a
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0x8f7492de823025b4cfaab1d34c58963f2af5dedafalse0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae1290112023327123906250000000002023-11-10T19:43:51.000Z123861670101051000x01a44bb402ca0e521cf14ed3d2d82f692b16af278e7827b180d4eff3de95bf2c
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_optimism.ConnextDiamond_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
ConnextDiamond_XCalled_event

Cross-chain transfer initiation events emitted by Connext Diamond contracts when an xcall operation is executed. Records complete transfer context including origin/destination domains, asset addresses, amounts, message hashes, and execution parameters for tracking bridge operations across supported 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_transferIdSTRINGUnique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
in_nonceSTRINGUnique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
in_messageHashSTRINGHash of the cross-chain message data being transmitted. 66-character hex string including 0x prefix.
in_paramsSTRUCT<originDomain STRING, destinationDomain STRING, canonicalDomain STRING, to STRING, delegate STRING, receiveLocal BOOL, callData STRING, slippage STRING, originSender STRING, bridgedAmt STRING, normalizedIn STRING, nonce STRING, canonicalId STRING>Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_localSTRINGContract address of the local representation of the bridged asset on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
in_messageBodySTRINGEncoded cross-chain message payload containing routing and transaction data. Hex-encoded string starting with 0x prefix.
addressremovedin_assetin_localin_noncein_amountin_paramslog_indexblock_numberin_transferIdin_messageBodyin_messageHashblock_timestamptransaction_hash
0x8f7492de823025b4cfaab1d34c58963f2af5dedafalse0x7f5c764cbc14f9669b88837ca1490cca17c316070x67e51f46e8e14d4e4cab9df48c59ad8f512486dd541427991319{“to”:“0x4a251e6a21d8233f1c6ba58fc44611bbd213e2ac”,“nonce”:“5414”,“callData”:“0x”,“delegate”:“0x4a251e6a21d8233f1c6ba58fc44611bbd213e2ac”,“slippage”:“300”,“bridgedAmt”:“27972559”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“27991319000000000000”,“originDomain”:“1869640809”,“originSender”:“0x4a251e6a21d8233f1c6ba58fc44611bbd213e2ac”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“1634886255”}8804876470xd9bb6ebfa0eb9eba81296b70075995bfbdea357ce8f92d726b964589cde6a1710x6f7074690000000000000000000000008f7492de823025b4cfaab1d34c58963f2af5deda00000ee36172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c800657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48030000000000000000000000000000000000000000000000000000000001aad3cfd9bb6ebfa0eb9eba81296b70075995bfbdea357ce8f92d726b964589cde6a1710xab1d28d7d85098a85d7db704182d7e73a7cf1f453a370f499a8da65521d08bb72023-03-13T07:56:05.000Z0xaeb74ce364efd9180335262618740577f35d42b7f0992f7c19922ef5212e44c7
0x8f7492de823025b4cfaab1d34c58963f2af5dedafalse0x7f5c764cbc14f9669b88837ca1490cca17c316070x67e51f46e8e14d4e4cab9df48c59ad8f512486dd540643629259{“to”:“0xb84cb282c3c91d70125d1a6f023d7ad4a91380d1”,“nonce”:“5406”,“callData”:“0x”,“delegate”:“0xb84cb282c3c91d70125d1a6f023d7ad4a91380d1”,“slippage”:“300”,“bridgedAmt”:“43605006”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“43629259000000000000”,“originDomain”:“1869640809”,“originSender”:“0xb84cb282c3c91d70125d1a6f023d7ad4a91380d1”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“1634886255”}8804466890x51d7b62fe9318d16233afb976b4744afd83396bf4767c91ad7550e193415ce0d0x6f7074690000000000000000000000008f7492de823025b4cfaab1d34c58963f2af5deda00000ede6172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c800657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48030000000000000000000000000000000000000000000000000000000002995c0e51d7b62fe9318d16233afb976b4744afd83396bf4767c91ad7550e193415ce0d0xfe9593d6b4f14f39110615e1e050ed7e664540bcc9f03339ce827e31858422242023-03-13T04:01:00.000Z0xba5ba794b6f50c9eb57b7e1609a5f34d88e87007a5dca15a46682edaac5a0799
0x8f7492de823025b4cfaab1d34c58963f2af5dedafalse0x7f5c764cbc14f9669b88837ca1490cca17c316070x67e51f46e8e14d4e4cab9df48c59ad8f512486dd541953720663{“to”:“0xc20a75670e372e105eacdfd9289a62c4d70ca906”,“nonce”:“5419”,“callData”:“0x”,“delegate”:“0xc20a75670e372e105eacdfd9289a62c4d70ca906”,“slippage”:“300”,“bridgedAmt”:“53679718”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“53720663000000000000”,“originDomain”:“1869640809”,“originSender”:“0xc20a75670e372e105eacdfd9289a62c4d70ca906”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“1634886255”}8805043340x05d214be3ace3fbc3c65afedbe374550301043724ae45008b798fb8201c8197a0x6f7074690000000000000000000000008f7492de823025b4cfaab1d34c58963f2af5deda00000ee66172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c800657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4803000000000000000000000000000000000000000000000000000000000333166605d214be3ace3fbc3c65afedbe374550301043724ae45008b798fb8201c8197a0x83cd7017d3176dc219d9a847716c607ea785c85a34d1e29dbb602b5d94a037562023-03-13T09:29:05.000Z0xa18e6ee4717ca8821bf5e55e61c10ac4a678950d56ac5ef6cfa16933c3eb66c4
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_optimism.ConnextDiamond_XCalled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
ConnextDiamondSwapAdminFacet_SwapInitialized_event

StableSwap liquidity pool initialization events from Connext’s diamond proxy swap admin facet. Contains pool configuration parameters including amplification coefficients, fee structures, LP token addresses, and initial token balances for cross-chain AMM pools.
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_keySTRINGUnique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
in_swapSTRUCT<key STRING, initialA STRING, futureA STRING, initialATime STRING, futureATime STRING, swapFee STRING, adminFee STRING, lpToken STRING, pooledTokens ARRAY<STRING>, tokenPrecisionMultipliers ARRAY<STRING>, balances ARRAY<STRING>, adminFees ARRAY<STRING>, disabled BOOL, removeTime STRING>Comprehensive configuration data for a StableSwap automated market maker pool, including amplification parameters, fee structure, liquidity provider token address, constituent token addresses with precision multipliers, current token balances, accumulated admin fees, pool status, and timing metadata for parameter changes.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_keyaddressin_swapremovedin_callerlog_indexblock_numberblock_timestamptransaction_hash
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0x8f7492de823025b4cfaab1d34c58963f2af5deda{“key”:“0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a”,“futureA”:“20000”,“lpToken”:“0x0eb37a910cb5ac05ed85c3be5c2af5daf13311b9”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0xbad5b3c68f855eaece68203312fd88ad3d365e50”,“0x4200000000000000000000000000000000000006”],“tokenPrecisionMultipliers”:[“1”,“1”]}false0xade09131c6f43fe22c2cbabb759636c43cfc181e2531620062022-12-21T21:36:22.000Z0xd7b007208331e266b9e5b25cbc935006c2f00aa29eb4d39e249f258a7b2d8df1
0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c0x8f7492de823025b4cfaab1d34c58963f2af5deda{“key”:“0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c”,“futureA”:“20000”,“lpToken”:“0xb12a1be740b99d845af98098965af761be6bd7fe”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0x67e51f46e8e14d4e4cab9df48c59ad8f512486dd”,“0x7f5c764cbc14f9669b88837ca1490cca17c31607”],“tokenPrecisionMultipliers”:[“1000000000000”,“1000000000000”]}false0xade09131c6f43fe22c2cbabb759636c43cfc181e2531536372022-12-21T20:59:20.000Z0x9c598713961f8c9308b87c8c848b0e18fc82726243003b310482355b22371216
0x9e79219debefdf827d33c85c1bc250b0ba1f2821d37ccae57e96a42c70a442ec0x8f7492de823025b4cfaab1d34c58963f2af5deda{“key”:“0x9e79219debefdf827d33c85c1bc250b0ba1f2821d37ccae57e96a42c70a442ec”,“futureA”:“20000”,“lpToken”:“0x2c7fa89cc5ea38d4e5193512b9c10808348ba74f”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0x4cbb28fa12264cd8e87c62f4e1d9f5955ce67d20”,“0x94b008aa00579c1307b0ef2c499ad98a8ce58e58”],“tokenPrecisionMultipliers”:[“1000000000000”,“1000000000000”]}false0x6eced04ddc5a7709d5877c963ced0288fb1c73489922752172023-04-19T15:18:21.000Z0xaeaef9c72e91e771a723d996bcbd6fee51646b4f56197600de7ba54cf4866a13
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_optimism.ConnextDiamondSwapAdminFacet_SwapInitialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100