Why Dune Analytics?
Dune Analytics has become the go-to platform for on-chain data analysis, used by everyone from retail traders to institutional researchers. With SQL queries, you can extract insights that are impossible to get from price charts alone.
Getting Started
Sign up at dune.com with a free account. Navigate to "Create" → "New Query." Select your blockchain (Ethereum, Solana, Arbitrum, etc.) from the dataset dropdown. Dune uses a PostgreSQL-compatible SQL dialect with additional blockchain-specific functions.
Your First Query: Daily DEX Volume
Let's query Uniswap v3 daily trading volume on Ethereum. Start with a simple query to get comfortable with Dune's schema:
SELECT date_trunc('day', block_time) as day, SUM(amount_usd) as volume FROM dex.trades WHERE project = 'uniswap' AND blockchain = 'ethereum' GROUP BY 1 ORDER BY 1 DESC LIMIT 30
Building Visualizations
Dune supports line charts, bar charts, pie charts, tables, and counters. For our volume query, create a line chart with day on the X-axis and volume on the Y-axis. Add a moving average to smooth out daily volatility.
Creating a Dashboard
Combine multiple queries into a dashboard: (1) Daily volume chart, (2) Top pools by TVL table, (3) New users counter, (4) Fee generation chart. Arrange the widgets in a logical flow — overview at top, details below.
Sharing and Forking
Dashboards can be public or private. The Dune community thrives on forking — find an existing dashboard, fork it, and customize it for your needs. Many top analysts share their queries publicly, providing an excellent learning resource.
