dispatch__price

AEMO Description

DISPATCHPRICE records 5 minute dispatch prices for energy an

Note that the provided table descriptions are truncated by AEMO.


Total Schema Versions	1
Combined Rows	626,355
Combined Size	32.78 MiB
MMS Table	`dispatchprice`
Unified View	`nemwebviews.dispatch__price`

Schema Evolution

Column	Type	Description	fec48bf0
`APCFLAG`	`Nullable(Float64)`	APC Active flag (see note)	✓
`CUMUL_PRE_AP_ENERGY_PRICE`	`Nullable(Float64)`	Cumulative price that triggers administered pricing event if above the threshold	✓
`CUMUL_PRE_AP_LOWER1_PRICE`	`Nullable(Float64)`	Cumulative price that triggers administered pricing event if above the threshold	✓
`CUMUL_PRE_AP_LOWER5MIN_PRICE`	`Nullable(Float64)`	Cumulative price that triggers administered pricing event if above the threshold	✓
`CUMUL_PRE_AP_LOWER60_PRICE`	`Nullable(Float64)`	Cumulative price that triggers administered pricing event if above the threshold	✓
`CUMUL_PRE_AP_LOWER6_PRICE`	`Nullable(Float64)`	Cumulative price that triggers administered pricing event if above the threshold	✓
`CUMUL_PRE_AP_LOWERREG_PRICE`	`Nullable(Float64)`	Cumulative price that triggers administered pricing event if above the threshold	✓
`CUMUL_PRE_AP_RAISE1_PRICE`	`Nullable(Float64)`	Cumulative price that triggers administered pricing event if above the threshold	✓
`CUMUL_PRE_AP_RAISE5MIN_PRICE`	`Nullable(Float64)`	Cumulative price that triggers administered pricing event if above the threshold	✓
`CUMUL_PRE_AP_RAISE60_PRICE`	`Nullable(Float64)`	Cumulative price that triggers administered pricing event if above the threshold	✓
`CUMUL_PRE_AP_RAISE6_PRICE`	`Nullable(Float64)`	Cumulative price that triggers administered pricing event if above the threshold	✓
`CUMUL_PRE_AP_RAISEREG_PRICE`	`Nullable(Float64)`	Cumulative price that triggers administered pricing event if above the threshold	✓
`DISPATCHINTERVAL`	`Nullable(Float64)`	Dispatch interval identifier 001 to 288 in format YYYYMMDDPPP	✓
`EEP`	`Nullable(Float64)`	Excess energy price - no longer used	✓
`INTERVENTION`	`Nullable(Float64)`	Manual intervention flag	✓
`LASTCHANGED`	`Nullable(DateTime64(3))`	Last date and time record changed	✓
`LOWER1SECAPCFLAG`	`Nullable(Float64)`	BitFlag field for Price adjustments - “1” = Voll_Override; “4” = Floor_VoLL; “8” = Manual_Override; “16” = Price_Scaled	✓
`LOWER1SECROP`	`Nullable(Float64)`	Lower1Sec Regional Original Price - uncapped/unfloored and unscaled	✓
`LOWER1SECRRP`	`Nullable(Float64)`	Regional Lower 1Sec Price - RegionSolution element L1Price attribute	✓
`LOWER5MINAPCFLAG`	`Nullable(Float64)`		✓
`LOWER5MINROP`	`Nullable(Float64)`		✓
`LOWER5MINRRP`	`Nullable(Float64)`		✓
`LOWER60SECAPCFLAG`	`Nullable(Float64)`		✓
`LOWER60SECROP`	`Nullable(Float64)`		✓
`LOWER60SECRRP`	`Nullable(Float64)`		✓
`LOWER6SECAPCFLAG`	`Nullable(Float64)`		✓
`LOWER6SECROP`	`Nullable(Float64)`		✓
`LOWER6SECRRP`	`Nullable(Float64)`		✓
`LOWERREGAPCFLAG`	`Nullable(Float64)`		✓
`LOWERREGROP`	`Nullable(Float64)`		✓
`LOWERREGRRP`	`Nullable(Float64)`		✓
`MARKETSUSPENDEDFLAG`	`Nullable(Float64)`	Market suspended flag	✓
`MII_STATUS`	`LowCardinality(String)`	Communicates the current MII status for this dispatch interval. Values of: ‘‘NOT_MII’’, ‘‘MII_SUBJECT_TO_REVIEW’’, ‘‘MII_PRICE_REJECTED’’, ‘‘MII_PRICE_ACCEPTED’’.	✓
`OCD_STATUS`	`LowCardinality(String)`	Communicates the current OCD status for this dispatch interval. Values of: ‘‘NOT_OCD’’, ‘‘OCD_UNRESOLVED’’, ‘‘OCD_RESOLVED’’.	✓
`PRE_AP_ENERGY_PRICE`	`Nullable(Float64)`	Price before ap capping or scaling - for rolling sum price monitoring	✓
`PRE_AP_LOWER1_PRICE`	`Nullable(Float64)`	Price before AP capping or scaling - for Rolling Sum Price monitoring	✓
`PRE_AP_LOWER5MIN_PRICE`	`Nullable(Float64)`	Price before ap capping or scaling - for rolling sum price monitoring	✓
`PRE_AP_LOWER60_PRICE`	`Nullable(Float64)`	Price before ap capping or scaling - for rolling sum price monitoring	✓
`PRE_AP_LOWER6_PRICE`	`Nullable(Float64)`	Price before ap capping or scaling - for rolling sum price monitoring	✓
`PRE_AP_LOWERREG_PRICE`	`Nullable(Float64)`	Price before ap capping or scaling - for rolling sum price monitoring	✓
`PRE_AP_RAISE1_PRICE`	`Nullable(Float64)`	Price before AP capping or scaling - for Rolling Sum Price monitoring	✓
`PRE_AP_RAISE5MIN_PRICE`	`Nullable(Float64)`	Price before ap capping or scaling - for rolling sum price monitoring	✓
`PRE_AP_RAISE60_PRICE`	`Nullable(Float64)`	Price before ap capping or scaling - for rolling sum price monitoring	✓
`PRE_AP_RAISE6_PRICE`	`Nullable(Float64)`	Price before ap capping or scaling - for rolling sum price monitoring	✓
`PRE_AP_RAISEREG_PRICE`	`Nullable(Float64)`	Price before ap capping or scaling - for rolling sum price monitoring	✓
`PRICE_STATUS`	`LowCardinality(String)`	Status of regional prices for this dispatch interval “NOT FIRM” or “FIRM”	✓
`RAISE1SECAPCFLAG`	`Nullable(Float64)`	BitFlag field for Price adjustments - “1” = Voll_Override; “4” = Floor_VoLL; “8” = Manual_Override; “16” = Price_Scaled	✓
`RAISE1SECROP`	`Nullable(Float64)`	Raise1Sec Regional Original Price - uncapped/unfloored and unscaled	✓
`RAISE1SECRRP`	`Nullable(Float64)`	Regional Raise 1Sec Price - R1Price attribute after capping/flooring	✓
`RAISE5MINAPCFLAG`	`Nullable(Float64)`		✓
`RAISE5MINROP`	`Nullable(Float64)`		✓
`RAISE5MINRRP`	`Nullable(Float64)`		✓
`RAISE60SECAPCFLAG`	`Nullable(Float64)`		✓
`RAISE60SECROP`	`Nullable(Float64)`		✓
`RAISE60SECRRP`	`Nullable(Float64)`		✓
`RAISE6SECAPCFLAG`	`Nullable(Float64)`		✓
`RAISE6SECROP`	`Nullable(Float64)`		✓
`RAISE6SECRRP`	`Nullable(Float64)`		✓
`RAISEREGAPCFLAG`	`Nullable(Float64)`		✓
`RAISEREGROP`	`Nullable(Float64)`		✓
`RAISEREGRRP`	`Nullable(Float64)`		✓
`REGIONID`	`LowCardinality(String)`	Region Identifier	✓
`ROP`	`Nullable(Float64)`	Regional Override Price, being the original price prior to any price scaling, price capping or VoLL override being applied. The APC flag allows the determination of whether capping, scaling or override occurred	✓
`RRP`	`Nullable(Float64)`	Regional Reference Price for this dispatch period. RRP is the price used to settle the market	✓
`RUNNO`	`Nullable(Float64)`	Dispatch run no; always 1	✓
`SETTLEMENTDATE`	`Nullable(DateTime64(3))`	Market date and time starting at 04:05	✓
`processed_at`	`DateTime64(3)`		✓
`source_zip`	`String`		✓

Schema Versions

Version	Rows	Size
`fec48bf0`	626,355	32.78 MiB

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

pre_ap_price v1 price v5