connext_v2_bsc

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

in_key	address	removed	in_buyer	log_index	in_boughtId	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c	0xcd401c10afa37d641d2f594852da94c700e4f2ce	false	0xabcc9b596420a9e9172fd5938620e265a0f9df92	40	1	26854496	99878	2023-03-28T10:41:28.000Z	99946878438013126	0x2b3dbcb351b09d4df70c56f4657f5213ed47bccf1657d6e7955805f260b07c63
0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c	0xcd401c10afa37d641d2f594852da94c700e4f2ce	false	0xabcc9b596420a9e9172fd5938620e265a0f9df92	61	1	26854651	99878	2023-03-28T10:49:13.000Z	99946655209761295	0x4edf689047bd649db6b7d03a8e58d70ecf8147554680960078621f264be294ec
0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c	0xcd401c10afa37d641d2f594852da94c700e4f2ce	false	0xabcc9b596420a9e9172fd5938620e265a0f9df92	16	1	26864141	732710	2023-03-28T18:48:42.000Z	733164465622066885	0x64767b9f3bd23481fda26b6728a74bfffcb3d5488e91e92890b48eefa1d31fa0

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_messageHash`	`STRING`	Hash of the cross-chain message data being transmitted. 66-character hex string including 0x prefix.
`in_params`	`STRUCT<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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_local`	`STRING`	Contract address of the local representation of the bridged asset on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_messageBody`	`STRING`	Encoded cross-chain message payload containing routing and transaction data. Hex-encoded string starting with 0x prefix.

Sample Data

address	removed	in_asset	in_local	in_nonce	in_amount	in_params	log_index	block_number	in_transferId	in_messageBody	in_messageHash	block_timestamp	transaction_hash
0xcd401c10afa37d641d2f594852da94c700e4f2ce	false	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	0x5e7d83da751f4c9694b13af351b30ac108f32c38	13738	50326816118876330108	{“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”}	270	28450443	0x3056d166ba1c403df47e2b32247ea89f3cec1b9132e16265985bd1de06767814	0x00626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce000013d76172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c800657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480300000000000000000000000000000000000000000000000000000000030027423056d166ba1c403df47e2b32247ea89f3cec1b9132e16265985bd1de06767814	0xc7b7f798939fa44344f9c3d8d9ecc92d0380f80f5fb7d9a57f245280c9cfe354	2023-05-23T02:55:47.000Z	0x07490c61c4538becfe6cdd65fcc94e073757205c036395e0a87edf8754bf4239
0xcd401c10afa37d641d2f594852da94c700e4f2ce	false	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	0x5e7d83da751f4c9694b13af351b30ac108f32c38	13840	1000000000000000000000	{“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”}	383	28457551	0x4ba55eee2021e5438b9b160878302a929757c140fbe1516265ce7a1ed4db693f	0x00626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce0000140c6172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c800657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4803000000000000000000000000000000000000000000000000000000003bd1f5e44ba55eee2021e5438b9b160878302a929757c140fbe1516265ce7a1ed4db693f	0xe02a6f8f748d66a91512e83aeb066dad793ddb5b2e492e70b652fa692daa10ba	2023-05-23T08:51:27.000Z	0xe53d52dbb2aeb128593fe8ea7689057d097f5ba2737d9030d9d3c8112223e085
0xcd401c10afa37d641d2f594852da94c700e4f2ce	false	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	0x5e7d83da751f4c9694b13af351b30ac108f32c38	14177	3128247124815634647	{“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”}	137	28470120	0xb4e966c4a256b185068c0df69c646172ac2fa5a8c64be59b517e014a2cdaf5a1	0x00626e62000000000000000000000000cd401c10afa37d641d2f594852da94c700e4f2ce000014af6172626f000000000000000000000000ee9dec2712cce65174b561151701bf54b99c24c800657468000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480300000000000000000000000000000000000000000000000000000000002fc6feb4e966c4a256b185068c0df69c646172ac2fa5a8c64be59b517e014a2cdaf5a1	0xef00388b111ac333f268a3ce3a0052776901087b013d5e9b0cb809579a9a907d	2023-05-23T19:20:48.000Z	0x446464c9f6af0dce7b62680cdd2578f315b199f7651d90ecb0a4eeb52d7c2d47

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_swap`	`STRUCT<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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_key	address	in_swap	removed	in_caller	log_index	block_number	block_timestamp	transaction_hash
0xf1390056090f8ba7224c337f06ce86311484b83889eb116efe982fe5945779fd	0xcd401c10afa37d641d2f594852da94c700e4f2ce	{“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”]}	false	0x9435ba7c661a0fd477deed640491de8c100325a7	200	27487649	2023-04-19T15:15:59.000Z	0x08f37f38355a36257e36e1ff1f5ff319006f93cac50edd94466df23fe27b16be
0x9e79219debefdf827d33c85c1bc250b0ba1f2821d37ccae57e96a42c70a442ec	0xcd401c10afa37d641d2f594852da94c700e4f2ce	{“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”]}	false	0x9435ba7c661a0fd477deed640491de8c100325a7	189	27487649	2023-04-19T15:15:59.000Z	0x08f37f38355a36257e36e1ff1f5ff319006f93cac50edd94466df23fe27b16be
0x6d9af4a33ed4034765652ab0f44205952bc6d92198d3ef78fe3fb2b078d0941c	0xcd401c10afa37d641d2f594852da94c700e4f2ce	{“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”]}	false	0xade09131c6f43fe22c2cbabb759636c43cfc181e	140	24105978	2022-12-21T21:01:21.000Z	0x2036758b14c46354c352b5308027065f14ca82024b2266b6ee583bed6a326e78

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ConnextDiamond_TokenSwap_event

ConnextDiamond_XCalled_event

ConnextDiamondSwapAdminFacet_SwapInitialized_event

​Tables

​ConnextDiamond_TokenSwap_event

​ConnextDiamond_XCalled_event

​ConnextDiamondSwapAdminFacet_SwapInitialized_event

Tables

ConnextDiamond_TokenSwap_event

ConnextDiamond_XCalled_event

ConnextDiamondSwapAdminFacet_SwapInitialized_event