stader_v1_bsc

Tables

StakeManager_addRestakingRewards_function

Restaking reward distribution transactions on Stader’s BNB Chain liquid staking protocol, recording reward amounts credited to specific stake pool IDs. Used for tracking yield distribution patterns and reward frequency across Stader’s 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__id`	`STRING`	Unique identifier for the vault or position within the protocol. String-encoded integer value.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

gas	in__id	status	gas_used	signature	in__amount	to_address	block_number	from_address	block_timestamp	transaction_hash
56944	295994582	true	56472	0x7e30aa54	3042873660000000000	0x7276241a669489e4bbb76f63d2a43bfe63080f2f	25560206	0xdfb508e262b683ec52d533b80242ae74087bc7eb	2023-02-11T00:30:34.000Z	0xea685c851ed32756b3941ec7d21670fb53ac3358aaab920b527bf0211b6d686d
63171	355541461	true	62672	0x7e30aa54	5581121580000000000	0x7276241a669489e4bbb76f63d2a43bfe63080f2f	34161645	0xdfb508e262b683ec52d533b80242ae74087bc7eb	2023-12-08T01:40:18.000Z	0x1f4eec4ad7403963deb596604fd7c97ff6b7cb7b94ff79a6bcafd1e624b97cd4
63171	360637424	true	62672	0x7e30aa54	4950805680000000000	0x7276241a669489e4bbb76f63d2a43bfe63080f2f	34936935	0xdfb508e262b683ec52d533b80242ae74087bc7eb	2024-01-04T01:40:20.000Z	0xfa3f76ac6fea43d391811e8c70041bc1f75e59568f2c70fa54a552366e2c5be3

Example Query

Query with partition filter

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

StakeManager_completeUndelegation_function

Withdrawal completion records from Stader liquid staking protocol on BNB Smart Chain, tracking when users finalize their BNB undelegations after the unbonding period. Contains transaction details, withdrawal amounts in wei, and gas metrics for analyzing unstaking behavior and protocol 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__uuid`	`STRING`	Unique identifier parameter passed to the completeUndelegation function call, used to reference a specific undelegation request. Values are typically short numeric strings like ‘82’ or ‘8’ that correspond to pending withdrawal operations.

Sample Data

gas	value	status	gas_used	in__uuid	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
67033	3.0189188721e+21	true	66469	82	0xa21cfbc1	0x7276241a669489e4bbb76f63d2a43bfe63080f2f	37387719	0xdfb508e262b683ec52d533b80242ae74087bc7eb	2024-03-29T08:19:35.000Z	0x8de66b8fb4342a2df54bc65c3eb4ba1dda5b071a59d74c8c0a15ad26667ed4c1
57429	917505602970000000000	true	56945	8	0xa21cfbc1	0x7276241a669489e4bbb76f63d2a43bfe63080f2f	22159390	0x49afcdef47c024246cbef2031afe66af1a880b2f	2022-10-14T04:55:21.000Z	0xccca26c9a1a6ac435f840bff4b0bc37941eb0242b95753a8e157179b5c11cf34
67033	820598647850000000000	true	66469	86	0xa21cfbc1	0x7276241a669489e4bbb76f63d2a43bfe63080f2f	39306940	0xdfb508e262b683ec52d533b80242ae74087bc7eb	2024-06-04T03:05:40.000Z	0x838fb6269f5fa7031ee4a8c3a8cee89a9ad403d583c9cf96f69559e0e67e110f

Example Query

Query with partition filter

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

StakeManager_deposit_function

BNB deposit transactions into Stader’s StakeManager contract on BNB Smart Chain (BSC), capturing user staking operations with deposit amounts, transaction execution details, and gas costs for analyzing staking behavior and protocol inflows.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
325433	5978874864750000000	true	48416	0xd0e30db0	0x7276241a669489e4bbb76f63d2a43bfe63080f2f	35607673	0x6ae7073d801a74ee753f19323df320c8f5fe2dbc	0,3,0,0	2024-01-27T09:52:15.000Z	0xc322e15a6d704499f134ba45f3094a56c96b6e5e976909596df23a6955fa3bec
124588	100000000000000	true	48416	0xd0e30db0	0x7276241a669489e4bbb76f63d2a43bfe63080f2f	35607149	0x5307e5889c3cdf0f58640c6391a39d8662e7a634	1,0,0,0	2024-01-27T09:26:03.000Z	0xd8776df1372c51c4ef9ee010c98bf954396ce21148024d316d4232685fa01a85
152524	6000000000000000	true	65516	0xd0e30db0	0x7276241a669489e4bbb76f63d2a43bfe63080f2f	35607048	0x5307e5889c3cdf0f58640c6391a39d8662e7a634	1,0,0,0	2024-01-27T09:21:00.000Z	0x1d5e19c4d40f1fd7972318c82c7a060920f06cf44ab77a2919aa832f121f09b9

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

StakeManager_addRestakingRewards_function

StakeManager_completeUndelegation_function

StakeManager_deposit_function

​Tables

​StakeManager_addRestakingRewards_function

​StakeManager_completeUndelegation_function

​StakeManager_deposit_function

Tables

StakeManager_addRestakingRewards_function

StakeManager_completeUndelegation_function

StakeManager_deposit_function