SQL and Dune Analytics

Dune Analytics lets anyone query blockchain data with SQL. Community dashboards decode complex protocols; building your own queries unlocks custom research no preset dashboard covers.

Indexers decode raw chain data into tables like ethereum.transactions and erc20 transfers. You write SQL joins across tables; Dune renders charts and shares dashboards publicly.

Starter queries count daily active addresses for a contract, sum DEX volume by token pair, or rank top recipients of a governance token airdrop. Spell tables in newer DuneSQL versions abstract cross-chain queries across ecosystems.