trading__price__3
AEMO Description
TRADINGPRICE sets out 5 minutes spot market price, including
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 599,480 |
| Combined Size | 9.49 MiB |
| MMS Table | tradingprice |
| Unified View | nemwebviews.trading__price__3 |
Schema Evolution
| Column | Type | Description | 9223690b |
|---|---|---|---|
EEP |
Nullable(Float64) |
Excess energy price where negative average | ✓ |
INVALIDFLAG |
Nullable(Float64) |
Indicates when the Trading interval price has been adjusted after the trading interval was completed | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ |
LOWER1SECROP |
Nullable(Float64) |
Lower1Sec Regional Original Price - uncapped/unfloored and unscaled | ✓ |
LOWER1SECRRP |
Nullable(Float64) |
Regional Lower 1Sec Price - RegionSolution element L1Price attribute | ✓ |
LOWER5MINROP |
Nullable(Float64) |
Original regional price - prior to APC or VoLL overrides applied | ✓ |
LOWER5MINRRP |
Nullable(Float64) |
Regional reference price for this dispatch period | ✓ |
LOWER60SECROP |
Nullable(Float64) |
Original regional price - prior to APC or VoLL overrides applied | ✓ |
LOWER60SECRRP |
Nullable(Float64) |
Regional reference price for this dispatch period | ✓ |
LOWER6SECROP |
Nullable(Float64) |
Original regional price - prior to APC or VoLL overrides applied | ✓ |
LOWER6SECRRP |
Nullable(Float64) |
Regional reference price for this dispatch period | ✓ |
LOWERREGROP |
Nullable(Float64) |
Original regional price - prior to APC or VoLL overrides applied | ✓ |
LOWERREGRRP |
Nullable(Float64) |
Regional reference price for this dispatch period | ✓ |
PERIODID |
Nullable(Float64) |
Period number where 1 represents the trading interval ending at 00:05 AEST | ✓ |
PRICE_STATUS |
LowCardinality(String) |
Status of regional prices for this dispatch interval “NOT FIRM” or “FIRM” | ✓ |
RAISE1SECROP |
Nullable(Float64) |
Raise1Sec Regional Original Price - uncapped/unfloored and unscaled | ✓ |
RAISE1SECRRP |
Nullable(Float64) |
Regional Raise 1Sec Price - R1Price attribute after capping/flooring | ✓ |
RAISE5MINROP |
Nullable(Float64) |
Original regional price - prior to APC or VoLL overrides applied | ✓ |
RAISE5MINRRP |
Nullable(Float64) |
Regional reference price for this dispatch period | ✓ |
RAISE60SECROP |
Nullable(Float64) |
Original regional price - prior to APC or VoLL overrides applied | ✓ |
RAISE60SECRRP |
Nullable(Float64) |
Regional reference price for this dispatch period | ✓ |
RAISE6SECROP |
Nullable(Float64) |
Original regional price - prior to APC or VoLL overrides applied | ✓ |
RAISE6SECRRP |
Nullable(Float64) |
Regional reference price for this dispatch period | ✓ |
RAISEREGROP |
Nullable(Float64) |
Original regional price - prior to APC or VoLL overrides applied | ✓ |
RAISEREGRRP |
Nullable(Float64) |
Regional reference price for this dispatch period | ✓ |
REGIONID |
LowCardinality(String) |
Region Identifier | ✓ |
ROP |
Nullable(Float64) |
Regional Original Price. The price before any adjustments were made | ✓ |
RRP |
Nullable(Float64) |
Regional reference price for this dispatch period | ✓ |
RUNNO |
Nullable(Float64) |
Run No | ✓ |
SETTLEMENTDATE |
Nullable(DateTime64(3)) |
Date that this data applies to | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
9223690b |
599,480 | 9.49 MiB |
Last updated: 2025-12-10 08:00:09