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
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0xee9dec2712cce65174b561151701bf54b99c24c8false0xf9d64d54d32ee2bdceaabfa60c4c438e224427d000121199290738034068269318012024-05-16T22:40:09.000Z37999568545045770x37d1b67e72e971d8b60fd09b0690f7e5c1e84d9f9e5d3d3520e904435a70e6b8
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0xee9dec2712cce65174b561151701bf54b99c24c8false0xf9d64d54d32ee2bdceaabfa60c4c438e224427d000121179928565332524196023442024-05-16T08:52:40.000Z65267798830461620x3a34080f3795b5be52650cd0ee70d9ec2c6282bf93b3232e0fc3402495c00c83
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0xee9dec2712cce65174b561151701bf54b99c24c8false0xf9d64d54d32ee2bdceaabfa60c4c438e224427d00012119413807706536271454932024-05-16T19:02:31.000Z7699756837974650x4ccaa59b98fd3ec7868fc865c10eb011610dc87ac6544eb0a06a252e9f2671c7
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_arbitrum.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
0xee9dec2712cce65174b561151701bf54b99c24c8false0x17573150d67d820542efb24210371545a4868b030x17573150d67d820542efb24210371545a4868b032241862487425103945687721{“to”:“0x3b15cec2d922ab0ef74688bcc1056461049f89cb”,“nonce”:“224186”,“callData”:“0x”,“delegate”:“0x3b15cec2d922ab0ef74688bcc1056461049f89cb”,“slippage”:“300”,“bridgedAmt”:“2487425103945687721”,“canonicalId”:“0x000000000000000000000000ab2e847b6ba3f772d385038e5b4ff131c161ab4b”,“normalizedIn”:“2487425103945687721”,“originDomain”:“1634886255”,“originSender”:“0x3b15cec2d922ab0ef74688bcc1056461049f89cb”,“receiveLocal”:false,“canonicalDomain”:“11111”,“destinationDomain”:“1835365481”}122622453570x9193a7f97ee8155794895b16f2a5075087846b8ba90d89722f643fbae2c27df10x6172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c800000e656d6574690000000000000000000000006b142227a277ce62808e0df93202483547ec018800002b67000000000000000000000000ab2e847b6ba3f772d385038e5b4ff131c161ab4b0300000000000000000000000000000000000000000000000022851bf3fe1262a99193a7f97ee8155794895b16f2a5075087846b8ba90d89722f643fbae2c27df10x4943e17840903699721e79879353e035af2e5d0f1bba894043e6b8fd50836b0a2024-10-10T05:15:04.000Z0xc87424cacf482fde02cdc5939d9c60ed0060f0ba55c9206dc1807ea4e40a917d
0xee9dec2712cce65174b561151701bf54b99c24c8false0x27b58d226fe8f792730a795764945cf146815aa70x27b58d226fe8f792730a795764945cf146815aa722419512050000000000000000{“to”:“0xf9867278e13c908c08e2df54966540229fa5ffd8”,“nonce”:“224195”,“callData”:“0x”,“delegate”:“0xf9867278e13c908c08e2df54966540229fa5ffd8”,“slippage”:“300”,“bridgedAmt”:“12050000000000000000”,“canonicalId”:“0x000000000000000000000000bd18f9be5675a9658335e6b7e79d9d9b394ac043”,“normalizedIn”:“12050000000000000000”,“originDomain”:“1634886255”,“originSender”:“0xf9867278e13c908c08e2df54966540229fa5ffd8”,“receiveLocal”:false,“canonicalDomain”:“11111”,“destinationDomain”:“1869640809”}82624843550xab776c8ece8533ee9800aa356dcfaf29d0cc4dd6c96815a8982d96c017b4fa8c0x6172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c8000058bb6f7074690000000000000000000000008f7492de823025b4cfaab1d34c58963f2af5deda00002b67000000000000000000000000bd18f9be5675a9658335e6b7e79d9d9b394ac04303000000000000000000000000000000000000000000000000a73a332807750000ab776c8ece8533ee9800aa356dcfaf29d0cc4dd6c96815a8982d96c017b4fa8c0x0b6589bcf172fd06dcded47b5c2cd4943f6e4f27069469c3e7627b22ed6506f32024-10-10T21:56:29.000Z0xdd40df6d0aece462ffca7f81e4ff55760fdb661b63233118481dfde9fd00928c
0xee9dec2712cce65174b561151701bf54b99c24c8false0x27b58d226fe8f792730a795764945cf146815aa70x27b58d226fe8f792730a795764945cf146815aa7224185130500000000000000000{“to”:“0xcfe063a764ea04a9a1dc6cf8b8978955f779fc9f”,“nonce”:“224185”,“callData”:“0x000000000000000000000000f9867278e13c908c08e2df54966540229fa5ffd8”,“delegate”:“0xf9867278e13c908c08e2df54966540229fa5ffd8”,“slippage”:“300”,“bridgedAmt”:“130500000000000000000”,“canonicalId”:“0x000000000000000000000000bd18f9be5675a9658335e6b7e79d9d9b394ac043”,“normalizedIn”:“130500000000000000000”,“originDomain”:“1634886255”,“originSender”:“0xf9867278e13c908c08e2df54966540229fa5ffd8”,“receiveLocal”:false,“canonicalDomain”:“11111”,“destinationDomain”:“6648936”}242621930770x50892b351506f3df776acf12e94d6f0a7169ac7bb10d97a018482fb9d1500c130x6172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c8000012c7006574680000000000000000000000008898b472c54c31894e3b9bb83cea802a5d0e63c600002b67000000000000000000000000bd18f9be5675a9658335e6b7e79d9d9b394ac04303000000000000000000000000000000000000000000000007130d2294d47a000050892b351506f3df776acf12e94d6f0a7169ac7bb10d97a018482fb9d1500c130xa80bfc0e4117c0139e7c69270aa3bc6678459b11f1b51337e02b9684fd977c5a2024-10-10T01:36:25.000Z0x55cd4957f92ff0aa449eba4bb52c61033e35de03e17d94ef370ddf5c0139b7e1
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_arbitrum.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
0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c0xee9dec2712cce65174b561151701bf54b99c24c8{“key”:“0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c”,“futureA”:“20000”,“lpToken”:“0xda492c29d88ffe9b7cbfa6dc068c2f9befae851b”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0x8c556cf37faa0eedac7ae665f1bb0fbd4b2eae36”,“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”],“tokenPrecisionMultipliers”:[“1000000000000”,“1000000000000”]}false0xade09131c6f43fe22c2cbabb759636c43cfc181e2478968422022-12-21T21:00:53.000Z0xedadcb6837e798dde4d7143bb6353b28aecc92688a4fc52129928df9e05dbbc1
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0xee9dec2712cce65174b561151701bf54b99c24c8{“key”:“0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a”,“futureA”:“20000”,“lpToken”:“0x9890b51b117f765e9148a12902b0945fa6d285e5”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0x2983bf5c334743aa6657ad70a55041d720d225db”,“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”],“tokenPrecisionMultipliers”:[“1”,“1”]}false0xade09131c6f43fe22c2cbabb759636c43cfc181e2478979892022-12-21T21:09:59.000Z0xddbc54bf5b9a8927e2f4460e61cb6a1156a83c3bcf1758c5edb38f9d06c10cdf
0x9e79219debefdf827d33c85c1bc250b0ba1f2821d37ccae57e96a42c70a442ec0xee9dec2712cce65174b561151701bf54b99c24c8{“key”:“0x9e79219debefdf827d33c85c1bc250b0ba1f2821d37ccae57e96a42c70a442ec”,“futureA”:“20000”,“lpToken”:“0x45d0736d77a72ae2bd3c5770878bd85b72895057”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0x2fd7e61033b3904c65aa9a9b83dcd344fa19ffd2”,“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”],“tokenPrecisionMultipliers”:[“1000000000000”,“1000000000000”]}false0x5c711db90dec0a5b81c626968dea4187a7f9c1f210821285952023-04-19T15:17:57.000Z0xf2f6d105b98d85d5c9cef06f6fd6bfe1b3f82afb8eb7903cf24b6341927d7cef
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_arbitrum.ConnextDiamondSwapAdminFacet_SwapInitialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100