Skip to main content
Schema: monad.gov Table: ez_validator_totals_daily Type: View

What

Daily staking totals rolled up to the validator level. Aggregates all delegator balances per validator per day from ez_staking_balances_daily. Includes total active stake, pending withdrawals, delegator counts, and USD valuations. NOTE: Inherits event-based limitations from ez_staking_balances_daily - if event history is incomplete, totals may be inaccurate. For authoritative stake data, use fact_validator_snapshots.

Columns

Column NameData TypeDescription
BALANCE_DATEDATEDate of the balance snapshot
VALIDATOR_IDNUMBERID of the validator
VALIDATOR_NAMETEXTHuman-readable validator name from labels, or ‘Validator N’ if not labeled
CONSENSUS_ADDRESSTEXTBlock producer address derived from secp_pubkey. Appears as “miner” in block headers.
TOTAL_ACTIVE_STAKEFLOATSum of all delegators’ active stake for this validator in MON
TOTAL_ACTIVE_STAKE_USDFLOATTotal active stake value in USD
TOTAL_PENDING_WITHDRAWALFLOATSum of all pending withdrawals across delegators in MON
TOTAL_PENDING_WITHDRAWAL_USDFLOATTotal pending withdrawal value in USD
TOTAL_STAKE_AT_RISKFLOATActive + pending stake (both subject to slashing until withdrawn) in MON
TOTAL_STAKE_AT_RISK_USDFLOATTotal stake at risk value in USD
DAILY_ACTIVE_CHANGEFLOATNet change in total active stake for this day
DAILY_PENDING_CHANGEFLOATNet change in total pending withdrawal balance for this day
DELEGATOR_COUNTNUMBERTotal number of unique delegators who have interacted with this validator
ACTIVE_DELEGATOR_COUNTNUMBERNumber of delegators with active stake > 0
MON_PRICE_USDFLOATEnd of day MON price in USD used for valuations
EZ_VALIDATOR_TOTALS_DAILY_IDTEXTUnique identifier for this record