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

# aurafinance_v1_polygon

> Tables in tt-contracts.aurafinance_v1_polygon

## Tables

### BaseRewardPool4626\_RewardPaid\_event

Reward distribution events from Aura Finance BaseRewardPool4626 contracts recording token payouts to staking participants. Contains user address, reward token address, and amount paid for tracking liquidity mining incentives.

<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                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x0584e40da9ce45850d15c82743f8db96216b4ccb | 0x7ec016febb4d0c91734eaedfc0d86203c1cddce0 | false   | 39176370846922394600 | 302        | 50861923      | 2023-12-07T19:44:33.000Z | 0x8fc4ccb3509adf95b12aeb63b1e02f6691f6cb1ba9f5bdd0a2db24f20a43f379 |
  | 0x0584e40da9ce45850d15c82743f8db96216b4ccb | 0x44791b9c211ede531d80c544d015ac904c5684f5 | false   | 984895732075996128   | 626        | 50840927      | 2023-12-07T07:16:09.000Z | 0x3fa180f2d9b1291b0053a56b2fd1e777b8d377aab695f1dcc031b066a292a0ef |
  | 0x0ce870b89e4522ee6e0a8a7134ecd39c409bfecc | 0x20d61737f972eecb0af5f0a85ab358cd083dd56a | false   | 3917201672185148946  | 392        | 50831328      | 2023-12-07T01:29:41.000Z | 0xc51ef242e870e2506a46b00a7a316b7d32b740acf5dc4927df01862bdf8e4764 |
</Accordion>

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

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

***

### BoosterLite\_Deposited\_event

Aura Finance BoosterLite contract deposit events emitted when users stake liquidity pool tokens into reward vaults. Records user address, pool identifier, and deposited token amount for tracking staking activity across Aura's layer-2 deployments.

<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_poolid`        | `STRING`    | Identifier for the liquidity pool associated with the deposit operation. Numeric string representation of the pool index.                            |
  | `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            | in\_poolid | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | --------------------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x98ef32edd24e2c92525e59afc4475c1242a30184 | 0xf4d348e3d74300fcf35766b31b5ddab4c1dbc94b | false   | 65864702890787512636  | 12         | 269        | 73337680      | 2025-06-28T20:01:45.000Z | 0x379bfd44a1f3fdecfcef545876b6d8ddf09e0355c983825974dbe908e44eef7e |
  | 0x98ef32edd24e2c92525e59afc4475c1242a30184 | 0xf4d348e3d74300fcf35766b31b5ddab4c1dbc94b | false   | 70094639538579402989  | 12         | 884        | 73321889      | 2025-06-28T10:42:10.000Z | 0x5ca56191e2d08141cd78a41a77cc5d19e8bd9f1b0bee5acc0a80b89eb6595271 |
  | 0x98ef32edd24e2c92525e59afc4475c1242a30184 | 0x39ee6fb813052e67260a3f95d3739b336aabd2c6 | false   | 103753439825007434118 | 12         | 1037       | 73321298      | 2025-06-28T10:21:14.000Z | 0x7002adcba9f26e2565b78c20d137db32f65fe210864eb4aee391eff344fecf08 |
</Accordion>

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

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

***

### RewardFactory\_RewardPoolCreated\_event

Event logs emitted when Aura Finance reward pool contracts are created by the factory, containing pool identifier (PID), deposit token address, and newly deployed reward pool address. Used for tracking reward pool deployments across liquidity mining programs.

<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_rewardPool`    | `STRING`    | Contract address of the reward pool created by the factory. Hex-encoded, 0x-prefixed, 42-character string.                                           |
  | `in__pid`          | `STRING`    | Pool identifier for the reward pool or staking position. String-encoded integer used to reference specific pools within the protocol.                |
  | `in_depositToken`  | `STRING`    | Contract address of the token being deposited into the reward pool or margin position. Hex-encoded, 0x-prefixed, 42-character string.                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_\_pid | removed | log\_index | block\_number | in\_rewardPool                             | block\_timestamp         | in\_depositToken                           | transaction\_hash                                                  |
  | ------------------------------------------ | --------- | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0xb292be31649a0b079dbdb772fcf5c7a02a6e0144 | 1         | false   | 311        | 45431772      | 0xd90b5275b98d4865712487637b9266336b36ff0e | 2023-07-23T18:15:36.000Z | 0x9c779b0cbb42531027e2ec995e97c787125013d0 | 0x7cf83005437cb6e309b136483563c399265982c7114ef3ef19b23a997a32e213 |
  | 0xb292be31649a0b079dbdb772fcf5c7a02a6e0144 | 2         | false   | 317        | 45431772      | 0xe44e433326a698dd5be83ffbcd36b849dc0f4582 | 2023-07-23T18:15:36.000Z | 0x792f80ba0f6b05b9d3b2267af6f1cc0092f0cfa4 | 0x7cf83005437cb6e309b136483563c399265982c7114ef3ef19b23a997a32e213 |
  | 0xb292be31649a0b079dbdb772fcf5c7a02a6e0144 | 0         | false   | 305        | 45431772      | 0xc78b6d5586ef339ea511f26b943f13ddfa137f04 | 2023-07-23T18:15:36.000Z | 0x094c6846fb2801b4753182adfac336aae8030a46 | 0x7cf83005437cb6e309b136483563c399265982c7114ef3ef19b23a997a32e213 |
</Accordion>

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

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

***

### RewardFactory\_TokenRewardPoolCreated\_event

Event logs recording the creation of token reward pool contracts by the RewardFactory. Contains the newly deployed reward pool address, associated token, operator authorization, and main rewards contract reference for tracking Aura Finance incentive distribution infrastructure.

<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_rewardPool`    | `STRING`    | Contract address of the reward pool created by the factory. 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_mainRewards`   | `STRING`    | Contract address of the main rewards contract associated with the reward pool. Hex-encoded, 0x-prefixed, 42-character string.                        |
  | `in_operator`      | `STRING`    | Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.                             |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_token                                  | log\_index | in\_operator                               | block\_number | in\_rewardPool                             | in\_mainRewards                            | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0xb292be31649a0b079dbdb772fcf5c7a02a6e0144 | false   | 0xf7a5e07ddea618038caefdaddf6741375d0b12c0 | 88         | 0x417d097d504e5adedb441238f92f1b2c9b38900f | 45614626      | 0xbea6ff2b2ee3832f398007a9321d70c53853d5c8 | 0xaa0746892a97163b1d821724a6ea087ec208680e | 2023-07-28T09:30:37.000Z | 0xca3db4346c8adfb706e0b0a313bc75fc354568ac458a88522335e5d4fc6bbf7c |
  | 0xb292be31649a0b079dbdb772fcf5c7a02a6e0144 | false   | 0x2a899dd4226515ef2e3eda6d0972b3b7d77ed86e | 87         | 0x417d097d504e5adedb441238f92f1b2c9b38900f | 45614626      | 0x3dc0b0cd0f025b33143a7236cd71a8badeca7052 | 0xaa0746892a97163b1d821724a6ea087ec208680e | 2023-07-28T09:30:37.000Z | 0xca3db4346c8adfb706e0b0a313bc75fc354568ac458a88522335e5d4fc6bbf7c |
  | 0xb292be31649a0b079dbdb772fcf5c7a02a6e0144 | false   | 0x3ab8826d263637ba6aad7d65f707ff88cd39d482 | 39         | 0xe1f394057b7e4a76b1963f48e7766763cfc1e760 | 46366792      | 0x42fcd6ca48905601064947cf68d95539e3e73259 | 0x60673f2a61dde2bb3e0ca0add5c1ff4c1aadf4ba | 2023-08-16T07:01:04.000Z | 0xb1261be23d9e04fc19bf6f3df1c8a66f4f98c04f8986fe4c9d85f6ec8386a41d |
</Accordion>

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

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

***
