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
0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c0xcd401c10afa37d641d2f594852da94c700e4f2cefalse0xabcc9b596420a9e9172fd5938620e265a0f9df92040126854496998782023-03-28T10:41:28.000Z999468784380131260x2b3dbcb351b09d4df70c56f4657f5213ed47bccf1657d6e7955805f260b07c63
0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c0xcd401c10afa37d641d2f594852da94c700e4f2cefalse0xabcc9b596420a9e9172fd5938620e265a0f9df92061126854651998782023-03-28T10:49:13.000Z999466552097612950x4edf689047bd649db6b7d03a8e58d70ecf8147554680960078621f264be294ec
0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c0xcd401c10afa37d641d2f594852da94c700e4f2cefalse0xabcc9b596420a9e9172fd5938620e265a0f9df920161268641417327102023-03-28T18:48:42.000Z7331644656220668850x64767b9f3bd23481fda26b6728a74bfffcb3d5488e91e92890b48eefa1d31fa0
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_bsc.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
0xcd401c10afa37d641d2f594852da94c700e4f2cefalse0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d0x5e7d83da751f4c9694b13af351b30ac108f32c381373850326816118876330108{“to”:“0x1390136b4d5a431d1c6499644cf18037df2f5148”,“nonce”:“13738”,“callData”:“0x”,“delegate”:“0x1390136b4d5a431d1c6499644cf18037df2f5148”,“slippage”:“10”,“bridgedAmt”:“50341698”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“50326816118876330108”,“originDomain”:“6450786”,“originSender”:“0x1390136b4d5a431d1c6499644cf18037df2f5148”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“1634886255”}270284504430x3056d166ba1c403df47e2b32247ea89f3cec1b9132e16265985bd1de067678140x00626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce000013d76172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c800657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480300000000000000000000000000000000000000000000000000000000030027423056d166ba1c403df47e2b32247ea89f3cec1b9132e16265985bd1de067678140xc7b7f798939fa44344f9c3d8d9ecc92d0380f80f5fb7d9a57f245280c9cfe3542023-05-23T02:55:47.000Z0x07490c61c4538becfe6cdd65fcc94e073757205c036395e0a87edf8754bf4239
0xcd401c10afa37d641d2f594852da94c700e4f2cefalse0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d0x5e7d83da751f4c9694b13af351b30ac108f32c38138401000000000000000000000{“to”:“0xe22f1ed1b51e83a27f5736c9b84c9e66a26a4f71”,“nonce”:“13840”,“callData”:“0x”,“delegate”:“0xe22f1ed1b51e83a27f5736c9b84c9e66a26a4f71”,“slippage”:“30”,“bridgedAmt”:“1003615716”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“1000000000000000000000”,“originDomain”:“6450786”,“originSender”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“1634886255”}383284575510x4ba55eee2021e5438b9b160878302a929757c140fbe1516265ce7a1ed4db693f0x00626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce0000140c6172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c800657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4803000000000000000000000000000000000000000000000000000000003bd1f5e44ba55eee2021e5438b9b160878302a929757c140fbe1516265ce7a1ed4db693f0xe02a6f8f748d66a91512e83aeb066dad793ddb5b2e492e70b652fa692daa10ba2023-05-23T08:51:27.000Z0xe53d52dbb2aeb128593fe8ea7689057d097f5ba2737d9030d9d3c8112223e085
0xcd401c10afa37d641d2f594852da94c700e4f2cefalse0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d0x5e7d83da751f4c9694b13af351b30ac108f32c38141773128247124815634647{“to”:“0x74674dafd6f4495e7f63f7637e94b8b89b2f01db”,“nonce”:“14177”,“callData”:“0x000000000000000000000000000000000000000000000000000000000000004000000000000000000000000071376648d1d211b9b296da017bc80fae59746e6a000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000001111111254eeb25477b68fb85ed929f73a9605820000000000000000000000001111111254eeb25477b68fb85ed929f73a960582000000000000000000000000ff970a61a04b1ca14834a43f5de4533ebddb5cc8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002f32cb00000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000a8e449022e00000000000000000000000000000000000000000000000000000000002f32cb0000000000000000000000000000000000000000000000000005eb1a4c144caa00000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000e754841b77c874135caca3386676e886459c2d612e9b3012000000000000000000000000000000000000000000000000”,“delegate”:“0x71376648d1d211b9b296da017bc80fae59746e6a”,“slippage”:“50”,“bridgedAmt”:“3131134”,“canonicalId”:“0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“normalizedIn”:“3128247124815634647”,“originDomain”:“6450786”,“originSender”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“1634886255”}137284701200xb4e966c4a256b185068c0df69c646172ac2fa5a8c64be59b517e014a2cdaf5a10x00626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce000014af6172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c800657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480300000000000000000000000000000000000000000000000000000000002fc6feb4e966c4a256b185068c0df69c646172ac2fa5a8c64be59b517e014a2cdaf5a10xef00388b111ac333f268a3ce3a0052776901087b013d5e9b0cb809579a9a907d2023-05-23T19:20:48.000Z0x446464c9f6af0dce7b62680cdd2578f315b199f7651d90ecb0a4eeb52d7c2d47
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_bsc.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
0xf1390056090f8ba7224c337f06ce86311484b83889eb116efe982fe5945779fd0xcd401c10afa37d641d2f594852da94c700e4f2ce{“key”:“0xf1390056090f8ba7224c337f06ce86311484b83889eb116efe982fe5945779fd”,“futureA”:“20000”,“lpToken”:“0xf9d88d200f3d9b45bd9f8f3ae124f59a4fbdbae5”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0x86a343bcf17d79c475d300eed35f0145f137d0c9”,“0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3”],“tokenPrecisionMultipliers”:[“1”,“1”]}false0x9435ba7c661a0fd477deed640491de8c100325a7200274876492023-04-19T15:15:59.000Z0x08f37f38355a36257e36e1ff1f5ff319006f93cac50edd94466df23fe27b16be
0x9e79219debefdf827d33c85c1bc250b0ba1f2821d37ccae57e96a42c70a442ec0xcd401c10afa37d641d2f594852da94c700e4f2ce{“key”:“0x9e79219debefdf827d33c85c1bc250b0ba1f2821d37ccae57e96a42c70a442ec”,“futureA”:“20000”,“lpToken”:“0x9350470389848979fcdfed28352ff9e0c9aa87e9”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0xd609f26b5547d5e31562b29150769cb7c774b97a”,“0x55d398326f99059ff775485246999027b3197955”],“tokenPrecisionMultipliers”:[“1000000000000”,“1”]}false0x9435ba7c661a0fd477deed640491de8c100325a7189274876492023-04-19T15:15:59.000Z0x08f37f38355a36257e36e1ff1f5ff319006f93cac50edd94466df23fe27b16be
0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c0xcd401c10afa37d641d2f594852da94c700e4f2ce{“key”:“0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c”,“futureA”:“20000”,“lpToken”:“0xc170908481e928dfa39de3d0d31bea6292692f8e”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0x5e7d83da751f4c9694b13af351b30ac108f32c38”,“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”],“tokenPrecisionMultipliers”:[“1000000000000”,“1”]}false0xade09131c6f43fe22c2cbabb759636c43cfc181e140241059782022-12-21T21:01:21.000Z0x2036758b14c46354c352b5308027065f14ca82024b2266b6ee583bed6a326e78
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_bsc.ConnextDiamondSwapAdminFacet_SwapInitialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100