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

> Tables in tt-contracts.betswirl_v2_arbitrum

## Tables

### 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                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0xa7dd05a6cfc6e5238f04fd6e53d4efa859b492e4 | 0x35119741d2d3c40fcd456a93860f68c1754a4f56 | false   | 130522336318822668 | 14         | 212788763     | 2024-05-19T07:40:09.000Z | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x99128a3856da53108439ecb6db5d1e011d9f7c8e4a0713cd7263864befee74aa |
  | 0xa7dd05a6cfc6e5238f04fd6e53d4efa859b492e4 | 0x83febcf72458393a3957cc9793a9f04ff59a3d45 | false   | 11569913293170525  | 3          | 212872899     | 2024-05-19T13:36:59.000Z | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x4f234a0752f83e789935d31459f117ffa02acd291e6f2c4b360f032cfa7fba38 |
  | 0xa7dd05a6cfc6e5238f04fd6e53d4efa859b492e4 | 0x51fbd3162795632471dfcd8a0c9fe4e889fde9e5 | false   | 2155685262952987   | 7          | 212735397     | 2024-05-19T03:51:21.000Z | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x0bb9b45b6f2877aef447452afff25fe64cc8e06e9da9b1f27154aae6fe9a8754 |
</Accordion>

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

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

***