ankr_v1_bsc

Tables

BinancePool_Staked_event

BNB staking deposits on Ankr’s BinancePool liquid staking contract on BSC (BNB Smart Chain), capturing delegator addresses, stake amounts in wei, and intermediary routing addresses. Used for tracking BNB liquid staking inflows and user adoption of Ankr’s aBNBb/aBNBc tokens.

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_delegator`	`STRING`	Address of the delegator participating in the staking or delegation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_intermediary`	`STRING`	Address of the intermediary contract or account facilitating the stake delegation between the user and the Ankr BinancePool contract. Appears to be consistently 0xf92ff9dbda8b780a9c7bc2d2b37db9d74d1bacd6 across staking transactions.
`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	block_number	in_delegator	block_timestamp	in_intermediary	transaction_hash
0x66bea595aefd5a65799a920974b377ed20071118	false	4598000000000000000	341	18850965	0x32b5ec49b7737f3e07c3ae52105802bf4dff10fd	2022-06-20T10:34:32.000Z	0xf92ff9dbda8b780a9c7bc2d2b37db9d74d1bacd6	0xdfc7105528622f3413cb207149acccf3801a17bc96cd5cd6a4f50571310d34df
0x66bea595aefd5a65799a920974b377ed20071118	false	1000000000000000000	270	18854150	0x78e27beeae7319da787457c4efd66777575132d5	2022-06-20T13:14:00.000Z	0xf92ff9dbda8b780a9c7bc2d2b37db9d74d1bacd6	0x75d41acb5a582da9fef207a50037dcd1bc98af06f9d6ece57997cbbb5036262f
0x66bea595aefd5a65799a920974b377ed20071118	false	23998000000000000000	131	22441821	0x53fca7b0bd49739186cb49016b4f4aa0e7311689	2022-10-24T02:57:16.000Z	0xf92ff9dbda8b780a9c7bc2d2b37db9d74d1bacd6	0x5a566ecf501204721ef1afa90c2a412f863edd47cd7e5390d228d7301ddd1d5e

Example Query

Query with partition filter

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

BinancePool_UnstakePending_event

Pending unstake requests from Ankr’s BNB liquid staking pool on BSC, recording withdrawal initiation events before the unbonding period completes. Tracks claimer addresses and BNB amounts (in wei) entering the withdrawal queue for analyzing unstaking patterns and liquidity outflows.

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
0x66bea595aefd5a65799a920974b377ed20071118	false	1017999999999999998	360	0xe58564b8ce8344afdfe3a111bc0b541ee7f5f7fa	22143644	2022-10-13T15:39:51.000Z	0x8249a422db3c380b9561cbf42b118624a1bd77113867f435b40dd8e3d26887e1
0x66bea595aefd5a65799a920974b377ed20071118	false	500000000000000000	264	0x6e9681c9cbcf23fc3b9a044b04941b792b0dcbd9	22137184	2022-10-13T10:12:37.000Z	0x1ec8e56f5bcd3bb3f744df0ea3eb63ae986d95aef6d5d44f9c5aac8b25619a65
0x66bea595aefd5a65799a920974b377ed20071118	false	1497999999999999998	212	0x8f5aa241215ef04e01ba036ef09dc856a7d9f035	22143697	2022-10-13T15:42:45.000Z	0x3c0de9ae5a6ef3df27534a56ad60979056915bf510804bdf5ed6ae8b2eee2edc

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BinancePool_Staked_event

BinancePool_UnstakePending_event

​Tables

​BinancePool_Staked_event

​BinancePool_UnstakePending_event

Tables

BinancePool_Staked_event

BinancePool_UnstakePending_event