Dune SQL Cheatsheet

500 production-ready queries. A field-ready reference for Dune Analytics

Dune Analytics Trino SQL Ethereum Solana DeFi NFT Web3

Built for Customer Solutions Specialists, Support Engineers, and Data Analysts working with blockchain data. Covers raw tables, decoded contracts, Spellbook abstractions, and query optimization patterns.

Raw Tables

Ethereum Raw Tables

transactions, logs, traces, blocks

50 queries → raw_tables_ethereum.md

Solana Raw Tables

transactions, instruction_calls, account_activity

50 queries → raw_tables_solana.md

Decoded & Abstractions

Decoded Contracts

ERC20 transfers, DEX trades, NFT trades, Aave, Uniswap, Compound

50 queries → decoded_contracts.md

Spellbook Abstractions

tokens.erc20, prices.usd, dex.trades, nft.trades, labels

50 queries → spellbook_abstractions.md

Optimization & Patterns

Query Optimization

Timeout fixes, DATE_TRUNC filtering, CTEs vs subqueries

50 patterns → query_optimization.md

Trino SQL Patterns

Array operations, JSON parsing, bytea manipulation

50 queries → trino_sql_patterns.md

Window Functions: Onchain

LAG/LEAD, running totals, ranking, moving averages

50 queries → window_functions_onchain.md

Support & Reference

Support Triage Queries

Customer debugging templates, transaction lookup, wallet analysis

50 queries → support_triage_queries.md

Dune API Reference

API endpoints, query execution, result handling

50 patterns → dune_api_reference.md

Common Errors Reference

Error messages, troubleshooting steps, edge cases

50 entries → common_errors_reference.md