SonarX

Indexed Ethereum BeaconBlockchain Data

The Ethereum Beacon Chain is Ethereum's proof-of-stake consensus layer, running Gasper over twelve-second slots and keeping a ledger of validators, attestations, slashings and withdrawal payments with no virtual machine.

Ethereum Beacon Chain logo

How to query Ethereum Beacon Chain data with SonarX

Instant Data Share

Available today

Snowflake, and file dumps to your object storage

Query Ethereum Beacon Chain blockchain data with plain SQL from a live database inside your own Snowflake account, populated with the indexed chain dataset. There is no pipeline to build and no second copy to store. The same dataset ships as file dumps to your own object storage for lakes and warehouses that are not Snowflake.

  • Full history as a Snowflake data-share
  • File dumps to S3 or your own object storage
  • Real-time delivery, current to chain tip — on request

Used for:

  • Analytics teams already on Snowflake that want Ethereum Beacon Chain data beside their existing tables
  • Fund accounting and treasury reporting that reconciles against a fixed history
  • Cross-chain questions answered in one SQL statement instead of one query per chain
  • Loading Ethereum Beacon Chain history into BigQuery, Databricks, Redshift or a Spark lake
  • Replacing a self-hosted indexer and the engineering time that keeps it running
  • Serving one governed dataset to several desks without copying it per team

Curated Datasets

Available today

Purpose-built tables

Protocol-level Ethereum Beacon Chain datasets modelled for one job, so the decoding and the joins are done before the data reaches you.

  • Staking

Used for:

  • Position-level Ethereum Beacon Chain lending, swap and liquidity analysis
  • Reward, delegation and validator reporting without rebuilding the model
  • Token distribution, holder and payment-flow reporting
  • Risk and exposure work that needs protocol state, not raw logs
  • Skipping the decoding layer an in-house team would have to maintain
  • Extending an existing Ethereum Beacon Chain share with a modelled slice

Balances

Enabled on request

Tables and REST

Read what a Ethereum Beacon Chain address held, either as it stands now or exactly as it stood at a past block or timestamp.

  • Point-in-time balance tables, as at any block or timestamp

Used for:

  • Reconstructing Ethereum Beacon Chain portfolios and NAV as at a reporting date
  • Audit and reconciliation work that has to be repeatable months later
  • Wallet and portfolio products that render Ethereum Beacon Chain balances on page load
  • Compliance checks that read one Ethereum Beacon Chain address at one block height
  • Refreshing holdings for a whole book of accounts on a schedule
  • Tax and cost-basis workflows that need holdings at each event

Realtime API

Enabled on request

REST over the indexed dataset

Query indexed Ethereum Beacon Chain records over REST, reading the same dataset the share reads, with no warehouse in the path.

Used for:

  • Applications that need one answer rather than a table scan
  • Customer-facing screens where query latency is visible to a user
  • Services that have no data warehouse and do not want to run one
  • Prototyping against production data before committing to a share
  • Backend checks that run per request instead of per batch
  • Teams that want indexed Ethereum Beacon Chain data behind their own API layer

Ethereum Beacon Chain data: frequently asked questions

What is Ethereum Beacon Chain?

The Beacon Chain is the consensus layer of Ethereum, and it keeps a ledger of its own. It began producing blocks on 1 December 2020, ran alongside the execution chain for nearly two years, and took over ordering Ethereum’s blocks at the Merge in September 2022. Consensus runs under Gasper: Casper FFG supplies finality, LMD-GHOST supplies fork choice, and validators are assigned to twelve-second slots grouped into epochs of thirty-two. There is no virtual machine here and no contract state. The records are a validator registry keyed by index and BLS public key, attestations, block proposals, slashings, deposits, voluntary exits and, since the Shapella upgrade of April 2023, withdrawal payments. Balances are denominated in ETH but held against validator indices rather than twenty-byte addresses, and since the Pectra upgrade in 2025 a validator’s effective balance is no longer fixed at thirty-two ETH.

Ethereum Beacon Chain data on SonarX

SonarX indexes the consensus layer’s own objects: beacon blocks and the slots they fill, the validator registry and the state transitions that move a validator through it, attestations and where they were included, deposits, exits, slashings, sync-committee duty and withdrawal payments. The same normalized model is used on every chain SonarX covers, so consensus records sit beside execution records and can be joined in one query.

Full historical coverage is available today as a data-share or a file delivery. Real-time delivery is enabled on request. Point-in-time balance tables can be enabled for Ethereum Beacon Chain on request.

How SonarX indexes Ethereum Beacon Chain

The join key is the work. Consensus records identify a validator by index and by a BLS public key, execution records identify an account by a twenty-byte hash, and no beacon block carries the second. Tying a validator’s rewards back to whoever funded it means following the deposit that created it and the withdrawal credentials it was registered with. The volumes are lopsided too. A slot holds one block and tens of thousands of attestations, and those attestations are aggregated before inclusion, so participation per validator has to be expanded out of bitfields rather than read off a row.

What teams build with Ethereum Beacon Chain data

Validator and reward accounting is the workload this dataset exists for: what a validator was owed per epoch, what it actually received, and where the gap came from. Staking operators restate that per customer, which means attributing each validator to the deposit that funded it and to the address its withdrawals land on. Penalty research is the second, because missed attestations, inactivity leaks and slashings are the record of how an operator and its client software behaved under stress, and none of it is visible from execution data. Withdrawal reconciliation is the third and crosses both layers by construction. Gnosis Beacon Chain presents the same split for a different network, and staking analytics is the solution area this work sits in across the chains SonarX indexes.

Getting Ethereum Beacon Chain data from SonarX

Tell us the delivery target, how far back you need and how fresh it has to be, and the share is scoped against that. Consensus history is available now, and it is worth saying at the start whether execution records are in scope as well, since most questions here span both. The published coverage matrix for every network SonarX indexes lives in the data documentation, and the rest of the catalogue is at all indexed chains.

Is there an Ethereum Beacon Chain data API?

APIs over indexed Ethereum Beacon Chain data are enabled on request, reading the same indexed dataset as the Snowflake share. Note that Ethereum Beacon Chain has no user token-balance model: the only balances it records are validator balances, which belong to the staking dataset rather than to a balances API.

How do I get Ethereum Beacon Chain data into Snowflake?

SonarX provisions a data-share into your own Snowflake account. The share appears as a database you query with SQL, so there is no pipeline to build and no second copy to store, and it stays current as SonarX advances the indexing pipeline.

How far back does Ethereum Beacon Chain coverage go?

The historical data-share and file delivery cover the consensus layer from its own genesis on 1 December 2020 forward, which is nearly two years before the Merge tied it to execution. Real-time delivery keeps the same dataset current to chain tip and is enabled on request.

Is this Ethereum mainnet data?

It is one half of it. Ethereum mainnet execution data, meaning transactions, receipts, logs and contract state, is a separate dataset with its own page. This one carries the consensus side: validators, attestations, proposals, slashings and withdrawals. Analysis that follows ETH into and out of staking needs both, because the two layers record different ends of the same movement.

Where do validator withdrawals appear in the data?

On both layers, in two different forms. A withdrawal is triggered on the consensus layer and reduces a validator balance there, then arrives on the execution layer as a credit to the withdrawal address rather than as an ordinary transaction. Matching the two sides is what makes a staking address reconcile, and it is why consensus records and execution records are indexed against the same slot.

Does Beacon Chain data include transactions or smart contracts?

No. The consensus layer runs no virtual machine and holds no contract state, so there are no transactions, receipts or event logs in it. What it records is the validator set and everything that changes it: deposits, activations, attestations, proposals, penalties, exits and withdrawals, keyed by validator index rather than by a twenty-byte address.

Ethereum Beacon Chain logo

Get Ethereum Beacon Chain data from SonarX