|Period start||Period end||Trading period||Region ID||Region||Price ($/MWh)|
|24/01/2020 00:00:00||24/01/2020 00:30:00||1||UNI||Upper North Island||97.71|
|24/01/2020 00:00:00||24/01/2020 00:30:00||1||CNI||Central North Island||93.46|
|24/01/2020 00:00:00||24/01/2020 00:30:00||1||LNI||Lower North Island||98.20|
|24/01/2020 00:00:00||24/01/2020 00:30:00||1||USI||Upper South Island||108.96|
|24/01/2020 00:00:00||24/01/2020 00:30:00||1||LSI||Lower South Island||100.46|
|24/01/2020 00:30:00||24/01/2020 01:00:00||2||UNI||Upper North Island||103.04|
|24/01/2020 00:30:00||24/01/2020 01:00:00||2||CNI||Central North Island||98.69|
|24/01/2020 00:30:00||24/01/2020 01:00:00||2||LNI||Lower North Island||103.78|
|24/01/2020 00:30:00||24/01/2020 01:00:00||2||USI||Upper South Island||116.34|
|24/01/2020 00:30:00||24/01/2020 01:00:00||2||LSI||Lower South Island||107.50|
|24/01/2020 01:00:00||24/01/2020 01:30:00||3||UNI||Upper North Island||103.20|
|24/01/2020 01:00:00||24/01/2020 01:30:00||3||CNI||Central North Island||98.26|
|24/01/2020 01:00:00||24/01/2020 01:30:00||3||LNI||Lower North Island||103.66|
|24/01/2020 01:00:00||24/01/2020 01:30:00||3||USI||Upper South Island||112.96|
|24/01/2020 01:00:00||24/01/2020 01:30:00||3||LSI||Lower South Island||105.71|
|24/01/2020 01:30:00||24/01/2020 02:00:00||4||UNI||Upper North Island||114.93|
|24/01/2020 01:30:00||24/01/2020 02:00:00||4||CNI||Central North Island||109.23|
|24/01/2020 01:30:00||24/01/2020 02:00:00||4||LNI||Lower North Island||118.50|
|24/01/2020 01:30:00||24/01/2020 02:00:00||4||USI||Upper South Island||99.27|
|24/01/2020 01:30:00||24/01/2020 02:00:00||4||LSI||Lower South Island||93.41|
|24/01/2020 02:00:00||24/01/2020 02:30:00||5||UNI||Upper North Island||95.02|
|24/01/2020 02:00:00||24/01/2020 02:30:00||5||CNI||Central North Island||90.51|
|24/01/2020 02:00:00||24/01/2020 02:30:00||5||LNI||Lower North Island||95.27|
|24/01/2020 02:00:00||24/01/2020 02:30:00||5||USI||Upper South Island||102.51|
|24/01/2020 02:00:00||24/01/2020 02:30:00||5||LSI||Lower South Island||96.95|
|24/01/2020 02:30:00||24/01/2020 03:00:00||6||UNI||Upper North Island||91.54|
|24/01/2020 02:30:00||24/01/2020 03:00:00||6||CNI||Central North Island||87.20|
|24/01/2020 02:30:00||24/01/2020 03:00:00||6||LNI||Lower North Island||91.76|
|24/01/2020 02:30:00||24/01/2020 03:00:00||6||USI||Upper South Island||98.67|
|24/01/2020 02:30:00||24/01/2020 03:00:00||6||LSI||Lower South Island||93.43|
|24/01/2020 03:00:00||24/01/2020 03:30:00||7||UNI||Upper North Island||64.10|
|24/01/2020 03:00:00||24/01/2020 03:30:00||7||CNI||Central North Island||61.08|
|24/01/2020 03:00:00||24/01/2020 03:30:00||7||LNI||Lower North Island||64.28|
|24/01/2020 03:00:00||24/01/2020 03:30:00||7||USI||Upper South Island||89.06|
|24/01/2020 03:00:00||24/01/2020 03:30:00||7||LSI||Lower South Island||83.97|
|24/01/2020 03:30:00||24/01/2020 04:00:00||8||UNI||Upper North Island||63.52|
|24/01/2020 03:30:00||24/01/2020 04:00:00||8||CNI||Central North Island||60.93|
|24/01/2020 03:30:00||24/01/2020 04:00:00||8||LNI||Lower North Island||64.10|
|24/01/2020 03:30:00||24/01/2020 04:00:00||8||USI||Upper South Island||98.57|
|24/01/2020 03:30:00||24/01/2020 04:00:00||8||LSI||Lower South Island||93.24|
|24/01/2020 04:00:00||24/01/2020 04:30:00||9||UNI||Upper North Island||95.61|
|24/01/2020 04:00:00||24/01/2020 04:30:00||9||CNI||Central North Island||90.92|
|24/01/2020 04:00:00||24/01/2020 04:30:00||9||LNI||Lower North Island||98.42|
|24/01/2020 04:00:00||24/01/2020 04:30:00||9||USI||Upper South Island||108.03|
|24/01/2020 04:00:00||24/01/2020 04:30:00||9||LSI||Lower South Island||101.88|
|24/01/2020 04:30:00||24/01/2020 05:00:00||10||UNI||Upper North Island||107.89|
|24/01/2020 04:30:00||24/01/2020 05:00:00||10||CNI||Central North Island||102.80|
|24/01/2020 04:30:00||24/01/2020 05:00:00||10||LNI||Lower North Island||108.28|
|24/01/2020 04:30:00||24/01/2020 05:00:00||10||USI||Upper South Island||117.71|
|24/01/2020 04:30:00||24/01/2020 05:00:00||10||LSI||Lower South Island||111.02|
This report shows wholesale energy prices for the electricity spot market. Parameters allow selection of weighting type, time scale, and regional averages.
Region types are either network-based or derived from standard statistical boundaries. The current network-based regions are nodes and zones. Mappings are provided in the NSP table which is available as a wholesale report.
The time scale controls the resolution of data presented. This parameter provides a useful summary function that sums or averages data depending on report. There are settings which will automatically adjust to limit the load that large queries (long time periods at trading period time scale) place on our system. Data summarised with time scales is listed at the start of the period; part periods are not shown.
Final pricing demand and generation can be used as a proxy for reconciled demand and generation during the period for which reconciliation data is unavailable. Implementing this proxy requires making some assumptions regarding wind generation and demand. For final pricing demand, all positive demand from the final pricing case is counted; negative demand (wind generation) is ignored. Similarly, for final pricing generation, all generation plus the absolute value of negative demand (wind generation) is included. These conventions regarding final pricing demand and generation are used in calculating weighted prices.
Visit the glossary for a list of defined terms used on the website.
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?
Clicking the blue discussion tags below the notes will take you directly to discussions on that topic.