duneanalytics/spellbook

SQL views for Dune

Stars: 1.5k
Forks: 1.4k
Open beginner issues: 0
Indexed issues: 24
Avg merge: 3d 16h
Merged PRs (30d): 22

Dominant language: Python
License: No license data
Last GitHub push: Sep 18, 2026
Latest indexed: Sep 20, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed

Beginner friendly Everything

Open All

24 open issues indexed

[CONTRIBUTION] Added 1.5.0 support for existing Safe Contracts and included Robinhood, HyperEVM, Ink, Monad Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

duneanalytics/spellbook#10016 · Opened Sep 18, 2026
[BUG] dex.trades: amount_usd has no tie-break when both legs are trusted, so a 0.698 USDC swap books as $336,873,539 Open

bug

Difficulty 4/5 3-5 days Newbie friendliness 42/100

duneanalytics/spellbook#9997 · Opened Sep 11, 2026
lending.* on Base: moonwell misses newer mToken markets (~7x borrow undercount); compound v3 missing the cAEROv3 comet Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

duneanalytics/spellbook#9980 · Opened Sep 2, 2026
[BUG] solana_utils.daily_balances coerces unobserved SPL token state to zero after lamport-only final activity Open

bug

Difficulty 5/5 Over a week Newbie friendliness 35/100

duneanalytics/spellbook#9965 · Opened Aug 23, 2026
[BUG] oneinch project_swaps counts the same intent-settled swap twice (classic + intent rows) Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

duneanalytics/spellbook#9961 · 1 comment · Opened Aug 21, 2026
[CONTRIBUTION] Peer (ZKP2P) peer-to-peer fiat offramp on Base: deposits, intents, fills, withdrawals, fees Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

duneanalytics/spellbook#9939 · 1 comment · Opened Aug 17, 2026
[CONTRIBUTION] Add USDG Gold (USDG) Ethereum token metadata Open

Difficulty 2/5 1-3 hours Newbie friendliness 65/100

duneanalytics/spellbook#9935 · 1 comment · Opened Aug 13, 2026
[CONTRIBUTION] Add a relative amount_usd divergence test for dex.trades Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

duneanalytics/spellbook#9914 · 1 reaction · Opened Aug 1, 2026
[CONTRIBUTION] Squeeze launchpad — deployments, trades, labels (Base, Robinhood, Solana) Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

duneanalytics/spellbook#9903 · 1 comment · Opened Jul 25, 2026
CoW Protocol: Misleading dex_swaps Evaluation Open

Difficulty 3/5 1-2 days Newbie friendliness 68/100

duneanalytics/spellbook#9731 · Opened Jun 9, 2026
[CONTRIBUTION] Add BEX (Berachain native DEX) to dex.trades on berachain Open

Difficulty 3/5 1-2 days Newbie friendliness 65/100

duneanalytics/spellbook#9640 · Opened May 6, 2026
[CONTRIBUTION] Add staking_plume.deposits table (Plume staking sector) Open

Difficulty 3/5 1-2 days Newbie friendliness 62/100

duneanalytics/spellbook#9535 · Opened Apr 6, 2026
[CONTRIBUTION] Add Barter router trades to dex aggregators Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

duneanalytics/spellbook#9431 · Opened Mar 7, 2026
[CONTRIBUTION] Add RFQ_trades Ethereum dataset Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

duneanalytics/spellbook#9430 · Opened Mar 7, 2026
[CONTRIBUTION] Add ChimpX AI-powered DeFi aggregator to dex.trades on BNB Chain Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

duneanalytics/spellbook#9356 · Opened Feb 23, 2026
[BUG] records with empty token_mint_address in solana_utils.daily_balances Open

bug

Difficulty 4/5 3-5 days Newbie friendliness 35/100

duneanalytics/spellbook#9350 · Opened Feb 23, 2026
[CONTRIBUTION] Fix mislabeled Fluid Protocol contract on Base Open

bug

Difficulty 2/5 1-3 hours Newbie friendliness 45/100

duneanalytics/spellbook#9248 · 3 comments · Opened Jan 29, 2026
[CONTRIBUTION] Add DeSyn Protocol TVL models for Ethereum, Arbitrum, BSC，hemi，scroll，plume，linea Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

duneanalytics/spellbook#9137 · Opened Dec 17, 2025
[CONTRIBUTION] Add ToroDex (Sei-native perpetuals DEX) to perpetual.trades Open

Difficulty 5/5 Over a week Newbie friendliness 30/100

duneanalytics/spellbook#9112 · 1 comment · Opened Dec 10, 2025
[CONTRIBUTION] Add defituna to Solana dex_trades Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

duneanalytics/spellbook#9069 · 1 comment · Opened Nov 27, 2025
[CONTRIBUTION] [BUG] Chainlink Price Feeds stale on Polygon, Ethereum, etc Open

bug in review

Difficulty 4/5 3-5 days Newbie friendliness 48/100

duneanalytics/spellbook#8883 · 2 comments · Opened Oct 17, 2025
data in dex.trades for Curve is incomplete Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

duneanalytics/spellbook#8716 · Opened Sep 5, 2025
[BUG] Incorrect token address for curve trades on metapool Open

bug

Difficulty 4/5 3-5 days Newbie friendliness 45/100

duneanalytics/spellbook#8376 · Opened Jun 18, 2025
[BUG] solana bot trades lineage is unable to run full refresh and data is stale Open

bug dbt: solana

Difficulty 5/5 Over a week Newbie friendliness 20/100

duneanalytics/spellbook#7989 · 6 comments · Opened Apr 7, 2025

A short digest of beginner-friendly GitHub issues.