monad.gov Table: fact_validator_self_delegation_snapshots Type: Base Table
What
Parsed daily validator self-delegation snapshots from getDelegator(validatorId, auth_address) LiveQuery calls. Returns the DelInfo struct for the validator’s own delegation. This captures the validator’s TOTAL earnings because commission is deposited into auth_address’s delegator.rewards by syscallReward. So unclaimed_rewards here = commission + proportional self-stake rewards. This is the source of truth for validator earnings.Columns
| Column Name | Data Type | Description |
|---|---|---|
| SNAPSHOT_DATE | DATE | Date of the snapshot (end of day UTC) |
| VALIDATOR_ID | NUMBER | ID of the validator |
| AUTH_ADDRESS | TEXT | Validator’s authority address - used as the delegator parameter in getDelegator call |
| SNAPSHOT_BLOCK | NUMBER | Last block number of the snapshot date |
| STAKE_RAW | NUMBER | Raw self-stake amount in wei (DelInfo.stake - current active stake) |
| STAKE | FLOAT | Current active self-stake in MON. Validator’s own delegation that is earning rewards. |
| STAKE_USD | FLOAT | Self-stake value in USD |
| ACC_REWARD_PER_TOKEN_RAW | NUMBER | Delegator’s last checked accumulator value (DelInfo.acc). Used to calculate unclaimed rewards. Updated when delegator interacts with the contract. |
| UNCLAIMED_REWARDS_RAW | NUMBER | Raw unclaimed rewards in wei (DelInfo.rewards). For auth_address, this includes BOTH commission (deposited by syscallReward) AND proportional rewards earned on self-stake. This is the validator’s total pending earnings. |
| UNCLAIMED_REWARDS | FLOAT | Validator’s total unclaimed earnings in MON. Includes commission + self-stake rewards. This is what gets transferred when the validator calls claimRewards(). |
| UNCLAIMED_REWARDS_USD | FLOAT | Validator’s total unclaimed earnings value in USD |
| DELTA_STAKE_RAW | NUMBER | Raw stake to be activated next epoch in wei (DelInfo.delta_stake) |
| DELTA_STAKE | FLOAT | Pending stake to be activated in delta_epoch in MON. Set when delegating during non-delay period. |
| NEXT_DELTA_STAKE_RAW | NUMBER | Raw stake to be activated in 2 epochs in wei (DelInfo.nextdeltastake) |
| NEXT_DELTA_STAKE | FLOAT | Pending stake to be activated in nextdeltaepoch in MON. Set when delegating during delay period. |
| DELTA_EPOCH | NUMBER | Epoch when delta_stake becomes active and starts earning rewards (0 if no pending stake) |
| NEXT_DELTA_EPOCH | NUMBER | Epoch when nextdeltastake becomes active (0 if no pending stake) |
| TOTAL_PENDING_STAKE | FLOAT | Sum of deltastake and nextdelta_stake in MON. Total stake awaiting activation. |
| MON_PRICE_USD | FLOAT | End of day MON price in USD used for valuations |
| FACT_VALIDATOR_SELF_DELEGATION_SNAPSHOTS_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 |