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

> Tables in tt-contracts.ankr_v1_ethereum

## Tables

### ETHStaking\_StakeConfirmed\_event

Confirmed ETH staking deposits to Ankr's liquid staking protocol, recording staker addresses and deposit amounts (in wei) for each stake transaction. Used for analyzing Ankr staking activity, depositor behavior, and total value locked (TVL) changes over time.

<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                                                  |
  | ------------------------------------------ | ------- | -------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x84db6ee82b7cf3b47e8f19270abde5718b936670 | false   | 32000000000000000000 | 0x1e49f7edfd23ae814061da0719ccaa080369762d | 116        | 11473340      | 2020-12-17T22:26:48.000Z | 0x3e6cb86c0505e0813bddd6e12aedc2619d348039aecc84e0866d5614c6b45db5 |
  | 0x84db6ee82b7cf3b47e8f19270abde5718b936670 | false   | 32000000000000000000 | 0x1e49f7edfd23ae814061da0719ccaa080369762d | 141        | 11473437      | 2020-12-17T22:46:36.000Z | 0x39a3642334782ab0f0e879a3430f632133f163bf1275b97e3fa9fb3dff977c8b |
  | 0x84db6ee82b7cf3b47e8f19270abde5718b936670 | false   | 32000000000000000000 | 0x1e49f7edfd23ae814061da0719ccaa080369762d | 16         | 11473509      | 2020-12-17T22:56:44.000Z | 0x00935d57ddab95d1519126bbd5ab712264da55ed6632d2d9372b3ff8b5542d5d |
</Accordion>

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

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

***

### ETHStaking\_StakeRemoved\_event

ETH stake removal events from Ankr's Ethereum liquid staking protocol, recording when users unstake ETH with amounts in wei and staker addresses. Used for tracking withdrawal activity and analyzing liquidity flows in Ankr's staking service.

<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                                                  |
  | ------------------------------------------ | ------- | ------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x84db6ee82b7cf3b47e8f19270abde5718b936670 | false   | 6500000000000000000 | 0xaee5a126c39a0250b9657c139f28c7c961a9f48f | 153        | 11594639      | 2021-01-05T12:58:43.000Z | 0x5210f753161e1beb8de2a800c25f55371cc68f75e050bbe2f135ee1385f0954d |
  | 0x84db6ee82b7cf3b47e8f19270abde5718b936670 | false   | 8500000000000000000 | 0x2e35628dc65ae683e3743835634cf85116641d2f | 275        | 11417048      | 2020-12-09T06:25:47.000Z | 0x3d5e68a63f3edbd78e4d5592ce33d6dcc7677621915eaeb4ba46114523f9ef66 |
  | 0x84db6ee82b7cf3b47e8f19270abde5718b936670 | false   | 6000000000000000000 | 0x274b79cc01fd88c7b0441e59e56b20687881710b | 276        | 11661703      | 2021-01-15T19:45:37.000Z | 0xca4836e302239ff7e2d822a5cc8b371d7c82326c0ae7c297178ca81388df3466 |
</Accordion>

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

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

***

### ETHStakingV2\_PendingUnstake\_event

Pending unstake requests from Ankr's Ethereum liquid staking protocol (aETH), capturing user-initiated withdrawals with amounts, owner addresses, and token type flags. Used for tracking unstaking queue activity and analyzing withdrawal patterns from Ankr's staking service.

<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_ownerAddress`    | `STRING`    | Ethereum address of the user who initiated the unstaking request and owns the staked tokens. Hex-encoded, 0x-prefixed 40-character string representing the account withdrawing from Ankr's ETH staking contract. |
  | `in_receiverAddress` | `STRING`    | Ethereum address designated to receive the unstaked tokens upon completion of the pending withdrawal. Typically matches the owner address, indicating users usually receive their own unstaked funds.            |
  | `in_amount`          | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                                                                                  |
  | `in_isAETH`          | `BOOL`      | Flag indicating whether the unstake request is denominated in ankrETH (aETH) tokens versus the underlying staked ETH. Determines the token type being withdrawn from the Ankr staking contract.                  |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_amount           | in\_isAETH | log\_index | block\_number | block\_timestamp         | in\_ownerAddress                           | transaction\_hash                                                  | in\_receiverAddress                        |
  | ------------------------------------------ | ------- | -------------------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
  | 0x84db6ee82b7cf3b47e8f19270abde5718b936670 | false   | 6709665167746479144  | false      | 334        | 17751454      | 2023-07-22T21:49:59.000Z | 0x274b79cc01fd88c7b0441e59e56b20687881710b | 0xad88055f8e5bf2bd91a4f0d022265b61cf1c1ad1b2258d5b79ba1147d00825de | 0x274b79cc01fd88c7b0441e59e56b20687881710b |
  | 0x84db6ee82b7cf3b47e8f19270abde5718b936670 | false   | 43009704435043655500 | true       | 127        | 17747229      | 2023-07-22T07:38:23.000Z | 0x79515c211e1fc889ac50384c52700becab54f177 | 0xb8e66fc6e5d8c07a03083f7b488201c8abec1ebda7c285f8b50ee88c45d99ba7 | 0x79515c211e1fc889ac50384c52700becab54f177 |
  | 0x84db6ee82b7cf3b47e8f19270abde5718b936670 | false   | 1126552421813221463  | true       | 178        | 17387421      | 2023-06-01T17:23:47.000Z | 0x0252b927d2f2cde667d26fca9619cb6c611dbb4c | 0xa5918703a11a71c2dd5155cae0c3479b0dd96aadcca6c3b3f29acfae60769d31 | 0x0252b927d2f2cde667d26fca9619cb6c611dbb4c |
</Accordion>

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

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

***