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

# betswirl_v2_avalanche

> Tables in tt-contracts.betswirl_v2_avalanche

## Tables

### Bank\_AllocateHouseEdgeAmount\_event

Event logs recording the distribution of house edge revenue across multiple recipients including bank reserves, dividends, team allocations, treasury, and partner/referral shares. Used for tracking revenue allocation flows in decentralized gaming protocols.

<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_dividend`      | `STRING`    | Amount allocated to dividends from house edge distribution. Numeric string representation of token wei or smallest unit amount.                      |
  | `in_referral`      | `STRING`    | Referral code identifier associated with the transaction. Numeric string representation, often '0' when no referral is present.                      |
  | `in_partner`       | `STRING`    | Address of the partner or referral entity associated with the transaction. Hex-encoded, 0x-prefixed, 42-character string.                            |
  | `in_treasury`      | `STRING`    | Contract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.                                                       |
  | `in_team`          | `STRING`    | Amount allocated to the team from house edge distribution. Numeric string representation of token wei or smallest unit amount.                       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_team | removed | in\_token                                  | log\_index | in\_partner | in\_dividend | in\_referral | in\_treasury | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | -------- | ------- | ------------------------------------------ | ---------- | ----------- | ------------ | ------------ | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x187de399100aa962f209aa78621f5138aca6111f | 11666    | false   | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 5          | 0           | 19166        | 0            | 19166        | 16312711      | 2022-06-21T05:18:05.000Z | 0xce2a3a0decb8382c83b437206e1fe3caf302a1385efdc599a6f3c5116959efd1 |
  | 0x187de399100aa962f209aa78621f5138aca6111f | 11666    | false   | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 4          | 0           | 19166        | 0            | 19166        | 16307523      | 2022-06-21T02:24:57.000Z | 0x33e97e99773f0bd71a554a52fe0d2544c14dc73e53acfc205a7c915694b34512 |
  | 0x187de399100aa962f209aa78621f5138aca6111f | 11666    | false   | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 11         | 0           | 19166        | 0            | 19166        | 16307636      | 2022-06-21T02:28:43.000Z | 0xd758b1b5bfbe280f3856362635fcca1caf60b3cd32a628e53a6dd81f385a2f39 |
</Accordion>

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

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

***

### Roulette\_Roll\_event

Roulette game outcome event emitted when a player's bet is resolved, containing the bet identifier, wagered amount, random result (0-36), selected numbers, payout awarded, player address, and token used. Primary source for analyzing roulette game outcomes and player winnings.

<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_id`            | `STRING`    | Unique identifier for the position, record, or entity within the protocol. Numeric string representation.                                            |
  | `in_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `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.                      |
  | `in_numbers`       | `STRING`    | Player's selected numbers or positions for the wager. Numeric string representation encoding the chosen bet configuration in the gaming protocol.    |
  | `in_rolled`        | `INT64`     | Randomly generated outcome value from the gaming protocol's verifiable randomness system.                                                            |
  | `in_payout`        | `STRING`    | Payout amount awarded to the player or winner. Numeric string representation of token quantity in smallest denomination.                             |
</Accordion>

<Accordion title="Sample Data">
  | in\_id                                                                         | address                                    | in\_user                                   | removed | in\_token                                  | in\_amount        | in\_payout | in\_rolled | log\_index | in\_numbers | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ----------------- | ---------- | ---------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 95991177802350761550933669352548807914347647180912517778249389053065612497574  | 0x556bc2bbe113cec48fc3b2c45afb708fb09dda63 | 0x4ca11ba147210542a0acc519fbb8ef82c051db8c | false   | 0x0000000000000000000000000000000000000000 | 10000000000000000 | 0          | 18         | 5          | 1           | 19889090      | 2022-09-15T05:39:55.000Z | 0x36f9ee91f8875bb8f6ecc1de2877555d1b729a9bf8ab0af1df75eded2630727a |
  | 111293384270617304380142352401078866982921490611903461372623607616651657526327 | 0x556bc2bbe113cec48fc3b2c45afb708fb09dda63 | 0x4ca11ba147210542a0acc519fbb8ef82c051db8c | false   | 0x0000000000000000000000000000000000000000 | 20000000000000000 | 0          | 28         | 2          | 1           | 19889113      | 2022-09-15T05:40:53.000Z | 0x3ce63cc2f033ad91249e6a38b974f57c39df7ebb4bda1a4c221b045ffe8d474f |
  | 73855330743945606192568479760099395596419888961936516566658102002627333265998  | 0x556bc2bbe113cec48fc3b2c45afb708fb09dda63 | 0x4ca11ba147210542a0acc519fbb8ef82c051db8c | false   | 0x0000000000000000000000000000000000000000 | 20000000000000000 | 0          | 23         | 49         | 1           | 19889104      | 2022-09-15T05:40:31.000Z | 0xbbf11eed5a269d6c43f9b261b4a8ad57cbe23a9a1cec39a59f5ea0c768d9d3a0 |
</Accordion>

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

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

***

### StakingV2\_RewardPaid\_event

Staking reward distribution events emitted when users claim accrued rewards from staking contracts. Records the recipient address, reward token contract, and reward amount paid out.

<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_rewardsToken`  | `STRING`    | Contract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string.                                               |
  | `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                                    | in\_user                                   | removed | in\_reward         | log\_index | block\_number | block\_timestamp         | in\_rewardsToken                           | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0x9913effa744b72385e537e092710072d21f8bc98 | 0x0ec9efc8c5305978cb957c74b228d4949f5e9dd0 | false   | 449025211385896365 | 33         | 34864956      | 2023-09-07T03:22:56.000Z | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 0xb11975dadd4b2b577de7a4fd6f35f81276c99032a07b6a60d063c64c34dad013 |
  | 0x9913effa744b72385e537e092710072d21f8bc98 | 0x671675805456d04165f6e03f71ab2b92f63e01b8 | false   | 488089123605342845 | 12         | 34883948      | 2023-09-07T14:41:26.000Z | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 0x7a77969ce98d21a49252ec3e0353f728083390afd933bbbf6d494260b339f922 |
  | 0x9913effa744b72385e537e092710072d21f8bc98 | 0x671675805456d04165f6e03f71ab2b92f63e01b8 | false   | 290945444313139007 | 10         | 34866954      | 2023-09-07T04:34:27.000Z | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 0x6a99b2f445a4572ccae8737923457fc8975ba782970e8cd10fc958075eae1dab |
</Accordion>

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

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

***