biswap_v3_bsc

Tables

BiswapPoolV3_swapX2Y_function

Swap executions from Biswap V3 liquidity pools on BSC (Binance Smart Chain) where tokenX is exchanged for tokenY, recording input amounts, output amounts, price points, recipients, and accumulated fees for analyzing trading patterns and liquidity provision.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. 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_lowPt`	`INT64`	Lowest price point (tick) boundary for the swap execution in the Biswap V3 concentrated liquidity pool. Negative values indicate price ranges below the current spot price, commonly seen in swaps moving from token X to token Y.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`out_amountX`	`STRING`	Amount of token X received by the recipient after executing the swap from X to Y tokens. Represented as a wei-denominated string for precision; null if the transaction failed.
`out_amountY`	`STRING`	Token Y amount received from this swap, denominated in the token’s smallest unit (wei). Null when transaction fails; otherwise represents the output quantity of the second token in the Biswap V3 pool pair.
`out_accFee`	`STRING`	Accumulated protocol fee charged for this swap transaction in token units. Represented as a string to preserve precision for large integers; null when transaction fails.

Sample Data

gas	status	in_data	gas_used	in_lowPt	in_amount	signature	out_accFee	to_address	out_amountX	out_amountY	block_number	from_address	in_recipient	trace_address	block_timestamp	transaction_hash
146151	false		144348			0x857f812f		0x46d71eaa3c7ba030a1573cd6587ef4231df21b7e			48150591	0x90ccc3f8419129cde2b51a3da488369604e09a71		21,0	2025-04-07T13:46:34.000Z	0x88bc4c2d2abe7c3dbd08adb481a62cc65b759b1322c5e7727c792a66b6e1134f
925995	true	0x	108908	42764	975516379210891511	0x857f812f	624330482694972	0xe6b58b6e20099f43aabe13a19908d9046a86689d	975516379210891511	70228549136073360371	48160417	0x1d21550e525e75a546c58fba37518b18d6c209c1	0x1d21550e525e75a546c58fba37518b18d6c209c1	0,0,1,5	2025-04-07T21:57:52.000Z	0x31a2ce634be737559803a3ecadfbd8bd1b49fc480de65043a74e16fec96af6e7
5973963	true	0x	154626	-887271	56327592240692580098	0x857f812f	126173806619151380	0x517c5d56527dabffbe9d1a1e8b98406f349d3470	56327592240692580097	353620658704989841	48141807	0x0c575cba80b5d8e0314cefcd4decdb38b7dcbe3a	0x0c575cba80b5d8e0314cefcd4decdb38b7dcbe3a	3,4,1,15	2025-04-07T06:27:22.000Z	0x5a64ffbf2707330aefc7e90707e07e2f92dd44ecedc105a670c41ae117c4f3d7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.BiswapPoolV3_swapX2Y_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

BiswapPoolV3_swapY2X_function

Token Y to Token X swap executions from Biswap V3 liquidity pools on BSC (BNB Smart Chain). Records swap direction, input/output amounts, price points, fees, and recipients for analyzing concentrated liquidity DEX (decentralized exchange) trading patterns.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. 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_highPt`	`INT64`	Maximum price tick (point) boundary for the swap execution. Controls the slippage protection by setting the highest acceptable price point in the concentrated liquidity range.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`out_amountX`	`STRING`	Token amount X received from the swap, denominated in the pool’s X token’s smallest unit. Always accompanies out_amountY in the Y-to-X swap direction for this Biswap V3 concentrated liquidity pool.
`out_amountY`	`STRING`	Token Y amount received from the swap, denominated in the token’s smallest unit (wei-equivalent). Generally close in value to in_amount, representing the Y-to-X swap output on Biswap V3 pools.
`out_accFee`	`STRING`	Accumulated protocol fees collected from this Y-to-X swap, denominated in the smallest unit of the token. Typically represents a small percentage of the swap volume deducted by the Biswap V3 pool.

Sample Data

gas	status	in_data	gas_used	in_amount	in_highPt	signature	out_accFee	to_address	out_amountX	out_amountY	block_number	from_address	in_recipient	trace_address	block_timestamp	transaction_hash
698873	true	0x	132478	100000000000000000	-7136	0x2c481252	221803239611156	0xae3fb8e3576bb1051b0cf15ebb8420fd79d9e073	202149136229086938	99019303397837144	46772688	0x9c1a49609aec38c0ccd9e07be3ec9e11823bc855	0xb1b8a9ffb31f9475b7f1a0b3d0525348a6e9f184	1	2025-02-18T17:26:11.000Z	0xcad2a37edd1419ed861ba42cd42aae8cd03c62d25d93cbaa71875784ef4773f1
1643999	true	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000400000000000000000000000004c6f446dd88fd1be8b80d2940806002777dc12a2000000000000000000000000000000000000000000000000000000000000002abb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c009655d398326f99059ff775485246999027b319795500000000000000000000000000000000000000000000	157333	7222778055	799999	0x2c481252	866734	0xd3fb273006626b30f51e640f752bcaa16978b0d6	4669398719224	7222778055	46772131	0x90ccc3f8419129cde2b51a3da488369604e09a71	0x4c6f446dd88fd1be8b80d2940806002777dc12a2	1,11,0	2025-02-18T16:58:20.000Z	0x1a7971022bf74203c30094a733811e05509737b123196ed80bac9a50b07aff63
1077304	true	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000400000000000000000000000004c6f446dd88fd1be8b80d2940806002777dc12a2000000000000000000000000000000000000000000000000000000000000002abb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c009655d398326f99059ff775485246999027b319795500000000000000000000000000000000000000000000	133299	4824936725	799999	0x2c481252	578993	0xd3fb273006626b30f51e640f752bcaa16978b0d6	3205070801432	4824936725	46764936	0x90ccc3f8419129cde2b51a3da488369604e09a71	0x4c6f446dd88fd1be8b80d2940806002777dc12a2	1,8,0	2025-02-18T10:58:35.000Z	0x244c0d5f8e3416c45597accdb901cf9679377b15d9447748b5b7a0c65e013417

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.BiswapPoolV3_swapY2X_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Factory_NewPool_event

Pool creation events from Biswap V3 decentralized exchange (DEX) factory contract on BNB Smart Chain. Tracks newly deployed liquidity pools with token pairs, fee tiers, and tick spacing (pointDelta) for analyzing market expansion and pool configuration patterns.

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_tokenX`	`STRING`	Contract address of the first token in a liquidity pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenY`	`STRING`	Contract address of the second token in a liquidity pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_pointDelta`	`STRING`	Tick spacing parameter that defines the granularity of price points in the Biswap V3 liquidity pool. Common values are 50 for concentrated liquidity (low fee) and 200 for standard liquidity pools.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	in_pool	removed	in_tokenX	in_tokenY	log_index	block_number	in_pointDelta	block_timestamp	transaction_hash
10000	0x4d175f2cfe3e2215c1b55865b07787b751cedd36	0xd772e674cf83f2908cf03f72609277f88f20f60c	false	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	0xe7ef88b0ce752e2c754c71d1bbb2fa39a4b3d425	53	32941987	200	2023-10-26T13:41:00.000Z	0x3404cead2415ca0a6ac844706e4b4c9fade42725b0020256a14ca0ca853d1355
10000	0x4d175f2cfe3e2215c1b55865b07787b751cedd36	0xac3422a7b4f3cfd051a4de26fdd4c2f9c189076c	false	0x55d398326f99059ff775485246999027b3197955	0xe7ef88b0ce752e2c754c71d1bbb2fa39a4b3d425	143	32379148	200	2023-10-06T22:58:11.000Z	0xb8874d2b1eccb113cf4b93dc17387a6c250ca20cf94c303a5214f79976857866
2800	0x4d175f2cfe3e2215c1b55865b07787b751cedd36	0x36df8aac648661b0ad064019a913bf0de4662f5b	false	0x55d398326f99059ff775485246999027b3197955	0xa6b0eeb1138f9dbe8e6f1a61e2a84f4c675d6ced	124	32354493	50	2023-10-06T02:21:18.000Z	0x0c7f43b7f5efee13f322342669e4826a1d1735367d1ba3b12903175bd3044669

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.Factory_NewPool_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

limitOrderManager_Claim_event

Limit order claim events from Biswap V3 decentralized exchange on BNS Chain (Binance Smart Chain), tracking when users claim filled or partially filled limit orders with amounts sold and earned. Useful for analyzing limit order execution patterns and liquidity provider behavior at specific price points.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_point`	`INT64`	Price tick point identifier for the limit order in the liquidity pool. Integer value representing a specific price level on the order book.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sold`	`STRING`	Amount of tokens sold in the limit order transaction, represented as a raw integer string. Typically shows ‘0’ when orders are claimed before execution or when no tokens have been sold yet.
`in_earn`	`STRING`	Amount of tokens earned by the user when claiming from this limit order on Biswap V3. Represented as a string-encoded integer value, commonly ‘0’ when orders are claimed without earnings.
`in_sellXEaryY`	`BOOL`	Direction of the limit order indicating whether selling token X early for token Y (true) or selling token Y early for token X (false). Determines which side of the trading pair the user’s order operates on.

Sample Data

address	in_pool	in_user	removed	in_point	log_index	block_number	in_sellXEaryY	block_timestamp	transaction_hash
0xe45d08a10f253c9541c7612a9a70411e4c15dff9	0x47ceffdd864861f8cd85b8d66c5b0c3a9fc2c71e	0x011fa375721780065fd5b78f822acc7c4077b69e	false	42380	24	32321199	false	2023-10-04T22:31:29.000Z	0x7dd3a809e676b221f02fe1a56ad8c7dd29d6cfa521a7699b60e00aebbe24817e
0xe45d08a10f253c9541c7612a9a70411e4c15dff9	0x47ceffdd864861f8cd85b8d66c5b0c3a9fc2c71e	0x011fa375721780065fd5b78f822acc7c4077b69e	false	42380	27	32321199	false	2023-10-04T22:31:29.000Z	0x7dd3a809e676b221f02fe1a56ad8c7dd29d6cfa521a7699b60e00aebbe24817e
0xe45d08a10f253c9541c7612a9a70411e4c15dff9	0xa64977e5938e493acbfa160de771acbc433ee093	0x2d7db6c558d265b84c0f2316336206b76c0373ff	false	27670	76	32302540	true	2023-10-04T06:53:36.000Z	0x8ec86a135fc4f2de90af7818022410ac8b7778069f6c2dd25b0f9b57d90e0748

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.limitOrderManager_Claim_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

limitOrderManager_collectLimOrder_function

Limit order collection events from Biswap V3 DEX (decentralized exchange) on BSC (BNB Smart Chain), recording earned and decremented token amounts when users collect from partially or fully filled orders. Used for tracking order settlement activity and liquidity provider earnings.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_orderIdx`	`STRING`	Index identifier for the limit order being collected. Unique numeric value per order within the Biswap V3 limit order manager contract.
`in_collectDec`	`STRING`	Requested amount of decremented tokens to collect from the limit order, specified in wei-denomination. Uses maximum uint128 value to collect all available decremented tokens.
`in_collectEarn`	`STRING`	Maximum amount of earned tokens (e.g., fees, rewards) the user requests to collect from their limit order, expressed in token’s smallest unit. Often set to max uint128 value to collect all available earnings.
`out_actualCollectDec`	`STRING`	Actual amount of decremented tokens collected from the limit order, denominated in the order’s base token. Returns zero when no decremented tokens were available for collection.
`out_actualCollectEarn`	`STRING`	Actual amount of earned tokens collected from the limit order on Biswap V3 (BSC). Wei-denominated integer representing the profit or fees accrued, often zero if order was unfilled.

Sample Data

gas	status	gas_used	signature	to_address	in_orderIdx	block_number	from_address	in_recipient	in_collectDec	in_collectEarn	block_timestamp	transaction_hash	out_actualCollectEarn
444095	true	240263	0x8f159451	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	1	34453713	0x48ad375c0a2cb41ab3311839e95dc51baf8167f6	0x48ad375c0a2cb41ab3311839e95dc51baf8167f6	340282366920938463463374607431768211455	340282366920938463463374607431768211455	2023-12-18T05:58:49.000Z	0x040ed90f1b55fbe02f6c23303e01efef3206d73d3349798dacb84fc3863bbbb4	10290316399848070075577
295383	true	239583	0x8f159451	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	0	34459563	0x48ad375c0a2cb41ab3311839e95dc51baf8167f6	0x48ad375c0a2cb41ab3311839e95dc51baf8167f6	340282366920938463463374607431768211455	340282366920938463463374607431768211455	2023-12-18T10:52:02.000Z	0x8cae2c44d4677a05c8acd3137f4152c0f2a1ad323d1ffaf8e2f04a17f401c9b8	10544613873437511459961
343498	true	256471	0x8f159451	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	0	38844162	0xcc66e94f4d97d76707a70a5b331521f87bb49992	0xcc66e94f4d97d76707a70a5b331521f87bb49992	340282366920938463463374607431768211455	340282366920938463463374607431768211455	2024-05-19T00:24:35.000Z	0x7aa40d5f44d47e91f1cf4d2b6cf43d35d57a17c26698a7a149157579da25e2ae	98039205880418977193

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.limitOrderManager_collectLimOrder_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

limitOrderManager_decLimOrder_function

Limit order decrease function calls from Biswap V3 (DEX - decentralized exchange) on BSC, recording order index, amount, deadline, and actual token delta. Used for analyzing limit order modifications and partial fills in Biswap’s concentrated liquidity 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_orderIdx`	`STRING`	Index identifier for the limit order being decremented within the Biswap V3 limit order manager contract. Typically starts at 0 and increments for multiple orders from the same address.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.
`out_actualDelta`	`STRING`	Token amount actually received or transferred when the limit order was decremented, denominated in the order’s output token with full decimal precision. Values vary significantly based on order size and token decimals, as seen in samples ranging from sub-unit amounts to tens of thousands of tokens.

Sample Data

gas	status	gas_used	in_amount	signature	to_address	in_deadline	block_number	from_address	block_timestamp	out_actualDelta	transaction_hash
339614	true	141505	340282366920938463463374607431768211455	0x1490d44b	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	1767225600	44284577	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	2024-11-24T07:48:17.000Z	14565000000000000000000	0x40930e05de7f4e5f466698d7d23a5ba30d43e89a59dfe2b7d598e8a7be65c9ec
330380	true	132728	340282366920938463463374607431768211455	0x1490d44b	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	1767225600	36684664	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	2024-03-04T21:05:49.000Z	59930000000000000000	0x35f84faa0f487e24197af7ab80c619199e9f82df160f8d89247ae2524652c83e
346734	true	134857	340282366920938463463374607431768211455	0x1490d44b	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	1767225600	36663101	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	2024-03-04T03:05:54.000Z	543578871932590396489	0xae0d9baafe7d49f18e5d94de8b7bb2071b3891944416d497cce37f4e74dd7737

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.limitOrderManager_decLimOrder_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

limitOrderManager_NewLimitOrder_event

Limit order creation events from Biswap V3 decentralized exchange (DEX) on BNB Smart Chain, tracking order parameters including pool address, price point, order size, direction (buy/sell), and user account. Used for analyzing limit order book dynamics and maker order placement patterns.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_point`	`INT64`	Price tick point identifier for the limit order in the liquidity pool. Integer value representing a specific price level on the order book.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. 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_sellingRemain`	`STRING`	Initial amount of tokens remaining to be sold in the limit order, denominated in the token’s smallest unit. This value equals in_amount at order creation and decreases as the order fills.
`in_earn`	`STRING`	Cumulative amount earned by the limit order at the time of this event, denominated in the receiving token. Initialized to zero when the order is created, indicating no fills have occurred yet.
`in_sellXEaryY`	`BOOL`	Direction flag indicating whether the limit order is selling token X to buy token Y (true) or selling token Y to buy token X (false). This determines the order’s trading direction within the concentrated liquidity pool.

Sample Data

address	in_pool	in_user	removed	in_point	in_amount	log_index	block_number	in_sellXEaryY	block_timestamp	in_sellingRemain	transaction_hash
0xe45d08a10f253c9541c7612a9a70411e4c15dff9	0xa64977e5938e493acbfa160de771acbc433ee093	0xd0fa4dcb3b4a3357cfed3f0a1dc63c6b6a5c8900	false	28030	614815431782503332606	16	32491088	false	2023-10-10T20:39:14.000Z	614815431782503332606	0x32a075af1ae2e1e052fae189369deff2841eeb0e755b442922779d3e6d47dba4
0xe45d08a10f253c9541c7612a9a70411e4c15dff9	0xa64977e5938e493acbfa160de771acbc433ee093	0x84a786fbeba0336dfc63bf6eef2b2788f286a4e5	false	28075	146791863620122569855	46	32482320	false	2023-10-10T13:19:41.000Z	146791863620122569855	0xf03d41d7183e94efc057cfc5316c3d52f530803d5bcdf28744201d056d2937d6
0xe45d08a10f253c9541c7612a9a70411e4c15dff9	0xa64977e5938e493acbfa160de771acbc433ee093	0xed3cbc416a52cffbada1a7a898de2e985a48ca4a	false	27680	594248000000000000000	16	32024550	false	2023-09-24T14:31:05.000Z	594248000000000000000	0x8ceb80d9e7ed5587071e08f4c7d1fd7cf7e15908a668bae6e0dfaa06ba698e40

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.limitOrderManager_NewLimitOrder_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

liquidityManager_DecLiquidity_event

Liquidity decrease events from Biswap V3 decentralized exchange on BSC, tracking NFT position liquidity removals with token amounts and delta changes. Used for analyzing liquidity provider withdrawal activity and position management across V3 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_nftId`	`STRING`	NFT identifier representing the liquidity position being decreased in the Biswap V3 liquidity manager contract. Integer value stored as string, uniquely identifies the LP position token on BSC.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidityDelta`	`STRING`	Change in liquidity for a concentrated liquidity position. Numeric string representation of the signed delta value, where positive values indicate liquidity additions and negative values indicate liquidity removals.
`in_amountX`	`STRING`	Amount of token X involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.
`in_amountY`	`STRING`	Amount of token Y involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_pool	removed	in_nftId	log_index	in_amountX	in_amountY	block_number	block_timestamp	transaction_hash	in_liquidityDelta
0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	0x0749052f6dc98c30b0dec988663d4ae205268eda	false	7268	146	3001050074979827080	3180025306627237624	32208485	2023-10-01T00:13:56.000Z	0x453502b159bfb071d030a4d655ae78771fc8712afa98d82b8f5fd644071c4897	22970672323024983
0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	0x17b27dd90c967d92e0042e1a86b423701a1b8305	false	2901	56	0	0	32218065	2023-10-01T08:13:40.000Z	0xe64ad09374b72fe76cf379847725650cfea4e9615c1961b7994b56975e5b5ce3	0
0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	0x17b27dd90c967d92e0042e1a86b423701a1b8305	false	2901	199	609943321869937230	865503788	32218090	2023-10-01T08:14:55.000Z	0xc23263ce9ad67c9782d64b0cc52b40b3e62403ee77762a66ca2d15f791b4e1e0	23863382573

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.liquidityManager_DecLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Burn_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL changes.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_leftPoint`	`INT64`	Left boundary of the liquidity position’s price tick range in the Biswap V3 pool. When burned (liquidity removed), this value defines the lower price point of the concentrated liquidity position being withdrawn.
`in_rightPoint`	`INT64`	Right boundary tick of the liquidity position being burned in the concentrated liquidity pool. Represents the upper price point of the tick range where liquidity is being removed.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_amountX`	`STRING`	Amount of token X involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.
`in_amountY`	`STRING`	Amount of token Y involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.
`in_state`	`STRUCT<currentPoint INT64, fee STRING, liquidity STRING, liquidityX STRING>`	State identifier or account address representing the protocol’s global state or configuration. Base58-encoded Solana public key for Solana programs, numeric identifier for EVM event logs.

Sample Data

address	removed	in_owner	in_state	log_index	in_amountX	in_amountY	block_number	in_leftPoint	in_liquidity	in_rightPoint	block_timestamp	transaction_hash
0x5995fbce50d945f3fc0f9a97a72113da430c041c	false	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	{“fee”:“800”,“liquidity”:“0”,“liquidityX”:“0”,“currentPoint”:47975}	371	7989999999848	1069078318608389	32039899	46920	94414196807	48930	2023-09-25T03:20:25.000Z	0x46055c7f8106f0090ae9c0a856a32dcae9b93925b8cfb2299bfd462dbccb3790
0x6073625aabce27372b97b57529dd05c2bd4bcb94	false	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	{“fee”:“2800”,“liquidity”:“12381305452114”,“liquidityX”:“10187712031149”,“currentPoint”:161711}	91	0	0	32041761	160350	0	162400	2023-09-25T04:53:54.000Z	0x18fb20c5e500bff4562b772c17c24152b45dd5d3489d221c4772242031bac6fe
0x54aecdbaf106a769076a4ee7571f3a1cd9272b54	false	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	{“fee”:“2800”,“liquidity”:“137801661979673085”,“liquidityX”:“67827893507129420”,“currentPoint”:-28128}	132	0	0	32036057	-29000	0	-26950	2023-09-25T00:07:34.000Z	0xbe3d72f59dc5e031a8b0fb73fa702cb3cd437b0451e585b2787af8c903617d07

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.Pool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_ChangeLiquidityState_event

Liquidity position state changes from Biswap V3 pools on BNB Smart Chain, tracking additions and removals with tick ranges, liquidity deltas, and accumulated fee metrics. Used for analyzing LP activity, position management, and fee accrual patterns across concentrated liquidity ranges.

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_lp`	`STRUCT<liquidSum STRING, liquidDelta STRING, accFeeXOut_128 STRING, accFeeYOut_128 STRING, isEndpt BOOL, feeTimesL STRING, accFPOut_128 STRING>`	Liquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_rp`	`STRUCT<liquidSum STRING, liquidDelta STRING, accFeeXOut_128 STRING, accFeeYOut_128 STRING, isEndpt BOOL, feeTimesL STRING, accFPOut_128 STRING>`	State snapshot of the right boundary point in Biswap V3’s price range affected by this liquidity change. Contains accumulated fee metrics and liquidity totals at the right tick position; typically shows zero values when the right point is not an active endpoint.
`in_lpn`	`INT64`	Left point index (point number) defining one boundary of the liquidity range in the Biswap v3 concentrated liquidity pool. Typically paired with `in_rpn` to demarcate a specific price tick range where liquidity is being added or removed.
`in_rpn`	`INT64`	Right point identifier for the liquidity range affected by this state change. Represents the upper tick boundary of the position in Biswap V3’s concentrated liquidity model.

Sample Data

in_lp	in_rp	in_lpn	in_rpn	address	removed	log_index	block_number	block_timestamp	transaction_hash
{“isEndpt”:true,“feeTimesL”:“7491690640998676000”,“liquidSum”:“9364613301248345”,“liquidDelta”:“9364613301248345”,“accFPOut_128”:“14509249006003000242323528174576072849286824”,“accFeeXOut_128”:“67534372671403760632729850303511967331”,“accFeeYOut_128”:“99734007293744096101642116772492108625316”}	{“isEndpt”:false,“feeTimesL”:“0”,“liquidSum”:“0”,“liquidDelta”:“0”,“accFPOut_128”:“0”,“accFeeXOut_128”:“0”,“accFeeYOut_128”:“0”}	73420	73425	0x46d71eaa3c7ba030a1573cd6587ef4231df21b7e	false	282	32570885	2023-10-13T15:23:33.000Z	0x2a3a0be119e2e55cf390b813d878cef8934f4b0f4ef78b557f397dfb2f98ef1c
{“isEndpt”:true,“feeTimesL”:“7611054476074169600”,“liquidSum”:“9513818095092712”,“liquidDelta”:“-9513818095092712”,“accFPOut_128”:“22441032285670927047759350863163393198948164”,“accFeeXOut_128”:“6085153545742376801478580353843705198267”,“accFeeYOut_128”:“28886190663734975767212135660978355422”}	{“isEndpt”:false,“feeTimesL”:“0”,“liquidSum”:“0”,“liquidDelta”:“0”,“accFPOut_128”:“0”,“accFeeXOut_128”:“0”,“accFeeYOut_128”:“0”}	-53280	-53270	0xd647583eadc9d6bdffb88be8f47d8f858fc2a61c	false	163	32567944	2023-10-13T12:55:17.000Z	0x3cb0e825e5494e60cea219ba2082e41e7c221117fcfcf928edc39109a555d32f
{“isEndpt”:true,“feeTimesL”:“45099863061920477112000”,“liquidSum”:“56374828827400596390”,“liquidDelta”:“56374828827400596390”,“accFPOut_128”:“15365544439396654135366167397891730001386004”,“accFeeXOut_128”:“138159801000424938211624116813860789284”,“accFeeYOut_128”:“26657778267199448624634092683946851608819”}	{“isEndpt”:false,“feeTimesL”:“0”,“liquidSum”:“0”,“liquidDelta”:“0”,“accFPOut_128”:“0”,“accFeeXOut_128”:“0”,“accFeeYOut_128”:“0”}	53260	53270	0x444ed79c5f80676ae9d110952a8563483df802a9	false	52	32564581	2023-10-13T10:06:51.000Z	0xdc2475a135928fbcca454006e07cf72548de3a4efb66ffe5b1613023bddbdb8f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.Pool_ChangeLiquidityState_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_CollectLimitOrder_event

Limit order collection events from Biswap V3 decentralized exchange (DEX) pools on BNB Smart Chain (BSC). Records when liquidity providers withdraw earned tokens from their limit orders, including collection amounts, price points, and order direction.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_point`	`INT64`	Price tick point identifier for the limit order in the liquidity pool. Integer value representing a specific price level on the order book.
`in_collectDec`	`STRING`	Amount of tokens being decreased or collected from the limit order, denominated in the token’s smallest unit. Typically represents the unfilled portion being withdrawn when `in_collectEarn` is zero.
`in_collectEarn`	`STRING`	Amount of tokens earned from the limit order in raw token units. Non-zero when the order has been filled and tokens are being collected by the owner.
`in_sellXEarnY`	`BOOL`	Direction flag indicating whether the limit order sells token X to earn token Y (true) or sells token Y to earn token X (false). Determines which token is being sold and which is being earned in the limit order collection.

Sample Data

address	removed	in_owner	in_point	log_index	block_number	in_recipient	in_collectDec	in_sellXEarnY	block_timestamp	transaction_hash
0xa64977e5938e493acbfa160de771acbc433ee093	false	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	27255	61	32091099	0xb42eb21fe784409148ab22b35f1541731e4c7922	156900000000000000000000	false	2023-09-26T22:07:45.000Z	0xe0b80e6fa637cec775e8bf28bc846913cf4e51198692df3befba0f052028a28e
0xa64977e5938e493acbfa160de771acbc433ee093	false	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	27255	79	32091272	0xb42eb21fe784409148ab22b35f1541731e4c7922	156900000000000000000000	false	2023-09-26T22:16:24.000Z	0x0c6d5576f9602ff42f3a68bdba53068b0038ddef1c22ab7c8f25f11b6f669c63
0xa64977e5938e493acbfa160de771acbc433ee093	false	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	28090	51	32092114	0xb42eb21fe784409148ab22b35f1541731e4c7922	10248619999999999000000	true	2023-09-26T22:59:22.000Z	0x33a09cced359c4caf8fb4bfbc61729b74ef2e9cfb4d5176b58c15e51f176151b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.Pool_CollectLimitOrder_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_collectLimOrder_function

Limit order collection events from Biswap V3 liquidity pools on BNB Smart Chain, recording earned fees and decreasing token amounts withdrawn by recipients at specific price points. Used for analyzing limit order profitability and liquidity provider earnings across concentrated liquidity ranges.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_point`	`INT64`	Price tick point identifier for the limit order in the liquidity pool. Integer value representing a specific price level on the order book.
`in_collectDec`	`STRING`	Requested amount of the decreasing token to collect from the limit order at the specified price point. Typically zero when collecting the earning token, otherwise contains the wei-denominated token amount being withdrawn.
`in_collectEarn`	`STRING`	Amount of “earn” tokens requested to be collected from the limit order at the specified price point. Denominated in the smallest token unit (wei-equivalent); null or zero when collecting “dec” tokens instead.
`in_isEarnY`	`BOOL`	Boolean flag indicating whether earnings are collected in token Y (true) or token X (false) for this limit order. All sample rows show false, meaning earnings were collected in token X.
`out_actualCollectDec`	`STRING`	Amount of decreasing (Dec) tokens actually collected from the limit order after execution. Raw token amount represented as a string to preserve precision for tokens with high decimal places.
`out_actualCollectEarn`	`STRING`	Actual amount of earned tokens collected from the limit order at the specified price point. Denominated in wei (smallest token unit), may differ from requested amount due to available liquidity.

Sample Data

gas	status	gas_used	in_point	signature	in_isEarnY	to_address	block_number	from_address	in_recipient	in_collectDec	trace_address	in_collectEarn	block_timestamp	transaction_hash	out_actualCollectDec	out_actualCollectEarn
305938	true	37707	40760	0x6ad1718f	false	0x47ceffdd864861f8cd85b8d66c5b0c3a9fc2c71e	57352135	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	0xf6dd42ae532ee92a68183ff4ebc1b0a820589fb5	0	3	1136663652667797116560	2025-08-12T15:23:12.000Z	0xa3d15f693156d42493bbdf1f519ade96ff5a9566cdc1fabda5d250cb0350cdfe	0	1136663652667797116560
305627	true	37729	38165	0x6ad1718f	false	0xa64977e5938e493acbfa160de771acbc433ee093	57300976	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	0xc793d665856aacb123431e1c8262d24a8f1c5de4	0	3	22008881826268665975	2025-08-12T04:43:41.000Z	0x45be780f84cb53d89ed71fed96771d6df0d8713409f2a70dc221d3b219f122de	0	22008881826268665975
139366	true	37669	36135	0x6ad1718f	false	0xa64977e5938e493acbfa160de771acbc433ee093	57326427	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	0x4b35b14fe361ae16c7e691fdd9f670446eec5eb1	1000000000000000000	1,3	0	2025-08-12T10:01:50.000Z	0xefba19c9509ffcc244045ef3ffcb6087bbbd3ae82b7e6d31a76d3dc812ef40fc	1000000000000000000	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.Pool_collectLimOrder_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_CollectLiquidity_event

Liquidity withdrawal events from Biswap V3 concentrated liquidity pools on BNB Smart Chain, recording token amounts (amountX and amountY) collected by liquidity providers within specified price tick ranges (leftPoint to rightPoint). Used for tracking LP position management, fee collection patterns, and capital efficiency analysis across different price ranges.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_leftPoint`	`INT64`	Left boundary of the price tick range for the liquidity position being collected in Biswap V3. Negative values indicate prices below the reference point, with more negative numbers representing lower price ticks.
`in_rightPoint`	`INT64`	Right boundary tick of the liquidity position range being collected from the Biswap V3 pool. Tick values define price points in the concentrated liquidity model, with negative values representing prices below 1:1 ratio.
`in_amountX`	`STRING`	Amount of token X involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.
`in_amountY`	`STRING`	Amount of token Y involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	log_index	in_amountX	in_amountY	block_number	in_leftPoint	in_recipient	in_rightPoint	block_timestamp	transaction_hash
0x060775e7a01e148da179d66a6481b729bd29e55d	false	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	79	9999999999926399024	8336853688190009595	31746915	30156	0x9ec5a046c5e2ed6eddf8a5a22206ecfb7f450368	30207	2023-09-14T22:28:06.000Z	0x06842ce6882a04f39929d8bd2e92f488acc97ab4d9e7840c08dbdf0c5bab0f08
0x060775e7a01e148da179d66a6481b729bd29e55d	false	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	117	9999999999973273328	45344183121620746995	31746992	30156	0x9ec5a046c5e2ed6eddf8a5a22206ecfb7f450368	30167	2023-09-14T22:31:57.000Z	0x26cd5040c985f420a12ab175f88d33bde0d17561887daba1ea69a29af4182ea4
0x10887006aa59cc7108c3375b0c8386206257b97c	false	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	57	3286827021115028759192	6274803054549980651	31740639	-61000	0x3e83e5df550317112e9d02524fe7b76f9d7b3628	-60600	2023-09-14T17:13:40.000Z	0x970ade3d74f401510ff81645d73633a20734b3ffe0551df8998e02ed0714dd48

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.Pool_CollectLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_DecLimitOrder_event

Limit order decrease events from Biswap V3 liquidity pools on BNB Smart Chain, recording when users reduce or cancel their limit orders at specific price points. Useful for analyzing limit order book depth changes and liquidity provider order management strategies.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_decreaseAmount`	`STRING`	Amount of tokens being removed from a limit order position in the Biswap V3 pool. String-encoded integer in base token units, often zero when only claiming earnings without reducing position size.
`in_point`	`INT64`	Price tick point identifier for the limit order in the liquidity pool. Integer value representing a specific price level on the order book.
`in_claimSold`	`STRING`	Amount of tokens sold through the limit order that were claimed in this event, denominated in the smallest unit of the token being sold. Typically zero when decreasing or canceling orders, and populated when settling completed limit orders.
`in_claimEarn`	`STRING`	Amount of tokens earned and claimed from the limit order, denominated in the earn token. Represented as a wei-denominated integer string, typically zero at order decrease but non-zero when profits are realized.
`in_sellXEarnY`	`BOOL`	Direction flag indicating whether the limit order sells token X to earn token Y (true) or sells token Y to earn token X (false). This boolean defines the trading direction for the limit order at the specified price point.

Sample Data

address	removed	in_owner	in_point	log_index	block_number	in_sellXEarnY	block_timestamp	transaction_hash	in_decreaseAmount
0x517c5d56527dabffbe9d1a1e8b98406f349d3470	false	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	-39450	74	31761977	false	2023-09-15T11:02:28.000Z	0xdeacb1898a14cc67a83f868d27fcf241b63edaab97f1153a979ddbe9201bfff7	4993994000000000
0x517c5d56527dabffbe9d1a1e8b98406f349d3470	false	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	-39450	72	31761977	false	2023-09-15T11:02:28.000Z	0xdeacb1898a14cc67a83f868d27fcf241b63edaab97f1153a979ddbe9201bfff7	0
0x517c5d56527dabffbe9d1a1e8b98406f349d3470	false	0xe45d08a10f253c9541c7612a9a70411e4c15dff9	-39450	75	31761977	false	2023-09-15T11:02:28.000Z	0xdeacb1898a14cc67a83f868d27fcf241b63edaab97f1153a979ddbe9201bfff7	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.Pool_DecLimitOrder_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation analysis.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountX`	`STRING`	Amount of token X involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.
`in_amountY`	`STRING`	Amount of token Y involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.
`in_paidX`	`STRING`	Amount of token X repaid to the pool after the flash loan, denominated in the token’s smallest unit. This value includes the borrowed amount plus fees, with samples showing typical flash loan repayment amounts in wei-equivalent units.
`in_paidY`	`STRING`	Amount of token Y repaid to the pool after the flash loan, denominated in the token’s smallest unit (wei-equivalent). This represents the principal plus fee for the Y token borrowed in the flash loan transaction.

Sample Data

address	removed	in_paidX	in_sender	log_index	in_amountX	block_number	in_recipient	block_timestamp	transaction_hash
0x928a48c68ca76433ea695d6068f7cfbbeac5f766	false	137111766461206669760	0x9180981034364f683ea25bcce0cff5e03a595bef	46	914078443074711131731694	32522170	0x9180981034364f683ea25bcce0cff5e03a595bef	2023-10-11T22:40:24.000Z	0x9b5595be245656ef7dea4cc82d527e602a3536e1b1779c9ab074c5fb0be4afbb
0xbf2aff6e6bb4e210b877fda7a8a28a6e09639f79	false	9681594386511760479	0x9180981034364f683ea25bcce0cff5e03a595bef	44	12101992983139700597686	32522170	0x9180981034364f683ea25bcce0cff5e03a595bef	2023-10-11T22:40:24.000Z	0x9b5595be245656ef7dea4cc82d527e602a3536e1b1779c9ab074c5fb0be4afbb
0xd647583eadc9d6bdffb88be8f47d8f858fc2a61c	false	787789329227744634735	0x9180981034364f683ea25bcce0cff5e03a595bef	48	984736661534680793418243	32522170	0x9180981034364f683ea25bcce0cff5e03a595bef	2023-10-11T22:40:24.000Z	0x9b5595be245656ef7dea4cc82d527e602a3536e1b1779c9ab074c5fb0be4afbb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.Pool_Flash_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_leftPoint`	`INT64`	Left boundary of the concentrated liquidity price range, expressed as a tick point in the Biswap V3 pool. Negative values indicate prices below the reference point, with larger absolute values representing lower price bounds.
`in_rightPoint`	`INT64`	Right boundary of the concentrated liquidity position tick range. Defines the upper price limit where the liquidity provider’s position becomes inactive.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_amountX`	`STRING`	Amount of token X involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.
`in_amountY`	`STRING`	Amount of token Y involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.
`in_state`	`STRUCT<currentPoint INT64, fee STRING, liquidity STRING, liquidityX STRING>`	State identifier or account address representing the protocol’s global state or configuration. Base58-encoded Solana public key for Solana programs, numeric identifier for EVM event logs.

Sample Data

address	removed	in_owner	in_state	in_sender	log_index	in_amountX	in_amountY	block_number	in_leftPoint	in_liquidity	in_rightPoint	block_timestamp	transaction_hash
0x17b27dd90c967d92e0042e1a86b423701a1b8305	false	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	{“fee”:“2800”,“liquidity”:“9025255894584”,“liquidityX”:“144256990452”,“currentPoint”:-198106}	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	62	48218991708114687235	67999999998	32148802	-198750	2145478793671	-196950	2023-09-28T22:21:36.000Z	0xd54efd521699bd0537517029dc3826e4d4ba015195e680bdb5621ba46a197cb0
0x17b27dd90c967d92e0042e1a86b423701a1b8305	false	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	{“fee”:“2800”,“liquidity”:“7008894355420”,“liquidityX”:“144256990452”,“currentPoint”:-198106}	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	71	12031008291848972576	16966521590	32148957	-198750	535313415778	-196950	2023-09-28T22:29:21.000Z	0x42a0c468a5b4039491971c4e923259443b816808bede1779021609b5d63157c3
0x3267a6f937ccc076440bb41fd59e990d6cf54ee7	false	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	{“fee”:“150”,“liquidity”:“68829168713724157510251”,“liquidityX”:“2675190133229316043595”,“currentPoint”:-9}	0xa6fa4115f9c6b3aca9454df84b43deb7fe389019	669	0	7012999999999999999999	32131655	-9	7016156402319774538371	-8	2023-09-28T08:01:09.000Z	0x1852ca527548cf42f22b11034bbc8d2aebdc5cc6a9e3884280071f70fc9f18c5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.Pool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

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_returnValues`	`STRUCT<amountX STRING, amountY STRING, accFee STRING>`	Token amounts exchanged and accumulated fees for this swap event on the Biswap V3 DEX (decentralized exchange). Contains amountX (token0 amount), amountY (token1 amount), and accFee (accumulated protocol fees), all denominated in the smallest token unit (wei).
`in_state`	`STRUCT<currentPoint INT64, fee STRING, liquidity STRING, liquidityX STRING>`	State identifier or account address representing the protocol’s global state or configuration. Base58-encoded Solana public key for Solana programs, numeric identifier for EVM event logs.
`in_sellXEarnY`	`BOOL`	Boolean flag indicating swap direction: true when selling token X to earn token Y, false when selling token Y to earn token X. Determines which asset is being sold in the liquidity pool swap.

Sample Data

address	removed	in_state	log_index	block_number	in_sellXEarnY	block_timestamp	in_returnValues	transaction_hash
0x6f7d4669c9fe2499deb714b7e3816b4a1d3b23d3	false	{“fee”:“800”,“liquidity”:“5065245100191421”,“liquidityX”:“1346722556111171”,“currentPoint”:-81495}	345	31646331	false	2023-09-11T10:25:43.000Z	{“accFee”:“6272000000000”,“amountX”:“34076150205764130609”,“amountY”:“9800000000000000”}	0xe263e881decf256b892f5069b60a49aff3e44c2d22925733f0932d7f5a6e7b7a
0x6f7d4669c9fe2499deb714b7e3816b4a1d3b23d3	false	{“fee”:“800”,“liquidity”:“5065245100191421”,“liquidityX”:“4594521425145962”,“currentPoint”:-81449}	122	31637548	false	2023-09-11T03:05:27.000Z	{“accFee”:“7270315520000”,“amountX”:“39356534676105853956”,“amountY”:“11359868000000000”}	0x1994f1e2744f6c8f86dd5d2a2465156b21630139f65a08622ef40efdad192b6a
0xae3fb8e3576bb1051b0cf15ebb8420fd79d9e073	false	{“fee”:“2800”,“liquidity”:“42418496524301785”,“liquidityX”:“24324067436347514”,“currentPoint”:-1180}	45	31658421	false	2023-09-11T20:31:54.000Z	{“accFee”:“1495368421891116”,“amountX”:“749706666585740053”,“amountY”:“667575188344247669”}	0x62adf5463e7801dad5b7949644e7b786de3c119fd09af5a32e9068265f29795d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v3_bsc.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BiswapPoolV3_swapX2Y_function

BiswapPoolV3_swapY2X_function

Factory_NewPool_event

limitOrderManager_Claim_event

limitOrderManager_collectLimOrder_function

limitOrderManager_decLimOrder_function

limitOrderManager_NewLimitOrder_event

liquidityManager_DecLiquidity_event

Pool_Burn_event

Pool_ChangeLiquidityState_event

Pool_CollectLimitOrder_event

Pool_collectLimOrder_function

Pool_CollectLiquidity_event

Pool_DecLimitOrder_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

​Tables

​BiswapPoolV3_swapX2Y_function

​BiswapPoolV3_swapY2X_function

​Factory_NewPool_event

​limitOrderManager_Claim_event

​limitOrderManager_collectLimOrder_function

​limitOrderManager_decLimOrder_function

​limitOrderManager_NewLimitOrder_event

​liquidityManager_DecLiquidity_event

​Pool_Burn_event

​Pool_ChangeLiquidityState_event

​Pool_CollectLimitOrder_event

​Pool_collectLimOrder_function

​Pool_CollectLiquidity_event

​Pool_DecLimitOrder_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

Tables

BiswapPoolV3_swapX2Y_function

BiswapPoolV3_swapY2X_function

Factory_NewPool_event

limitOrderManager_Claim_event

limitOrderManager_collectLimOrder_function

limitOrderManager_decLimOrder_function

limitOrderManager_NewLimitOrder_event

liquidityManager_DecLiquidity_event

Pool_Burn_event

Pool_ChangeLiquidityState_event

Pool_CollectLimitOrder_event

Pool_collectLimOrder_function

Pool_CollectLiquidity_event

Pool_DecLimitOrder_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event