Ready to transform blockchain data into actionable insights?
This guide will fast-track your understanding of how to query, visualize, and share insights using Dune. Let’s dive in!Dune offers many features, but this guide focuses on the essentials you’ll need to get started. For more detailed guides, check out our Analytics Guidelines and Data Tables sections.
Begin by constructing the SQL queries you need using Dune’s Query Editor, a powerful tool for writing and executing SQL. Check out our detailed guide on writing queries.
Analyze daily activity on Ethereum by entering the following SQL:
Copy
Ask AI
--Query to get Ethereum's unique daily active users and passive users in 2023SELECT--truncate time to daydate_trunc('day', block_time) AS time,-- count distinct addresses that sent a transactionsCOUNT(distinct "from") AS users,-- count distinct addresses that received a transactionCOUNT(distinct "to") AS receiving_addressesFROM ethereum.transactionsWHERE block_time > DATE '2023-01-01'GROUP BY time
After executing a query, the results are displayed in a table below the Query Editor. The next step is to transform these raw data into a more digestible format through visualization.
Adjust the settings to suit your visualization needs, such as formatting axis labels and tick marks to enhance readability.
In the example below, we’ll create a line chart to visualize the number of unique daily active users and passive users on Ethereum in 2023. We’ll format the axis label and tick label to 0ato make the numbers more user-friendly.
Congratulations, you’ve just queried blockchain data, created a visualization, and presented your data on Dune!Now, you can share your dashboard with the world. Learn more about sharing your content effectively in our guide on how to share Dune content.