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

# aragon_v1_ethereum

> Tables in tt-contracts.aragon_v1_ethereum

## Tables

### AntBptRewards\_RewardPaid\_event

Reward claim events from Aragon's ANT-BPT (Balancer Pool Token) liquidity mining program on Ethereum. Tracks individual reward payouts to liquidity providers with user addresses and reward amounts for analyzing incentive distribution 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_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         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x7f2b9e4134ba2f7e99859ae40436cbe888e86b79 | 0x12bb2d969b59ff2830c1c6d760a2b87e8204109c | false   | 4503832634 | 140        | 11276842      | 2020-11-17T17:37:30.000Z | 0xe65ddbfbc09a05bf62bb815b07d6eff687ae51d5bcb6d204ea6c05b11b9688b3 |
  | 0x7f2b9e4134ba2f7e99859ae40436cbe888e86b79 | 0x6f69286d7c51de0f0cf5f3c03c8ca3eda8a322f9 | false   | 7387426    | 178        | 11466700      | 2020-12-16T21:48:08.000Z | 0x825f9416660d363608771c8dd36cc96c9c26bc4881d2fd842b83674a55d39812 |
  | 0x7f2b9e4134ba2f7e99859ae40436cbe888e86b79 | 0xbd1f7d88c76a86c60d41bddd4819fae404e7151e | false   | 9783484    | 182        | 11266422      | 2020-11-16T03:11:48.000Z | 0x5a5dcde6eee177304006b66952a9c2b0304c35b7f368fb3b1d345d88c60b9d11 |
</Accordion>

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

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

***

### AntUniRewards\_RewardPaid\_event

Reward distribution events from Aragon's ANT-UNI liquidity mining program on Ethereum, tracking token payouts to individual stakers. Used for analyzing liquidity provider returns and reward claim patterns in Aragon's Uniswap incentive mechanism.

<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_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         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x37b7870148b4b815cb6a4728a84816cc1150e3aa | 0xe8adaea0ba507a28d1309051beceb4db7fe377af | false   | 108967045608681752 | 268        | 11214567      | 2020-11-08T04:13:05.000Z | 0x7ac226270fbe5aa11014cc9b31962031ce88127471168c7dacd2321b7d04db12 |
  | 0x37b7870148b4b815cb6a4728a84816cc1150e3aa | 0xaf4cecd76e37eae3ec942de9a86aa3a0e683c384 | false   | 51232800072959991  | 62         | 11285080      | 2020-11-19T00:13:50.000Z | 0xebf49e2270ddf98d4d474970828c8981e55ac1dd2e1277996ce0d68258ed891e |
  | 0x37b7870148b4b815cb6a4728a84816cc1150e3aa | 0xbec73ba0817403cd11c11be891d671ea30443562 | false   | 879725222357863452 | 265        | 11207836      | 2020-11-07T03:22:49.000Z | 0xe8b96ff18e23c6af1e0abddb152f2d9f11a0dbee594ac7dfbbaeb97eddde4dcf |
</Accordion>

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

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

***

### Unipool\_RewardPaid\_event

RewardPaid events from Aragon v1 Unipool liquidity mining contracts on Ethereum, capturing reward token distributions to staking participants. Used for analyzing reward claim patterns, participant behavior, and incentive program effectiveness.

<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_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         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xea4d68cf86bce59bf2bfa039b97794ce2c43debc | 0xe5767ade043d95c35e9723f7a463d25278ce6d4b | false   | 124041930616904089   | 214        | 10558696      | 2020-07-30T03:51:27.000Z | 0x4423be0233b5bfb583ddaef66e5cb68032389d2bc754b2b4f8621ae6050de94c |
  | 0xea4d68cf86bce59bf2bfa039b97794ce2c43debc | 0xa26ebb8b409a8596f9bb5ae0711c661a3e16abb7 | false   | 10535200863298681951 | 182        | 10561175      | 2020-07-30T13:24:05.000Z | 0x628dff8598b0ea8133aba25f6c9314b796f85b6e954faae15f934354e7b1bc74 |
  | 0xea4d68cf86bce59bf2bfa039b97794ce2c43debc | 0x0285c10aa06ac166f2576ab2d3473fc42cefb933 | false   | 51320865703553205235 | 250        | 10562850      | 2020-07-30T19:40:51.000Z | 0x9d27eff84c3c4a015155cd2995dfbf6172ed386957ea63b4c109d966a9677741 |
</Accordion>

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

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

***