Name of Retrospective Award
Node and Minipool Analytics + Dune Spellbook
Who is the proposed retrospective award recipient?
What specific project or work is the retrospective award in recognition of? Please detail what the project or work entailed and the duration over which it took place.
Over the past six months (from November 2024 to May 2025), I completed a data infrastructure and analytics project for the Rocket Pool community, focused on improving visibility into Node Operators and Minipools. This work is the basis for my retrospective grant application.
Key components of the project include:
-
Dashboard Development: I created a Dune Analytics dashboard under the
rp_communityaccount to surface key metrics and insights surrounding Node Operators and Minipools. -
Reusable Datasets: I built scalable, modular datasets designed to support future Rocket Pool protocol upgrades and new features for node operators. These datasets enable other contributors to build additional analytics without starting from scratch.
-
Open Source Contribution: All dataset code was published to the
rp_communityGitHub repository for transparency and community use:
GitHub - rp_community validator datasets -
Documentation: I wrote a Medium article explaining how the datasets were constructed, the methodology behind them, and how they can be used by the community.
-
Integration with Dune Spellbook: I collaborated with the Dune Analytics team to integrate these datasets into the Dune Spellbook. This makes them available as native tables, improving query performance and discoverability, while also laying the groundwork for future dataset expansion.
This project significantly enhances transparency and tooling for Rocket Pool Node Operators, and provides a sustainable foundation for ongoing analytics development by the community.
Are the subjects of this award entirely open source (MIT, GPL, Apache, CC BY license or similar)? If not, which parts will not be, why, and under what license will they be published?
Yes
Benefit
The analytics and datasets created as part of this project serve multiple stakeholders in the Rocket Pool ecosystem. By increasing transparency and providing actionable insights, this work helps grow trust, engagement, and understanding across the community:
| Group | Benefits |
|---|---|
| Potential rETH holders | Analytics highlight demand for rETH by showing minipool queue length and deposit needs. |
| rETH holders | Analytics demonstrate decentralization among node operators and validate Rocket Pool’s unique value proposition versus other LSTs. |
| Potential Node Operators (NOs) | Analytics build trust in the protocol by providing transparency into existing node operator behavior. |
| Node Operators (NOs) | Analytics help operators benchmark their performance and operations against peers. |
| Community | Analytics support informed discussion about protocol health and the impact of upgrades or changes. |
| RPL holders | Analytics show RPL staking utilization relative to circulating supply, helping assess token utility. |
Costs
$4,500
This amount reflects a contribution similar in scope and effort to my previous work, with a strong focus on generating long-term value for the Rocket Pool ecosystem. In addition to developing reusable datasets and a comprehensive analytics dashboard, this work includes integration into the Dune Spellbook—a foundational step that encourages further community contributions to analytics.
By enabling native access to key metrics and improving dataset performance, this effort supports more informed decision-making for both community members and protocol leaders.
Conflict of Interest
Does the person or persons requesting the retrospective award have any conflicts of interest to disclose? (Please disclose here if you are a member of the GMC or if you have nominated a member of the GMC for this retrospective award).
No