AVERAGEPRICE30
Reflects the 30-minute average price (the pre-5MS trading price).
Package
TRADING_DATA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PERIODDATE |
datetime(3)  |
datetime2(0) |
30-minute interval period, 1 to 48 from the start of the calendar day |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| PERIODID |
numeric(3, 0) (not nullable) |
tinyint (not nullable) |
The 30-minute interval period, 1 to 48 |
| RRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this period |
| PRICE_CONFIDENCE |
varchar(20) |
varchar(20) |
Result of Manifestly Incorrect Inputs Price Status and OCD_Status - either \"FIRM\" or \"NOT FIRM\". Only FIRM if the Dispatch Interval is resolved for both MII and OCD |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AVERAGEPRICE30_PK |
clustered, unique, primary key |
PERIODDATE, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_AVERAGEPRICE30 |
clustered, unique, primary key |
PERIODDATE, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AVERAGEPRICE30_PK |
clustered, unique, primary key |
PERIODDATE, REGIONID |