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 |