Ask the Grid
Create free workspace
MISO logo

Rolling public ACE JSON

MISO's Rolling public ACE JSON.

Interchange dataMISO market
Query with the agent
Native record
publisher period x document x sheet/archive member x source row x collected revision
Publisher snapshot publication cadence
Evidence
Mixed evidence
Multiple evidence types kept distinct in the contract
Time basis
Date-labelled records
UTC · report_date

Overview

Each row preserves a publisher record, workbook row, or report document with its source member and row index. Source timestamps, units, geographic scope, and revision qualifiers are retained in record_json; event_time is collection time; completed_at is when the entire document became available.

Query contract

The view admits a document only when its completion record and exact mirrored row count agree. Select a report_date, source_url and source_sha256 revision before joining source_member and row_index. Interpret observation times from the source record, never from the collection clock.

Analysis rules

  • Decode the report's source headers and units before aggregating. Never sum report_date, row_index, snapshots, revisions, regional totals and components, or forecast vintages.

Interpretation

  • report_date identifies the requested publisher period. It is not an observation timestamp. event_time records collection, not source publication or delivery.
  • The serving mirror keeps the latest row for each publisher record; older collected revisions may no longer be queryable.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

MISO MCP API reference
HTTP endpoint
POST /api/v1/datasets/miso_report_area_control_error_live/query

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema11

Column
Type
event_timeDateTime64(6, 'UTC')
datasetLowCardinality(String)
report_dateDate32
source_urlString
source_memberString
source_sha256String
row_indexInt64
record_jsonString
response_metadataString
ingested_atDateTime64(6, 'UTC')
completed_atDateTime64(6, 'UTC')

Sample data

event_timedatasetreport_datesource_urlsource_membersource_sha256row_indexrecord_jsonresponse_metadataingested_atcompleted_at
2026-10-11 04:20:41.160965area_control_error_live2026-10-11https://public-api.misoenergy.org/api/AceAce1f661f4479730a6bac3c1fa79c63e70f2a0e29ad62e071471a867cd7569219960{"MktDay": "10-10-2026", "RefId": "10-Oct-2026 - Interval 23:18:00 EST", "ACE": [{"instantEST": "2026-10-10 9:18:30 PM", "value": "41.52"}, {"instantEST": "2026-10-10 9:19:00 PM", "value": "-102.68"}, {"instantEST": "2026-10-10 9:19:30 PM", "value": "-171.30"}, {"instantEST": "2026-10-10 9:20:00 PM", "value": "19.58"}, {"instantEST": "2026-10-10 9:20:30 PM", "value": "-75.27"}, {"instantEST": "2026-10-10 9:21:00 PM", "value": "28.47"}, {"instantEST": "2026-10-10 9:21:30 PM", "value": "-23.56"}, {"instantEST": "2026-10-10 9:22:00 PM", "value": "-1.64"}, {"instantEST": "2026-10-10 9:22:30 PM", "value": "-99.99"}, {"instantEST": "2026-10-10 9:23:00 PM", "value": "153.28"}, {"instantEST": "2026-10-10 9:23:30 PM", "value": "125.86"}, {"instantEST": "2026-10-10 9:24:00 PM", "value": "27.86"}, {"instantEST": "2026-10-10 9:24:30 PM", "value": "151.84"}, {"instantEST": "2026-10-10 9:25:00 PM", "value": "212.98"}, {"instantEST": "2026-10-10 9:25:30 PM", "value": "187.48"}, {"instantEST": "2026-10-10 9:26:00 PM", "value": "-41.19"}, {"instantEST": "2026-10-10 9:26:30 PM", "value": "-201.44"}, {"instantEST": "2026-10-10 9:27:00 PM", "value": "129.74"}, {"instantEST": "2026-10-10 9:27:30 PM", "value": "109.34"}, {"instantEST": "2026-10-10 9:28:00 PM", "value": "260.70"}, {"instantEST": "2026-10-10 9:28:30 PM", "value": "216.84"}, {"instantEST": "2026-10-10 9:29:00 PM", "value": "-35.48"}, {"instantEST": "2026-10-10 9:29:30 PM", "value": "-103.03"}, {"instantEST": "2026-10-10 9:30:00 PM", "value": "192.83"}, {"instantEST": "2026-10-10 9:30:30 PM", "value": "-2.81"}, {"instantEST": "2026-10-10 9:31:00 PM", "value": "123.15"}, {"instantEST": "2026-10-10 9:31:30 PM", "value": "34.08"}, {"instantEST": "2026-10-10 9:32:00 PM", "value": "-1.39"}, {"instantEST": "2026-10-10 9:32:30 PM", "value": "-10.42"}, {"instantEST": "2026-10-10 9:33:00 PM", "value": "-180.12"}, {"instantEST": "2026-10-10 9:33:30 PM", "value": "-44.01"}, {"instantEST": "2026-10-10 9:34:00 PM", "value": "33.63"}, {"instantEST": "2026-10-10 9:34:30 PM", "value": "86.18"}, {"instantEST": "2026-10-10 9:35:00 PM", "value": "-222.22"}, {"instantEST": "2026-10-10 9:35:30 PM", "value": "-101.57"}, {"instantEST": "2026-10-10 9:36:00 PM", "value": "101.37"}, {"instantEST": "2026-10-10 9:36:30 PM", "value": "157.83"}, {"instantEST": "2026-10-10 9:37:00 PM", "value": "298.67"}, {"instantEST": "2026-10-10 9:37:30 PM", "value": "105.48"}, {"instantEST": "2026-10-10 9:38:00 PM", "value": "-25.29"}, {"instantEST": "2026-10-10 9:38:30 PM", "value": "21.55"}, {"instantEST": "2026-10-10 9:39:00 PM", "value": "-212.53"}, {"instantEST": "2026-10-10 9:39:30 PM", "value": "151.63"}, {"instantEST": "2026-10-10 9:40:00 PM", "value": "-1.80"}, {"instantEST": "2026-10-10 9:40:30 PM", "value": "32.56"}, {"instantEST": "2026-10-10 9:41:00 PM", "value": "61.56"}, {"instantEST": "2026-10-10 9:41:30 PM", "value": "120.61"}, {"instantEST": "2026-10-10 9:42:00 PM", "value": "120.56"}, {"instantEST": "2026-10-10 9:42:30 PM", "value": "135.90"}, {"instantEST": "2026-10-10 9:43:00 PM", "value": "222.58"}, {"instantEST": "2026-10-10 9:43:30 PM", "value": "161.55"}, {"instantEST": "2026-10-10 9:44:00 PM", "value": "203.87"}, {"instantEST": "2026-10-10 9:44:30 PM", "value": "211.57"}, {"instantEST": "2026-10-10 9:45:00 PM", "value": "99.79"}, {"instantEST": "2026-10-10 9:45:30 PM", "value": "275.97"}, {"instantEST": "2026-10-10 9:46:00 PM", "value": "263.57"}, {"instantEST": "2026-10-10 9:46:30 PM", "value": "121.19"}, {"instantEST": "2026-10-10 9:47:00 PM", "value": "184.00"}, {"instantEST": "2026-10-10 9:47:30 PM", "value": "-160.14"}, {"instantEST": "2026-10-10 9:48:00 PM", "value": "-167.65"}, {"instantEST": "2026-10-10 9:48:30 PM", "value": "-133.04"}, {"instantEST": "2026-10-10 9:49:00 PM", "value": "-304.56"}, {"instantEST": "2026-10-10 9:49:30 PM", "value": "-285.14"}, {"instantEST": "2026-10-10 9:50:00 PM", "value": "-61.28"}, {"instantEST": "2026-10-10 9:50:30 PM", "value": "-41.04"}, {"instantEST": "2026-10-10 9:51:00 PM", "value": "-261.86"}, {"instantEST": "2026-10-10 9:51:30 PM", "value": "-14.34"}, {"instantEST": "2026-10-10 9:52:00 PM", "value": "85.43"}, {"instantEST": "2026-10-10 9:52:30 PM", "value": "186.91"}, {"instantEST": "2026-10-10 9:53:00 PM", "value": "142.43"}, {"instantEST": "2026-10-10 9:53:30 PM", "value": "126.64"}, {"instantEST": "2026-10-10 9:54:00 PM", "value": "254.26"}, {"instantEST": "2026-10-10 9:54:30 PM", "value": "147.58"}, {"instantEST": "2026-10-10 9:55:00 PM", "value": "-5.03"}, {"instantEST": "2026-10-10 9:55:30 PM", "value": "-21.91"}, {"instantEST": "2026-10-10 9:56:00 PM", "value": "-210.78"}, {"instantEST": "2026-10-10 9:56:30 PM", "value": "-191.50"}, {"instantEST": "2026-10-10 9:57:00 PM", "value": "-253.06"}, {"instantEST": "2026-10-10 9:57:30 PM", "value": "-32.38"}, {"instantEST": "2026-10-10 9:58:00 PM", "value": "-36.03"}, {"instantEST": "2026-10-10 9:58:30 PM", "value": "-55.66"}, {"instantEST": "2026-10-10 9:59:00 PM", "value": "-40.26"}, {"instantEST": "2026-10-10 9:59:30 PM", "value": "138.61"}, {"instantEST": "2026-10-10 10:00:00 PM", "value": "-52.50"}, {"instantEST": "2026-10-10 10:00:30 PM", "value": "-84.08"}, {"instantEST": "2026-10-10 10:01:00 PM", "value": "-57.67"}, {"instantEST": "2026-10-10 10:01:30 PM", "value": "-112.51"}, {"instantEST": "2026-10-10 10:02:00 PM", "value": "-61.34"}, {"instantEST": "2026-10-10 10:02:30 PM", "value": "61.77"}, {"instantEST": "2026-10-10 10:03:00 PM", "value": "13.95"}, {"instantEST": "2026-10-10 10:03:30 PM", "value": "333.18"}, {"instantEST": "2026-10-10 10:04:00 PM", "value": "200.34"}, {"instantEST": "2026-10-10 10:04:30 PM", "value": "196.03"}, {"instantEST": "2026-10-10 10:05:00 PM", "value": "-176.29"}, {"instantEST": "2026-10-10 10:05:30 PM", "value": "-122.63"}, {"instantEST": "2026-10-10 10:06:00 PM", "value": "-267.83"}, {"instantEST": "2026-10-10 10:06:30 PM", "value": "-312.93"}, {"instantEST": "2026-10-10 10:07:00 PM", "value": "-501.62"}, {"instantEST": "2026-10-10 10:07:30 PM", "value": "-476.55"}, {"instantEST": "2026-10-10 10:08:00 PM", "value": "-403.37"}, {"instantEST": "2026-10-10 10:08:30 PM", "value": "-124.31"}, {"instantEST": "2026-10-10 10:09:00 PM", "value": "62.61"}, {"instantEST": "2026-10-10 10:09:30 PM", "value": "94.90"}, {"instantEST": "2026-10-10 10:10:00 PM", "value": "-61.04"}, {"instantEST": "2026-10-10 10:10:30 PM", "value": "147.55"}, {"instantEST": "2026-10-10 10:11:00 PM", "value": "129.32"}, {"instantEST": "2026-10-10 10:11:30 PM", "value": "-151.59"}, {"instantEST": "2026-10-10 10:12:00 PM", "value": "-102.91"}, {"instantEST": "2026-10-10 10:12:30 PM", "value": "89.71"}, {"instantEST": "2026-10-10 10:13:00 PM", "value": "80.75"}, {"instantEST": "2026-10-10 10:13:30 PM", "value": "179.80"}, {"instantEST": "2026-10-10 10:14:00 PM", "value": "238.37"}, {"instantEST": "2026-10-10 10:14:30 PM", "value": "48.97"}, {"instantEST": "2026-10-10 10:15:00 PM", "value": "-326.02"}, {"instantEST": "2026-10-10 10:15:30 PM", "value": "-457.53"}, {"instantEST": "2026-10-10 10:16:00 PM", "value": "-164.90"}, {"instantEST": "2026-10-10 10:16:30 PM", "value": "50.97"}, {"instantEST": "2026-10-10 10:17:00 PM", "value": "-12.38"}, {"instantEST": "2026-10-10 10:17:30 PM", "value": "29.65"}, {"instantEST": "2026-10-10 10:18:00 PM", "value": "-194.86"}, {"instantEST": "2026-10-10 10:18:30 PM", "value": "57.35"}, {"instantEST": "2026-10-10 10:19:00 PM", "value": "-49.80"}, {"instantEST": "2026-10-10 10:19:30 PM", "value": "-202.06"}, {"instantEST": "2026-10-10 10:20:00 PM", "value": "-57.28"}, {"instantEST": "2026-10-10 10:20:30 PM", "value": "94.75"}, {"instantEST": "2026-10-10 10:21:00 PM", "value": "-293.59"}, {"instantEST": "2026-10-10 10:21:30 PM", "value": "-460.71"}, {"instantEST": "2026-10-10 10:22:00 PM", "value": "-321.69"}, {"instantEST": "2026-10-10 10:22:30 PM", "value": "-302.27"}, {"instantEST": "2026-10-10 10:23:00 PM", "value": "-130.24"}, {"instantEST": "2026-10-10 10:23:30 PM", "value": "-72.14"}, {"instantEST": "2026-10-10 10:24:00 PM", "value": "141.07"}, {"instantEST": "2026-10-10 10:24:30 PM", "value": "229.64"}, {"instantEST": "2026-10-10 10:25:00 PM", "value": "262.85"}, {"instantEST": "2026-10-10 10:25:30 PM", "value": "360.01"}, {"instantEST": "2026-10-10 10:26:00 PM", "value": "435.94"}, {"instantEST": "2026-10-10 10:26:30 PM", "value": "666.79"}, {"instantEST": "2026-10-10 10:27:00 PM", "value": "496.73"}, {"instantEST": "2026-10-10 10:27:30 PM", "value": "373.07"}, {"instantEST": "2026-10-10 10:28:00 PM", "value": "498.66"}, {"instantEST": "2026-10-10 10:28:30 PM", "value": "352.53"}, {"instantEST": "2026-10-10 10:29:00 PM", "value": "333.71"}, {"instantEST": "2026-10-10 10:29:30 PM", "value": "370.76"}, {"instantEST": "2026-10-10 10:30:00 PM", "value": "426.23"}, {"instantEST": "2026-10-10 10:30:30 PM", "value": "235.84"}, {"instantEST": "2026-10-10 10:31:00 PM", "value": "117.76"}, {"instantEST": "2026-10-10 10:31:30 PM", "value": "-167.96"}, {"instantEST": "2026-10-10 10:32:00 PM", "value": "-315.84"}, {"instantEST": "2026-10-10 10:32:30 PM", "value": "-112.70"}, {"instantEST": "2026-10-10 10:33:00 PM", "value": "-470.58"}, {"instantEST": "2026-10-10 10:33:30 PM", "value": "-174.12"}, {"instantEST": "2026-10-10 10:34:00 PM", "value": "34.71"}, {"instantEST": "2026-10-10 10:34:30 PM", "value": "43.65"}, {"instantEST": "2026-10-10 10:35:00 PM", "value": "97.45"}, {"instantEST": "2026-10-10 10:35:30 PM", "value": "154.63"}, {"instantEST": "2026-10-10 10:36:00 PM", "value": "147.02"}, {"instantEST": "2026-10-10 10:36:30 PM", "value": "333.93"}, {"instantEST": "2026-10-10 10:37:00 PM", "value": "333.30"}, {"instantEST": "2026-10-10 10:37:30 PM", "value": "242.97"}, {"instantEST": "2026-10-10 10:38:00 PM", "value": "388.39"}, {"instantEST": "2026-10-10 10:38:30 PM", "value": "532.18"}, {"instantEST": "2026-10-10 10:39:00 PM", "value": "590.83"}, {"instantEST": "2026-10-10 10:39:30 PM", "value": "542.52"}, {"instantEST": "2026-10-10 10:40:00 PM", "value": "422.19"}, {"instantEST": "2026-10-10 10:40:30 PM", "value": "269.40"}, {"instantEST": "2026-10-10 10:41:00 PM", "value": "166.53"}, {"instantEST": "2026-10-10 10:41:30 PM", "value": "147.27"}, {"instantEST": "2026-10-10 10:42:00 PM", "value": "1.53"}, {"instantEST": "2026-10-10 10:42:30 PM", "value": "-58.29"}, {"instantEST": "2026-10-10 10:43:00 PM", "value": "-155.90"}, {"instantEST": "2026-10-10 10:43:30 PM", "value": "-247.91"}, {"instantEST": "2026-10-10 10:44:00 PM", "value": "170.54"}, {"instantEST": "2026-10-10 10:44:30 PM", "value": "137.87"}, {"instantEST": "2026-10-10 10:45:00 PM", "value": "56.18"}, {"instantEST": "2026-10-10 10:45:30 PM", "value": "-183.25"}, {"instantEST": "2026-10-10 10:46:00 PM", "value": "-63.96"}, {"instantEST": "2026-10-10 10:46:30 PM", "value": "-114.87"}, {"instantEST": "2026-10-10 10:47:00 PM", "value": "-149.64"}, {"instantEST": "2026-10-10 10:47:30 PM", "value": "-15.74"}, {"instantEST": "2026-10-10 10:48:00 PM", "value": "-266.26"}, {"instantEST": "2026-10-10 10:48:30 PM", "value": "-221.84"}, {"instantEST": "2026-10-10 10:49:00 PM", "value": "95.10"}, {"instantEST": "2026-10-10 10:49:30 PM", "value": "453.04"}, {"instantEST": "2026-10-10 10:50:00 PM", "value": "297.33"}, {"instantEST": "2026-10-10 10:50:30 PM", "value": "144.43"}, {"instantEST": "2026-10-10 10:51:00 PM", "value": "-119.91"}, {"instantEST": "2026-10-10 10:51:30 PM", "value": "208.02"}, {"instantEST": "2026-10-10 10:52:00 PM", "value": "-278.73"}, {"instantEST": "2026-10-10 10:52:30 PM", "value": "-97.87"}, {"instantEST": "2026-10-10 10:53:00 PM", "value": "48.10"}, {"instantEST": "2026-10-10 10:53:30 PM", "value": "204.22"}, {"instantEST": "2026-10-10 10:54:00 PM", "value": "126.32"}, {"instantEST": "2026-10-10 10:54:30 PM", "value": "152.21"}, {"instantEST": "2026-10-10 10:55:00 PM", "value": "-5.27"}, {"instantEST": "2026-10-10 10:55:30 PM", "value": "254.15"}, {"instantEST": "2026-10-10 10:56:00 PM", "value": "-32.57"}, {"instantEST": "2026-10-10 10:56:30 PM", "value": "-226.33"}, {"instantEST": "2026-10-10 10:57:00 PM", "value": "-110.46"}, {"instantEST": "2026-10-10 10:57:30 PM", "value": "152.65"}, {"instantEST": "2026-10-10 10:58:00 PM", "value": "-17.94"}, {"instantEST": "2026-10-10 10:58:30 PM", "value": "-3.94"}, {"instantEST": "2026-10-10 10:59:00 PM", "value": "27.68"}, {"instantEST": "2026-10-10 10:59:30 PM", "value": "34.61"}, {"instantEST": "2026-10-10 11:00:00 PM", "value": "108.69"}, {"instantEST": "2026-10-10 11:00:30 PM", "value": "-333.90"}, {"instantEST": "2026-10-10 11:01:00 PM", "value": "-2.47"}, {"instantEST": "2026-10-10 11:01:30 PM", "value": "270.41"}, {"instantEST": "2026-10-10 11:02:00 PM", "value": "-21.56"}, {"instantEST": "2026-10-10 11:02:30 PM", "value": "127.99"}, {"instantEST": "2026-10-10 11:03:00 PM", "value": "228.61"}, {"instantEST": "2026-10-10 11:03:30 PM", "value": "-60.17"}, {"instantEST": "2026-10-10 11:04:00 PM", "value": "-73.01"}, {"instantEST": "2026-10-10 11:04:30 PM", "value": "63.70"}, {"instantEST": "2026-10-10 11:05:00 PM", "value": "268.36"}, {"instantEST": "2026-10-10 11:05:30 PM", "value": "180.94"}, {"instantEST": "2026-10-10 11:06:00 PM", "value": "242.69"}, {"instantEST": "2026-10-10 11:06:30 PM", "value": "194.23"}, {"instantEST": "2026-10-10 11:07:00 PM", "value": "227.93"}, {"instantEST": "2026-10-10 11:07:30 PM", "value": "164.03"}, {"instantEST": "2026-10-10 11:08:00 PM", "value": "22.38"}, {"instantEST": "2026-10-10 11:08:30 PM", "value": "-70.98"}, {"instantEST": "2026-10-10 11:09:00 PM", "value": "-202.75"}, {"instantEST": "2026-10-10 11:09:30 PM", "value": "-385.62"}, {"instantEST": "2026-10-10 11:10:00 PM", "value": "-141.84"}, {"instantEST": "2026-10-10 11:10:30 PM", "value": "34.33"}, {"instantEST": "2026-10-10 11:11:00 PM", "value": "-80.26"}, {"instantEST": "2026-10-10 11:11:30 PM", "value": "141.81"}, {"instantEST": "2026-10-10 11:12:00 PM", "value": "162.64"}, {"instantEST": "2026-10-10 11:12:30 PM", "value": "19.27"}, {"instantEST": "2026-10-10 11:13:00 PM", "value": "28.86"}, {"instantEST": "2026-10-10 11:13:30 PM", "value": "274.09"}, {"instantEST": "2026-10-10 11:14:00 PM", "value": "113.04"}, {"instantEST": "2026-10-10 11:14:30 PM", "value": "-14.02"}, {"instantEST": "2026-10-10 11:15:00 PM", "value": "62.02"}, {"instantEST": "2026-10-10 11:15:30 PM", "value": "19.04"}, {"instantEST": "2026-10-10 11:16:00 PM", "value": "216.25"}, {"instantEST": "2026-10-10 11:16:30 PM", "value": "338.32"}, {"instantEST": "2026-10-10 11:17:00 PM", "value": "441.39"}, {"instantEST": "2026-10-10 11:17:30 PM", "value": "350.14"}, {"instantEST": "2026-10-10 11:18:00 PM", "value": "64.35"}]}{"content-type": "application/json"}2026-10-11 04:20:41.3036302026-10-11 04:20:41.990900

Coverage

100.0% complete0 gap days1 days with data
Show coverage history
Coverage: 100.0%Days with data: 1Gaps: 0
2026
gaplessmore