Staking
Delegator Balances Daily
Daily snapshot of delegator balances for each validator on BSC
This table provides daily snapshots of delegator balances for each validator on the BNB Smart Chain (BSC), including both stake credit tokens and equivalent BNB amounts.
Use Cases
- Track delegator participation and stake distribution over time
- Monitor validator popularity through delegation trends
- Analyze staking behavior during network events
- Calculate daily staking returns and rewards
- Measure validator market share changes
Table Schema
| Column Name | Data Type | Description |
|---|---|---|
| day | DATE | The date of the balance snapshot |
| address | VARCHAR | The delegator’s wallet address holding the credit contract token |
| operator_address | VARCHAR | The validator’s operator address |
| consensus_address | VARCHAR | The validator’s consensus address used for block validation |
| credit_contract | VARCHAR | The address of the validator’s stake credit token contract |
| credit_contract_name | VARCHAR | The name of the validator’s stake credit token |
| bnb_balance_str | VARCHAR | String representation of the delegator’s BNB balance |
| bnb_balance | DECIMAL | Float representation of the delegator’s BNB balance |
| stake_credit_balance_str | VARCHAR | String representation of the delegator’s stake credit token balance |
| stake_credit_balance | DECIMAL | Float representation of the delegator’s stake credit token balance |
| last_block_timestamp | TIMESTAMP | Timestamp of the last block where the balance was updated |
| last_block_number | INTEGER | Block number of the last balance update |
| last_block_hash | VARCHAR | Hash of the last block where the balance was updated |
| unique_id | VARCHAR | Unique identifier for the daily balance record |