Skip to main content
  1. Wholesale category / Datasets
  2. Real-time prices (RTP)

Wholesale datasets

Real-time prices (RTP)

Real-time prices, or 5-minute prices as they are also known, are prepared and published on WITS  by the pricing manager according to the provisions set out in Part 13 of the Code.  Real-time prices derived from the RTP schedule  are made available here for analysis and research purposes.

Price files published during any given day are compressed into a zip file and uploaded to EMI datasets in a single batch job early in the morning of the following day. The zipped up CSV price files are presented as is where is, i.e. we do not transform the data or in any other way reformulate it from that which WITS published. We do, however, slightly revise the CSV file naming convention.

Each real-time price file contains data pertaining to a single 5-minute interval. There are six 5-minute intervals per half hour trading period, giving rise to 288 RTP files per day, all collected into the daily zip file. For a variety of reasons, there will be occasions when there are fewer than 288 files per day. We will make no effort to track down any missing files or explain why they are missing.

The CSV files contain nine columns and have no header row. Taken in order, the columns are:

  • Point of connection, e.g. HAY2201
  • Trading date - dd/mm/yyyy
  • Trading period - an integer from 1 to 50
  • Market time - hh:mm, i.e. the time at which the 5-min interval starts
  • Price ($/MWh) - number(8,2)
  • Island - NI or SI
  • Load area - a 2-character label denoting one of ten load forecasting areas used by the system operator
  • Market flag - I for immediate or W for withheld, i.e. a flag indicating whether details were released after five minutes or held back
  • Run time - dd/mm/yyyy hh:mm:ss, i.e. the time the SPD model was run to generate the prices.

At this time, real-time prices are made available dating back to 20 October 2018.

Name Date modified File size
19 Aug 2022
31 Dec 2021
31 Dec 2020
31 Dec 2019
08 Dec 2019
What are datasets?

Datasets are collections of files that often contain large volumes of data and are available for immediate download. Dataset users are typically analysts familiar with the electricity industry and have a need to obtain a large set of data or specific data on a regular basis.

Trending wholesale datasets
Check a term

Visit the glossary for a list of defined terms used on the website.

Have a question?

Visit the forum to see if the information you are looking for is already available or ask a question to see if some of our informed users or staff can help?

Alternative access to datasets

Alternative methods are supported to connect to EMI datasets. These methods better facilitate downloading many files or automating regular downloads. See here for more information.