|Period start||Period end||Trading period||Region ID||Region||Price ($/MWh)|
|27/03/2017 00:00:00||27/03/2017 00:30:00||1||UNI||Upper North Island||52.79|
|27/03/2017 00:00:00||27/03/2017 00:30:00||1||CNI||Central North Island||50.98|
|27/03/2017 00:00:00||27/03/2017 00:30:00||1||LNI||Lower North Island||51.53|
|27/03/2017 00:00:00||27/03/2017 00:30:00||1||USI||Upper South Island||37.31|
|27/03/2017 00:00:00||27/03/2017 00:30:00||1||LSI||Lower South Island||38.44|
|27/03/2017 00:30:00||27/03/2017 01:00:00||2||UNI||Upper North Island||39.57|
|27/03/2017 00:30:00||27/03/2017 01:00:00||2||CNI||Central North Island||38.24|
|27/03/2017 00:30:00||27/03/2017 01:00:00||2||LNI||Lower North Island||38.56|
|27/03/2017 00:30:00||27/03/2017 01:00:00||2||USI||Upper South Island||41.56|
|27/03/2017 00:30:00||27/03/2017 01:00:00||2||LSI||Lower South Island||42.76|
|27/03/2017 01:00:00||27/03/2017 01:30:00||3||UNI||Upper North Island||42.41|
|27/03/2017 01:00:00||27/03/2017 01:30:00||3||CNI||Central North Island||41.03|
|27/03/2017 01:00:00||27/03/2017 01:30:00||3||LNI||Lower North Island||41.93|
|27/03/2017 01:00:00||27/03/2017 01:30:00||3||USI||Upper South Island||37.60|
|27/03/2017 01:00:00||27/03/2017 01:30:00||3||LSI||Lower South Island||38.53|
|27/03/2017 01:30:00||27/03/2017 02:00:00||4||UNI||Upper North Island||37.50|
|27/03/2017 01:30:00||27/03/2017 02:00:00||4||CNI||Central North Island||36.34|
|27/03/2017 01:30:00||27/03/2017 02:00:00||4||LNI||Lower North Island||36.67|
|27/03/2017 01:30:00||27/03/2017 02:00:00||4||USI||Upper South Island||56.89|
|27/03/2017 01:30:00||27/03/2017 02:00:00||4||LSI||Lower South Island||58.47|
|27/03/2017 02:00:00||27/03/2017 02:30:00||5||UNI||Upper North Island||6.11|
|27/03/2017 02:00:00||27/03/2017 02:30:00||5||CNI||Central North Island||5.92|
|27/03/2017 02:00:00||27/03/2017 02:30:00||5||LNI||Lower North Island||5.97|
|27/03/2017 02:00:00||27/03/2017 02:30:00||5||USI||Upper South Island||41.54|
|27/03/2017 02:00:00||27/03/2017 02:30:00||5||LSI||Lower South Island||42.91|
|27/03/2017 02:30:00||27/03/2017 03:00:00||6||UNI||Upper North Island||46.40|
|27/03/2017 02:30:00||27/03/2017 03:00:00||6||CNI||Central North Island||44.85|
|27/03/2017 02:30:00||27/03/2017 03:00:00||6||LNI||Lower North Island||45.24|
|27/03/2017 02:30:00||27/03/2017 03:00:00||6||USI||Upper South Island||49.21|
|27/03/2017 02:30:00||27/03/2017 03:00:00||6||LSI||Lower South Island||51.10|
|27/03/2017 03:00:00||27/03/2017 03:30:00||7||UNI||Upper North Island||46.42|
|27/03/2017 03:00:00||27/03/2017 03:30:00||7||CNI||Central North Island||44.92|
|27/03/2017 03:00:00||27/03/2017 03:30:00||7||LNI||Lower North Island||45.29|
|27/03/2017 03:00:00||27/03/2017 03:30:00||7||USI||Upper South Island||56.10|
|27/03/2017 03:00:00||27/03/2017 03:30:00||7||LSI||Lower South Island||58.36|
|27/03/2017 03:30:00||27/03/2017 04:00:00||8||UNI||Upper North Island||46.38|
|27/03/2017 03:30:00||27/03/2017 04:00:00||8||CNI||Central North Island||45.00|
|27/03/2017 03:30:00||27/03/2017 04:00:00||8||LNI||Lower North Island||45.39|
|27/03/2017 03:30:00||27/03/2017 04:00:00||8||USI||Upper South Island||55.38|
|27/03/2017 03:30:00||27/03/2017 04:00:00||8||LSI||Lower South Island||58.37|
|27/03/2017 04:00:00||27/03/2017 04:30:00||9||UNI||Upper North Island||46.43|
|27/03/2017 04:00:00||27/03/2017 04:30:00||9||CNI||Central North Island||45.12|
|27/03/2017 04:00:00||27/03/2017 04:30:00||9||LNI||Lower North Island||45.76|
|27/03/2017 04:00:00||27/03/2017 04:30:00||9||USI||Upper South Island||49.03|
|27/03/2017 04:00:00||27/03/2017 04:30:00||9||LSI||Lower South Island||51.67|
|27/03/2017 04:30:00||27/03/2017 05:00:00||10||UNI||Upper North Island||52.81|
|27/03/2017 04:30:00||27/03/2017 05:00:00||10||CNI||Central North Island||51.02|
|27/03/2017 04:30:00||27/03/2017 05:00:00||10||LNI||Lower North Island||52.11|
|27/03/2017 04:30:00||27/03/2017 05:00:00||10||USI||Upper South Island||56.94|
|27/03/2017 04:30:00||27/03/2017 05:00:00||10||LSI||Lower South Island||59.07|
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.