Beacon Chain Tables

Goerli Beacon Chain tables available to query via SQL

The Goerli testnet has been deprecated on Spice.ai as of March 22, 2024. Datasets are available but no longer updated.

Goerli Beacon tables available to query

Table Name	Description
goerli.beacon.validators	Latest validators, with their status and current balance
goerli.beacon.slots	This table contains data about each slot in the Beacon Chain.
goerli.beacon.recent_slots	Slots from the past 30 minutes.
goerli.beacon.attestations	This table stores data about attestations made by validators on the Beacon Chain.
goerli.beacon.recent_attestations	Attestations from the past 30 minutes.
goerli.beacon.deposits	This table contains data about validator deposits made on the Beacon Chain.
goerli.beacon.recent_deposits	Deposits from the past 30 minutes.
goerli.beacon.voluntary_exits	This table stores data about voluntary exits of validators from the Beacon Chain.
goerli.beacon.recent_voluntary_exits	Voluntary exits from the past 30 minutes.
goerli.beacon.attester_slashings	This table contains information about attester slashings on the Beacon Chain. Occurs when a validator has made conflicting attestations
goerli.beacon.recent_attester_slashings	Attester slashings from the past 30 minutes
goerli.beacon.proposer_slashings	This table stores data about proposer slashings on the Beacon Chain. Proposer slashings occur when a validator has been found to have proposed two conflicting blocks for the same slot.
goerli.beacon.recent_proposer_slashings	Proposer slashings from the past 30 minutes
goerli.beacon.bls_to_execution_changes	Requests to change old BLS withdrawal credentials to the new withdrawal credentials in execution address format
goerli.beacon.recent_bls_to_execution_changes	Requests from the past 30 minutes
goerli.beacon.withdrawals	Withdrawals of ETH from the beacon chain to the Goerli testnet chain
goerli.beacon.recent_withdrawals	Withdrawals from the past 30 minutes

The table list is also available as a SQL query using show tables. For example:

SHOW TABLES IN goerli.beacon