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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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

Example Query

Query with partition filter

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

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.

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

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AvalanchePool_AvaxClaimPending_event

AvalanchePool_AvaxClaimPendingV2_event

AvalanchePool_StakePending_event

AvalanchePool_StakePendingV2_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AvalanchePool_AvaxClaimPending_event

​AvalanchePool_AvaxClaimPendingV2_event

​AvalanchePool_StakePending_event

​AvalanchePool_StakePendingV2_event

Tables

AvalanchePool_AvaxClaimPending_event

AvalanchePool_AvaxClaimPendingV2_event

AvalanchePool_StakePending_event

AvalanchePool_StakePendingV2_event