> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# wombat_v2_bsc
> Tables in tt-contracts.wombat_v2_bsc
## 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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | in\_haircutRate\_ | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 369549 | 0 | true | 9896 | 0xf57e84d5 | 0x8df1126de13bcfef999556899f469d64021adbae | 27912423 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 1,0,0,2 | 2023-05-04T09:52:05.000Z | 100000000000000 | 0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67 |
| 56936 | 0 | true | 9896 | 0xf57e84d5 | 0x8df1126de13bcfef999556899f469d64021adbae | 27710406 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,0 | 2023-04-27T09:16:35.000Z | 400000000000000 | 0xd58b308027dab85edf30ce6c542ed06c4c29b57aad39a30fe2e749f7c33f1dd2 |
| 9985 | 0 | true | 9896 | 0xf57e84d5 | 0x8df1126de13bcfef999556899f469d64021adbae | 25165591 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,2 | 2023-01-28T02:26:19.000Z | 1000000000000000 | 0x7cd041a384fb5f5f06ec86f0bd0a805e900a76925445d18c8330aa04be06c232 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | in\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | -------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1ee15673e07105bcf360139fa8cafebdd7754bef | false | 20000000000000 | 91 | 32098998 | 2023-09-27T04:44:07.000Z | 0xcf921077cecd0ff1d97e1f87c4f6b6762894034e18adf66fefabd3a8a2a93822 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | in\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183 | false | 100000000000000 | 539 | 27912423 | 2023-05-04T09:52:05.000Z | 0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | in\_haircutRate\_ | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 35571 | 0 | true | 9865 | 0xf57e84d5 | 0x2ea772346486972e7690219c190dadda40ac5da4 | 27710406 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,2 | 2023-04-27T09:16:35.000Z | 400000000000000 | 0xd58b308027dab85edf30ce6c542ed06c4c29b57aad39a30fe2e749f7c33f1dd2 |
| 348227 | 0 | true | 9865 | 0xf57e84d5 | 0x2ea772346486972e7690219c190dadda40ac5da4 | 27912423 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 1,0,0,4 | 2023-05-04T09:52:05.000Z | 100000000000000 | 0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67 |
| 42105 | 0 | true | 5665 | 0xf57e84d5 | 0x2ea772346486972e7690219c190dadda40ac5da4 | 27446153 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,11 | 2023-04-18T04:36:03.000Z | 1000000000000000 | 0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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%).
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| in\_pid | address | in\_user | removed | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 7 | 0xe2c07d20af0fb50cae6cdd615ca44abaaa31f9c8 | 0x1b9f38e893ba4cf5c3a59d6b49ae5b6273899cfc | false | 0 | 224 | 29238613 | 2023-06-19T13:11:50.000Z | 0xc54bf96bfc2239b66fbce4fd044766b382f3cc4d997092be13c002e18ad90961 |
| 0 | 0xe2c07d20af0fb50cae6cdd615ca44abaaa31f9c8 | 0x3a3d69b847277b2493c1e24f13b07e4ae74525a0 | false | 0 | 547 | 29238609 | 2023-06-19T13:11:38.000Z | 0x647a488be79b22103b5a38fa5b11351d80ea334acd3e08709f383486a25b4f0f |
| 6 | 0xe2c07d20af0fb50cae6cdd615ca44abaaa31f9c8 | 0xa753c81b8d840923da3aaf5790e72ce3273ae852 | false | 0 | 400 | 29238612 | 2023-06-19T13:11:47.000Z | 0xedfcca11d88b542d404626fe29f0891fdc4fb7df3ab172b685926f62c44b1e3d |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | in\_haircutRate\_ | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 24927 | 0 | true | 9896 | 0xf57e84d5 | 0x083640c5dbd5a8ddc30100fb09b45901e12f9f55 | 27446153 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,13 | 2023-04-18T04:36:03.000Z | 2000000000000000 | 0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7 |
| 31327 | 0 | true | 9896 | 0xf57e84d5 | 0x083640c5dbd5a8ddc30100fb09b45901e12f9f55 | 27931802 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,0 | 2023-05-05T02:02:18.000Z | 2000000000000000 | 0xf7c7457aa184d11ee75cc4b1b2dc9e37a1655dc67e9f8988ab4892a3474e35c2 |
| 305589 | 0 | true | 9896 | 0xf57e84d5 | 0x083640c5dbd5a8ddc30100fb09b45901e12f9f55 | 27912423 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 1,0,0,8 | 2023-05-04T09:52:05.000Z | 100000000000000 | 0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | in\_haircutRate\_ | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 204288 | 0 | true | 9915 | 0xf57e84d5 | 0x312bc7eaaf93f1c60dc5afc115fccde161055fb0 | 31102825 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 1,0,0 | 2023-08-23T11:39:39.000Z | 20000000000000 | 0x16542e0b1fe834fd96f984b05e58dd778a371bb4e50a9d164178c111b5e08bbd |
| 142918 | 0 | true | 5652 | 0xf57e84d5 | 0x312bc7eaaf93f1c60dc5afc115fccde161055fb0 | 27446153 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,0 | 2023-04-18T04:36:03.000Z | 100000000000000 | 0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7 |
| 15943 | 0 | true | 14415 | 0xf57e84d5 | 0x312bc7eaaf93f1c60dc5afc115fccde161055fb0 | 36294356 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0 | 2024-02-20T07:11:01.000Z | 400000000000000 | 0xadd904c2ab48a12e5abb760a824cf6c5332105ca90b8e8ba6e2192107d8a39f8 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | in\_haircutRate\_ | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 14244 | 0 | true | 9896 | 0xf57e84d5 | 0x2c5464b9052319e3d76f8279031f04e4b7fd7955 | 27446153 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,14 | 2023-04-18T04:36:03.000Z | 2000000000000000 | 0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7 |
| 20645 | 0 | true | 9896 | 0xf57e84d5 | 0x2c5464b9052319e3d76f8279031f04e4b7fd7955 | 27931802 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,1 | 2023-05-05T02:02:18.000Z | 2000000000000000 | 0xf7c7457aa184d11ee75cc4b1b2dc9e37a1655dc67e9f8988ab4892a3474e35c2 |
| 294906 | 0 | true | 9896 | 0xf57e84d5 | 0x2c5464b9052319e3d76f8279031f04e4b7fd7955 | 27912423 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 1,0,0,9 | 2023-05-04T09:52:05.000Z | 100000000000000 | 0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | in\_haircutRate\_ | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 31328 | 0 | true | 9874 | 0xf57e84d5 | 0x0520451b19ad0bb00ed35ef391086a692cfc74b2 | 25165591 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,0 | 2023-01-28T02:26:19.000Z | 200000000000000 | 0x7cd041a384fb5f5f06ec86f0bd0a805e900a76925445d18c8330aa04be06c232 |
| 15943 | 0 | true | 14415 | 0xf57e84d5 | 0x0520451b19ad0bb00ed35ef391086a692cfc74b2 | 31529810 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 1,0,0 | 2023-09-07T09:04:56.000Z | 20000000000000 | 0x39146d380e970da7d1904e77fe6468a5aecdbee38d9b15d0b27be24d4cee8fcb |
| 136413 | 0 | true | 9874 | 0xf57e84d5 | 0x0520451b19ad0bb00ed35ef391086a692cfc74b2 | 27446153 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,1 | 2023-04-18T04:36:03.000Z | 100000000000000 | 0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | in\_haircutRate\_ | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 316271 | 0 | true | 9896 | 0xf57e84d5 | 0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0 | 27912423 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 1,0,0,7 | 2023-05-04T09:52:05.000Z | 100000000000000 | 0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67 |
| 46253 | 0 | true | 9896 | 0xf57e84d5 | 0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0 | 27710406 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,1 | 2023-04-27T09:16:35.000Z | 400000000000000 | 0xd58b308027dab85edf30ce6c542ed06c4c29b57aad39a30fe2e749f7c33f1dd2 |
| 55171 | 0 | true | 5696 | 0xf57e84d5 | 0xb0219a90ef6a24a237bc038f7b7a6eac5e01edb0 | 27446153 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,9 | 2023-04-18T04:36:03.000Z | 1000000000000000 | 0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | in\_haircutRate\_ | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 9962 | 0 | true | 9874 | 0xf57e84d5 | 0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e | 27931802 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,2 | 2023-05-05T02:02:18.000Z | 2000000000000000 | 0xf7c7457aa184d11ee75cc4b1b2dc9e37a1655dc67e9f8988ab4892a3474e35c2 |
| 284224 | 0 | true | 9874 | 0xf57e84d5 | 0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e | 27912423 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 1,0,0,10 | 2023-05-04T09:52:05.000Z | 100000000000000 | 0x305d2ad3b3a9d911f0d816799362c2b9a45af7070af4c710240c6d9f2492ba67 |
| 35588 | 0 | true | 9874 | 0xf57e84d5 | 0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e | 27446153 | 0xc37a89cdb064ac2921fcc8b3538ac0d6a3aadf48 | 0,0,12 | 2023-04-18T04:36:03.000Z | 2000000000000000 | 0x875113edad17116a09919eb1bf6f7d23187a23adb5495c7c8cb58c47e709b0b7 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.wombat_v2_bsc.WmxWOMPool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***