ankr_v2_ethereum

Tables

PolygonPool_MaticClaimPending_event

MaticClaimPending events from Ankr’s Ethereum-based liquid staking pool for Polygon (MATIC), recording pending claim requests with claimer addresses and amounts in wei. Used to track unstaking activity and withdrawal patterns for ankrMATIC holders.

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.

Sample Data

address	removed	in_amount	log_index	in_claimer	block_number	block_timestamp	transaction_hash
0xcfd4b4bc15c8bf0fd820b0d4558c725727b3ce89	false	1584238800000000000000	178	0x32d18915f3b653a4f4744f665abd26fabf598f32	16156135	2022-12-10T18:36:11.000Z	0x2ca20b3000e4437b1dea8d1f28d6fedbded2b190c674758135c3c25953bf6678
0xcfd4b4bc15c8bf0fd820b0d4558c725727b3ce89	false	666742351217277450976	238	0x94bb1739ae42cf69d31d603b06a6e95992ab0fc6	16157214	2022-12-10T22:12:59.000Z	0x14d46f5ca1a9d6df7c4f57a6943e67faa51fdcf5c9f77c6e1ccd690a94baab32
0xcfd4b4bc15c8bf0fd820b0d4558c725727b3ce89	false	6003192123429370707847	26	0x9d8320c0d6f0130434fb945072d6fff879576697	16746168	2023-03-03T06:21:35.000Z	0xf70f678151da7111ceea91b3d53ca5747ac15a79aa97a102b829d914c47dcd89

Example Query

Query with partition filter

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

PolygonPool_StakePending_event

Pending stake deposit events from Ankr’s Polygon liquid staking pool contract on Ethereum, capturing user addresses and MATIC token amounts awaiting processing. Useful for tracking staking queue activity and deposit flows before final stake confirmation.

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
0xcfd4b4bc15c8bf0fd820b0d4558c725727b3ce89	false	1000000000000000000	0x6e9681c9cbcf23fc3b9a044b04941b792b0dcbd9	289	15184709	2022-07-21T07:56:27.000Z	0xcfe8d5e424fb811fc0dd4f580a6bc56a3ac410f7048da2ff0a0c49eefac52ed4
0xcfd4b4bc15c8bf0fd820b0d4558c725727b3ce89	false	1000000000000000000	0x6e9681c9cbcf23fc3b9a044b04941b792b0dcbd9	50	15184694	2022-07-21T07:53:46.000Z	0xa20961895ddb0809e2c00ed005c55a60039e02bb69007cade3444ac92eef2217
0xcfd4b4bc15c8bf0fd820b0d4558c725727b3ce89	false	25000000000000000000	0x88c59f61fc5c8578f799d907fb520bb9fc028bdb	165	15184960	2022-07-21T08:53:03.000Z	0x9c1d43148619e5b5f846a32fb974d069ead3bc71f677a3b24a37900823cf296b

Example Query

Query with partition filter

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

PolygonPool_StakePendingV2_event

Pending stake deposits to Ankr’s Polygon liquid staking pool on Ethereum, capturing staker addresses, deposit amounts in wei, and rebasing preference flags. Useful for analyzing Ankr staking flow patterns and user adoption of rebasing versus non-rebasing token variants.

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.

Sample Data

address	removed	in_amount	in_staker	log_index	block_number	in_isRebasing	block_timestamp	transaction_hash
0xcfd4b4bc15c8bf0fd820b0d4558c725727b3ce89	false	5548813916167087352	0x402fdb1a672166ac3e40ce6b491869e8fe408e34	353	17485868	false	2023-06-15T14:26:59.000Z	0x20012e87ecb50542cc57452c966b6bec62f5e257336cbd691d48de358760a10a
0xcfd4b4bc15c8bf0fd820b0d4558c725727b3ce89	false	15760540365457082123601	0xad0dcc6635a5c38be6b87007210797ad94adb4b7	461	16055066	false	2022-11-26T15:30:35.000Z	0xb9181783383c88e28fe21bd4ba83720f73da16e3360e691970e80eaa65ffd657
0xcfd4b4bc15c8bf0fd820b0d4558c725727b3ce89	false	1000000000000000000	0x402fdb1a672166ac3e40ce6b491869e8fe408e34	57	17135649	false	2023-04-27T06:10:11.000Z	0x4895721bc099619a95e7f62ce64fa32182f3250412adc88491a571752410ac1f

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

PolygonPool_MaticClaimPending_event

PolygonPool_StakePending_event

PolygonPool_StakePendingV2_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​PolygonPool_MaticClaimPending_event

​PolygonPool_StakePending_event

​PolygonPool_StakePendingV2_event

Tables

PolygonPool_MaticClaimPending_event

PolygonPool_StakePending_event

PolygonPool_StakePendingV2_event