trading__price

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	633,470
Combined Size	9.98 MiB
MMS Table	`tradingprice`
Unified View	`nemwebviews.trading__price`

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`	633,470	9.98 MiB

Last updated: 2026-01-02 16:00:09

irsr v2 price v3