Overview
This schema contains 32 tables and views for Monad data.Tables and Views
Dim Epochs
Dimension table for staking epochs.
Dim Miner Validators
Slowly Changing Dimension (Type 2) tracking miner address to validator ID relationships.
Dim Validators
Dimension table for Monad validators.
Ez Block Production
Block production metrics per validator per epoch.
Ez Compound Decision
Compound vs sell decision support data per validator.
Ez Delegator Balances Daily
Daily staking balances enriched with delegator labels from dim_labels.
Ez Miss Rate
Miss rate and estimated commission impact per validator per epoch.
Ez Net Stake Changes
Daily net stake changes per validator.
Ez Restart Impact
Restart impact estimates per validator.
Ez Staking Balances Daily
End of day staking balances for each validator-delegator pair, reconstructed from event history.
Ez Staking Flows Daily
Daily staking flows aggregated by validator, delegator, and flow type.
Ez Validator Apr
Daily and rolling APR/APY calculations per validator.
Ez Validator Balances Daily
Daily wallet balances for validator addresses (auth_address from ValidatorCreated events).
Ez Validator Consensus Logs
Consensus log data joined with validator dimension data.
Ez Validator Earnings
Daily validator total earnings calculated as claimed rewards plus the change in unclaimed balance from the prior day.
Ez Validator Epoch Performance
Validator performance per epoch comparing expected vs actual block production based on MonadBFT’s stake-weighted leader selection.
Ez Validator Self Stake
Daily view showing the percentage of each validator’s total stake that is self-staked (where validator auth_address equals delegator_address).
Ez Validator Totals Daily
Daily staking totals rolled up to the validator level.
Ez Validator Uptime
Validator uptime metrics at the epoch level.
Fact Block Priority Fees
Priority fees paid to block producers (validators) per block.
Fact Delegations
Delegate events from the Monad staking precompile.
Fact Epoch Changes
EpochChanged events emitted by syscallOnEpochChange at the end of epoch delay rounds.
Fact Rewards Claimed
ClaimRewards events emitted when claimRewards() is called to withdraw accumulated rewards.
Fact Undelegations
Undelegate events from the Monad staking precompile.
Fact Validator Commission Changes
CommissionChanged events emitted when changeCommission() is called by a validator’s auth_address.
Fact Validator Rewards
ValidatorRewarded events emitted by syscallReward for every block.
Fact Validator Self Delegation Snapshots
Parsed daily validator self-delegation snapshots from getDelegator(validatorId, auth_address) LiveQuery calls.
Fact Validator Snapshots
Parsed daily validator snapshots from getValidator() LiveQuery calls.
Fact Validator Status Changes
ValidatorStatusChanged events emitted when a validator’s flags change during addValidator(), delegate(), undelegate(), or compound().
Fact Validator Timeouts
Timeout events from Monad consensus joined with validator dimension data.
Fact Validators Created
ValidatorCreated events from the Monad staking precompile (0x0000000000000000000000000000000000001000).
Fact Withdrawals
Withdraw events from the Monad staking precompile.