Quickstart

Get started on Dune in five minutes!

Convert data into knowledge!

Welcome to Dune

This guide will help you get started on Dune in five minutes. We’ll walk you through how to:

1. Query blockchain data
2. Create a visualization
3. Present your data

Dune has many more features, but these are the basics you’ll need to get started. If you’re looking for more advanced guides, check out the Analytics Guidelines and Data Tables sections.

Prerequisites:

• You’ll need to have a Dune account to follow along. If you don’t have one, you can sign up here.
• We also recommend you have a basic understanding of SQL and Blockchain concepts.

1. Query blockchain data

To query for blockchain data on Dune you’ll need to:

1. Create a new query
2. Write some SQL
3. Run the query
4. Name and save the query

--Query to get Ethereum's unique daily active users and passive users  in 2023

SELECT  
--truncate time to day
date_trunc('day', block_time) AS time,
-- count distinct addresses that sent a transactions
COUNT(distinct "from") AS users,
-- count distinct addresses that received a transaction
COUNT(distinct "to") AS receiving_addresses
FROM ethereum.transactions
WHERE block_time > DATE '2023-01-01'
GROUP BY 1

Direct link to query here.

2. Create a visualization

To create a visualization you’ll need to:

1. Create a new visualization
2. Select the type of visualization you want to create
3. Choose the data source for the x and y axis
4. adjust the visualization settings

In our example below, we’ll create a line chart to visualize the number of unique daily active users and passive users on Ethereum in 2023. Additionally, we format the axis label and tick label to 0ato make the numbers more readable.

3. Present your data

To present your data you’ll need to:

1. Create a new dashboard
2. Add a visualization to the dashboard
3. Adjust the layout of the dashboard
4. Name and save the dashboard

Recap

Congratulations, you’ve just queried blockchain data, created a visualization, and presented your data on Dune!

You can now share your dashboard with the world.

We’ll take care of updating this dashboard whenever somebody looks at it, so you don’t have to worry about keeping it up to date.

Next steps

Check out these resources to learn more about Dune:

• Dune Official Getting Started Video Series to learn how the data flows and how to navigate the Dune app to create queries, visualizations, and dashboards.

• All Ethereum and SQL Basics to learn all the basic SQL concepts and Ethereum tables you’ll need in your analysis.

• For pure SQL practice, try going through the “easy” problems on hackerrank.

Join the community and learn together in Discord by participating in the #🐥︱beginners and #🙋︱query-questions channels