GET
/
v1
/
execution
/
{execution_id}
/
status

curl -X GET "https://api.dune.com/api/v1/execution/{{execution_id}}/status" -H x-dune-api-key:{{api_key}}


{
  "execution_id": "01HKZW3PD00VEX36QYZ1FNRA3Z",
  "query_id": 2636251,
  "state": "QUERY_STATE_COMPLETED",
  "submitted_at": "2024-01-12T22:19:03.45706Z",
  "expires_at": "2024-04-11T22:20:01.029896Z",
  "execution_started_at": "2024-01-12T22:19:03.528268679Z",
  "execution_ended_at": "2024-01-12T22:20:01.029893899Z",
  "cancelled_at": "2023-04-08T12:27:15.749154Z",
  "result_metadata": {
    "column_names": [
      "totalNumberOfTransactions",
      "totalNumberOfUsers",
      "totalVolumeUSD",
      "totalFeesETH",
      "averageDailyNumberOfTransactions7dMA",
      "averageDailyNumberOfUsers7dMA",
      "averageDailyVolumeUSD7dMA",
      "averageDailyFeesETH7dMA",
      "averageTradesPerUser",
      "averageVolumePerUserUSD",
      "averageFeesPerUserETH",
      "numberOfUsers24h",
      "numberOfTrades24h",
      "volumeUSD24h",
      "unibotPriceWETH",
      "supplyEligibleForRevshare",
      "unibotMarketcapEligibleForRevshareETH",
      "ethPriceUSD",
      "totalTaxV1ETH",
      "totalTaxETH",
      "totalTaxV1AndV2ETH",
      "totalTax24hETH",
      "teamRevenueETH",
      "revShareRevenueETH",
      "revShareRevenueETHPer100UNIBOT",
      "revShareRevenue24hETH",
      "revShareRevenue7dETH",
      "revShareRevenue30dETH",
      "revShareRevenue30dSimpleMovingAverageETH",
      "taxPoolBalanceUNIBOT",
      "botFees24hETH",
      "botFeesHolderRevenue24hETH",
      "botFeesHolderRevenue7dETH",
      "botFeesHolderRevenue30dETH",
      "botFeesHolderRevenue30dSimpleMovingAverageETH",
      "totalCombinedRevenueETH",
      "combinedRevenue24hETH",
      "combinedHolderRevenue24hETH",
      "combinedHolderRevenue7dETH",
      "combinedRevenue7dSimpleMovingAverageETH",
      "combinedRevenue7dSimpleMovingAverageUSD",
      "combinedHolderRevenue30dSimpleMovingAverageETH",
      "totalBridgeVolumeETH",
      "numberOfBridgeTransactions",
      "numberOfBridgeUsers",
      "friendtechLifetimeVolumeUSD",
      "friendtechLifetimeNumberOfUsers",
      "friendtechLifetimeNumberOfSubjectsTraded",
      "friendtechLifetimeNumberOfTrades",
      "dailyTaxAPR",
      "weeklyTaxAPR",
      "annualizedTaxAPR",
      "annualizedTaxAPY",
      "dailyFeesAPR",
      "weeklyFeesAPR",
      "annualizedFeesAPR",
      "annualizedFeeAPY",
      "dailyCombinedAPR",
      "weeklyCombinedAPR",
      "annualizedCombinedAPR",
      "annualizedCombinedAPY"
    ],
    "result_set_bytes": 2271,
    "total_row_count": 1,
    "datapoint_count": 61,
    "pending_time_millis": 71,
    "execution_time_millis": 57501
  }
}

You must pass the execution_id obtained from making an execute query POST request.

Returns the status of a query execution along with relevant metadata of the results if the execution is completed.

​
Execution States

Once an execution is triggered, it can be in one of the following states:

  • QUERY_STATE_PENDING: The query execution is waiting for an execution slot.
  • QUERY_STATE_EXECUTING: The query is currently executing.
  • QUERY_STATE_FAILED: The query execution failed. This is a terminal state.
  • QUERY_STATE_COMPLETED: The query execution completed successfully. You can retrieve the query result for this execution_id.
  • QUERY_STATE_CANCELED: The query execution was canceled by the user.
  • QUERY_STATE_EXPIRED: The query execution expired, and the result is no longer available.
  • QUERY_STATE_COMPLETED_PARTIAL: The query execution was successful, but the result was truncated because it was too large. To receive the truncated result, set the allow_partial_results flag to true in the API request to fetch result.

curl -X GET "https://api.dune.com/api/v1/execution/{{execution_id}}/status" -H x-dune-api-key:{{api_key}}

Headers

​
X-DUNE-API-KEY
string
required

API Key for accessing this service

Path Parameters

​
execution_id
string
required

unique identifier of the execution

Response

200
application/json
OK
​
execution_id
string
required

Unique identifier for the execution of the query.

​
query_id
integer
required

Unique identifier of the query.

​
state
string
required

The state of the query execution.

​
submitted_at
string
required

Timestamp of when the query was submitted.

​
expires_at
string

Timestamp of when the query result expires.

​
execution_started_at
string

Timestamp of when the query execution started.

​
execution_ended_at
string

Timestamp of when the query execution ended.

​
cancelled_at
string

Timestamp of when the query execution was cancelled, if applicable.

​
result_metadata
object

Metadata about the execution of the query, including details like column names, row counts, and execution times.

Was this page helpful?

Raise issue
Cancel ExecutionGet Execution Result