Table Details
| Property | Value |
|---|---|
| Table Name | bsc.staking.overview |
| Table Status | Production-Ready |
| Unique Key | activity_date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| activity_date | DATE | Calendar date (UTC) this daily record aggregates. |
| total_validators | NUMBER(38,0) | Total number of validators registered on this date. |
| active_validators | NUMBER(38,0) | Number of validators in the active set on this date. |
| total_stake | FLOAT | Total staked amount across all validators. |
| active_stake | FLOAT | Staked amount held by the active validator set. |
| apy | FLOAT | Estimated annualized staking yield on this date. |
| total_rewards | FLOAT | Total staking rewards distributed on this date. |
| total_validator_commission | FLOAT | Total commission retained by validators on this date. |
| total_delegator_rewards | FLOAT | Total rewards distributed to delegators on this date. |
| stake_inflow | FLOAT | Stake added by delegations on this date. |
| stake_outflow | FLOAT | Stake removed by undelegations on this date. |
| stake_outflow_claimed | FLOAT | Undelegated stake claimed by delegators on this date. |
| stake_relegated | FLOAT | Stake moved between validators (redelegated) on this date. |
| stake_inflow_delegator_count | NUMBER(38,0) | Distinct delegators that added stake on this date. |
| stake_outflow_delegator_count | NUMBER(38,0) | Distinct delegators that removed stake on this date. |
| stake_outflow_claimed_delegator_count | NUMBER(38,0) | Distinct delegators that claimed undelegated stake on this date. |
| stake_relegated_delegator_count | NUMBER(38,0) | Distinct delegators that redelegated stake on this date. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |