> ## 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_avalanche

> Tables in tt-contracts.wombat_v2_avalanche

## Tables

### 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.

<Accordion title="Columns">
  | Column               | Type        | Description                                                                                                                                          |
  | -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`    | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`       | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash`   | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`          | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`            | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`            | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_lpDividendRatio` | `STRING`    | Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.               |
  | `in_retentionRatio`  | `STRING`    | Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.                                 |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_retentionRatio | in\_lpDividendRatio |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------ | ------------------- |
  | 0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a | false   | 0          | 36551919      | 2023-10-17T06:00:56.000Z | 0x700c26a4fc378a64d49372c8d4cbe4a507cceafae77f4a7a71a81be5de6717d3 | 500000000000000000 | 500000000000000000  |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.wombat_v2_avalanche.CrossChainPool_SetFee_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_value`         | `STRING`    | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_value       | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a | false   | 400000000000000 | 3          | 43724842      | 2024-04-03T08:52:15.000Z | 0xf1511eb7be3cb780edb82090e366d59a0676bdf33eb15feb9f853a992f51816b |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.wombat_v2_avalanche.CrossChainPool_SetHaircutRate_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                                              |
  | ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                                              |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain.                     |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                                      |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                                       |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                                  |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                                             |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                      |
  | `in_fromToken`     | `STRING`    | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.                                                                       |
  | `in_toToken`       | `STRING`    | Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.                                                     |
  | `in_fromAmount`    | `STRING`    | Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.                          |
  | `in_toAmount`      | `STRING`    | Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.              |
  | `in_toTokenFee`    | `STRING`    | Fee charged in destination token units for the swap transaction. String-encoded integer value representing the fee amount in the smallest unit of the destination token. |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                                          |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | in\_toToken                                | in\_toAmount | block\_number | in\_fromToken                              | in\_fromAmount | in\_toTokenFee | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x1d39a90dac4596b36d60682b6cec147eb758af90 | 0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a | false   | 0x4a88c44b8d9b9f3f2ba4d97236f737cf03df76cd | 8          | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 39998        | 36696256      | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 40000          | 0              | 2023-10-20T15:59:37.000Z | 0x823c3171ae80cac94fd7bc136051180e5b3f329e2ae6988acc17cbecf7c1d341 |
  | 0xc3f0cb0b70ef09c17fbdea0059c0e85fd324f94b | 0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a | false   | 0xc3f0cb0b70ef09c17fbdea0059c0e85fd324f94b | 4          | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 1099124237   | 36936009      | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 1099225718     | 21982          | 2023-10-26T07:47:53.000Z | 0x7c7c9b1f2701b4941afc204bd7e94c0afddf0a48f7feb3bed3cb3ed4bd06ae2d |
  | 0xadf5349df8186379a4e8c919c5d6fb447f8956f0 | 0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a | false   | 0x4a88c44b8d9b9f3f2ba4d97236f737cf03df76cd | 10         | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 949930650    | 37039252      | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 930000000      | 18998          | 2023-10-28T18:12:06.000Z | 0x9faa0eb55b3a2e732533fdd07dc5807273407c4d4392aa20370d6b3edf32646f |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.wombat_v2_avalanche.CrossChainPool_SwapV2_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### SAVAXPool\_SetFee\_event

Fee configuration events from Wombat Exchange's SAVAX (Staked AVAX) pool on Avalanche, recording changes to retention and LP dividend ratios. Used for tracking protocol fee structure adjustments and revenue distribution parameters.

<Accordion title="Columns">
  | Column               | Type        | Description                                                                                                                                          |
  | -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`    | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`       | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash`   | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`          | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`            | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`            | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_lpDividendRatio` | `STRING`    | Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.               |
  | `in_retentionRatio`  | `STRING`    | Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.                                 |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_retentionRatio | in\_lpDividendRatio |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------ | ------------------- |
  | 0xe3abc29b035874a9f6dcdb06f8f20d9975069d87 | false   | 0          | 36841295      | 2023-10-24T01:58:06.000Z | 0xb16e0204a50b6d74789fd0acaeeacf9b6e59aca0f62459d08333be055c8c0d2e | 500000000000000000 | 500000000000000000  |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.wombat_v2_avalanche.SAVAXPool_SetFee_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### SAVAXPool\_SetHaircutRate\_event

Haircut rate configuration changes for the sAVAX (staked AVAX) pool in Wombat Exchange V2 on Avalanche. Tracks adjustments to the stability fee parameter that affects withdrawal costs during imbalanced pool conditions.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_value`         | `STRING`    | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_value       | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xe3abc29b035874a9f6dcdb06f8f20d9975069d87 | false   | 20000000000000  | 19         | 43970022      | 2024-04-09T05:38:47.000Z | 0x0741bf87e28ecb6c35098ec4db833b9385693fc80ccab7c0029bde4f905b0245 |
  | 0xe3abc29b035874a9f6dcdb06f8f20d9975069d87 | false   | 400000000000000 | 5          | 43724842      | 2024-04-03T08:52:15.000Z | 0xf1511eb7be3cb780edb82090e366d59a0676bdf33eb15feb9f853a992f51816b |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.wombat_v2_avalanche.SAVAXPool_SetHaircutRate_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### SAVAXPool\_Swap\_event

Swap events from Wombat Exchange's sAVAX liquidity pool on Avalanche, recording token exchanges between sAVAX (staked AVAX) and WAVAX with amounts, participants, and transaction details. Used for analyzing stablecoin-like swap volumes, liquidity provider activity, and price stability between liquid staking derivatives.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                                 |
  | ------------------ | ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                                 |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain.        |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                         |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                          |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                     |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                                |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                         |
  | `in_fromToken`     | `STRING`    | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.                                                          |
  | `in_toToken`       | `STRING`    | Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.                                        |
  | `in_fromAmount`    | `STRING`    | Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.             |
  | `in_toAmount`      | `STRING`    | Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token. |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                             |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | in\_toToken                                | in\_toAmount         | block\_number | in\_fromToken                              | in\_fromAmount       | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | -------------------- | ------------- | ------------------------------------------ | -------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xd291d9355a7b1a1d297b5f3c6c59f64458632ed1 | 0xe3abc29b035874a9f6dcdb06f8f20d9975069d87 | false   | 0x4a88c44b8d9b9f3f2ba4d97236f737cf03df76cd | 24         | 0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be | 3155788889603891692  | 36929339      | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 3500000000000000000  | 2023-10-26T03:59:51.000Z | 0x046500450096bbb6042f29125419ef6306e2f3878cdabe20a4d555edd4af1495 |
  | 0x6a376d33decf462274c9d1768cbc1b9d6c1927bc | 0xe3abc29b035874a9f6dcdb06f8f20d9975069d87 | false   | 0x6a376d33decf462274c9d1768cbc1b9d6c1927bc | 20         | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 18881549853891298922 | 36961092      | 0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be | 17020497221196443854 | 2023-10-26T21:52:13.000Z | 0x16f567a2f2998b5272fbcfff2d12aef2cadd77c02579a13630eb784921058b23 |
  | 0x6a376d33decf462274c9d1768cbc1b9d6c1927bc | 0xe3abc29b035874a9f6dcdb06f8f20d9975069d87 | false   | 0x6a376d33decf462274c9d1768cbc1b9d6c1927bc | 52         | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 19165181287872434437 | 36957142      | 0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be | 17277191664131368863 | 2023-10-26T19:37:48.000Z | 0x9d932d632862cc1f5fb7b9ad67202d636b1f9f36b12490db008957ae00b71126 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.wombat_v2_avalanche.SAVAXPool_Swap_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### USDVPool\_SetFee\_event

Fee parameter change events from Wombat V2's USDV stablecoin pool on Avalanche, capturing updates to retention ratios and LP dividend distribution settings for protocol revenue management.

<Accordion title="Columns">
  | Column               | Type        | Description                                                                                                                                          |
  | -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`    | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`       | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash`   | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`          | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`            | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`            | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_lpDividendRatio` | `STRING`    | Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.               |
  | `in_retentionRatio`  | `STRING`    | Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.                                 |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_retentionRatio | in\_lpDividendRatio |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------ | ------------------- |
  | 0x108c990c93fa8e3cd88ddb13594d39f09d9b3c02 | false   | 1          | 37565172      | 2023-11-10T04:12:37.000Z | 0x38227467edf013e967b1c97dfd31b9e08d2d50347cd5f18c71a90398d2035141 | 500000000000000000 | 500000000000000000  |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.wombat_v2_avalanche.USDVPool_SetFee_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### USDVPool\_SetHaircutRate\_event

Haircut rate parameter changes for the USDV pool in Wombat V2 protocol on Avalanche, tracking risk management adjustments where haircut represents the percentage deducted during withdrawals to protect liquidity providers.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_value`         | `STRING`    | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_value       | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x108c990c93fa8e3cd88ddb13594d39f09d9b3c02 | false   | 400000000000000 | 4          | 43724842      | 2024-04-03T08:52:15.000Z | 0xf1511eb7be3cb780edb82090e366d59a0676bdf33eb15feb9f853a992f51816b |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.wombat_v2_avalanche.USDVPool_SetHaircutRate_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### USDVPool\_Swap\_event

Token swap events from Wombat V2's USDV stablecoin pool on Avalanche. Captures stablecoin exchanges with input/output token addresses and amounts for analyzing pool liquidity and trading patterns.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                                 |
  | ------------------ | ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                                 |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain.        |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                         |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                          |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                     |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                                |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                         |
  | `in_fromToken`     | `STRING`    | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.                                                          |
  | `in_toToken`       | `STRING`    | Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.                                        |
  | `in_fromAmount`    | `STRING`    | Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.             |
  | `in_toAmount`      | `STRING`    | Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token. |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                             |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | in\_toToken                                | in\_toAmount | block\_number | in\_fromToken                              | in\_fromAmount | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x1111111254eeb25477b68fb85ed929f73a960582 | 0x108c990c93fa8e3cd88ddb13594d39f09d9b3c02 | false   | 0x7ab5194e730c4ec4a9d1d7f1dcad9c173075888a | 11         | 0x323665443cef804a3b5206103304bd4872ea4253 | 6008495614   | 38099217      | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 5999699460     | 2023-11-22T14:43:25.000Z | 0x008c977be94a2e5f770927f565f18cf5d18783c7c4cf25cb7a5dbf530c17d828 |
  | 0x1111111254eeb25477b68fb85ed929f73a960582 | 0x108c990c93fa8e3cd88ddb13594d39f09d9b3c02 | false   | 0x7ab5194e730c4ec4a9d1d7f1dcad9c173075888a | 9          | 0x323665443cef804a3b5206103304bd4872ea4253 | 24053021     | 38096312      | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 23992854       | 2023-11-22T13:04:31.000Z | 0xaccb06568c41998e0fcb3c83a2b3c0f7973e76205103cfbfde97920f650a74aa |
  | 0x1111111254eeb25477b68fb85ed929f73a960582 | 0x108c990c93fa8e3cd88ddb13594d39f09d9b3c02 | false   | 0x7ab5194e730c4ec4a9d1d7f1dcad9c173075888a | 11         | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 964472817    | 38093537      | 0x323665443cef804a3b5206103304bd4872ea4253 | 966889551      | 2023-11-22T11:28:41.000Z | 0x545261a33742588fc3bcb4272c0f3ba130428e955dbbf7d214ee587ac72d1fb5 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.wombat_v2_avalanche.USDVPool_Swap_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***