Metrics

​

Overview

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