Staking
Staking Events
Record of all staking-related events on BSC including delegations, undelegations, redelegations, and claims
This table captures all staking-related events on the BNB Smart Chain (BSC), providing a comprehensive record of delegations, undelegations, redelegations, and claim events.
Use Cases
- Track staking activity patterns and trends
- Monitor validator popularity through delegation events
- Analyze network participation during market events
- Calculate total staked amounts over time
- Identify correlated staking behaviors across validators
- Measure network growth through new delegation events
Table Schema
| Column Name | Data Type | Description |
|---|---|---|
| event_type | VARCHAR | Type of staking event (delegate, undelegate, redelegate_from, redelegate_to, claim_undelegated_stake, migrate) |
| delegator_address | VARCHAR | Address of the delegator performing the action |
| operator_address | VARCHAR | Address of the validator involved in the action |
| amount_str | VARCHAR | String representation of the BNB amount involved in the event |
| amount | DECIMAL | Float representation of the BNB amount involved in the event |
| shares | DECIMAL | Amount of stake credit tokens involved in the event |
| shares_exchange_rate | DECIMAL | Exchange rate between BNB and stake credit tokens at the time of the event |
| params | JSON | Raw parameters from the event |
| transaction_hash | VARCHAR | Hash of the transaction containing the event |
| transaction_index | INTEGER | Index of the transaction in the block |
| log_index | INTEGER | Index of the event log in the transaction |
| block_timestamp | TIMESTAMP | Timestamp of the block containing the event |
| block_number | INTEGER | Block number containing the event |
| block_hash | VARCHAR | Hash of the block containing the event |
| unique_id | VARCHAR | Unique identifier for the event |