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
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0x5bb83e95f63217cda6ae3d181ba580ef377d2109false0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae190269410906786933359581090532023-03-14T15:54:35.000Z6777640380064911490xb26618732857dde5d2f8cb69909f67726b606181a61568d4fc6b8a749d8a791d
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0x5bb83e95f63217cda6ae3d181ba580ef377d2109false0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae1160269351634755626723331950722023-03-14T07:15:25.000Z4748951433458120610x03b6070ff0f398e466bbdab2357c1b778de75768c11fb68bd2dd300d52fd1328
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0x5bb83e95f63217cda6ae3d181ba580ef377d2109false0x7a7029bc89182f61a15de8ee7ecbf14368b7691618026937384500000000000000002023-03-14T10:29:25.000Z499300300776735350xbe4fdd9d51e1d661520413ad642a1506ce088a1ae462a1317aebf56634ff268b
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_gnosis.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
0x5bb83e95f63217cda6ae3d181ba580ef377d2109false0xe91d153e0b41518a2ce8dd3d7944fa863463a97d0x0e1d5bcd2ac5cf2f71841a9667afc1e995caaf4f192263363081901359444000{“to”:“0x69fe2954765041bd6529f79d7198e9b6ed6aec12”,“nonce”:“19226”,“callData”:“0x”,“delegate”:“0x69fe2954765041bd6529f79d7198e9b6ed6aec12”,“slippage”:“300”,“bridgedAmt”:“3361962616802826272”,“canonicalId”:“0x0000000000000000000000006b175474e89094c44da98b954eedeac495271d0f”,“normalizedIn”:“3363081901359444000”,“originDomain”:“6778479”,“originSender”:“0x8bdbbfc9518970bc3df3ee83ff691b8320ddb1d0”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“6450786”}13298347600x9001f3f77202769a85d5b0b4934035cbbeb14abbbff2f837f372345617aa2d760x00676e6f0000000000000000000000005bb83e95f63217cda6ae3d181ba580ef377d210900000cad00626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce006574680000000000000000000000006b175474e89094c44da98b954eedeac495271d0f030000000000000000000000000000000000000000000000002ea8173002acd8209001f3f77202769a85d5b0b4934035cbbeb14abbbff2f837f372345617aa2d760xcd88d266c181b7a6519f073f6433024306fbcb94ed4189fdfbf7c998d77f4eee2023-09-06T07:26:45.000Z0x0366506840076d291179f4db1c5a7d5556acb8e2065d099f6135d4ae9efb95b7
0x5bb83e95f63217cda6ae3d181ba580ef377d2109false0xe91d153e0b41518a2ce8dd3d7944fa863463a97d0x0e1d5bcd2ac5cf2f71841a9667afc1e995caaf4f19193439000000000000000000{“to”:“0x50d4461aeede411ea1a11c50e09fdf5e6511e5b3”,“nonce”:“19193”,“callData”:“0x”,“delegate”:“0x50d4461aeede411ea1a11c50e09fdf5e6511e5b3”,“slippage”:“100”,“bridgedAmt”:“438856629870879565164”,“canonicalId”:“0x0000000000000000000000006b175474e89094c44da98b954eedeac495271d0f”,“normalizedIn”:“439000000000000000000”,“originDomain”:“6778479”,“originSender”:“0x8bdbbfc9518970bc3df3ee83ff691b8320ddb1d0”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“6450786”}16298304480x424a59cca3e4585eac00182c14648a499e7e71b1cc3ea9a093b2399ecae74f060x00676e6f0000000000000000000000005bb83e95f63217cda6ae3d181ba580ef377d210900000ca800626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce006574680000000000000000000000006b175474e89094c44da98b954eedeac495271d0f03000000000000000000000000000000000000000000000017ca5bf3b49adbe56c424a59cca3e4585eac00182c14648a499e7e71b1cc3ea9a093b2399ecae74f060x0f61336bb3ca4829600039a1dc6e5aad3f25ea8fcc50220a9d5a2b66ff50c2d02023-09-06T01:13:20.000Z0xf8d786c66b4d7e24b5a1d69745766b07e216a701922a93cb396bb5d3f0e76f95
0x5bb83e95f63217cda6ae3d181ba580ef377d2109false0xe91d153e0b41518a2ce8dd3d7944fa863463a97d0x0e1d5bcd2ac5cf2f71841a9667afc1e995caaf4f192572107000000000000000000{“to”:“0xa83935efd1d09dbd0e09021036b6b79b211baf65”,“nonce”:“19257”,“callData”:“0x”,“delegate”:“0xa83935efd1d09dbd0e09021036b6b79b211baf65”,“slippage”:“300”,“bridgedAmt”:“2106271283598694089821”,“canonicalId”:“0x0000000000000000000000006b175474e89094c44da98b954eedeac495271d0f”,“normalizedIn”:“2107000000000000000000”,“originDomain”:“6778479”,“originSender”:“0x8bdbbfc9518970bc3df3ee83ff691b8320ddb1d0”,“receiveLocal”:false,“canonicalDomain”:“6648936”,“destinationDomain”:“6450786”}9298396130x8835f904e18394f9a5bd18671c81a77d538c465a697d980bb244b90c0d42841f0x00676e6f0000000000000000000000005bb83e95f63217cda6ae3d181ba580ef377d210900000cb300626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce006574680000000000000000000000006b175474e89094c44da98b954eedeac495271d0f030000000000000000000000000000000000000000000000722e62ccedf235045d8835f904e18394f9a5bd18671c81a77d538c465a697d980bb244b90c0d42841f0xaf72574efb03f84a7000deab0eb8be900a09b6041f3204ea161d511eb1e68d1d2023-09-06T14:28:35.000Z0x0ede2429a5b8a953103c5079940ca5a95b8deb3ae7f39d99597801ad92386e2d
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_gnosis.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
0xf1390056090f8ba7224c337f06ce86311484b83889eb116efe982fe5945779fd0x5bb83e95f63217cda6ae3d181ba580ef377d2109{“key”:“0xf1390056090f8ba7224c337f06ce86311484b83889eb116efe982fe5945779fd”,“futureA”:“20000”,“lpToken”:“0x98f7656a6c09388c646ff423ed82980675a152dd”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0x0e1d5bcd2ac5cf2f71841a9667afc1e995caaf4f”,“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”],“tokenPrecisionMultipliers”:[“1”,“1”]}false0x7616bc6d0dee5e250ba5b3dda6cbbb71786fb63824275283182023-04-19T15:14:20.000Z0x21ba72cf23735b6b19e97e4a60da6cb221f662185d18c3f83cd572817214e3e7
0x9e79219debefdf827d33c85c1bc250b0ba1f2821d37ccae57e96a42c70a442ec0x5bb83e95f63217cda6ae3d181ba580ef377d2109{“key”:“0x9e79219debefdf827d33c85c1bc250b0ba1f2821d37ccae57e96a42c70a442ec”,“futureA”:“20000”,“lpToken”:“0xd8a772fd2b7872230ccd92ef073be81de87137d7”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0xf4d944883d6fddc56d3534986fef82105cadbfa1”,“0x4ecaba5870353805a9f068101a40e0f32ed605c6”],“tokenPrecisionMultipliers”:[“1000000000000”,“1000000000000”]}false0x7616bc6d0dee5e250ba5b3dda6cbbb71786fb63813275283182023-04-19T15:14:20.000Z0x21ba72cf23735b6b19e97e4a60da6cb221f662185d18c3f83cd572817214e3e7
0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a0x5bb83e95f63217cda6ae3d181ba580ef377d2109{“key”:“0x12acadfa38ab02479ae587196a9043ee4d8bf52fcb96b7f8d2ba240f03bcd08a”,“futureA”:“20000”,“lpToken”:“0x7ac5bbefae0459f007891f9bd245f6beaa91076c”,“swapFee”:“4000000”,“adminFee”:“0”,“balances”:[“0”,“0”],“disabled”:false,“initialA”:“20000”,“adminFees”:[“0”,“0”],“removeTime”:“0”,“futureATime”:“0”,“initialATime”:“0”,“pooledTokens”:[“0x538e2ddbfdf476d24ccb1477a518a82c9ea81326”,“0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1”],“tokenPrecisionMultipliers”:[“1”,“1”]}false0xade09131c6f43fe22c2cbabb759636c43cfc181e6260061582023-01-17T07:01:25.000Z0xc8138c18d955bcc4e5d922d00f04afc7541953976b6f5209bd3320dd1770e7cd
Query with partition filter
SELECT *
FROM `tt-contracts.connext_v2_gnosis.ConnextDiamondSwapAdminFacet_SwapInitialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100