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

# ankr_v2_avalanche

> Tables in tt-contracts.ankr_v2_avalanche

## Tables

### AvalanchePool\_AvaxClaimPending\_event

Pending AVAX unstaking claim events from Ankr liquid staking protocol on Avalanche, tracking user withdrawal requests awaiting processing. Used to monitor unstaking queue dynamics and user claim activity across the protocol.

<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_claimer`       | `STRING`    | Address of the account initiating the claim transaction. 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.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_amount            | log\_index | in\_claimer                                | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 527898820123713296416 | 6          | 0xf3ea8ea3e2c0b83626da4ec6730eec3ed74b0b73 | 25491561      | 2023-01-27T18:57:36.000Z | 0xcb4ccf9a637d50ca3d15a601cb5ddce25190cffbca53a981a19d6e57d25db30c |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 772474890258669286    | 6          | 0x402fdb1a672166ac3e40ce6b491869e8fe408e34 | 25477758      | 2023-01-27T11:10:15.000Z | 0x9af85577d866073c97641c51bf7c59c640d7f2ea90f9fc6ce2b531e845d5ca57 |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 4023631092829154364   | 19         | 0x4677c06757a2059c7b750fd5b59c2e65bf1851b3 | 26889197      | 2023-03-01T15:45:35.000Z | 0xd315821737c120ee11028604d93305db108fac4a9bae2115900070417b3cb74e |
</Accordion>

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

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

***

### AvalanchePool\_AvaxClaimPendingV2\_event

Pending claim events from Ankr's Avalanche liquid staking pool contract, recording user withdrawal requests with claim amounts and rebasing token status. Used for tracking unstaking flows and analyzing liquidity demand in Ankr's aAVAXb/aAVAXc staking derivatives.

<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_claimer`       | `STRING`    | Address of the account initiating the claim transaction. 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_isRebasing`    | `BOOL`      | Boolean flag indicating whether the staked or claimed tokens use a rebasing token model.                                                             |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_amount           | log\_index | in\_claimer                                | block\_number | in\_isRebasing | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | -------------------- | ---------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 19182152904826915699 | 1          | 0x9a5890640f7f6feb402a26c27e6685fe5badb309 | 17270620      | true           | 2022-07-13T11:26:38.000Z | 0xcddb2c2e0bbdccf625a8b1c6590ee88f3a59ecced21f82e1764e0cadf0cbeac4 |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 589052281185650      | 4          | 0x8d61ab7571b117644a52240456df66ef846cd999 | 22489095      | true           | 2022-11-17T11:37:53.000Z | 0x6e5432540055786e9c4cab7e76ae282d4a778ea7fcfb6dd8438ccc78626ae9af |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 112175225552286946   | 6          | 0x8d61ab7571b117644a52240456df66ef846cd999 | 22489210      | false          | 2022-11-17T11:42:01.000Z | 0x025bf7d73c358f95c0b12f8820fd124816fa9914b3f4e48412d81bb1c79f6647 |
</Accordion>

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

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

***

### AvalanchePool\_StakePending\_event

Pending stake deposits to Ankr's liquid staking pool on Avalanche, emitted when users initiate AVAX staking before finalization. Used for tracking stake deposit flow and analyzing user staking patterns by amount and timing.

<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_staker`        | `STRING`    | Address of the account that deposited or staked tokens into the protocol. 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.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_amount          | in\_staker                                 | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 1000000000000000000 | 0xd751b311518af1e45156870927242953cfb6ab4e | 1          | 1950235       | 2021-05-20T21:07:45.000Z | 0xe590c07f208eaa71cacb712c2b45fc01fca1f1dd91727a88e55d8d296d79b0d1 |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 1000000000000000000 | 0x6e9681c9cbcf23fc3b9a044b04941b792b0dcbd9 | 3          | 18808466      | 2022-08-18T15:55:39.000Z | 0x1af144adb98f282278653d00300e27067a3cba22ce085efd7a1699be0b347926 |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 1000000000000000000 | 0x6e9681c9cbcf23fc3b9a044b04941b792b0dcbd9 | 2          | 18808449      | 2022-08-18T15:55:05.000Z | 0x5d6a96fa04c4fe8411a1fae5c9b59cd2c35f63a3d923cb0449c54bee16a68ab9 |
</Accordion>

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

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

***

### AvalanchePool\_StakePendingV2\_event

Pending stake deposit events from Ankr's Avalanche liquid staking pool contract, capturing AVAX amounts and staker addresses before stakes are confirmed. Used for tracking staking flow and analyzing rebasing vs non-rebasing token preferences.

<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_staker`        | `STRING`    | Address of the account that deposited or staked tokens into the protocol. 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_isRebasing`    | `BOOL`      | Boolean flag indicating whether the staked or claimed tokens use a rebasing token model.                                                             |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_amount           | in\_staker                                 | log\_index | block\_number | in\_isRebasing | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | -------------------- | ------------------------------------------ | ---------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 50000000000000000000 | 0x08504247c8e714c1913a46bf4d76e390112f0073 | 3          | 17928667      | true           | 2022-07-28T23:27:54.000Z | 0x71e598bf761c4dd4d070f32428266a1699b2ec4560d4e3b0badb88ce82bfd23b |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 2000000000000000000  | 0x0c0f133f8c37d63cc24ddb6448485605c3acf4ea | 4          | 17913040      | true           | 2022-07-28T14:26:59.000Z | 0xf2002890cb80ef0552a21dcb068f7e799ee8faa094b45df573a8d2765c817143 |
  | 0x7baa1e3bfe49db8361680785182b80bb420a836d | false   | 7000000000000000000  | 0x82b80b15801caf83432203f3a2355e7a869b45aa | 3          | 21381078      | true           | 2022-10-22T06:16:38.000Z | 0x75fc4d4284215a4472d7340ef04f84e9656e5efb01b4ce68f5c32967a2cd5b33 |
</Accordion>

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

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

***