Download Dune query execution results as CSV via a session-based MPP endpoint.
What it does
This endpoint returns the results of a previously executed Dune query in CSV format, given an execution ID. It is part of Dune's broader API platform, which provides programmatic access to over 1 PB of indexed multi-chain blockchain data including raw transactions, decoded smart contract events, DeFi positions, NFT activity, stablecoin flows, and more.
The endpoint accepts a GET request at `/api/v1/execution/{execution_id}/results/csv` and returns plain-text CSV. It supports query parameters for pagination (`limit`, `offset`), column selection (`columns`), row filtering (`filters`), sorting (`sort_by`), sampling (`sample_count`), and partial result retrieval (`allow_partial_results`). Authentication is via the `X-Dune-Api-Key` header or an `api_key` query parameter. The OpenAPI spec annotates this endpoint with `x-payment-info` indicating a Tempo session-based payment method at $1.00 per MB of result data.
Note: the MPP probe returned 404 rather than the expected 402 challenge, likely because the URL template contains a path parameter (`:execution_id`) that must be replaced with a valid execution ID. The endpoint is documented in Dune's OpenAPI spec and the broader API is live (the origin returns 403 at root), so the endpoint itself is likely operational when called with a real execution ID. Callers must first execute a query (via `/v1/query/{query_id}/execute` or `/v1/sql/execute`) and then use the returned `execution_id` to fetch CSV results from this endpoint.
Capabilities
Use cases
- —Exporting blockchain analytics query results as CSV for spreadsheet or BI tool ingestion
- —Downloading large on-chain datasets in a machine-parseable tabular format
- —Automating periodic data pulls of DeFi, NFT, or token metrics into data pipelines
- —Feeding CSV result data into pandas, dbt, or other data-processing frameworks
- —Retrieving filtered/sorted subsets of Dune query results for downstream analysis
Fit
Best for
- —Developers building data pipelines that consume on-chain analytics in CSV format
- —Analysts who need bulk tabular exports of blockchain query results
- —Automation workflows that chain query execution with result retrieval
Not for
- —Real-time streaming of blockchain events (this is a batch result download)
- —Running SQL queries directly — use the execute endpoints first, then fetch results here
- —Users who need JSON-formatted results (use the /results endpoint instead)
Quick start
curl -X GET "https://api.dune.com/api/v1/execution/01HKZJ2683PHF9Q9PHHQ8FW4Q1/results/csv?limit=100" \
-H "X-Dune-Api-Key: YOUR_API_KEY"Example
Response
"datetime,block_number,tx_hash,value\n2024-01-15T12:00:00,18900123,0xabc...def,1500000\n2024-01-15T12:05:00,18900130,0x123...456,2300000\n"Endpoint
Quality
Full OpenAPI schema is available with detailed parameter descriptions and payment info annotation. However, the MPP probe returned 404 (not 402) because the path contains a required execution_id parameter, so the live payment challenge was not captured. Pricing is described in x-payment-info but no actual 402 challenge was observed.
Warnings
- —MPP probe returned 404 — the endpoint requires a valid execution_id path parameter and cannot be probed with a placeholder.
- —Pricing ($1.00/MB via Tempo session) is sourced from x-payment-info in the OpenAPI spec but was not confirmed via a live 402 challenge.
- —No dedicated docs page was found at api.dune.com/docs (404); refer to docs.dune.com for full documentation.
Citations
- —Endpoint returns CSV results for a given execution ID with support for pagination, filtering, sorting, and sampling.https://api.dune.com/api
- —Payment info: $1.00 per MB of result data, session intent, tempo method.https://api.dune.com/api
- —Dune provides access to 1+ PB of indexed multi-chain data.https://api.dune.com
- —Authentication via X-Dune-Api-Key header or api_key query parameter.https://api.dune.com/api
- —API reference documentation available at docs.dune.com.https://api.dune.com