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

# houdiniswap_v2_ethereum

> Tables in tt-contracts.houdiniswap_v2_ethereum

## Tables

### Staker\_Compounded\_event

Reward compounding events from Houdiniswap V2 staking contract on Ethereum, capturing when stakers reinvest their earned rewards back into their stake positions. Contains user addresses, compounded amounts in wei, and transaction metadata for tracking staking yield auto-compounding behavior.

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_amount           | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0xf96094910fc82e71a022c52276ef16f41548219c | false   | 12693428614289195728 | 167        | 19211462      | 2024-02-12T10:50:47.000Z | 0xbc6c37a4d546d8ef967d613a223db11b7cf225366e8eed189b866c6171dbeb2a |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0xcd3f9b3389794104e2ce3d5e4424014d56e59729 | false   | 6059649164073240481  | 552        | 19213310      | 2024-02-12T17:03:35.000Z | 0x9a76ac348be9f8fcb910a738b9d1df76a8fcd2a42b73076fba3c9091e6876b93 |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0xe99d339f9d18b76ffa4085f5e6d82e6a3ff546ca | false   | 76660915427162146635 | 289        | 19617850      | 2024-04-09T11:40:47.000Z | 0xc5b829ddfd43d6638d8771ec915cc692829e4edafa23bc3831e869b643717f30 |
</Accordion>

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

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

***

### Staker\_FallenWizardFee\_event

Fee distribution events for HoudiniSwap V2 stakers on Ethereum, recording token amounts allocated to user addresses from the Fallen Wizard fee mechanism. Used to track staking reward distributions and fee-sharing payouts to 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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_amount            | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | --------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0xff16d25c97a872da47a0d49c04da9539db0fd2e1 | false   | 150752483380111370407 | 189        | 19494938      | 2024-03-23T04:32:11.000Z | 0xe37c86c4f9470e0c3e1dbd1c2d1129320b6c9ab80a71455327fe8ba082ea3358 |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0xff16d25c97a872da47a0d49c04da9539db0fd2e1 | false   | 0                     | 77         | 19494946      | 2024-03-23T04:33:47.000Z | 0x8739479a7fd1ebe212cd367d699d9589ae9b506b1f289d86f4569c5397ad7dc2 |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0xaf02acf6074bc07869fb8f4f590603db05765229 | false   | 229107707953462788891 | 181        | 19342224      | 2024-03-01T18:49:47.000Z | 0xd1a9ed8dd6a3134033ede807e943b60d3b7e438866a04358396d7e178f5f9dc0 |
</Accordion>

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

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

***

### Staker\_initialize\_function

*No description available.*

<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.                                                                                                                                                                                  |
  | `trace_address`            | `STRING`    | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
  | `status`                   | `BOOL`      | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.                                                                                                                             |
  | `from_address`             | `STRING`    | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                              |
  | `to_address`               | `STRING`    | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                                   |
  | `value`                    | `FLOAT64`   | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).                                                                                                                                     |
  | `gas_used`                 | `INT64`     | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.                                                                                                                                                       |
  | `gas`                      | `INT64`     | 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__rewardsToken`         | `STRING`    | -                                                                                                                                                                                                                                                                    |
  | `in__stakingToken`         | `STRING`    | -                                                                                                                                                                                                                                                                    |
  | `in__stakingTokensDecimal` | `STRING`    | -                                                                                                                                                                                                                                                                    |
  | `in__treasuryAddress`      | `STRING`    | -                                                                                                                                                                                                                                                                    |
  | `in__admin`                | `STRING`    | -                                                                                                                                                                                                                                                                    |
  | `in__earlyStakePeriodEnd`  | `STRING`    | -                                                                                                                                                                                                                                                                    |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

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

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

***

### Staker\_MultiplierChanged\_event

Staking reward multiplier adjustment events from HoudiniSwap V2 on Ethereum, tracking when user multipliers change (stored as basis points where 1000 = 1x). Used for analyzing staking incentive structures and user tier changes over time.

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                 |
  | `in_multiplier`    | `STRING`    | Multiplier value applied to the user's staking rewards or voting power, represented as an integer where 1000 equals 1x. Higher values indicate boosted rewards, with the sample showing a baseline 1x multiplier. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | log\_index | block\_number | in\_multiplier | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0x99910e1a4cd086dace05703acd25c3d1a0042036 | false   | 132        | 19317255      | 1000           | 2024-02-27T06:59:59.000Z | 0xb86cbca5cb6f617e30a4f225e4e3bdbe31bee8dc2b1a173cfaf18703bf08a3de |
</Accordion>

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

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

***

### Staker\_Rebased\_event

Staking multiplier adjustment events from HoudiniSwap V2 on Ethereum, tracking when user stake positions are rebalanced with new multiplier values. Used for analyzing reward distribution mechanics and stake weight changes over time.

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                                       |
  | `in_multiplier`    | `STRING`    | Multiplier value applied during the rebase event for the specified user's staked position. Typically expressed as basis points or a scaled integer (e.g., 1000 = 1.0x). |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | log\_index | block\_number | in\_multiplier | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0x99910e1a4cd086dace05703acd25c3d1a0042036 | false   | 131        | 19317255      | 1000           | 2024-02-27T06:59:59.000Z | 0xb86cbca5cb6f617e30a4f225e4e3bdbe31bee8dc2b1a173cfaf18703bf08a3de |
</Accordion>

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

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

***

### Staker\_Recovered\_event

*No description available.*

<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_token`         | `STRING`    | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                               |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

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

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

***

### Staker\_RequestUnlock\_event

Unlock requests initiated by stakers in HoudiniSwap v2 staking contract on Ethereum, recording user addresses and token amounts being withdrawn. Used for tracking staking exit behavior and liquidity movement 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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_amount             | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0x96f7336b43d58bfb62b0da07b6d6786bd976a3f4 | false   | 7550131965000623762864 | 531        | 19491377      | 2024-03-22T16:32:47.000Z | 0xcb306f40c8e130044a92a48dcd5dc98e7570b8b29af5341264a12ed24f254503 |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0xd0e614213dd13f59fe780843cc012dcc656738ff | false   | 3850308580643509372964 | 887        | 19486480      | 2024-03-22T00:04:47.000Z | 0xf075e62938b7cfd29e6ee71333398fbf0a645bec7cc89835b94300faa90327c6 |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0xae1f5ce62cd70da2faeb297f9720c55bdbae3ec1 | false   | 1124811334657468454989 | 735        | 19486465      | 2024-03-22T00:01:47.000Z | 0x585377d4e121f85a0ebeb47eb741e2a64e116ffcf4a36e9309620f14e1df250b |
</Accordion>

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

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

***

### Staker\_RewardAdded\_event

Reward distribution events from HoudiniSwap V2 staking contracts on Ethereum, capturing the token amounts added to staker reward pools. Used for tracking staking yield distribution patterns and reward frequency analysis.

<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_reward`        | `STRING`    | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.                                    |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_reward              | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ----------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | false   | 87100706964008624258922 | 266        | 19609621      | 2024-04-08T08:00:11.000Z | 0x8e522cf1906b65bfa66e40b337138157d7aee11f948c17da5cce8e90b69a5dc1 |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | false   | 33495608674405462386924 | 310        | 19360464      | 2024-03-04T08:00:11.000Z | 0x1dc8715a600a533ac243935209c7d5bc867be52bc618a4aa9f2b1817d9bba3cc |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | false   | 61003411040621882711184 | 245        | 19510174      | 2024-03-25T08:00:11.000Z | 0x2bb4b61ccf108d6a404a0b8a7cdb6bc008951a7d25466414fe2ec474509486e5 |
</Accordion>

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

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

***

### Staker\_RewardPaid\_event

*No description available.*

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

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

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

***

### Staker\_stake\_function

Staking deposits to HoudiniSwap V2 protocol on Ethereum, capturing user addresses, token amounts, and transaction execution details. Contains both successful and failed stake attempts for analyzing protocol participation and staking 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.                                                                                                                                                                                  |
  | `trace_address`    | `STRING`    | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
  | `status`           | `BOOL`      | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.                                                                                                                             |
  | `from_address`     | `STRING`    | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                              |
  | `to_address`       | `STRING`    | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                                   |
  | `value`            | `FLOAT64`   | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).                                                                                                                                     |
  | `gas_used`         | `INT64`     | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.                                                                                                                                                       |
  | `gas`              | `INT64`     | 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_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                                                                                                                                      |
</Accordion>

<Accordion title="Sample Data">
  | gas    | value | status | gas\_used | in\_amount             | signature  | to\_address                                | block\_number | from\_address                              | trace\_address | block\_timestamp         | transaction\_hash                                                  |
  | ------ | ----- | ------ | --------- | ---------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 152166 | 0     | true   | 131072    | 222999999999999999999  | 0xa694fc3a | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 20151038      | 0x3f560c2dd30d15a4bb479ad0fff3ac77bc48a149 |                | 2024-06-23T01:12:23.000Z | 0x8267cc60be46dc84323ec29c67c9cefd3b915c4a1ef3fda748df66fc64ecfe77 |
  | 170410 | 0     | true   | 101932    | 0                      | 0xa694fc3a | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 20155301      | 0x2797f0fee73b3ef4878349529f1b0359efbdcf96 |                | 2024-06-23T15:31:47.000Z | 0x9a92d2e7525a0c0a8aceadbd769c4466e718d8a3307b262e4fe663d348c39cf6 |
  | 259884 | 0     | true   | 165449    | 1309999999999999999999 | 0xa694fc3a | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 20151279      | 0x503844682489f75f3c59b84a1a547e4336f5ccba |                | 2024-06-23T02:00:47.000Z | 0x646c29a2bbf35115bf5c5b41365ce2ca4e1858708667c4f29dca6cce3b6a57d7 |
</Accordion>

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

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

***

### Staker\_Staked\_event

Staking deposit events from HoudiniSwap V2 on Ethereum, recording when users lock tokens into the staking contract. Useful for analyzing staking participation, deposit sizes, and staker wallet behavior over time.

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_amount             | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0x3a3c3a5115bc299fe4e03664c9bccf43bc252a7d | false   | 7999999999999999999999 | 183        | 19409925      | 2024-03-11T05:59:59.000Z | 0x1dee12eb3b45f58c9b8dbf7d6e274dc56a007b902d55ffb6c9f8fecc77a6832a |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0xd24dd11b6bca2c119321f2acb29ad1b45ef98ea5 | false   | 1426999999999999999999 | 335        | 19410959      | 2024-03-11T09:28:23.000Z | 0x1457362460aa3000739218e44bd06ecc989516af4e04f7647151cd59793b7103 |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0x020b1ba5c3fa43cf613e87032b1badd210301da8 | false   | 3445999999999999999999 | 146        | 19411018      | 2024-03-11T09:40:11.000Z | 0x22512c1d09fa4ec059a7e9ed543d0d33c89c1b66c8a263a24ecf78f47eea0b32 |
</Accordion>

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

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

***

### Staker\_Withdrawn\_event

Withdrawal events from HoudiniSwap V2 staking contract on Ethereum, recording when users unstake tokens with withdrawal amounts and user addresses. Useful for analyzing staking behavior, liquidity movements, and participant activity in the HoudiniSwap protocol.

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_amount             | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0x7364bc2e9019e6e2506c4571558e5ab9b8cb5b91 | false   | 745158764383016428971  | 236        | 19191490      | 2024-02-09T15:33:35.000Z | 0xe2317fade76683fadb81c3fd183e815ece3acd7bff5338479f05cf587961f491 |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0x019d805a1fe8d1f54835fe0107916ed189452993 | false   | 1501099992585927532720 | 305        | 19193927      | 2024-02-09T23:45:11.000Z | 0xf1efea1b7de970a220ea7f8c2aaaffd5a7a586dab2abee56b9380d71ea5ae1ca |
  | 0x4401c51110e7d3a970fe48aeaee8249b181210a1 | 0x7c86472518046cf6ec2e8baa29822cfa1c1c7aec | false   | 444186291454596537055  | 155        | 19265546      | 2024-02-20T01:09:23.000Z | 0xe844b2a226f614e67f81358e90409ec9258e4790021d136a655da5d291de5e69 |
</Accordion>

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

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

***