monad.gov Table: ez_staking_balances_daily Type: Base Table
What
End of day staking balances for each validator-delegator pair, reconstructed from event history. Tracks three balance states: active (delegated), pending withdrawal (undelegated but not withdrawn), and total at risk (both active and pending are subject to slashing until withdrawn). Flow: Delegate increases active -> Undelegate moves active to pending -> Withdraw removes pending. IMPORTANT: This table calculates balances from delegation/undelegation/withdrawal events. If event history is incomplete (e.g., delegations before data collection started), balances may be inaccurate. For authoritative stake data, use fact_validator_snapshots.snapshot_stake which queries on-chain state directly.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BALANCE_DATE | DATE | Date of the balance snapshot (end of day) |
| VALIDATOR_ID | NUMBER | ID of the validator |
| VALIDATOR_NAME | TEXT | Human-readable validator name from labels, or ‘Validator N’ if not labeled |
| CONSENSUS_ADDRESS | TEXT | Block producer address derived from secp_pubkey. Appears as “miner” in block headers. |
| DELEGATOR_ADDRESS | TEXT | Address of the delegator |
| ACTIVE_BALANCE | FLOAT | Currently delegated stake in MON (earning rewards, increased by Delegate, decreased by Undelegate) |
| PENDING_WITHDRAWAL_BALANCE | FLOAT | Undelegated but not yet withdrawn stake in MON (no longer earning rewards, increased by Undelegate, decreased by Withdraw) |
| TOTAL_BALANCE_AT_RISK | FLOAT | Sum of active and pending balances - total stake subject to potential slashing |
| DAILY_ACTIVE_CHANGE | FLOAT | Net change in active balance for this day |
| DAILY_PENDING_CHANGE | FLOAT | Net change in pending withdrawal balance for this day |
| EZ_STAKING_BALANCES_DAILY_ID | TEXT | Unique identifier for this record |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was inserted |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was last modified |