Overview - Allium Documentation Hub

Table Details

Property	Value
Table Name	`beacon.metrics.overview`
Table Status	Production-Ready

ImportantThis model is new and we may have additional columns with time. If you would like a particular Beacon Chain metric supported, please get in touch with us.

The beacon.metrics.overview table provides a comprehensive daily view of Ethereum’s beacon chain performance metrics. This table consolidates key statistics about validator activity, staking economics, rewards, and queue dynamics into a single source of truth. The table includes critical metrics such as:

Daily validator counts and balances
APR calculations for different reward types
Consensus and execution layer rewards
Deposit and withdrawal activity
Entry and exit queue statistics

This table is ideal for analysts tracking Ethereum’s staking ecosystem, validator performance, and overall network health. The data is updated daily and provides a complete picture of the beacon chain’s economic activity.

Sample Query

-- Get the last 30 days of staking APR and validator counts
SELECT
    activity_date,
    apr_total_reward,
    apr_consensus_reward,
    apr_execution_pbs_reward,
    apr_execution_non_pbs_reward,
    validators_active_ongoing,
    total_validators,
    staked_balance_active_ongoing / 1e6 AS staked_eth_active_ongoing_millions
FROM beacon.metrics.overview
WHERE activity_date >= CURRENT_DATE - 30
ORDER BY activity_date DESC;

Table Columns

Column Name	Data Type	Description
activity_date	TIMESTAMP_NTZ(9)	The date for which metrics are being calculated. Only includes completed days.
missed_slots	NUMBER(19,0)	Number of slots where a block was expected but not produced
apr_consensus_reward	FLOAT	Annualized percentage rate of consensus rewards relative to active staked balance
apr_execution_pbs_reward	FLOAT	Annualized percentage rate of execution PBS rewards relative to active staked balance
apr_execution_non_pbs_reward	FLOAT	Annualized percentage rate of execution non-PBS rewards relative to active staked balance
apr_total_reward	FLOAT	Annualized percentage rate of all rewards (consensus + execution) relative to active staked balance
staked_balance	NUMBER(38,0)	Total amount of ETH staked across all validators
staked_balance_active_ongoing	NUMBER(38,0)	Total amount of ETH staked by active and ongoing validators
total_balance	FLOAT	Total balance including staked ETH and rewards across all validators
balance_active_ongoing	FLOAT	Total balance of active and ongoing validators including staked ETH and rewards
total_validators	NUMBER(38,0)	Total count of validators across all states
validators_active_ongoing	NUMBER(38,0)	Count of validators in the active and ongoing state
execution_rewards_non_pbs	FLOAT	Total execution layer rewards not from PBS (Priority Block Space)
execution_rewards_pbs	FLOAT	Total execution layer rewards from PBS (Priority Block Space)
consensus_rewards	FLOAT	Total consensus layer rewards
block_rewards	FLOAT	Total rewards from block proposals
block_rewards_validators	NUMBER(38,0)	Number of validators that received block proposal rewards
sync_committee_rewards	FLOAT	Total rewards from sync committee participation
sync_committee_validators	NUMBER(38,0)	Number of validators that received sync committee rewards
attestation_rewards	FLOAT	Total rewards from attestations
total_eth_deposits	FLOAT	Total amount of ETH deposited during the period
avg_eth_deposits	FLOAT	Average amount of ETH per deposit
total_validator_deposits	NUMBER(38,0)	Total number of validator deposits
total_eth_withdrawals	FLOAT	Total amount of ETH withdrawn during the period
avg_eth_withdrawals	FLOAT	Average amount of ETH per withdrawal
total_validator_withdrawals	NUMBER(38,0)	Total number of validator withdrawals
validators_entry_queued	NUMBER(38,0)	Number of validators waiting in the entry queue
entry_churn_per_epoch	FLOAT	Number of validators that can enter the active set per epoch
total_entry_queue_epochs	FLOAT	Estimated number of epochs required to process the entry queue
total_entry_queue_minutes	FLOAT	Estimated time in minutes to process the entry queue
total_entry_queue_hours	FLOAT	Estimated time in hours to process the entry queue
total_entry_queue_days	FLOAT	Estimated time in days to process the entry queue
validators_exit_queued	NUMBER(38,0)	Number of validators waiting in the exit queue
exit_churn_per_epoch	FLOAT	Number of validators that can exit the active set per epoch
total_exit_queue_epochs	FLOAT	Estimated number of epochs required to process the exit queue
total_exit_queue_minutes	FLOAT	Estimated time in minutes to process the exit queue
total_exit_queue_hours	FLOAT	Estimated time in hours to process the exit queue
total_exit_queue_days	FLOAT	Estimated time in days to process the exit queue

EVM Metrics Overview

EVM

​Table Details

​Sample Query

​Table Columns

​Related Docs

Table Details

Sample Query

Table Columns

Related Docs