wombat_v2_bsc - Token Terminal Docs

Tables

AxlUsdcPool_SetFee_event

Fee configuration events from Wombat V2’s Axelar USDC pool on BSC, tracking changes to retention ratios and LP dividend distribution parameters. Used for analyzing protocol fee structure adjustments and liquidity provider reward mechanisms.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x8ad47d7ab304272322513ee63665906b64a49da2	false	4	25313177	2023-02-02T07:48:38.000Z	0xfb801aa8fd1dc533022222ee224f733b6e3e83b73883269c1b55254452cefcc2	1000000000000000000	0
0x8ad47d7ab304272322513ee63665906b64a49da2	false	245	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

AxlUsdcPool_SetHaircutRate_event

Haircut rate parameter changes for the Axelar USDC pool in Wombat V2 protocol on BSC. Tracks risk management adjustments where haircut rates (values like 0.0001 to 0.0004) control slippage penalties for imbalanced withdrawals.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x8ad47d7ab304272322513ee63665906b64a49da2	false	100000000000000	359	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0x8ad47d7ab304272322513ee63665906b64a49da2	false	400000000000000	92	26441908	2023-03-13T22:59:09.000Z	0x3d5aff71c4577373b3cf6d5430c8e8594c88b1fbd01af736ca44d4de4e9656be
0x8ad47d7ab304272322513ee63665906b64a49da2	false	400000000000000	453	37533356	2024-04-03T09:56:05.000Z	0xfcc61b2894871b33654c477d55169a7aba38afceb480f79282bd75d359594744

Example Query

Query with partition filter

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

AxlUsdcPool_setHaircutRate_function

Administrative function calls that update the haircut rate parameter for the Axial USDC (axlUSDC) liquidity pool in Wombat Exchange V2 on BSC. Records governance actions adjusting the fee charged on withdrawals during imbalanced pool conditions.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
93705	0	true	9896	0xf57e84d5	0x8ad47d7ab304272322513ee63665906b64a49da2	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,5	2023-04-18T04:36:03.000Z	100000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
10001	0	true	9896	0xf57e84d5	0x8ad47d7ab304272322513ee63665906b64a49da2	26441908	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0	2023-03-13T22:59:09.000Z	400000000000000	0x3d5aff71c4577373b3cf6d5430c8e8594c88b1fbd01af736ca44d4de4e9656be

Example Query

Query with partition filter

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

AxlUsdcPool_Swap_event

Swap events from Wombat V2’s Axelar USDC pool on BNB Smart Chain, capturing token exchanges with input/output amounts, token addresses, sender and recipient data. Used for analyzing liquidity pool trading activity and cross-chain stablecoin flows.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x96794f03b3114f50b892b0dec79d753658c931ee	0x8ad47d7ab304272322513ee63665906b64a49da2	false	0x484571309d6a9e9285fc0b4634acd43bd0ba97d8	545	0x4268b8f0b87b6eae5d897996e6b845ddbd99adf3	3665002018	28292366	0xe9e7cea3dedca5984780bafc599bd69add087d56	3664905279300785143808	2023-05-17T14:59:24.000Z	0x7a6e32fe7eb7158b147b2a336b1841acc16e6ed9076fdcfcdff4d9f0df3c39c1
0xce16f69375520ab01377ce7b88f5ba8c48f8d666	0x8ad47d7ab304272322513ee63665906b64a49da2	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	178	0x4268b8f0b87b6eae5d897996e6b845ddbd99adf3	295248367	28289681	0xe9e7cea3dedca5984780bafc599bd69add087d56	295300000000000000000	2023-05-17T12:44:39.000Z	0x0270d5e01a90d9f338eab9f2a9299e0536b6a5e4f4cab9f3b10601527a803732
0xce16f69375520ab01377ce7b88f5ba8c48f8d666	0x8ad47d7ab304272322513ee63665906b64a49da2	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	123	0x4268b8f0b87b6eae5d897996e6b845ddbd99adf3	264818	28275575	0xe9e7cea3dedca5984780bafc599bd69add087d56	264736540000000000	2023-05-17T00:58:40.000Z	0x9d7f1c909773260acaaf94da6124327e058e9fcd30026240001cfead4ca34bbb

Example Query

Query with partition filter

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

BnbxPool_SetFee_event

Fee configuration events from the BNBx staking pool on Wombat Exchange (BSC), tracking changes to LP dividend and retention ratio parameters. Used for analyzing protocol fee structure adjustments and revenue distribution mechanisms.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x8df1126de13bcfef999556899f469d64021adbae	false	248	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000
0x8df1126de13bcfef999556899f469d64021adbae	false	1	24927358	2023-01-19T17:24:27.000Z	0x83664519c6925b08a73d1e52d7a0065d824547d2af58edd311892e25e9b08422	1000000000000000000	0

Example Query

Query with partition filter

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

BnbxPool_SetHaircutRate_event

Haircut rate adjustment events from Wombat Exchange’s BNBx pool on BSC, recording fee parameter changes for withdrawal penalties. Used for tracking protocol risk management and liquidity provider fee structure modifications over time.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x8df1126de13bcfef999556899f469d64021adbae	false	1000000000000000	362	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0x8df1126de13bcfef999556899f469d64021adbae	false	1000000000000000	127	25165591	2023-01-28T02:26:19.000Z	0x7cd041a384fb5f5f06ec86f0bd0a805e900a76925445d18c8330aa04be06c232
0x8df1126de13bcfef999556899f469d64021adbae	false	400000000000000	163	27710406	2023-04-27T09:16:35.000Z	0xd58b308027dab85edf30ce6c542ed06c4c29b57aad39a30fe2e749f7c33f1dd2

Example Query

Query with partition filter

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

BnbxPool_setHaircutRate_function

Administrative function calls that update the haircut rate parameter for Wombat’s BNBx stablecoin pool on BNB Smart Chain. Used for analyzing protocol risk management and governance adjustments to withdrawal penalty fees.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
369549	true	9896	0xf57e84d5	0x8df1126de13bcfef999556899f469d64021adbae	27912423	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	1,0,0,2	2023-05-04T09:52:05.000Z	100000000000000	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67
56936	true	9896	0xf57e84d5	0x8df1126de13bcfef999556899f469d64021adbae	27710406	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,0	2023-04-27T09:16:35.000Z	400000000000000	0xd58b308027dab85edf30ce6c542ed06c4c29b57aad39a30fe2e749f7c33f1dd2
9985	true	9896	0xf57e84d5	0x8df1126de13bcfef999556899f469d64021adbae	25165591	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,2	2023-01-28T02:26:19.000Z	1000000000000000	0x7cd041a384fb5f5f06ec86f0bd0a805e900a76925445d18c8330aa04be06c232

Example Query

Query with partition filter

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

BnbxPool_Swap_event

Token swap events from Wombat Exchange’s BNBx pool on BNB Chain, recording exchanges between BNBx liquid staking tokens and WBNB with sender, recipient, and swap amounts for liquidity 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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x172fcd41e0913e95784454622d1c3724f546f849	0x8df1126de13bcfef999556899f469d64021adbae	false	0x6827ab5b01b02a594d9d36f2ffa787f6c7c5a72d	370	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	332817434866345181	32986463	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	310932567494233035	2023-10-28T02:51:42.000Z	0x079e811190cef12912974741ca5705f3a5bc22cd63ea766bcfe87b518088fd78
0x172fcd41e0913e95784454622d1c3724f546f849	0x8df1126de13bcfef999556899f469d64021adbae	false	0x6827ab5b01b02a594d9d36f2ffa787f6c7c5a72d	289	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	296344185357011737	32983670	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	276837577958139332	2023-10-28T00:31:56.000Z	0xd92afeddc39d39258ba5c8ee4f9d52da1756a19a4e4d365da2ab760c045f4b33
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0x8df1126de13bcfef999556899f469d64021adbae	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	45	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	42291376444777761701	33007108	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	39520686116675964514	2023-10-28T20:07:58.000Z	0x39748f887aa816065105283a1a735fdf1babfb029712e5d600efa477775efc41

Example Query

Query with partition filter

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

BobPool_SetFee_event

Fee parameter update events from Wombat V2’s BobPool on BSC, capturing changes to retention ratios and LP (liquidity provider) dividend distributions. Used for tracking protocol fee structure modifications and revenue-sharing configuration changes over time.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0xea6cdd9e8819bbf7f8791e7d084d9f0a6afa7892	false	0	25881357	2023-02-22T07:10:07.000Z	0x6bd6cf1a57002edadad9da68a0eaa0f8857ff44ac5a92bc3f48ba58f04975895	1000000000000000000	0
0xea6cdd9e8819bbf7f8791e7d084d9f0a6afa7892	false	247	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

BobPool_SetHaircutRate_event

Haircut rate parameter changes for Wombat Protocol’s BobPool on BNS Chain, tracking risk management adjustments that affect withdrawal penalties during pool imbalances. Used for monitoring protocol governance decisions and liquidity risk parameters.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xea6cdd9e8819bbf7f8791e7d084d9f0a6afa7892	false	100000000000000	361	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0xea6cdd9e8819bbf7f8791e7d084d9f0a6afa7892	false	400000000000000	353	27019619	2023-04-03T05:56:11.000Z	0x6241a1f4363c059e6b20d4eb7ed5f7f13eaef409304443c2a4c525e54a2281e0
0xea6cdd9e8819bbf7f8791e7d084d9f0a6afa7892	false	400000000000000	455	37533356	2024-04-03T09:56:05.000Z	0xfcc61b2894871b33654c477d55169a7aba38afceb480f79282bd75d359594744

Example Query

Query with partition filter

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

BobPool_setHaircutRate_function

Haircut rate parameter updates for Wombat Exchange’s BobPool stableswap pool on BNB Chain, tracking governance changes to the protocol’s slippage fee mechanism. Used to analyze pool risk parameter adjustments and protocol governance activity over time.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
76081	0	true	9865	0xf57e84d5	0xea6cdd9e8819bbf7f8791e7d084d9f0a6afa7892	27019619	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,0,1	2023-04-03T05:56:11.000Z	400000000000000	0x6241a1f4363c059e6b20d4eb7ed5f7f13eaef409304443c2a4c525e54a2281e0
72371	0	true	9865	0xf57e84d5	0xea6cdd9e8819bbf7f8791e7d084d9f0a6afa7892	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,7	2023-04-18T04:36:03.000Z	100000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7

Example Query

Query with partition filter

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

BobPool_Swap_event

Token swap events from Wombat V2’s BobPool on BNB Smart Chain (BSC). Records token exchanges between sender and recipient addresses with input/output token addresses and amounts for analyzing liquidity pool trading activity.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0xea6cdd9e8819bbf7f8791e7d084d9f0a6afa7892	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	96	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	3769288847809036366	26676714	0xb0b195aefa3650a6908f15cdac7d92f8a5791b0b	3769398333440864446	2023-03-22T05:14:06.000Z	0xcb17fa3135e42bc2c8df5d8fddcc783bb6e50a5e3f29a09d2ed732d43dd7c6e7
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0xea6cdd9e8819bbf7f8791e7d084d9f0a6afa7892	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	522	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	2713008833968030060	26684008	0xb0b195aefa3650a6908f15cdac7d92f8a5791b0b	2713109199849374016	2023-03-22T11:21:08.000Z	0xc19a9982747fd3dc4ff34517dfbb8a0dd9bade61fca22e8b3582de01a1d10d01
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0xea6cdd9e8819bbf7f8791e7d084d9f0a6afa7892	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	64	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	12792890885026459448	28091351	0xb0b195aefa3650a6908f15cdac7d92f8a5791b0b	12794749846997681808	2023-05-10T15:10:33.000Z	0x2451cd0367842de1e62c017268c925a4e9ec031c89c948fdcc005ab30011c020

Example Query

Query with partition filter

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

CrossChainPool_SetFee_event

Fee configuration events emitted when cross-chain liquidity pool fee parameters are updated, containing LP (liquidity provider) dividend ratio and retention ratio settings. Used for tracking fee structure changes across Wombat protocol deployments.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x1ee15673e07105bcf360139fa8cafebdd7754bef	false	0	31267857	2023-08-29T05:49:54.000Z	0xbc4402d44938fb9ac787b23b69267f7321112d153af831cc6d3b4bb65434e393	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

CrossChainPool_SetHaircutRate_event

Event log emitted when the haircut rate parameter is updated in a Wombat cross-chain liquidity pool contract. Records the new rate value alongside transaction context for tracking pool fee configuration 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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x1ee15673e07105bcf360139fa8cafebdd7754bef	false	20000000000000	91	32098998	2023-09-27T04:44:07.000Z	0xcf921077cecd0ff1d97e1f87c4f6b6762894034e18adf66fefabd3a8a2a93822

Example Query

Query with partition filter

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

CrossChainPool_SwapV2_event

Token swap events from Wombat cross-chain pools recording exchange of tokens between different assets. Contains sender, recipient, source/destination token addresses, swap amounts, and fees charged on the destination token.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toTokenFee`	`STRING`	Fee charged in destination token units for the swap transaction. String-encoded integer value representing the fee amount in the smallest unit of the destination token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	in_toTokenFee	block_timestamp	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	0x1ee15673e07105bcf360139fa8cafebdd7754bef	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	89	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	249670147878227415736	32292723	0x55d398326f99059ff775485246999027b3197955	249635758886080235444	4993502827621101	2023-10-03T22:41:10.000Z	0x3f52e1627c7be568d1f9b247edb25b478a3d75905433a4b3aae40a8fd0619033
0x1111111254eeb25477b68fb85ed929f73a960582	0x1ee15673e07105bcf360139fa8cafebdd7754bef	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	291	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	141762576872799243269	32275949	0x55d398326f99059ff775485246999027b3197955	141762115859900644833	2835308243620857	2023-10-03T08:39:28.000Z	0x7a82a1882007e05786d5430297717d29e72b4738a96ee527cf88467b62151bf6
0x1111111254eeb25477b68fb85ed929f73a960582	0x1ee15673e07105bcf360139fa8cafebdd7754bef	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	30	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	333746430602531262251	32281422	0x55d398326f99059ff775485246999027b3197955	333736997860000000000	6675062113292891	2023-10-03T13:14:44.000Z	0xda663e50eab1da965da8d40f355c836021e8bf498f1aa4df6957c75a69db108e

Example Query

Query with partition filter

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

CUsdPool_SetFee_event

Fee configuration change events from Wombat V2’s CUSD stablecoin pool on BSC. Tracks updates to LP dividend and retention ratio parameters for analyzing protocol fee distribution mechanisms.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x4dfa92842d05a790252a7f374323b9c86d7b7e12	false	244	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000
0x4dfa92842d05a790252a7f374323b9c86d7b7e12	false	0	25312980	2023-02-02T07:38:47.000Z	0x3dfafd008a9769702c829eda6679378d2b12a036f60d256cc4fc4b0ad67555b6	1000000000000000000	0

Example Query

Query with partition filter

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

CUsdPool_SetHaircutRate_event

Haircut rate parameter updates for Wombat Exchange’s CUSD stablecoin pool on BSC, tracking risk adjustment changes with values in basis points (1e14 = 1%). Used to monitor protocol risk management and liquidity provider protection settings over time.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x4dfa92842d05a790252a7f374323b9c86d7b7e12	false	100000000000000	358	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0x4dfa92842d05a790252a7f374323b9c86d7b7e12	false	400000000000000	171	26009066	2023-02-26T18:40:48.000Z	0x7073d99b827267f50d6927dff6d9b1d0b40edb47c807580c7cee358d7f3b9237

Example Query

Query with partition filter

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

CUsdPool_setHaircutRate_function

Haircut rate parameter updates for Wombat V2’s stablecoin pool on BSC, tracking administrative changes to the protocol’s risk parameter that controls withdrawal penalties during imbalanced pool conditions. Used for monitoring governance actions and risk management strategy 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.
`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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
104388	0	true	9896	0xf57e84d5	0x4dfa92842d05a790252a7f374323b9c86d7b7e12	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,4	2023-04-18T04:36:03.000Z	100000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
130778	0	true	9896	0xf57e84d5	0x4dfa92842d05a790252a7f374323b9c86d7b7e12	26009066	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,1	2023-02-26T18:40:48.000Z	400000000000000	0x7073d99b827267f50d6927dff6d9b1d0b40edb47c807580c7cee358d7f3b9237

Example Query

Query with partition filter

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

CUsdPool_Swap_event

Swap events from Wombat Exchange’s CUSD stablecoin pool on BNС Chain, capturing token exchanges between stablecoins with sender, recipient, input/output tokens and amounts. Used for analyzing stablecoin liquidity provision, swap pricing efficiency, and pool utilization 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0x4dfa92842d05a790252a7f374323b9c86d7b7e12	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	47	0x0782b6d8c4551b9760e74c0545a9bcd90bdc41e5	164175083215501731420	26643543	0xfa4ba88cf97e282c505bea095297786c16070129	164851725196103275661	2023-03-21T01:20:50.000Z	0x499fa856e473f63e821cbb42b1907f7af4c79180d5780d73176b2d7da0171e60
0x70c26e9805ec5df3d4ab0b2a3df86bba2231b6c1	0x4dfa92842d05a790252a7f374323b9c86d7b7e12	false	0xf0cb298a4cc5222dfe1d593d4f2b125b4f42a7d0	111	0x0782b6d8c4551b9760e74c0545a9bcd90bdc41e5	234293876396922004718	26651055	0xfa4ba88cf97e282c505bea095297786c16070129	235337849948224030100	2023-03-21T07:41:56.000Z	0xe89ad2d160d83e33d1d98598c2d1502e7ca87ebb4d697973b43289c8420f6852
0x70c26e9805ec5df3d4ab0b2a3df86bba2231b6c1	0x4dfa92842d05a790252a7f374323b9c86d7b7e12	false	0xf0cb298a4cc5222dfe1d593d4f2b125b4f42a7d0	114	0x0782b6d8c4551b9760e74c0545a9bcd90bdc41e5	668557200834144527706	26665588	0xfa4ba88cf97e282c505bea095297786c16070129	671549173742507149848	2023-03-21T19:55:41.000Z	0xf1a656b9e81178b4c886162da876100dbb2751b6cb71fb11047247bf09378290

Example Query

Query with partition filter

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

DynamicPool_SetFee_event

Fee configuration change events from Wombat Exchange V2 liquidity pools on BSC. Tracks updates to retention ratios and LP dividend ratios for analyzing protocol revenue distribution and liquidity provider economics.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	false	1	20773599	2022-08-26T07:52:07.000Z	0x17afde11936b96168d7c2f43f2980a9d313929d8cf3ecb0da45e38a36b74a09a	1000000000000000000	0

Example Query

Query with partition filter

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

DynamicPool_SetHaircutRate_event

Haircut rate configuration changes emitted by Wombat DynamicPool contracts on BNB Smart Chain, where haircut rate (in_value) represents the penalty fee applied to withdrawals to maintain pool stability. Used for tracking risk parameter adjustments and protocol governance decisions.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	false	100000000000000	539	27912423	2023-05-04T09:52:05.000Z	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67

Example Query

Query with partition filter

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

DynamicPool_setHaircutRate_function

Haircut rate parameter updates for Wombat Exchange V2 liquidity pools on BSC, where haircut rate controls the penalty applied during asset withdrawals to maintain pool stability. Used to track governance-driven risk parameter adjustments and their impact on withdrawal costs.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
358866	0	true	9852	0xf57e84d5	0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	27912423	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	1,0,0,3	2023-05-04T09:52:05.000Z	100000000000000	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67

Example Query

Query with partition filter

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

DynamicPool_Swap_event

Token swap events from Wombat Exchange V2 liquidity pools on BNB Smart Chain (BSC). Records input/output token addresses and amounts for analyzing exchange rates, trading volumes, and liquidity provider performance.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	false	0x18101ac1d35230f1a3c005e2abaaeb25cae79e7f	420	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	7083159329940197157	23337627	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	7226451478613403000	2022-11-24T17:15:18.000Z	0xd7fb45d1696db996a4b990d8059b6a62c99a2d44a4f67471fee20ccca8acba36
0x1111111254eeb25477b68fb85ed929f73a960582	0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	false	0x18101ac1d35230f1a3c005e2abaaeb25cae79e7f	449	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	1075891464676732621	23337622	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	1097559810898859500	2022-11-24T17:14:56.000Z	0x4830057b8f04cae8be91b19e3382b40d9f601960a425bd35a5c4e9ff80c90b4d
0x1111111254eeb25477b68fb85ed929f73a960582	0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	false	0x18101ac1d35230f1a3c005e2abaaeb25cae79e7f	257	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	2441807622583862820	23327005	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	2505908124574336500	2022-11-24T08:16:46.000Z	0xd6967288feafdb31400fbfd16528dcfe847e30f4411333546a4e615caab9c555

Example Query

Query with partition filter

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

FraxEthPool_SetFee_event

Fee configuration events from the Wombat V2 FraxEth liquidity pool on BNB Smart Chain, capturing changes to LP dividend and retention ratios. Used for tracking fee structure adjustments and understanding protocol revenue distribution mechanics.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x2ea772346486972e7690219c190dadda40ac5da4	false	4	26056626	2023-02-28T10:41:42.000Z	0x761072c5649718d870893606a81f39d09248bd58e83e83247cca2712a7f7b78d	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

FraxEthPool_SetHaircutRate_event

Haircut rate parameter changes for the Frax Ethereum pool in Wombat V2 DEX on BNB Chain, recording risk management adjustments that affect withdrawal fees during unstable market conditions. Values represent basis points used to calculate slippage protection during imbalanced pool scenarios.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x2ea772346486972e7690219c190dadda40ac5da4	false	1000000000000000	365	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0x2ea772346486972e7690219c190dadda40ac5da4	false	400000000000000	165	27710406	2023-04-27T09:16:35.000Z	0xd58b308027dab85edf30ce6c542ed06c4c29b57aad39a30fe2e749f7c33f1dd2
0x2ea772346486972e7690219c190dadda40ac5da4	false	100000000000000	540	27912423	2023-05-04T09:52:05.000Z	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67

Example Query

Query with partition filter

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

FraxEthPool_setHaircutRate_function

Administrative transactions setting the haircut rate parameter for Wombat V2’s FraxETH liquidity pool on BNB Smart Chain. Used to track risk parameter adjustments that affect withdrawal fees during imbalanced pool conditions.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
35571	true	9865	0xf57e84d5	0x2ea772346486972e7690219c190dadda40ac5da4	27710406	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,2	2023-04-27T09:16:35.000Z	400000000000000	0xd58b308027dab85edf30ce6c542ed06c4c29b57aad39a30fe2e749f7c33f1dd2
348227	true	9865	0xf57e84d5	0x2ea772346486972e7690219c190dadda40ac5da4	27912423	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	1,0,0,4	2023-05-04T09:52:05.000Z	100000000000000	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67
42105	true	5665	0xf57e84d5	0x2ea772346486972e7690219c190dadda40ac5da4	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,11	2023-04-18T04:36:03.000Z	1000000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7

Example Query

Query with partition filter

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

FraxEthPool_Swap_event

Token swap events from Wombat V2’s frxETH (Frax Ether) pool on BNB Chain. Records token exchanges between frxETH and ETH with sender addresses, amounts, and recipient details for analyzing liquidity pool trading activity.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x14831f12fccc86c4f3dae41c769593df766e4353	0x2ea772346486972e7690219c190dadda40ac5da4	false	0x14831f12fccc86c4f3dae41c769593df766e4353	69	0x2170ed0880ac9a755fd29b2688956bd959f933f8	1439261653812864301	27577050	0x64048a7eecf3a2f1ba9e144aac3d7db6e58f555e	1438073855819936204	2023-04-22T17:55:55.000Z	0x924c1f8bf06c3a771ccaa8a712df88a624ab726de9fe2d46450e703043eb5184
0x9ad32e3054268b849b84a8dbcc7c8f7c52e4e69a	0x2ea772346486972e7690219c190dadda40ac5da4	false	0x14831f12fccc86c4f3dae41c769593df766e4353	93	0x2170ed0880ac9a755fd29b2688956bd959f933f8	790970996784372526	27557808	0x64048a7eecf3a2f1ba9e144aac3d7db6e58f555e	787088295776993344	2023-04-22T01:52:26.000Z	0x60a2ce259fb216d256b0f3189afaa7ace2077233a3f13be6454294f6ce57a15b
0x9ad32e3054268b849b84a8dbcc7c8f7c52e4e69a	0x2ea772346486972e7690219c190dadda40ac5da4	false	0x14831f12fccc86c4f3dae41c769593df766e4353	251	0x2170ed0880ac9a755fd29b2688956bd959f933f8	3069373066876145501	27557814	0x64048a7eecf3a2f1ba9e144aac3d7db6e58f555e	3059560852549630007	2023-04-22T01:52:44.000Z	0x9664f4210484c0d38886961cf87289e7478b5ab243ff82e1e7beced52634d231

Example Query

Query with partition filter

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

HighCovRatioFeePool_Swap_event

Token swap events from Wombat V2’s HighCovRatioFeePool contract on BNB Smart Chain. Tracks token exchanges with sender, recipient, input/output token addresses and amounts for analyzing liquidity pool trading activity.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x09460d2e03502e39352f1311b3e7b00aff0f23da	0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	365	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	959509763106219249	22938812	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	1000000000000000000	2022-11-10T15:43:20.000Z	0x99a5d723e786603b18a259d3cd7254232529663631ddff3445152e5f067fa129
0x29f82d09c2afd12f3c10ee49cd713331f4a7228e	0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	344	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	288540365917715954889	22945436	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	300000000000000000000	2022-11-10T21:20:27.000Z	0x00a421ff278c9bbb3fb0b8f8318038eed5755f52db01e28182ccc513a43c9e27
0x29f82d09c2afd12f3c10ee49cd713331f4a7228e	0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	144	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	192620876626933901302	22945060	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	200000000000000000000	2022-11-10T21:01:29.000Z	0xaf1c4be091740df57e7886e92d33d541cc8cad3602c5a9ba7489440fcaac0d10

Example Query

Query with partition filter

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

InnovationPool_SetFee_event

Fee configuration change events from Wombat Exchange Innovation Pools on BSC, tracking adjustments to LP dividend distribution ratios and protocol retention percentages. Used for monitoring revenue sharing parameter updates across 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.
`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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x48f6a8a0158031baf8ce3e45344518f1e69f2a14	false	1	23303325	2022-11-23T12:17:52.000Z	0xb7098f8a091493c0ae0fe7caa4627045d24316fcd57f0722abc127032eb539af	1000000000000000000	0
0x48f6a8a0158031baf8ce3e45344518f1e69f2a14	false	242	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

InnovationPool_SetHaircutRate_event

Haircut rate parameter changes for Wombat Exchange V2 innovation pools on BSC, where haircut rate controls slippage protection in stableswap AMM operations. Tracks protocol risk management adjustments with rates stored as basis points (e.g., 100000000000000 = 0.01%).

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x48f6a8a0158031baf8ce3e45344518f1e69f2a14	false	100000000000000	356	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0x48f6a8a0158031baf8ce3e45344518f1e69f2a14	false	300000000000000	126	25165591	2023-01-28T02:26:19.000Z	0x7cd041a384fb5f5f06ec86f0bd0a805e900a76925445d18c8330aa04be06c232
0x48f6a8a0158031baf8ce3e45344518f1e69f2a14	false	400000000000000	449	37533356	2024-04-03T09:56:05.000Z	0xfcc61b2894871b33654c477d55169a7aba38afceb480f79282bd75d359594744

Example Query

Query with partition filter

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

InnovationPool_setHaircutRate_function

Function call logs for Wombat Exchange V2 InnovationPool haircut rate parameter updates on BSC. Tracks administrative changes to the protocol’s haircut mechanism (withdrawal fee percentage) used for risk management in stablecoin 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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
125752	0	true	9896	0xf57e84d5	0x48f6a8a0158031baf8ce3e45344518f1e69f2a14	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,2	2023-04-18T04:36:03.000Z	100000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
20667	0	true	9896	0xf57e84d5	0x48f6a8a0158031baf8ce3e45344518f1e69f2a14	25165591	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,1	2023-01-28T02:26:19.000Z	300000000000000	0x7cd041a384fb5f5f06ec86f0bd0a805e900a76925445d18c8330aa04be06c232

Example Query

Query with partition filter

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

InnovationPool_Swap_event

Token swap events from Wombat Exchange v2 Innovation Pool on BNB Smart Chain (BSC). Captures input/output token addresses, amounts, sender and recipient for analyzing swap activity and liquidity flows in Wombat’s specialized stableswap 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	0x48f6a8a0158031baf8ce3e45344518f1e69f2a14	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	168	0x90c97f71e18723b0cf0dfa30ee176ab653e89f40	152398303770909186	32427716	0x55d398326f99059ff775485246999027b3197955	151658115340326304	2023-10-08T15:37:25.000Z	0x4bbaf0dc449041ade1f5c182bd2ea00753ab37d1a1687a394df70f60f6c17dff
0x1111111254eeb25477b68fb85ed929f73a960582	0x48f6a8a0158031baf8ce3e45344518f1e69f2a14	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	135	0x90c97f71e18723b0cf0dfa30ee176ab653e89f40	264130621004926665	32431533	0x55d398326f99059ff775485246999027b3197955	262854246915259122	2023-10-08T18:48:49.000Z	0x9dcfb2a64389ae2620f6b30a016cb3b50a79ab8221e80490a39f2c9df224b636
0x1111111254eeb25477b68fb85ed929f73a960582	0x48f6a8a0158031baf8ce3e45344518f1e69f2a14	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	324	0x90c97f71e18723b0cf0dfa30ee176ab653e89f40	248777378852496679	32411106	0x55d398326f99059ff775485246999027b3197955	247603243211039600	2023-10-08T01:44:16.000Z	0xbc9851639ccc73d4bb158204c95db2088de71582f6e299df11868bb72b11b62d

Example Query

Query with partition filter

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

IUsdPool_SetFee_event

Fee configuration change events from Wombat stableswap pools on BSC, capturing updates to retention ratio and LP (liquidity provider) dividend ratio parameters. Used to track protocol fee distribution policy changes between the protocol treasury and liquidity providers.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x277e777f7687239b092c8845d4d2cd083a33c903	false	4	25312809	2023-02-02T07:30:06.000Z	0x53140af7e41ecc8bdb42f9550f434bef62607219813389b01a6671c62ad4e07b	1000000000000000000	0
0x277e777f7687239b092c8845d4d2cd083a33c903	false	243	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

IUsdPool_SetHaircutRate_event

Haircut rate parameter changes for Wombat V2 USD pools on BNB Smart Chain (BSC). Records governance adjustments to the haircut rate (withdrawal fee percentage) with values stored in wei format for protocol risk management 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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x277e777f7687239b092c8845d4d2cd083a33c903	false	400000000000000	170	26009066	2023-02-26T18:40:48.000Z	0x7073d99b827267f50d6927dff6d9b1d0b40edb47c807580c7cee358d7f3b9237
0x277e777f7687239b092c8845d4d2cd083a33c903	false	100000000000000	357	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0x277e777f7687239b092c8845d4d2cd083a33c903	false	400000000000000	452	37533356	2024-04-03T09:56:05.000Z	0xfcc61b2894871b33654c477d55169a7aba38afceb480f79282bd75d359594744

Example Query

Query with partition filter

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

IUsdPool_setHaircutRate_function

Administrative function calls that update haircut rate parameters in Wombat’s USD stablecoin pool on BSC. Tracks governance changes to the risk penalty applied when withdrawals exceed pool liquidity thresholds.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
141460	0	true	9896	0xf57e84d5	0x277e777f7687239b092c8845d4d2cd083a33c903	26009066	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,0	2023-02-26T18:40:48.000Z	400000000000000	0x7073d99b827267f50d6927dff6d9b1d0b40edb47c807580c7cee358d7f3b9237
115070	0	true	9896	0xf57e84d5	0x277e777f7687239b092c8845d4d2cd083a33c903	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,3	2023-04-18T04:36:03.000Z	100000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7

Example Query

Query with partition filter

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

IUsdPool_Swap_event

Swap events from Wombat v2 USD stablecoin pool on BNP Smart Chain (BSC), recording token exchanges between stablecoins with sender, recipient, input/output amounts, and token addresses. Used for analyzing stablecoin swap volume, pricing, and liquidity provider activity in Wombat’s single-sided 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x33edc4c558c4badfe050d79f565632cf910573b6	0x277e777f7687239b092c8845d4d2cd083a33c903	false	0xc27d980b71d5978f8b6de9e1ba01ed001d8760d3	193	0xe9e7cea3dedca5984780bafc599bd69add087d56	10611071756307020507	32464282	0x0a3bb08b3a15a19b4de82f8acfc862606fb69a2d	10678479574267825304	2023-10-09T22:11:38.000Z	0xc3f8108d130d01b3b80c88233c19e81638a71cf0215fd87f4691a95cd6708274
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0x277e777f7687239b092c8845d4d2cd083a33c903	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	134	0xe9e7cea3dedca5984780bafc599bd69add087d56	105516544806882693416	29726465	0x0a3bb08b3a15a19b4de82f8acfc862606fb69a2d	106000000000000000000	2023-07-06T12:59:38.000Z	0x660254c84f7ec93cfa4c9ed3b35cc2471d93b394138ebe00cd3ea930219b2c08
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0x277e777f7687239b092c8845d4d2cd083a33c903	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	176	0xe9e7cea3dedca5984780bafc599bd69add087d56	641290700167142960	29730232	0x0a3bb08b3a15a19b4de82f8acfc862606fb69a2d	644306612222600450	2023-07-06T16:09:07.000Z	0x85818eaf14c1c6dcbc1c450d85c2dc43f07bdab1daca25a636d0cc74980025c6

Example Query

Query with partition filter

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

MasterWombat_Harvest_event

Reward harvest events from Wombat Exchange’s MasterWombat staking contract on BNB Chain, capturing when users claim accumulated rewards from liquidity pool positions (pid). Used for tracking yield farming activity and reward distribution patterns across different 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pid`	`STRING`	Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_pid	address	in_user	removed	log_index	block_number	block_timestamp	transaction_hash
7	0xe2c07d20af0fb50cae6cdd615ca44abaaa31f9c8	0x1b9f38e893ba4cf5c3a59d6b49ae5b6273899cfc	false	224	29238613	2023-06-19T13:11:50.000Z	0xc54bf96bfc2239b66fbce4fd044766b382f3cc4d997092be13c002e18ad90961
0	0xe2c07d20af0fb50cae6cdd615ca44abaaa31f9c8	0x3a3d69b847277b2493c1e24f13b07e4ae74525a0	false	547	29238609	2023-06-19T13:11:38.000Z	0x647a488be79b22103b5a38fa5b11351d80ea334acd3e08709f383486a25b4f0f
6	0xe2c07d20af0fb50cae6cdd615ca44abaaa31f9c8	0xa753c81b8d840923da3aaf5790e72ce3273ae852	false	400	29238612	2023-06-19T13:11:47.000Z	0xedfcca11d88b542d404626fe29f0891fdc4fb7df3ab172b685926f62c44b1e3d

Example Query

Query with partition filter

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

MimPool_SetFee_event

Fee configuration events from Wombat Exchange’s MIM stablecoin pool on BNB Smart Chain. Records changes to LP dividend and retention ratios for analyzing pool economics and revenue distribution.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0xb8b1b72a9b9ba90e2539348fec1ad6b265f9f684	false	0	26990305	2023-04-02T04:56:28.000Z	0x673bac0c81318d84334c243c003a7d2e3362d581188756b6b74265a28cccdac2	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

MimPool_SetHaircutRate_event

Haircut rate parameter update events from Wombat V2’s MIM stablecoin pool on BSC, tracking protocol risk management adjustments. Used to monitor changes in the haircut multiplier that affects withdrawal penalties during pool imbalances.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xb8b1b72a9b9ba90e2539348fec1ad6b265f9f684	false	100000000000000	541	27912423	2023-05-04T09:52:05.000Z	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67
0xb8b1b72a9b9ba90e2539348fec1ad6b265f9f684	false	400000000000000	457	37533356	2024-04-03T09:56:05.000Z	0xfcc61b2894871b33654c477d55169a7aba38afceb480f79282bd75d359594744

Example Query

Query with partition filter

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

MimPool_setHaircutRate_function

Administrative function calls that update the haircut rate parameter in Wombat Exchange’s MIM stablecoin pool on BSC. Tracks governance actions adjusting the penalty applied to withdrawals during imbalanced pool conditions.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
337575	0	true	9865	0xf57e84d5	0xb8b1b72a9b9ba90e2539348fec1ad6b265f9f684	27912423	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	1,0,0,5	2023-05-04T09:52:05.000Z	100000000000000	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67

Example Query

Query with partition filter

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

MimPool_Swap_event

Token swap events from Wombat Exchange’s MIM stablecoin pool on BNB Smart Chain (BSC). Records token exchanges with sender/recipient addresses, input/output token addresses, and swap amounts for analyzing MIM pool trading activity and liquidity flows.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	0xb8b1b72a9b9ba90e2539348fec1ad6b265f9f684	false	0x170d2ed0b2a5d9f450652be814784f964749ffa4	332	0xfe19f0b51438fd612f6fd59c1dbb3ea319f433ba	34083120422607848472	30742490	0x55d398326f99059ff775485246999027b3197955	33953024000000000000	2023-08-10T22:15:16.000Z	0x57af0ba43f28164b2d0f17a41bf78c3076727c67c4459e357b602b4638c09a2f
0xad3b67bca8935cb510c8d18bd45f0b94f54a968f	0xb8b1b72a9b9ba90e2539348fec1ad6b265f9f684	false	0x170d2ed0b2a5d9f450652be814784f964749ffa4	57	0xfe19f0b51438fd612f6fd59c1dbb3ea319f433ba	131981190968726450400	30740327	0x55d398326f99059ff775485246999027b3197955	131608700000000000000	2023-08-10T20:26:52.000Z	0x359cc52f01d7d55746c3af304f1fd364ee6d0ca1f1468fbb2e14cb1472f02203
0x1111111254eeb25477b68fb85ed929f73a960582	0xb8b1b72a9b9ba90e2539348fec1ad6b265f9f684	false	0x170d2ed0b2a5d9f450652be814784f964749ffa4	702	0xfe19f0b51438fd612f6fd59c1dbb3ea319f433ba	50194189782883798	30741719	0x55d398326f99059ff775485246999027b3197955	50000000000000000	2023-08-10T21:36:36.000Z	0xc921bbefa17d1da72179701f5ff3bc0545cb1b8726273e9ad9b5a935cd26a894

Example Query

Query with partition filter

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

MWOMPool_SetFee_event

Fee configuration change events from Wombat Exchange’s mWOM staking pools on BSC, capturing retention and LP dividend ratio adjustments. Used to track protocol fee distribution policy changes and their timing.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	false	251	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000
0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	false	0	22698245	2022-11-02T03:44:59.000Z	0xe26c9a58773f509d6afb87743879026d77f2a96ad2f148d7d54dfe8ff1ab7662	1000000000000000000	0

Example Query

Query with partition filter

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

MWOMPool_SetHaircutRate_event

Haircut rate adjustment events from Wombat Exchange’s mWOM pool contracts on BSC, tracking risk parameter changes that affect asset withdrawal penalties. Used for monitoring pool configuration changes and risk management policy updates.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	false	100000000000000	544	27912423	2023-05-04T09:52:05.000Z	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67
0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	false	2000000000000000	367	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	false	2000000000000000	226	27931802	2023-05-05T02:02:18.000Z	0xf7c7457aa184d11ee75cc4b1b2dc9e37a1655dc67e9f8988ab4892a3474e35c2

Example Query

Query with partition filter

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

MWOMPool_setHaircutRate_function

Administrative function calls that update the haircut rate parameter in Wombat V2 mWOM pools on BSC. Used for tracking protocol risk parameter adjustments and governance actions over time.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
24927	true	9896	0xf57e84d5	0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,13	2023-04-18T04:36:03.000Z	2000000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
31327	true	9896	0xf57e84d5	0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	27931802	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,0	2023-05-05T02:02:18.000Z	2000000000000000	0xf7c7457aa184d11ee75cc4b1b2dc9e37a1655dc67e9f8988ab4892a3474e35c2
305589	true	9896	0xf57e84d5	0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	27912423	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	1,0,0,8	2023-05-04T09:52:05.000Z	100000000000000	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67

Example Query

Query with partition filter

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

MWOMPool_Swap_event

Token swap events from Wombat Exchange V2 mWOM pools on BNB Smart Chain (BSC). Captures input/output token addresses and amounts for analyzing liquidity pool trading activity and price impact.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0xac29c5b9eefc7c3d83b59b0fa0aec16ff2697636	0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	41	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	13230112397092621727842	26379622	0x027a9d301fb747cd972cfb29a63f3bda551dfc5c	16674192757294547216683	2023-03-11T18:37:28.000Z	0x61e50f53afd2f430317e643582e1b06a32182ac504646bfae1a13f8264b879cd
0xe4b0aa0dc4c73f8d4b78564d5100d544876199c7	0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	37	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	63704497442424011414	26369380	0x027a9d301fb747cd972cfb29a63f3bda551dfc5c	80544547780829964953	2023-03-11T10:00:23.000Z	0xc273d44de81ba18f390a7ebc46135c74779037344f3afac8b66689ba93446001
0x7e42eac95ea2bb41595b48bf2e6c453d6ca8d49e	0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	178	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	317654688737316504718	26378574	0x027a9d301fb747cd972cfb29a63f3bda551dfc5c	398441504385139473326	2023-03-11T17:44:16.000Z	0x06d93c482d016c149c510ce0e92be77396395aaf0789a199198ab2cb94ca812f

Example Query

Query with partition filter

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

Pool_SetFee_event

Fee parameter update events from Wombat V2 liquidity pools on BSC, recording changes to LP (liquidity provider) dividend ratios and protocol retention ratios. Used for tracking fee structure modifications and revenue distribution changes across pool configurations.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	false	1	17048658	2022-04-18T08:59:54.000Z	0x68efe7db33e9d44a3f34d17c7d17cbc7df77f46affb73daed8cfd6c7e30bebaa	1000000000000000000	0
0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	false	240	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

Pool_SetHaircutRate_event

Haircut rate configuration events from Wombat Exchange V2 liquidity pools on BSC, recording risk parameter adjustments that control withdrawal penalties during imbalanced pool conditions. Used for tracking pool risk management and governance parameter 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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	false	20000000000000	107	31102825	2023-08-23T11:39:39.000Z	0x16542e0b1fe834fd96f984b05e58dd778a371bb4e50a9d164178c111b5e08bbd
0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	false	100000000000000	354	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	false	400000000000000	122	36294356	2024-02-20T07:11:01.000Z	0xadd904c2ab48a12e5abb760a824cf6c5332105ca90b8e8ba6e2192107d8a39f8

Example Query

Query with partition filter

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

Pool_setHaircutRate_function

Pool haircut rate parameter updates for Wombat V2 stableswap protocol on BSC (Binance Smart Chain). Tracks administrative changes to the haircut rate, a risk parameter that determines withdrawal fees during pool imbalances.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
204288	true	9915	0xf57e84d5	0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	31102825	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	1,0,0	2023-08-23T11:39:39.000Z	20000000000000	0x16542e0b1fe834fd96f984b05e58dd778a371bb4e50a9d164178c111b5e08bbd
142918	true	5652	0xf57e84d5	0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,0	2023-04-18T04:36:03.000Z	100000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
15943	true	14415	0xf57e84d5	0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	36294356	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0	2024-02-20T07:11:01.000Z	400000000000000	0xadd904c2ab48a12e5abb760a824cf6c5332105ca90b8e8ba6e2192107d8a39f8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_bsc.Pool_setHaircutRate_function`
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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x1111111254fb6c44bac0bed2854e76f90643097d	0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	false	0x18101ac1d35230f1a3c005e2abaaeb25cae79e7f	287	0x55d398326f99059ff775485246999027b3197955	403443680997830314484	24547768	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	403369330035022087407	2023-01-06T10:01:55.000Z	0x85e80909f4541bdfc8bbf3b9d872820089d6fc94b07314c9c4542092115612aa
0x1111111254fb6c44bac0bed2854e76f90643097d	0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	false	0x18101ac1d35230f1a3c005e2abaaeb25cae79e7f	191	0xe9e7cea3dedca5984780bafc599bd69add087d56	19997163829051351590	24557040	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	20000000000000000000	2023-01-06T17:52:19.000Z	0xc6e47f7f7c50e641d5d19843acac3f9a4c82c3a510b0ddd6c400c1c97eb015ab
0x1111111254fb6c44bac0bed2854e76f90643097d	0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	false	0x18101ac1d35230f1a3c005e2abaaeb25cae79e7f	120	0xe9e7cea3dedca5984780bafc599bd69add087d56	12487994448299944484	24564088	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	12490000000000000000	2023-01-06T23:46:19.000Z	0x299cf0908e940c05055cf96ccdfb8d0237c0793895c795efcbb80c9a1a3a2ec9

Example Query

Query with partition filter

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

QWOMPool_SetFee_event

Fee parameter update events from Wombat Exchange v2 QWOM pools on BNB Smart Chain, recording changes to LP dividend ratios and retention ratios with 18-decimal precision values.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x2c5464b9052319e3d76f8279031f04e4b7fd7955	false	0	23097302	2022-11-16T05:58:19.000Z	0x0e9cee5ea716aad16d2e904632535e8e9c39afaaafe6eace2c66045a92675391	1000000000000000000	0
0x2c5464b9052319e3d76f8279031f04e4b7fd7955	false	252	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

QWOMPool_SetHaircutRate_event

Haircut rate parameter updates for Wombat’s qWOM pool on BSC, capturing governance changes to the withdrawal penalty rate applied when pool balance falls below coverage ratio. Used for analyzing risk parameter adjustments and pool configuration history.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x2c5464b9052319e3d76f8279031f04e4b7fd7955	false	2000000000000000	368	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0x2c5464b9052319e3d76f8279031f04e4b7fd7955	false	2000000000000000	227	27931802	2023-05-05T02:02:18.000Z	0xf7c7457aa184d11ee75cc4b1b2dc9e37a1655dc67e9f8988ab4892a3474e35c2
0x2c5464b9052319e3d76f8279031f04e4b7fd7955	false	100000000000000	545	27912423	2023-05-04T09:52:05.000Z	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67

Example Query

Query with partition filter

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

QWOMPool_setHaircutRate_function

Administrative function calls that update the haircut rate parameter in Wombat V2’s QWOM pools on BNB Chain. Used to track risk parameter adjustments and governance actions affecting withdrawal penalties during liquidity imbalances.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
14244	true	9896	0xf57e84d5	0x2c5464b9052319e3d76f8279031f04e4b7fd7955	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,14	2023-04-18T04:36:03.000Z	2000000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
20645	true	9896	0xf57e84d5	0x2c5464b9052319e3d76f8279031f04e4b7fd7955	27931802	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,1	2023-05-05T02:02:18.000Z	2000000000000000	0xf7c7457aa184d11ee75cc4b1b2dc9e37a1655dc67e9f8988ab4892a3474e35c2
294906	true	9896	0xf57e84d5	0x2c5464b9052319e3d76f8279031f04e4b7fd7955	27912423	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	1,0,0,9	2023-05-04T09:52:05.000Z	100000000000000	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67

Example Query

Query with partition filter

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

QWOMPool_Swap_event

Token swap events from Wombat Exchange’s qWOM pool on BNB Smart Chain (BSC). Records token-to-token exchanges including sender, recipient, input/output tokens and amounts for analyzing pool trading activity and liquidity flows.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x0db1f475e841948777eaaa6519efeb6e4d01648c	0x2c5464b9052319e3d76f8279031f04e4b7fd7955	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	71	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	12350934895351434319474	24605162	0x0fe34b8aaaf3f522a6088e278936d10f934c0b19	19547536410951301318763	2023-01-08T10:10:55.000Z	0x0a7f371b8dd77406a8537b8295570a03b2891efbd9e872cec3f6c32a93e3c861
0x4fe6b3c5f964ae3cd6f9771254364718892b2253	0x2c5464b9052319e3d76f8279031f04e4b7fd7955	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	496	0x0fe34b8aaaf3f522a6088e278936d10f934c0b19	16043999999999999619417	24605011	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	10217394387736182794943	2023-01-08T10:03:06.000Z	0x0acf84927770c41a07670bf80c02e1c39fd11643927ded97a7fef1d4ae769f6f
0x6d1cb0e25ea525c4e08b29fbd992fd16f0fc3579	0x2c5464b9052319e3d76f8279031f04e4b7fd7955	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	103	0x0fe34b8aaaf3f522a6088e278936d10f934c0b19	15863151538623881627	24604095	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	10000000000000000000	2023-01-08T09:17:15.000Z	0x02615a56ba7ba661c2227733cb01888be9d2166eb8689c27535a4b6e6369e6c5

Example Query

Query with partition filter

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

SidePool_SetFee_event

Fee configuration change events from Wombat Exchange V2 SidePool contracts on BSC, capturing updates to LP dividend ratios and retention ratios. Used for tracking protocol fee parameter adjustments and revenue distribution mechanisms.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x0520451b19ad0bb00ed35ef391086a692cfc74b2	false	241	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000
0x0520451b19ad0bb00ed35ef391086a692cfc74b2	false	10	21370882	2022-09-16T02:40:48.000Z	0x0ce15bab68b19e27fb897b86d2e112099b9915d12d43eefc0c94051df465b6ba	1000000000000000000	0

Example Query

Query with partition filter

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

SidePool_SetHaircutRate_event

Haircut rate parameter changes for Wombat v2 SidePools on BSC, where haircut rate controls withdrawal penalties during imbalanced liquidity conditions. Used for tracking risk parameter adjustments and protocol governance decisions.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x0520451b19ad0bb00ed35ef391086a692cfc74b2	false	200000000000000	125	25165591	2023-01-28T02:26:19.000Z	0x7cd041a384fb5f5f06ec86f0bd0a805e900a76925445d18c8330aa04be06c232
0x0520451b19ad0bb00ed35ef391086a692cfc74b2	false	100000000000000	355	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0x0520451b19ad0bb00ed35ef391086a692cfc74b2	false	20000000000000	178	31529810	2023-09-07T09:04:56.000Z	0x39146d380e970da7d1904e77fe6468a5aecdbee38d9b15d0b27be24d4cee8fcb

Example Query

Query with partition filter

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

SidePool_setHaircutRate_function

Haircut rate parameter updates for Wombat V2 SidePool contracts on BNB Smart Chain, tracking protocol risk adjustments made by admin addresses. Used for monitoring liquidity pool safety parameter changes and governance activity.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
31328	true	9874	0xf57e84d5	0x0520451b19ad0bb00ed35ef391086a692cfc74b2	25165591	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,0	2023-01-28T02:26:19.000Z	200000000000000	0x7cd041a384fb5f5f06ec86f0bd0a805e900a76925445d18c8330aa04be06c232
15943	true	14415	0xf57e84d5	0x0520451b19ad0bb00ed35ef391086a692cfc74b2	31529810	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	1,0,0	2023-09-07T09:04:56.000Z	20000000000000	0x39146d380e970da7d1904e77fe6468a5aecdbee38d9b15d0b27be24d4cee8fcb
136413	true	9874	0xf57e84d5	0x0520451b19ad0bb00ed35ef391086a692cfc74b2	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,1	2023-04-18T04:36:03.000Z	100000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7

Example Query

Query with partition filter

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

SidePool_Swap_event

Token swap events from Wombat V2 SidePool contracts on BNB Smart Chain (BSC). Records swap execution details including sender, recipient, token addresses, and amounts for analyzing stablecoin trading activity and liquidity 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x01408149497e99cf93d920c3145b1fe553ba2257	0x0520451b19ad0bb00ed35ef391086a692cfc74b2	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	116	0x0782b6d8c4551b9760e74c0545a9bcd90bdc41e5	63011478264359388669	25781235	0xe9e7cea3dedca5984780bafc599bd69add087d56	63060849773266033337	2023-02-18T18:41:10.000Z	0x0e843da56ea1d3b5d3905a63aa54260eb9770d20e7d18dfb475e4101051615e8
0x1111111254eeb25477b68fb85ed929f73a960582	0x0520451b19ad0bb00ed35ef391086a692cfc74b2	false	0x7f9e3430880580713b03670046c7e89a0a91403b	334	0x0782b6d8c4551b9760e74c0545a9bcd90bdc41e5	118000360583646926775	25778013	0xe9e7cea3dedca5984780bafc599bd69add087d56	118085979981611618500	2023-02-18T15:55:18.000Z	0x6324f3a05bb34378cede8001a87d0fb6582d3f745292c339a16147c70455004c
0x1111111254eeb25477b68fb85ed929f73a960582	0x0520451b19ad0bb00ed35ef391086a692cfc74b2	false	0x7f9e3430880580713b03670046c7e89a0a91403b	302	0x0782b6d8c4551b9760e74c0545a9bcd90bdc41e5	317687168136806646972	25766382	0xe9e7cea3dedca5984780bafc599bd69add087d56	317897681391922109457	2023-02-18T06:07:21.000Z	0x1482dc14463f8e6c9ab71c70e35fa298a7d7d4bab26a499cd08f7e06736ccb5c

Example Query

Query with partition filter

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

SktBnbPool_SetFee_event

Fee configuration change events from Wombat V2’s staked BNB pool contract on BSC, tracking updates to LP dividend ratios and retention ratios. Used for analyzing fee structure modifications and reward distribution parameters in the stablecoin AMM 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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0	false	249	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000
0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0	false	0	25257317	2023-01-31T08:15:32.000Z	0x8e01c6acdf9c007716d11b6fa873c65cf1a9a18047b224a7d0530625dc14adb9	1000000000000000000	0

Example Query

Query with partition filter

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

SktBnbPool_SetHaircutRate_event

Haircut rate parameter changes for Wombat’s sktBNB stablecoin pool on BSC, tracking risk management adjustments that affect withdrawal penalties during imbalanced liquidity conditions. Used for monitoring pool safety parameters and governance decisions.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0	false	1000000000000000	363	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0	false	400000000000000	164	27710406	2023-04-27T09:16:35.000Z	0xd58b308027dab85edf30ce6c542ed06c4c29b57aad39a30fe2e749f7c33f1dd2
0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0	false	100000000000000	543	27912423	2023-05-04T09:52:05.000Z	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67

Example Query

Query with partition filter

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

SktBnbPool_setHaircutRate_function

Haircut rate parameter updates for Wombat’s SktBnb pool on BSC, tracking protocol risk adjustments that affect withdrawal penalties during volatile market conditions. Used to analyze how the protocol manages pool solvency and user exit costs over time.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
316271	true	9896	0xf57e84d5	0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0	27912423	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	1,0,0,7	2023-05-04T09:52:05.000Z	100000000000000	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67
46253	true	9896	0xf57e84d5	0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0	27710406	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,1	2023-04-27T09:16:35.000Z	400000000000000	0xd58b308027dab85edf30ce6c542ed06c4c29b57aad39a30fe2e749f7c33f1dd2
55171	true	5696	0xf57e84d5	0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,9	2023-04-18T04:36:03.000Z	1000000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7

Example Query

Query with partition filter

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

SktBnbPool_Swap_event

Swap events from Wombat V2’s staked BNB (sktBNB) pool on BSC, capturing token exchanges between WBNB and sktBNB with amounts, participants, and exchange rates. Useful for analyzing liquidity pool activity and liquid staking swap 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0xd0e226f674bbf064f54ab47f42473ff80db98cba	0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0	false	0x6827ab5b01b02a594d9d36f2ffa787f6c7c5a72d	297	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	190411942266221805	32703042	0xc2e9d07f66a89c44062459a47a0d2dc038e4fb16	184613357896834747	2023-10-18T05:53:41.000Z	0xd57f46b0d08d6aee2091d684b0217eb1e011dc7d2aaa61582e020f809b2b1b7d
0x00000000000e8716b4e2d12400a01474cdfad760	0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0	false	0x00000000000e8716b4e2d12400a01474cdfad760	138	0xc2e9d07f66a89c44062459a47a0d2dc038e4fb16	9936697780182501867	31997163	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	10223000000000000000	2023-09-23T15:38:46.000Z	0x747727490d54fb4a45133581220704f438345dbc8a43f84cf008b133ad82e39a
0xf8a1527325bb62d6d0320eb2312748d590f1ce27	0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0	false	0xf8a1527325bb62d6d0320eb2312748d590f1ce27	48	0xc2e9d07f66a89c44062459a47a0d2dc038e4fb16	4857667096381088522	31997326	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	5000000000000000000	2023-09-23T15:46:55.000Z	0xde84ec10e5b3fe956c855889a79baaf90e10cdf6debd166c3110c756842db200

Example Query

Query with partition filter

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

UsddPool_SetFee_event

Fee configuration change events from the Wombat Exchange USDD stablecoin pool on BSC, tracking updates to liquidity provider (LP) dividend ratios and protocol retention ratios. Used for analyzing fee structure evolution and revenue distribution between LPs and the 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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x05f727876d7c123b9bb41507251e2afd81ead09a	false	246	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000
0x05f727876d7c123b9bb41507251e2afd81ead09a	false	0	25654346	2023-02-14T07:34:44.000Z	0x36a1133604a3546d38b54d52de11c67ca6f5cf177109a583e8f8674abdafeef3	1000000000000000000	0

Example Query

Query with partition filter

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

UsddPool_SetHaircutRate_event

Haircut rate parameter changes for the USDD stablecoin pool in Wombat V2 protocol on BSC. Tracks risk management adjustments that affect swap slippage and withdrawal penalties during pool imbalances.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x05f727876d7c123b9bb41507251e2afd81ead09a	false	400000000000000	172	26009066	2023-02-26T18:40:48.000Z	0x7073d99b827267f50d6927dff6d9b1d0b40edb47c807580c7cee358d7f3b9237
0x05f727876d7c123b9bb41507251e2afd81ead09a	false	100000000000000	360	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0x05f727876d7c123b9bb41507251e2afd81ead09a	false	400000000000000	454	37533356	2024-04-03T09:56:05.000Z	0xfcc61b2894871b33654c477d55169a7aba38afceb480f79282bd75d359594744

Example Query

Query with partition filter

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

UsddPool_setHaircutRate_function

Function call records for haircut rate adjustments on Wombat Exchange’s USDD stablecoin pool on BSC. Tracks governance parameter changes that affect withdrawal penalties during pool imbalances.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
120095	0	true	9865	0xf57e84d5	0x05f727876d7c123b9bb41507251e2afd81ead09a	26009066	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,2	2023-02-26T18:40:48.000Z	400000000000000	0x7073d99b827267f50d6927dff6d9b1d0b40edb47c807580c7cee358d7f3b9237
83023	0	true	9865	0xf57e84d5	0x05f727876d7c123b9bb41507251e2afd81ead09a	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,6	2023-04-18T04:36:03.000Z	100000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7

Example Query

Query with partition filter

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

UsddPool_Swap_event

Token swap events from Wombat Exchange’s USDD stablecoin pool on BNB Smart Chain. Records swaps between USDD and USDC tokens with input/output amounts, participants, and transaction details for analyzing stablecoin liquidity and 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.
`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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x96794f03b3114f50b892b0dec79d753658c931ee	0x05f727876d7c123b9bb41507251e2afd81ead09a	false	0x484571309d6a9e9285fc0b4634acd43bd0ba97d8	214	0xd17479997f34dd9156deef8f95a52d81d265be9c	120919339118382617645	32135521	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	120791664308975861760	2023-09-28T11:15:47.000Z	0x1d47bec9be864c9fdc89caaf33019c8a7120b61c97a3a7a3008d0fdc769014e2
0x4f04c39399b7d6e81adbdbc1ad451524d6b3d9e4	0x05f727876d7c123b9bb41507251e2afd81ead09a	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	190	0xd17479997f34dd9156deef8f95a52d81d265be9c	10029853219499893193	32135515	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	9996752169257711821	2023-09-28T11:15:29.000Z	0x62e161a2f63e9b7a6bcbca0348b5b1c307f00efb535ab7909e5088cc8edf514e
0xc27d980b71d5978f8b6de9e1ba01ed001d8760d3	0x05f727876d7c123b9bb41507251e2afd81ead09a	false	0xc27d980b71d5978f8b6de9e1ba01ed001d8760d3	126	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	99854649010033174469	32127347	0xd17479997f34dd9156deef8f95a52d81d265be9c	100049082062756329722	2023-09-28T04:25:13.000Z	0x60c4dc179c0f1f5f629030ebfb6ae0afdc65df83487800babf954b031fb48d17

Example Query

Query with partition filter

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

UsdPlusPool_SetFee_event

Fee configuration events from Wombat Exchange’s USD+ pool on BSC, capturing changes to LP dividend and retention ratios. Used for tracking fee structure adjustments and revenue distribution parameters over time.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x9498563e47d7cfdfa22b818bb8112781036c201c	false	0	26990985	2023-04-02T05:30:29.000Z	0x53ad2bd658f96d2eda0795458c1a6331547b2423004ead2051587aa06b7344b3	500000000000000000	500000000000000000
0x9498563e47d7cfdfa22b818bb8112781036c201c	false	94	27020817	2023-04-03T06:58:52.000Z	0x2db647ace5b6143a7455ce439b8cde4ac4c85e5ac57573b071800aaca67ebc08	0	500000000000000000

Example Query

Query with partition filter

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

UsdPlusPool_SetHaircutRate_event

Haircut rate configuration events from Wombat Exchange’s USD+ stablecoin pool on BSC, tracking risk parameter adjustments that affect withdrawal penalties during pool imbalances. Used for monitoring protocol risk management and liquidity conditions.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x9498563e47d7cfdfa22b818bb8112781036c201c	false	100000000000000	542	27912423	2023-05-04T09:52:05.000Z	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67
0x9498563e47d7cfdfa22b818bb8112781036c201c	false	400000000000000	456	37533356	2024-04-03T09:56:05.000Z	0xfcc61b2894871b33654c477d55169a7aba38afceb480f79282bd75d359594744

Example Query

Query with partition filter

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

UsdPlusPool_setHaircutRate_function

Administrative function calls that update the haircut rate parameter in Wombat Exchange’s USD+ liquidity pool on BSC. Used for tracking pool risk parameter adjustments and governance actions by pool operators.

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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
326923	0	true	9865	0xf57e84d5	0x9498563e47d7cfdfa22b818bb8112781036c201c	27912423	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	1,0,0,6	2023-05-04T09:52:05.000Z	100000000000000	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67

Example Query

Query with partition filter

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

UsdPlusPool_Swap_event

Swap event records from Wombat Exchange’s USD+ stablecoin pool on BSC, capturing token exchanges with sender, recipient, input/output tokens and amounts. Used for analyzing stablecoin trading patterns and liquidity pool activity.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x6ce6b65c5e2d177cf0b2bfa219848dbb5f3684fb	0x9498563e47d7cfdfa22b818bb8112781036c201c	false	0x6ce6b65c5e2d177cf0b2bfa219848dbb5f3684fb	138	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	551686609788263842517	27835586	0x5335e87930b410b8c5bb4d43c3360aca15ec0c8c	551367119330369391964	2023-05-01T17:44:03.000Z	0xab96383b778a81d66fcac25c7a17f0c3bc448a823513632466f329ad4e3256bb
0x14831f12fccc86c4f3dae41c769593df766e4353	0x9498563e47d7cfdfa22b818bb8112781036c201c	false	0x14831f12fccc86c4f3dae41c769593df766e4353	146	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	215374505199376473364	27829736	0x5335e87930b410b8c5bb4d43c3360aca15ec0c8c	215096325088987617814	2023-05-01T12:51:02.000Z	0x9032ac557663979241ee1078fa1214615323bfb43a54869ed69b90865a1ba1d7
0x14831f12fccc86c4f3dae41c769593df766e4353	0x9498563e47d7cfdfa22b818bb8112781036c201c	false	0x14831f12fccc86c4f3dae41c769593df766e4353	55	0xe80772eaf6e2e18b651f160bc9158b2a5cafca65	5014490360	27841880	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	5000000000000000000000	2023-05-01T22:59:15.000Z	0xe6ad786aa623eae8f1538725b187c532ef25fb1512db2d3f606128ac56b59a70

Example Query

Query with partition filter

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

WmxWOMPool_SetFee_event

Fee configuration change events from Wombat Exchange’s WMX pool contract on BSC, capturing retention ratio and LP dividend ratio parameters. Values are in 18-decimal wei format where 1e18 represents 100% allocation.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	false	250	26050581	2023-02-28T05:35:51.000Z	0x9b3c981aec32bcb46701676a746bc8e4ed92e2e0a11f1cc984a8e2cb9462de4b	500000000000000000	500000000000000000
0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	false	0	22476393	2022-10-25T08:03:17.000Z	0xc5ced731d4b877c306fdbff335855b8862998f8aba6109027a8cbaae7c99d37b	1000000000000000000	0

Example Query

Query with partition filter

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

WmxWOMPool_SetHaircutRate_event

Haircut rate configuration changes for Wombat Exchange liquidity pools on BNB Chain, tracking risk parameter adjustments that affect withdrawal penalties. Used for analyzing pool risk management and liquidity provider protection mechanisms.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	false	2000000000000000	366	27446153	2023-04-18T04:36:03.000Z	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7
0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	false	2000000000000000	228	27931802	2023-05-05T02:02:18.000Z	0xf7c7457aa184d11ee75cc4b1b2dc9e37a1655dc67e9f8988ab4892a3474e35c2
0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	false	100000000000000	546	27912423	2023-05-04T09:52:05.000Z	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67

Example Query

Query with partition filter

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

WmxWOMPool_setHaircutRate_function

Function calls to setHaircutRate on Wombex WOM Pool contracts on BSC, recording haircut rate parameter adjustments. Used for tracking liquidity pool risk parameter changes and governance actions in the Wombex 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.
`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`	`NUMERIC`	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_haircutRate_`	`STRING`	Haircut rate parameter passed to the setHaircutRate function. String-encoded integer representing a basis point value used in liquidity pool calculations.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_haircutRate_	transaction_hash
9962	true	9874	0xf57e84d5	0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	27931802	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,2	2023-05-05T02:02:18.000Z	2000000000000000	0xf7c7457aa184d11ee75cc4b1b2dc9e37a1655dc67e9f8988ab4892a3474e35c2
284224	true	9874	0xf57e84d5	0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	27912423	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	1,0,0,10	2023-05-04T09:52:05.000Z	100000000000000	0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67
35588	true	9874	0xf57e84d5	0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	27446153	0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48	0,0,12	2023-04-18T04:36:03.000Z	2000000000000000	0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7

Example Query

Query with partition filter

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

WmxWOMPool_Swap_event

Token swap events from Wombat Exchange’s WOM pool on BNB Smart Chain (BSC), recording token-to-token exchanges with sender addresses, input/output token addresses, and swap amounts. Used for analyzing liquidity pool activity and trading patterns in the Wombat stablecoin 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x3eb1686b9d0001f1703717e2362eeb3553a64060	0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	376	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	121767921025197619429	25341413	0x0415023846ff1c6016c4d9621de12b24b2402979	138563340155425921873	2023-02-03T07:43:01.000Z	0xbaf37fcdd80b2cd7c4bbf3f3848a544cb9c4d7da30df4132c1f235ddd8518656
0xfb98314c176bfc1ff689766dc799e1d89a3c633a	0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	52	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	69794342835701859548	25332425	0x0415023846ff1c6016c4d9621de12b24b2402979	79894999978056157485	2023-02-03T00:04:21.000Z	0xcdeacd4cd34ef0f4afa91f3b00904fe5e9753c497a0864ac5e726be563b3c391
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	151	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	1233635651903331903467	25355799	0x0415023846ff1c6016c4d9621de12b24b2402979	1398994884340346421203	2023-02-03T19:54:03.000Z	0x94e860f742b10783765d48af7610dbc995d667dc2d4c22189a638576fed349f8

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​AxlUsdcPool_SetFee_event

​AxlUsdcPool_SetHaircutRate_event

​AxlUsdcPool_setHaircutRate_function

​AxlUsdcPool_Swap_event

​BnbxPool_SetFee_event

​BnbxPool_SetHaircutRate_event

​BnbxPool_setHaircutRate_function

​BnbxPool_Swap_event

​BobPool_SetFee_event

​BobPool_SetHaircutRate_event

​BobPool_setHaircutRate_function

​BobPool_Swap_event

​CrossChainPool_SetFee_event

​CrossChainPool_SetHaircutRate_event

​CrossChainPool_SwapV2_event

​CUsdPool_SetFee_event

​CUsdPool_SetHaircutRate_event

​CUsdPool_setHaircutRate_function

​CUsdPool_Swap_event

​DynamicPool_SetFee_event

​DynamicPool_SetHaircutRate_event

​DynamicPool_setHaircutRate_function

​DynamicPool_Swap_event

​FraxEthPool_SetFee_event

​FraxEthPool_SetHaircutRate_event

​FraxEthPool_setHaircutRate_function

​FraxEthPool_Swap_event

​HighCovRatioFeePool_Swap_event

​InnovationPool_SetFee_event

​InnovationPool_SetHaircutRate_event

​InnovationPool_setHaircutRate_function

​InnovationPool_Swap_event

​IUsdPool_SetFee_event

​IUsdPool_SetHaircutRate_event

​IUsdPool_setHaircutRate_function

​IUsdPool_Swap_event

​MasterWombat_Harvest_event

​MimPool_SetFee_event

​MimPool_SetHaircutRate_event

​MimPool_setHaircutRate_function

​MimPool_Swap_event

​MWOMPool_SetFee_event

​MWOMPool_SetHaircutRate_event

​MWOMPool_setHaircutRate_function

​MWOMPool_Swap_event

​Pool_SetFee_event

​Pool_SetHaircutRate_event

​Pool_setHaircutRate_function

​Pool_Swap_event

​QWOMPool_SetFee_event

​QWOMPool_SetHaircutRate_event

​QWOMPool_setHaircutRate_function

​QWOMPool_Swap_event

​SidePool_SetFee_event

​SidePool_SetHaircutRate_event

​SidePool_setHaircutRate_function

​SidePool_Swap_event

​SktBnbPool_SetFee_event

​SktBnbPool_SetHaircutRate_event

​SktBnbPool_setHaircutRate_function

​SktBnbPool_Swap_event

​UsddPool_SetFee_event

​UsddPool_SetHaircutRate_event

​UsddPool_setHaircutRate_function

​UsddPool_Swap_event

​UsdPlusPool_SetFee_event

​UsdPlusPool_SetHaircutRate_event

​UsdPlusPool_setHaircutRate_function

​UsdPlusPool_Swap_event

​WmxWOMPool_SetFee_event

​WmxWOMPool_SetHaircutRate_event

​WmxWOMPool_setHaircutRate_function

​WmxWOMPool_Swap_event

Tables

AxlUsdcPool_SetFee_event

AxlUsdcPool_SetHaircutRate_event

AxlUsdcPool_setHaircutRate_function

AxlUsdcPool_Swap_event

BnbxPool_SetFee_event

BnbxPool_SetHaircutRate_event

BnbxPool_setHaircutRate_function

BnbxPool_Swap_event

BobPool_SetFee_event

BobPool_SetHaircutRate_event

BobPool_setHaircutRate_function

BobPool_Swap_event

CrossChainPool_SetFee_event

CrossChainPool_SetHaircutRate_event

CrossChainPool_SwapV2_event

CUsdPool_SetFee_event

CUsdPool_SetHaircutRate_event

CUsdPool_setHaircutRate_function

CUsdPool_Swap_event

DynamicPool_SetFee_event

DynamicPool_SetHaircutRate_event

DynamicPool_setHaircutRate_function

DynamicPool_Swap_event

FraxEthPool_SetFee_event

FraxEthPool_SetHaircutRate_event

FraxEthPool_setHaircutRate_function

FraxEthPool_Swap_event

HighCovRatioFeePool_Swap_event

InnovationPool_SetFee_event

InnovationPool_SetHaircutRate_event

InnovationPool_setHaircutRate_function

InnovationPool_Swap_event

IUsdPool_SetFee_event

IUsdPool_SetHaircutRate_event

IUsdPool_setHaircutRate_function

IUsdPool_Swap_event

MasterWombat_Harvest_event

MimPool_SetFee_event

MimPool_SetHaircutRate_event

MimPool_setHaircutRate_function

MimPool_Swap_event

MWOMPool_SetFee_event

MWOMPool_SetHaircutRate_event

MWOMPool_setHaircutRate_function

MWOMPool_Swap_event

Pool_SetFee_event

Pool_SetHaircutRate_event

Pool_setHaircutRate_function

Pool_Swap_event

QWOMPool_SetFee_event

QWOMPool_SetHaircutRate_event

QWOMPool_setHaircutRate_function

QWOMPool_Swap_event

SidePool_SetFee_event

SidePool_SetHaircutRate_event

SidePool_setHaircutRate_function

SidePool_Swap_event

SktBnbPool_SetFee_event

SktBnbPool_SetHaircutRate_event

SktBnbPool_setHaircutRate_function

SktBnbPool_Swap_event

UsddPool_SetFee_event

UsddPool_SetHaircutRate_event

UsddPool_setHaircutRate_function

UsddPool_Swap_event

UsdPlusPool_SetFee_event

UsdPlusPool_SetHaircutRate_event

UsdPlusPool_setHaircutRate_function

UsdPlusPool_Swap_event

WmxWOMPool_SetFee_event

WmxWOMPool_SetHaircutRate_event

WmxWOMPool_setHaircutRate_function

WmxWOMPool_Swap_event