> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Staking

> Curated Ethereum staking datasets with entity identification on Dune

Dune's staking tables provide comprehensive data on Ethereum's Proof-of-Stake beacon chain — validator deposits, withdrawals, and entity identification. These tables map staking activity to known entities like Lido, Coinbase, Rocket Pool, and dozens of others.

<Info>
  **Maintained by:** Dune · **Refresh:** \~30 min · **Chain:** Ethereum only
</Info>

<Card title="Get This Data" icon="database" href="https://dune.com/enterprise?dataset=staking">
  Access staking data via API, Datashare, or the Dune App.
</Card>

## Available Tables

<CardGroup cols={2}>
  <Card title="staking_ethereum.deposits" icon="database" href="/data-catalog/curated/staking/deposits">
    All ETH staking deposits with entity attribution
  </Card>

  <Card title="staking_ethereum.flows" icon="database" href="/data-catalog/curated/staking/flows">
    Combined deposits and withdrawals in a unified view
  </Card>

  <Card title="staking_ethereum.entities" icon="database" href="/data-catalog/curated/staking/entities">
    Entity identification mapping for depositor addresses
  </Card>

  <Card title="staking_ethereum.info" icon="database" href="/data-catalog/curated/staking/info">
    Static metadata about staking entities
  </Card>
</CardGroup>

## When to Use These Tables

* Track ETH staking deposits and withdrawals over time
* Analyze staking entity market share (Lido vs Coinbase vs solo stakers)
* Monitor validator activity and withdrawal patterns
* Identify which entities control staking infrastructure
* Assess staking concentration risk

## Coverage

**Chain:** Ethereum only (beacon chain staking is Ethereum-specific)

**Entity identification via:** Depositor addresses, smart contract analysis, transaction origin addresses, withdrawal credentials, batch contract patterns, and protocol-specific identification for Coinbase, Binance, Lido, Rocket Pool, and many others.

## Query Performance

`staking_ethereum.deposits` is an incremental table. Filter on `block_time` ranges for best performance.

```sql theme={null}
-- ✅ Good: time-bounded
SELECT * FROM staking_ethereum.deposits
WHERE block_time >= DATE '2025-01-01'

-- ❌ Slow: full table scan
SELECT * FROM staking_ethereum.deposits
WHERE entity = 'Lido'
```

## Methodology

Staking tables are maintained by Dune ([source code](https://github.com/duneanalytics/spellbook)). They decode events from Ethereum's beacon chain deposit contract, enrich them with entity identification from multiple sources (on-chain traces, known address mappings, withdrawal credential analysis), and join with beacon chain validator data for withdrawal tracking.

Entity identification uses a layered approach: first matching depositor addresses to known entities, then analyzing smart contract patterns and withdrawal credentials, and finally using batch deposit heuristics for staking pools.

## Example Queries

**Staking entity market share:**

```sql theme={null}
SELECT
  entity,
  entity_category,
  SUM(amount_staked) AS total_eth_staked,
  COUNT(*) AS num_deposits
FROM staking_ethereum.deposits
GROUP BY 1, 2
ORDER BY 3 DESC
LIMIT 20
```

**Monthly staking deposits vs withdrawals:**

```sql theme={null}
SELECT
  date_trunc('month', block_time) AS month,
  SUM(amount_staked) AS eth_deposited,
  SUM(amount_full_withdrawn) AS eth_full_withdrawn,
  SUM(amount_partial_withdrawn) AS eth_partial_withdrawn,
  SUM(amount_staked) - SUM(amount_full_withdrawn) - SUM(amount_partial_withdrawn) AS net_staking_flow
FROM staking_ethereum.flows
WHERE block_time >= DATE '2024-01-01'
GROUP BY 1
ORDER BY 1
```

## Related Tables

* `labels.addresses` — Additional address labels beyond staking entities
* `cex.addresses` — Identifies CEX-controlled addresses, useful for understanding CEX staking

<CardGroup cols={2}>
  <Card title="Enterprise Data Solutions" icon="building" href="https://dune.com/enterprise">
    Need custom staking analytics or dedicated support? Talk to our enterprise team.
  </Card>

  <Card title="Build Custom Models" icon="code" href="/api-reference/connectors/overview">
    Build private staking analytics pipelines with the dbt Connector.
  </Card>
</CardGroup>