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

# kwenta_v1_optimism

> Tables in tt-contracts.kwenta_v1_optimism

## Tables

### MultipleMerkleDistributor\_Claimed\_event

Token claim events from Kwenta v1's merkle distributor contract on Optimism. Records user claims of trading rewards by epoch, useful for analyzing reward distribution patterns and participant engagement across incentive periods.

<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_index`         | `STRING`    | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).                 |
  | `in_account`       | `STRING`    | Account 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_epoch`         | `STRING`    | Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.                     |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_epoch | in\_index | in\_amount           | log\_index | in\_account                                | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------- | --------- | -------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xf486a72e8c8143acd9f65a104a16990fdb38be14 | false   | 2         | 115       | 92170002676104967    | 4          | 0xb8e1f0f1e0aab629ec07ae9e4fa680b58732c643 | 89501067      | 2023-04-12T13:45:00.000Z | 0xe1739b7e176a251422841f6f9f66a1786f7b50edb8e09cf2e2923bd1de463485 |
  | 0xf486a72e8c8143acd9f65a104a16990fdb38be14 | false   | 4         | 115       | 21015181268979016899 | 4          | 0xa3e373ad4b28ce9b6a35253d7fddeb875df5fb77 | 59627687      | 2023-01-03T15:03:16.000Z | 0x3072d1c1580f5b92cfd39ea4aff5c9997e9ce8091863fded534e20a2d53709c0 |
  | 0xf486a72e8c8143acd9f65a104a16990fdb38be14 | false   | 6         | 109       | 15544057983559253555 | 9          | 0xa3e373ad4b28ce9b6a35253d7fddeb875df5fb77 | 59627687      | 2023-01-03T15:03:16.000Z | 0x3072d1c1580f5b92cfd39ea4aff5c9997e9ce8091863fded534e20a2d53709c0 |
</Accordion>

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

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

***