Replace thousands of lines of SQL code with a single spell.

Spells are curated aggregations of best-in-class blockchain data, built and maintained by Dune and our community.

Explore Spellbook
Trusted by
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo

Open transformation tool

Spellbook is an open-source repository (DBT+Github) for creating and maintaining blockchain tables using SQL and Jinja templating.

Cross-chain datasets

Get insights faster with meaningful abstractions of raw blockchain data. Popular tables include DEX Trades, NFT Trades, Balances, and Labels.

Collaborative and transparent

Data tables are built and maintained by Dune and our expert community. Code is transparent and auditable, revealing the exact logic used.

How it works:

With web3 data, we have a foundational layer of Raw Data - blockchain transactions, traces, and logs. Spellbook offers abstracted data sets, like Decentralized Exchange Trades and NFT Trades, which aggregate and organize raw blockchain data from multiple sources to make it much easier to query.

This enables the crypto community to standardize the way we transform data into meaningful abstraction layers.

400+ expert contributors
Updated hourly
2,000+ models and schemas
We use Dune for market intelligence, protocol research, and information gathering. It is the main resource for the entire web3 community as we look to understand data and trends for Uniswap users and the industry at large.
Dune's Spellbook speeds up any crypto data analysis by at least 100x
Without Dune, we would need to build another Dune internally.

Visualization is a key factor in making technology tangible to most people. This deep integration of Polkadot data into Dune is a key step that makes analysis and consequently usage of Polkadot much more accessible.

Robert Habermeier

Co Founder

Outside of Dune's AI feature, theres little to no user experience improvements using LLMs in crypto.

Moses

@defi_moses

Might be the best thing AI has given me for work productivity so far

Katia Banina

Head of Product

Unlock the power of Spellbook

Individuals + Small Teams

Create and explore queries, dashboards and trends with 500,000+ data analysts.

Enterprise

Tailored solutions designed for the largest crypto teams and premier organizations.