Skip to content
DuneAnalytics

hagaetc avatar@hagaetc / Get started queries 🌱

Here are some example queries to get you started with Dune Analytics 👨‍🏫👩‍🏫

Step 1

Dai bought on Uniswap

CounterDai bought on Uniswap last 24 hours

Loading
 

This number is brought to you by a few lines of SQL code.

Click the upper right corner of the box to the left to see the SQL query.

Step 2

Let's add a time dimension

Dai bought on Uniswap per hour

Loading
 

This number is brought to you by 6 simple lines of SQL code.

We're adding block time from the Ethereum transactions table to group the number above by week.

Click the upper right corner of the box to the left to see the SQL query.

Step 3

Let's include all assets and get the USD value of volume on Uniswap

Uniswap total USD trading Volume 24 hours

Loading
 

We now include all assets and multiply with USD price of each asset at the minute it is traded.

Click the upper right corner of the box to the left to see the SQL query.

Now it's your turn 👊

  • You can fork these queries or any of the others you find on Dune
  • We have human readable data for heaps of popular dApps that you can play with
  • All data is updated real-time
  • We have tables for ETH and tokens to USD prices that you can join with
  • You can share your graphs and results on Twitter or wherever
  • Have a look at and fork dashboard and queries by other users.