​
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
ColumnData TypeDescription
activity_dateTIMESTAMP_NTZ(9)The date for which the metrics are reported
missed_slotsINTEGERNumber of slots where a block was expected but not produced
apr_consensus_rewardFLOATAnnualized percentage rate of consensus rewards relative to active staked balance
apr_execution_pbs_rewardFLOATAnnualized percentage rate of execution PBS rewards relative to active staked balance
apr_execution_non_pbs_rewardFLOATAnnualized percentage rate of execution non-PBS rewards relative to active staked balance
apr_total_rewardFLOATAnnualized percentage rate of all rewards (consensus + execution) relative to active staked balance
staked_balanceNUMERICTotal amount of ETH staked across all validators
staked_balance_active_ongoingNUMERICTotal amount of ETH staked by active and ongoing validators
total_balanceNUMERICTotal balance including staked ETH and rewards across all validators
balance_active_ongoingNUMERICTotal balance of active and ongoing validators including staked ETH and rewards
total_validatorsINTEGERTotal count of validators across all states
validators_active_ongoingINTEGERCount of validators in the active and ongoing state
execution_rewards_non_pbsNUMERICTotal execution layer rewards not from PBS (Priority Block Space)
execution_rewards_pbsNUMERICTotal execution layer rewards from PBS (Priority Block Space)
consensus_rewardsNUMERICTotal consensus layer rewards
block_rewardsNUMERICTotal rewards from block proposals
block_rewards_validatorsINTEGERNumber of validators that received block proposal rewards
sync_committee_rewardsNUMERICTotal rewards from sync committee participation
sync_committee_validatorsINTEGERNumber of validators that received sync committee rewards
attestation_rewardsNUMERICTotal rewards from attestations
total_eth_depositsNUMERICTotal amount of ETH deposited during the period
avg_eth_depositsNUMERICAverage amount of ETH per deposit
total_validator_depositsINTEGERTotal number of validator deposits
total_eth_withdrawalsNUMERICTotal amount of ETH withdrawn during the period
avg_eth_withdrawalsNUMERICAverage amount of ETH per withdrawal
total_validator_withdrawalsINTEGERTotal number of validator withdrawals
validators_entry_queuedINTEGERNumber of validators waiting in the entry queue
entry_churn_per_epochINTEGERNumber of validators that can enter the active set per epoch
total_entry_queue_epochsFLOATEstimated number of epochs required to process the entry queue
total_entry_queue_minutesFLOATEstimated time in minutes to process the entry queue
total_entry_queue_hoursFLOATEstimated time in hours to process the entry queue
total_entry_queue_daysFLOATEstimated time in days to process the entry queue
validators_exit_queuedINTEGERNumber of validators waiting in the exit queue
exit_churn_per_epochINTEGERNumber of validators that can exit the active set per epoch
total_exit_queue_epochsFLOATEstimated number of epochs required to process the exit queue
total_exit_queue_minutesFLOATEstimated time in minutes to process the exit queue
total_exit_queue_hoursFLOATEstimated time in hours to process the exit queue
total_exit_queue_daysFLOATEstimated time in days to process the exit queue