Skip to main content
In this quickstart, we will walk through how to query for Dune data in Python. Prerequisites
Save your Dune API key in a .env file.
DUNE_API_KEY=<paste your API key here>

​
Step 1: Prepare your Dune query

Have a Dune query you’d like to pull data from. Here, we’ll use this query to get the DAI token balance for vitalik.eth.

​
Step 2: Install Dune Python SDK

Ensure the Dune Python SDK is installed in your environment. You can install it using pip: 
pip install dune-client

​
Step 3: Get data from Dune query

​
Import packages and set up a Dune Python client

import dotenv, os
from dune_client.types import QueryParameter
from dune_client.client import DuneClient
from dune_client.query import QueryBase

# change the current working directory where .env file lives
# os.chdir("/Users/abc/project")
os.chdir("/Users/zokum/local-Workspace/python-notebook-examples")
# load .env file
dotenv.load_dotenv(".env")
# setup Dune Python client
dune = DuneClient.from_env()
To avoid request timeout, you can increase the request timeout setting to be higher than the default 10 seconds in the same .env file we saved the API key information.
DUNE_API_KEY=<paste your API key here>
DUNE_API_REQUEST_TIMEOUT=120

​
Get query result

You can choose to either get the latest query result without triggering an execution or to trigger an execution and get the result to ensure freshest data. 
  query_result = dune.get_latest_result(3373921) # get latest result in json format
  # query_result = dune.get_latest_result_dataframe(3373921) # get latest result in Pandas dataframe format

import dotenv, os
from dune_client.types import QueryParameter
from dune_client.client import DuneClient
from dune_client.query import QueryBase

# change the current working directory where .env file lives
os.chdir("/Users/abc/project")
# load .env file
dotenv.load_dotenv(".env")
# setup Dune Python client
dune = DuneClient.from_env()

""" get the latest executed result without triggering a new execution """
query_result = dune.get_latest_result(3373921) # get latest result in json format
# query_result = dune.get_latest_result_dataframe(3373921) # get latest result in Pandas dataframe format


"""  query the query (execute and get latest result) """
query = QueryBase(
    query_id=3373921,

    # uncomment and change the parameter values if needed
    # params=[
    #     QueryParameter.text_type(name="contract", value="0x6B175474E89094C44Da98b954EedeAC495271d0F"), # default is DAI
    #     QueryParameter.text_type(name="owner", value="owner"), # default using vitalik.eth's wallet 
    # ],
)

query_result = dune.run_query_dataframe(query=query
                                        # , performance="large" # uncomment to run query on large engine, default is medium
                                        ) 

# Note: to get the result in csv format, call run_query_csv(); for json format, call run_query().