Table: t_epoch_summaries

Table Documentation: t_epoch_summaries

Summary

The t_epoch_summaries table provides a comprehensive overview of various metrics and statistics for each epoch in the Ethereum 2.0 Beacon Chain. This includes data on validator participation, the effectiveness of attestation, and other critical metrics that are essential for analyzing the network's health and performance.

Description

This table aggregates data related to epochs, including the total number of validators, the amount of ETH staked, and the performance of validators in terms of attesting to the correct target and head. It serves as a critical tool for understanding the dynamics of the network and the efficiency of the consensus mechanism over time.

Schema Overview

• f_epoch(INT64, Nullable): The epoch to which the summary data pertains.
• f_activation_queue_length(INT64, Nullable): The length of the activation queue for validators waiting to be activated.
• f_activating_validators(INT64, Nullable): The number of validators that are in the process of being activated.
• f_active_validators(INT64, Nullable): The total number of active validators during the epoch.
• f_active_real_balance(INT64, Nullable): The total balance of active validators, taking into account the actual balance on the Beacon Chain.
• f_active_balance(INT64, Nullable): The total balance of active validators, typically measured in Gwei.
• f_attesting_validators(INT64, Nullable): The number of validators that successfully attested during the epoch.
• f_attesting_balance(INT64, Nullable): The total balance of validators that successfully attested.
• f_target_correct_validators(INT64, Nullable): Validators that correctly attested to the target.
• f_target_correct_balance(INT64, Nullable): The balance of validators that correctly attested to the target.
• f_head_correct_validators(INT64, Nullable): Validators that correctly attested to the head.
• f_head_correct_balance(INT64, Nullable): The balance of validators that correctly attested to the head.
• f_attestations_for_epoch(INT64, Nullable): The total number of attestations made for the epoch.
• f_attestations_in_epoch(INT64, Nullable): The number of attestations included in the epoch.
• f_duplicate_attestations_for_epoch(INT64, Nullable): The number of duplicate attestations for the epoch.
• f_proposer_slashings(INT64, Nullable): The number of proposer slashings in the epoch.
• f_attester_slashings(INT64, Nullable): The number of attester slashings in the epoch.
• f_deposits(INT64, Nullable): The total number of deposits made during the epoch.
• f_exiting_validators(INT64, Nullable): The number of validators that initiated exit during the epoch.
• f_canonical_blocks(INT64, Nullable): The number of blocks considered canonical within the epoch.
• f_withdrawals(INT64, Nullable): The total amount withdrawn by validators during the epoch.

Example SQL Query

SELECT *
FROM raw_beacon_chain.t_epoch_summaries
LIMIT 3;

Sample Query Result

This documentation provides an in-depth view of the t_epoch_summaries table, including its purpose, schema, and how to query it, along with a sample query result that demonstrates the type of data it stores.