| SNAPSHOT_DATE | DATE | Date of the snapshot (end of day UTC) |
| VALIDATOR_ID | NUMBER | ID of the validator |
| SNAPSHOT_BLOCK | NUMBER | Last block number of the snapshot date |
| AUTH_ADDRESS | TEXT | Validator’s authority address. Has withdrawal authority and receives commission. |
| FLAGS | NUMBER | Validator status flags (addressflags from ValExecution). ValidatorFlagsOk = active eligible, ValidatorFlagsStakeTooLow = below ACTIVEVALIDATOR_STAKE threshold. |
| EXECUTION_STAKE_RAW | NUMBER | Raw execution stake in wei. Realtime total stake pool (reflects immediately). |
| EXECUTION_STAKE | FLOAT | Execution stake in MON. Total delegated stake including pending. Changes reflect immediately. |
| EXECUTION_STAKE_USD | FLOAT | Execution stake value in USD |
| ACCUMULATED_REWARDS_PER_TOKEN_RAW | NUMBER | Validator’s accumulator value (acc from ValExecution). Used to calculate delegator rewards. Formula: delegatorrewards = stake * (currentacc - delegatoracc). Multiplied by ACCUMULATORDENOMINATOR (1e36). |
| EXECUTION_COMMISSION_BPS | NUMBER | Execution commission rate * 1e18 (e.g., 10% = 1e17). Changes reflect immediately. |
| EXECUTION_COMMISSION_PCT | FLOAT | Execution commission as percentage (0-100) |
| UNCLAIMED_REWARDS_RAW | NUMBER | Raw unclaimed_rewards from ValExecution in wei. IMPORTANT: This is the DELEGATOR REWARD POOL (total undistributed rewards for ALL delegators), NOT the validator’s personal earnings. Increased by syscallReward, decreased as delegators claim. |
| UNCLAIMED_REWARDS | FLOAT | Delegator reward pool in MON. This is NOT validator earnings - it’s the pool from which all delegators claim. For validator earnings, use factvalidatorearnings. |
| UNCLAIMED_REWARDS_USD | FLOAT | Delegator reward pool value in USD |
| CONSENSUS_STAKE_RAW | NUMBER | Raw consensus stake in wei. Stake used for current epoch’s consensus/rewards (val_consensus). |
| CONSENSUS_STAKE | FLOAT | Consensus stake in MON. Active stake for block production and reward calculations this epoch. |
| CONSENSUS_STAKE_USD | FLOAT | Consensus stake value in USD |
| CONSENSUS_COMMISSION_BPS | NUMBER | Consensus commission rate * 1e18. Active commission for reward calculations this epoch. |
| CONSENSUS_COMMISSION_PCT | FLOAT | Consensus commission as percentage |
| SNAPSHOT_STAKE_RAW | NUMBER | Raw snapshot stake in wei. Previous epoch’s consensus stake (val_snapshot). |
| SNAPSHOT_STAKE | FLOAT | Snapshot stake in MON. Used during epoch delay rounds for rewards. |
| SNAPSHOT_STAKE_USD | FLOAT | Snapshot stake value in USD |
| SNAPSHOT_COMMISSION_BPS | NUMBER | Snapshot commission rate * 1e18. Previous epoch’s active commission. |
| SNAPSHOT_COMMISSION_PCT | FLOAT | Snapshot commission as percentage |
| SECP_PUBKEY | TEXT | Secp256k1 public key used for consensus (hex encoded bytes) |
| BLS_PUBKEY | TEXT | BLS public key used for consensus (hex encoded bytes) |
| MON_PRICE_USD | FLOAT | End of day MON price in USD used for valuations |
| FACT_VALIDATOR_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 |
