Get Execution Status

Check the status of an execution request

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

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.

Example:

"01HKZW3PD00VEX36QYZ1FNRA3Z"

query_id

integer

required

Unique identifier of the query.

Example:

2636251

state

string

required

The state of the query execution.

Example:

"QUERY_STATE_COMPLETED"

submitted_at

string

required

Timestamp of when the query was submitted.

Example:

"2024-01-12T22:19:03.45706Z"

expires_at

string

Timestamp of when the query result expires.

Example:

"2024-04-11T22:20:01.029896Z"

execution_started_at

string

Timestamp of when the query execution started.

Example:

"2024-01-12T22:19:03.528268679Z"

execution_ended_at

string

Timestamp of when the query execution ended.

Example:

"2024-01-12T22:20:01.029893899Z"

cancelled_at

string

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

Example:

"2023-04-08T12:27:15.749154Z"

result_metadata

object

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

Show child attributes

result_metadata.column_names

string[]

Names of the columns in the result set.

Example:

[
  "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_metadata.result_set_bytes

integer

Total number of bytes in the result set.

Example:

2271

result_metadata.total_row_count

integer

Total number of rows in the result set.

Example:

1

result_metadata.datapoint_count

integer

The count of datapoints used for billing/pricing, based on the result set.

Example:

61

result_metadata.pending_time_millis

integer

Time in milliseconds that the query was pending before execution.

Example:

71

result_metadata.execution_time_millis

integer

Time in milliseconds that the query took to execute.

Example:

57501