[CONTRIBUTION] Remove stale Hildobby entity mapping: gamell.eth (0x79b5c1b215b506bd2d6ee7e244e3ec3eb765e0
Maintainers usually reply within 1 day
Nobody has claimed this yet.
Assessment
- Difficulty
- 1/5
- Estimated time
- Under an hour
- Newbie friendliness
- 88/100
Research direction
Open dbt_subprojects/hourly_spellbook/models/_sector/staking/ethereum/entities/staking_ethereum_entities_depositor_addresses.sql and locate the gamell.eth row at the address shown in the issue. Remove that single stale mapping, then verify the row is absent; the issue describes the ENS records supporting its removal.
Written by the indexing model from the issue text.
Description
Proposed change
Remove the gamell.eth depositor-address entity mapping; it is now stale.
File:
dbt_subprojects/hourly_spellbook/models/_sector/staking/ethereum/entities/staking_ethereum_entities_depositor_addresses.sql
Current row (line 502 on main as of 2026-10-28):
, (0x79b5c1b215b506bd2d6ee7e244e3ec3eb765e0df, 'gamell.eth', 'gamell.eth', 'Solo Staker')
Why it is stale
The gamell.eth ENS no longer resolves to / is associated with
0x79b5c1b215b506bd2d6ee7e244e3ec3eb765e0df:
- Forward record:
gamell.eth -> 0x79b5...at block 12,453,967, then
cleared to0x0at block 23,879,031 (name sold, old pointer removed). - Current owner of
gamell.ethis0x98d70c5a38b4b17333c113ddf6f1a9714a1b8580
(a different address). - No live (or historical) reverse record links
0x79b5...back to the name.
So the label points at an address that is no longer associated with that name.
Suggested fix
Delete the single row above. Pure stale-data removal — no schema, column, or join changes.
ENS profile for reference: https://etherscan.io/ens/profile/gamell.eth
cc @hildobby (original author of the staking entity dataset)
- Dominant language
- Python
- Stars
- 1.5k
- Forks
- 1.4k
- Avg merge
- 2d 6h
- Merged PRs (30d)
- 24
Getting set up
- No Dockerfile or Docker Compose file
- Has a pull request template
- Read the contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from duneanalytics/spellbook
-
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
duneanalytics/spellbook#9935 · 1 comment ·
Maintainers usually reply within 1 day
-
Difficulty 4/5 3-5 days Newbie friendliness 25/100
duneanalytics/spellbook#10075 ·
Maintainers usually reply within 1 day
-
Difficulty 3/5 1-2 days Newbie friendliness 63/100
duneanalytics/spellbook#10071 ·
Maintainers usually reply within 1 day
-
Difficulty 3/5 1-2 days Newbie friendliness 72/100
duneanalytics/spellbook#10045 · 1 comment ·
Maintainers usually reply within 1 day
-
Difficulty 5/5 Over a week Newbie friendliness 15/100
duneanalytics/spellbook#10044 · 2 comments ·
Maintainers usually reply within 1 day
All issues in duneanalytics/spellbook
Similar issues
-
changelog investigate
Difficulty 2/5 1-3 hours Newbie friendliness 67/100
ramnes/notion-sdk-py#433 ·
-
docs pkg:core
Difficulty 1/5 Under an hour Newbie friendliness 84/100
pydantic/pydantic-ai#11929 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
intake/intake-esm#789 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
MemMachine/MemMachine#1877 ·
Maintainers usually reply within 3 days
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
openedx/openedx-authz#579 ·
Maintainers usually reply within 1 day