TRADINGPRICE
TRADINGPRICE sets out 5 minutes spot market price, including fields to handle the Ancillary Services functionality. If prices are adjusted, the final price is recorded in the regional reference price (RRP) field with price before adjustment recorded in the regional original price (ROP) field. Prior to 5 Minute Settlements, this was half-hourly spot market values, which was calculated as the average of the six 5 minute dispatch intervals within the 30 minute period.
Package
TRADING_DATA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Date that this data applies to |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| PERIODID |
numeric(3, 0) |
smallint (not nullable) |
Period number where 1 represents the trading interval ending at 00:05 AEST |
| RRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| EEP |
numeric(15, 5) |
numeric(15, 5) |
Excess energy price where negative average |
| INVALIDFLAG |
varchar(1) |
varchar(1) |
Indicates when the Trading interval price has been adjusted after the trading interval was completed |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| ROP |
numeric(15, 5) |
numeric(15, 5) |
Regional Original Price. The price before any adjustments were made |
| RAISE6SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| RAISE6SECROP |
numeric(15, 5) |
numeric(15, 5) |
Original regional price - prior to APC or VoLL overrides applied |
| RAISE60SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| RAISE60SECROP |
numeric(15, 5) |
numeric(15, 5) |
Original regional price - prior to APC or VoLL overrides applied |
| RAISE5MINRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| RAISE5MINROP |
numeric(15, 5) |
numeric(15, 5) |
Original regional price - prior to APC or VoLL overrides applied |
| RAISEREGRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| RAISEREGROP |
numeric(15, 5) |
numeric(15, 5) |
Original regional price - prior to APC or VoLL overrides applied |
| LOWER6SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| LOWER6SECROP |
numeric(15, 5) |
numeric(15, 5) |
Original regional price - prior to APC or VoLL overrides applied |
| LOWER60SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| LOWER60SECROP |
numeric(15, 5) |
numeric(15, 5) |
Original regional price - prior to APC or VoLL overrides applied |
| LOWER5MINRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| LOWER5MINROP |
numeric(15, 5) |
numeric(15, 5) |
Original regional price - prior to APC or VoLL overrides applied |
| LOWERREGRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| LOWERREGROP |
numeric(15, 5) |
numeric(15, 5) |
Original regional price - prior to APC or VoLL overrides applied |
| PRICE_STATUS |
varchar(20) |
varchar(20) |
Status of regional prices for this dispatch interval \"NOT FIRM\" or \"FIRM\" |
| LOWER1SECROP |
numeric(15, 5) |
numeric(15, 5) |
Lower1Sec Regional Original Price - uncapped/unfloored and unscaled |
| LOWER1SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional Lower 1Sec Price - RegionSolution element L1Price attribute |
| RAISE1SECROP |
numeric(15, 5) |
numeric(15, 5) |
Raise1Sec Regional Original Price - uncapped/unfloored and unscaled |
| RAISE1SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional Raise 1Sec Price - R1Price attribute after capping/flooring |
| RUNNO |
numeric(3, 0) |
tinyint (not nullable) |
Run No |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_TRADINGPRICE |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, REGIONID, PERIODID |
| TRADINGPRICE_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_TRADINGPRICE |
clustered, unique, primary key |
SETTLEMENTDATE, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_TRADINGPRICE |
nonclustered, unique, primary key |
SETTLEMENTDATE, REGIONID |
| TRADINGPRICE_CCI |
clustered, columnstore |
n/a |