Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__idSTRINGUnique identifier for the vault or position within the protocol. String-encoded integer value.
in__amountSTRINGAmount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
gasvaluein__idstatusgas_usedsignaturein__amountto_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
569440295994582true564720x7e30aa5430428736600000000000x7276241a669489e4bbb76f63d2a43bfe63080f2f255602060xdfb508e262b683ec52d533b80242ae74087bc7eb2023-02-11T00:30:34.000Z0xea685c851ed32756b3941ec7d21670fb53ac3358aaab920b527bf0211b6d686d
631710355541461true626720x7e30aa5455811215800000000000x7276241a669489e4bbb76f63d2a43bfe63080f2f341616450xdfb508e262b683ec52d533b80242ae74087bc7eb2023-12-08T01:40:18.000Z0x1f4eec4ad7403963deb596604fd7c97ff6b7cb7b94ff79a6bcafd1e624b97cd4
631710360637424true626720x7e30aa5449508056800000000000x7276241a669489e4bbb76f63d2a43bfe63080f2f349369350xdfb508e262b683ec52d533b80242ae74087bc7eb2024-01-04T01:40:20.000Z0xfa3f76ac6fea43d391811e8c70041bc1f75e59568f2c70fa54a552366e2c5be3
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__uuidSTRINGUnique 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.
gasvaluestatusgas_usedin__uuidsignatureto_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
670333.0189188721e+21true66469820xa21cfbc10x7276241a669489e4bbb76f63d2a43bfe63080f2f373877190xdfb508e262b683ec52d533b80242ae74087bc7eb2024-03-29T08:19:35.000Z0x8de66b8fb4342a2df54bc65c3eb4ba1dda5b071a59d74c8c0a15ad26667ed4c1
57429917505602970000000000true5694580xa21cfbc10x7276241a669489e4bbb76f63d2a43bfe63080f2f221593900x49afcdef47c024246cbef2031afe66af1a880b2f2022-10-14T04:55:21.000Z0xccca26c9a1a6ac435f840bff4b0bc37941eb0242b95753a8e157179b5c11cf34
67033820598647850000000000true66469860xa21cfbc10x7276241a669489e4bbb76f63d2a43bfe63080f2f393069400xdfb508e262b683ec52d533b80242ae74087bc7eb2024-06-04T03:05:40.000Z0x838fb6269f5fa7031ee4a8c3a8cee89a9ad403d583c9cf96f69559e0e67e110f
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
gasvaluestatusgas_usedsignatureto_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
3254335978874864750000000true484160xd0e30db00x7276241a669489e4bbb76f63d2a43bfe63080f2f356076730x6ae7073d801a74ee753f19323df320c8f5fe2dbc0,3,0,02024-01-27T09:52:15.000Z0xc322e15a6d704499f134ba45f3094a56c96b6e5e976909596df23a6955fa3bec
124588100000000000000true484160xd0e30db00x7276241a669489e4bbb76f63d2a43bfe63080f2f356071490x5307e5889c3cdf0f58640c6391a39d8662e7a6341,0,0,02024-01-27T09:26:03.000Z0xd8776df1372c51c4ef9ee010c98bf954396ce21148024d316d4232685fa01a85
1525246000000000000000true655160xd0e30db00x7276241a669489e4bbb76f63d2a43bfe63080f2f356070480x5307e5889c3cdf0f58640c6391a39d8662e7a6341,0,0,02024-01-27T09:21:00.000Z0x1d5e19c4d40f1fd7972318c82c7a060920f06cf44ab77a2919aa832f121f09b9
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