Metrics

Overview

ImportantThis model is new and we may have additional columns with time. If 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 / 1e9 AS staked_eth_active_ongoing_billions
FROM beacon.metrics.overview
WHERE activity_date >= CURRENT_DATE - 30
ORDER BY activity_date DESC;

Table Columns

Unique Key: activity_date

Column	Data Type	Description
activity_date	TIMESTAMP_NTZ(9)	The date for which the metrics are reported
missed_slots	INTEGER	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	NUMERIC	Total amount of ETH staked across all validators
staked_balance_active_ongoing	NUMERIC	Total amount of ETH staked by active and ongoing validators
total_balance	NUMERIC	Total balance including staked ETH and rewards across all validators
balance_active_ongoing	NUMERIC	Total balance of active and ongoing validators including staked ETH and rewards
total_validators	INTEGER	Total count of validators across all states
validators_active_ongoing	INTEGER	Count of validators in the active and ongoing state
execution_rewards_non_pbs	NUMERIC	Total execution layer rewards not from PBS (Priority Block Space)
execution_rewards_pbs	NUMERIC	Total execution layer rewards from PBS (Priority Block Space)
consensus_rewards	NUMERIC	Total consensus layer rewards
block_rewards	NUMERIC	Total rewards from block proposals
block_rewards_validators	INTEGER	Number of validators that received block proposal rewards
sync_committee_rewards	NUMERIC	Total rewards from sync committee participation
sync_committee_validators	INTEGER	Number of validators that received sync committee rewards
attestation_rewards	NUMERIC	Total rewards from attestations
total_eth_deposits	NUMERIC	Total amount of ETH deposited during the period
avg_eth_deposits	NUMERIC	Average amount of ETH per deposit
total_validator_deposits	INTEGER	Total number of validator deposits
total_eth_withdrawals	NUMERIC	Total amount of ETH withdrawn during the period
avg_eth_withdrawals	NUMERIC	Average amount of ETH per withdrawal
total_validator_withdrawals	INTEGER	Total number of validator withdrawals
validators_entry_queued	INTEGER	Number of validators waiting in the entry queue
entry_churn_per_epoch	INTEGER	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	INTEGER	Number of validators waiting in the exit queue
exit_churn_per_epoch	INTEGER	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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Overview

Sample Query

Table Columns

​Overview

​Sample Query

​Table Columns

Overview

Sample Query

Table Columns