Validator Stake Daily

This table provides daily snapshots of validator stake and commission state on the Monad network, sourced from the staking precompile getValidator() call. Each record represents the latest validator state per day.

Table Schema

Column Name	Data Type	Description
date	DATE	Calendar date of the snapshot, derived from block_timestamp
validator_id	VARCHAR	Unique identifier assigned to the validator by the Monad network
auth_address	VARCHAR	Authorization (operator) address with control over the validator stake
commission	DECIMAL	Validator commission rate at the execution layer, expressed as a fraction (e.g., 0.10 = 10%)
stake	DECIMAL	Validator execution-layer stake (upcoming stake pool balance)
snapshot_stake	DECIMAL	Snapshot stake value recorded for the validator at the time of the read
consensus_stake	DECIMAL	Active stake used by the consensus layer for the current epoch
consensus_commission	DECIMAL	Commission rate applied at the consensus layer for the current epoch
snapshot_commission	DECIMAL	Snapshot commission rate recorded for the validator at the time of the read
acc_reward_per_token	DECIMAL	Accumulated reward per token for the validator, used for reward accounting
unclaimed_rewards	DECIMAL	Total rewards accrued by the validator that have not yet been claimed
secp_pubkey	VARCHAR	Secp256k1 public key used by the validator for consensus participation
bls_pubkey	VARCHAR	BLS public key used by the validator for consensus participation
params	VARIANT	Raw JSON payload returned from the `getValidator()` staking precompile call
block_number	INTEGER	Block number at which the validator state was read
block_timestamp	TIMESTAMP	Block timestamp at which the validator state was read
block_hash	VARCHAR	Block hash corresponding to the read operation

Understanding Validator State

The daily snapshot captures multiple layers of validator state:

Execution Layer State

stake: Upcoming stake pool balance that will be active in future epochs
commission: Commission rate that will apply to future rewards

Consensus Layer State

consensus_stake: Active stake currently used for block production and validation
consensus_commission: Commission rate currently applied to rewards

Snapshot State

snapshot_stake: Historical stake value at the time of the read
snapshot_commission: Historical commission rate at the time of the read

Reward Accounting

acc_reward_per_token: Used for calculating delegator rewards
unclaimed_rewards: Total pending rewards for the validator

Sample Query

Track validator stake growth over the last 30 days:

SELECT
  validator_id,
  auth_address,
  date,
  stake,
  consensus_stake,
  commission * 100 as commission_pct,
  unclaimed_rewards,
  stake - LAG(stake) OVER (PARTITION BY validator_id ORDER BY date) as daily_stake_change
FROM monad.staking.validator_stake_daily
WHERE date >= CURRENT_DATE - INTERVAL '30 days'
ORDER BY date DESC, stake DESC;

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Schema

Understanding Validator State

Execution Layer State

Consensus Layer State

Snapshot State

Reward Accounting

Sample Query

​Table Schema

​Understanding Validator State

​Execution Layer State

​Consensus Layer State

​Snapshot State

​Reward Accounting

​Sample Query

Table Schema

Understanding Validator State

Execution Layer State

Consensus Layer State

Snapshot State

Reward Accounting

Sample Query