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.

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.

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ankr_v1_ethereum.ETHStaking_StakeConfirmed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.

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.

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ankr_v1_ethereum.ETHStaking_StakeRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.

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.

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ankr_v1_ethereum.ETHStakingV2_PendingUnstake_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ETHStaking_StakeConfirmed_event

ETHStaking_StakeRemoved_event

ETHStakingV2_PendingUnstake_event

​Tables

​ETHStaking_StakeConfirmed_event

​ETHStaking_StakeRemoved_event

​ETHStakingV2_PendingUnstake_event

Tables

ETHStaking_StakeConfirmed_event

ETHStaking_StakeRemoved_event

ETHStakingV2_PendingUnstake_event