Use Cases
- Monitor current staking positions across validators
- Track realtime changes in validator market share
- Analyze delegation concentration and distribution
- Calculate current staking rewards and returns
- Identify large staking position movements
- Measure validator popularity through current stake
Table Schema
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR | The delegator’s wallet address |
| operator_address | VARCHAR | The validator’s operator address |
| consensus_address | VARCHAR | The validator’s consensus address |
| stake_credit_address | VARCHAR | The address of the validator’s stake credit token contract |
| stake_credit_name | VARCHAR | The name of the validator’s stake credit token |
| stake_credit_symbol | VARCHAR | The symbol of the validator’s stake credit token |
| balance_str | VARCHAR | String representation of the stake credit token balance |
| balance | DECIMAL | Float representation of the stake credit token balance |
| block_timestamp | TIMESTAMP | Timestamp of the block where the balance was last updated |
| block_number | INTEGER | Block number where the balance was last updated |
| block_hash | VARCHAR | Hash of the block where the balance was last updated |
| unique_id | VARCHAR | Unique identifier for the balance record |