ankr_v2_bsc

Tables

BinancePool_Staked_event

Staking deposit events from Ankr’s BinancePool contract on BNB Smart Chain, capturing BNB delegations through intermediary addresses with amounts in wei. Used for tracking liquid staking deposits and user participation in Ankr’s BNB staking pools.

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 wallet facilitating the staking transaction on behalf of the delegator. Consistently shows the same intermediary address (0xf92ff9dbda8b780a9c7bc2d2b37db9d74d1bacd6) across all staking events in the samples.
`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
0xa0c92efdcea55ca19396e4850b8d29df6f907bcd	false	3449000000000000000	193	25775567	0x2836d314d9b9919a2afe52b131d7a752d5021790	2023-02-18T13:52:11.000Z	0xf92ff9dbda8b780a9c7bc2d2b37db9d74d1bacd6	0xe151945349dbf2e670693e95bd76975aeded2d0e128df770498f050f8017a5b9
0xa0c92efdcea55ca19396e4850b8d29df6f907bcd	false	498998000000000000000	220	25778840	0xa186d2363e5048d129e0a35e2fddde767d4dada8	2023-02-18T16:38:10.000Z	0xf92ff9dbda8b780a9c7bc2d2b37db9d74d1bacd6	0x4059fdba406673820aded481aede4d201d498f118b4bcc2c4dbb6d8f2b491b68
0xa0c92efdcea55ca19396e4850b8d29df6f907bcd	false	98000000000000000	234	31067457	0x38fd479bf7cbc82a27cf1387e14c1e5f635ab103	2023-08-22T06:00:16.000Z	0xf92ff9dbda8b780a9c7bc2d2b37db9d74d1bacd6	0x169ca5a9858bc52e9dcf309872f7eadfa157a81ab0abcb343b867da7dab957b6

Example Query

Query with partition filter

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

BinancePool_UnstakePending_event

Unstaking request events from Ankr’s BNB staking pool on BNB Smart Chain, recording when users initiate withdrawals of their staked BNB before the unlock period completes. Useful for tracking liquidity flows and withdrawal patterns in the Ankr liquid staking 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
0xa0c92efdcea55ca19396e4850b8d29df6f907bcd	false	1000000000000000000	40	0xefea96e4ba7cbc8a6ebc9e5f58f5bbe4573cae56	27008116	2023-04-02T20:02:51.000Z	0x4b1d43cb491a2bf110c9b3113c3ed672cd92fd9b8453d826010f2b4374968087
0xa0c92efdcea55ca19396e4850b8d29df6f907bcd	false	1020814853322547367	35	0x60ddaf55a33f2bee51ad00eca38e9cffdc3632bd	26997988	2023-04-02T11:27:47.000Z	0x89ba30671aed07744162bff336ce372ba6354cf9b9f990b8aba8048f94f857ab
0xa0c92efdcea55ca19396e4850b8d29df6f907bcd	false	54555961112899155280	51	0xc28a1971f0b63f54fd1d4b531b82d5e167fde7d7	26990282	2023-04-02T04:55:19.000Z	0x67640667a02c7724b8917c8ad4e46b118a0965648371005ba03906aafa08908b

Example Query

Query with partition filter

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

BinancePoolV2_Staked_event

Staking event logs from Ankr’s BinancePoolV2 contract on BSC, capturing deposits with staked amounts, share allocations, and rebasing status. Useful for tracking liquid staking participation and analyzing the relationship between deposited BNB amounts and issued share 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_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_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
`in_isRebasing`	`BOOL`	Boolean flag indicating whether the staked or claimed tokens use a rebasing token model.

Sample Data

address	removed	in_amount	in_shares	in_staker	log_index	block_number	in_isRebasing	block_timestamp	transaction_hash
0x9e347af362059bf2e55839002c699f7a5bafe86e	false	39000000000000000000	36708303234736613532	0x8f0b0254f4058847676c4e52aa1f1e3c40bed61d	60	31530490	false	2023-09-07T09:39:11.000Z	0xe32008a7e0abb819a29f6b801de696a2ff8896ea0da6b9c5ea1dd880df0166b1
0x9e347af362059bf2e55839002c699f7a5bafe86e	false	100000000000000000	94123854448042598	0x58732f1c1243a0d5876a601fb8d1ee508b21580d	123	31519754	false	2023-09-07T00:41:34.000Z	0x9b91bbb685f0ec10d2b173e8a7341d547981b2f12a63e5ebbb0761b52065343d
0x9e347af362059bf2e55839002c699f7a5bafe86e	false	100000000000000000	94942672891022659	0xa186d2363e5048d129e0a35e2fddde767d4dada8	170	29356436	false	2023-06-23T15:42:48.000Z	0x985b429d0ad84a28eb6157e109db56b3751b6b43fe84fb544832ed2e0febea08

Example Query

Query with partition filter

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

BinancePoolV2_Unstaked_event

Unstaking events from Ankr’s BNB staking pool contract on BSC, recording withdrawals where users redeem their staked shares for BNB tokens. Contains amount, shares, owner and receiver addresses for analyzing staking withdrawal patterns and liquidity flows.

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`	Address of the account that owned the staked tokens being unstaked from the Ankr BinancePoolV2 contract. Typically matches the receiver address unless tokens are being unstaked on behalf of another user.
`in_receiverAddress`	`STRING`	Address receiving the unstaked tokens, typically the user withdrawing from the Binance staking pool. Often matches `in_ownerAddress` but may differ when unstaking to a different recipient address.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
`in_isRebasing`	`BOOL`	Boolean flag indicating whether the staked or claimed tokens use a rebasing token model.

Sample Data

address	removed	in_amount	in_shares	log_index	block_number	in_isRebasing	block_timestamp	in_ownerAddress	transaction_hash	in_receiverAddress
0x9e347af362059bf2e55839002c699f7a5bafe86e	false	322626597215450992	304680393217693128	38	30311322	false	2023-07-26T21:45:57.000Z	0xd2b337996822ecfa60db01beb547a0c342bfdc32	0x2c44b31ea3a7a089df10a369517f3e461de2581570c185457117917636863410	0xd2b337996822ecfa60db01beb547a0c342bfdc32
0x9e347af362059bf2e55839002c699f7a5bafe86e	false	8861568122833966902	8318868556467335959	86	32757985	false	2023-10-20T03:46:55.000Z	0xe85bb40ba5d59d5ab04e757bf3dc05869e9acf01	0xc039279133f129071894a47851bf3432a017ec279233e8d1a8464edc884b7d5a	0xe85bb40ba5d59d5ab04e757bf3dc05869e9acf01
0x9e347af362059bf2e55839002c699f7a5bafe86e	false	8521897479382308693	8000000000000000000	482	32770406	false	2023-10-20T14:11:37.000Z	0x197f4c3cc2c89a0f4c4e2443c453f29ecdf67d4b	0xb5c88c2ae89dd192e67084ff029b744cca59b93913c46ce889a8a7da9ab4c4e9	0x197f4c3cc2c89a0f4c4e2443c453f29ecdf67d4b

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BinancePool_Staked_event

BinancePool_UnstakePending_event

BinancePoolV2_Staked_event

BinancePoolV2_Unstaked_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​BinancePool_Staked_event

​BinancePool_UnstakePending_event

​BinancePoolV2_Staked_event

​BinancePoolV2_Unstaked_event

Tables

BinancePool_Staked_event

BinancePool_UnstakePending_event

BinancePoolV2_Staked_event

BinancePoolV2_Unstaked_event