Understanding on-chain data gives you an edge if you're building a crypto product, evaluating investment opportunities, or looking for a job.

Dune has a new AI assistant that allows you to analyse blockchain data without any programming experience!

In this guide, I will teach you how to use DuneAI to become a crypto data wizard 🧙✨

If you worked through the previous guide on using ChatGPT + Dune you'll find some basic Dune concepts repeated here. Feel free to skip those context sections and go straight to the prompting guidance.

What data is available on Dune?

To use DuneAI effectively, we must first understand what data is available in Dune. This allows us to identify the types of questions that DuneAI can and cannot answer given the data limitations.

Dune currently has data for Ethereum, Arbitrum, Optimism, Polygon, BSC, Gnosis Chain, Solana, Avalanche, Fantom, Bitcoin, Celo, Base, ZkSync, Zora Chain and Ethereum's Goerli testnet.

There are 4 main categories of data tables on Dune

  • Raw data: These tables have raw, unedited blockchain data, consisting of transactions, traces and logs.
  • Decoded data: These tables contain contract calls and events grouped by the smart contract and the project that the smart contract belongs to.
  • Spellbook: These tables provide a simplified and easy-to-understand overview of data relating to a project or a specific category.
  • Community: Datasets produced by third-party teams that bring off-chain data to Dune.
Dune Data Explorer

Types of Questions

We can generally classify the types of questions we can ask DuneAI based on the focus of the question and the data sources required.

A. Category-focused questions: For example, questions about NFT trades, bridge transactions or airdrop claims. Consult Spellbook tables specific to that category.

B. Project-focused questions: For example, questions about Uniswap, Aave or OpenSea. Use decoded data and/or Spellbook data for the respective project.

C. Smart contract or wallet-specific questions: Rely on raw data and/or decoded data filtered for that specific address.

In this lesson, we will be exploring a category-focused question. Specifically, we're going to ask DuneAI for some DEX trading data.

Generating Dune queries with DuneAI

Follow the video guide to make your first DuneAI prompt!

This post is for paying subscribers only

Already have an account? Sign in.

DuneAI - Beginner to Expert Crypto Data Guide #1 📊✨