Skip to content

P5MIN_UNITSOLUTION

The five-minute predispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The 5-minute Predispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods. P5MIN_UNITSOLUTION shows the Unit results from the capacity evaluations for each period of the study.

P5MIN_UNITSOLUTION data is confidential, so shows own details for participant.

Source

P5MIN_UNITSOLUTION updates every 5 minutes for all units, even zero targets.

Volume

Rows per day: 57600

Based on 200 units per Interval

Note

A bitwise flag exists for each ancillary service type such that a unit trapped or stranded in one or more service type can be immediately identified. The SPD Formulation document details the logic determining whether a unit is "trapped" or "stranded". The flag is defined as follows:

Flagged Condition Bit Description Field value
FCAS profile active 0 The bid profile for this service has been activated such that the unit is available to be cleared to provide this ancillary service type. 1 or 3
Trapped 1 The unit is enabled to provide this ancillary service type, however the profile for this service type is causing the unit to be trapped in the energy market. 3
Stranded 2 The unit is bid available to provide this ancillary service type, however, the unit is operating in the energy market outside of the profile for this service type and is stranded from providing this service. 4

Tip

1 second, 6 second, 5 minute, 60 second and regulation refer to types of FCAS markets.

Column Schema

DUID

Dispatchable unit identifier

Warning

This column may contain funny characters such as / (slash) or # (hash). This may break hive-style partitioning.

For more information, see the dedicated documentation page.

SQL Type: VARCHAR2(10) Polars Type: pl.Categorical

This column is mandatory, and a primary key.

Examples:

  • ADPBA1G
  • ADPBA1L
  • ADPPV1
  • AGLHAL
  • AGLSOM
  • ANGAST1
  • APD01
  • ARWF1
  • ASENGV01
  • ASENGY01

INTERVAL_DATETIME

The unique identifier for the interval within this study

SQL Type: DATE Polars Type: pl.Datetime()

This column is mandatory, and a primary key.

Example: 2024/07/01 00:05:00

RUN_DATETIME

Unique Timestamp Identifier for this study

SQL Type: DATE Polars Type: pl.Datetime()

This column is mandatory, and a primary key.

Example: 2024/07/01 00:05:00

AGCSTATUS

AGC Status from EMS: 1 = on, 0 = off

SQL Type: NUMBER(2,0) Polars Type: pl.Int8

This column is not mandatory.

Examples: 0, 1

AVAILABILITY

For Scheduled units, this is the MAXAVAIL bid availability For Semi-scheduled units, this is the lower of MAXAVAIL bid availability and UIGF

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0.003, 0, 2, 685

CONFORMANCE_MODE

Mode specific to units within an aggregate. 0 - no monitoring, 1 - aggregate monitoring, 2 - individual monitoring due to constraint

SQL Type: NUMBER(6,0) Polars Type: pl.Int32

This column is not mandatory.

Example: 1

CONNECTIONPOINTID

Connection point identifier for DUID

SQL Type: VARCHAR2(12) Polars Type: pl.Categorical

This column is not mandatory.

Examples:

  • NASENG01
  • NASSAV01
  • NBA21B
  • NBAY1
  • NBAY2
  • NBAY3
  • NBAY4
  • NBB21B
  • NBES1B
  • NBK11B

DISPATCHMODETIME

Minutes for which the unit has been in the current DISPATCHMODE. From NEMDE TRADERSOLUTION element FSTARGETMODETIME attribute.

SQL Type: NUMBER(4,0) Polars Type: pl.Int16

This column is not mandatory.

Examples: 0, 10, 65

ELEMENT_CAP

Cap on the number of turbines or inverters at a DUID.

SQL Type: NUMBER(5,0) Polars Type: pl.Int32

This column is not mandatory.

ENERGY_STORAGE

The projected energy storage based on cleared energy and regulation FCAS dispatch(MWh)

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

ENERGY_STORAGE_MAX

BDU only - Maximum Energy Storage constraint limit (MWh)

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

ENERGY_STORAGE_MIN

BDU only - Minimum Energy Storage constraint limit (MWh)

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

INITIAL_ENERGY_STORAGE

The energy storage at the start of this dispatch interval(MWh)

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

INITIALMW

Initial MW at start of period. For periods subsequent to the first period of a P5MIN run, this value represents the cleared target for the previous period of that P5MIN run. Negative values when Bi-directional Unit start from importing power, otherwise positive.

Warning

In AEMO data, datetimes usually refer to the end of an interval. Power values usually do too. However this column refers to the start of the interval. So you need to subtract 5 minutes from SETTLEMENTDATE to align it with INITIALMW.

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: -0.1, 0.001, 0, 575

INTERVENTION

Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run(INTERVENTION=1). In the event there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0

Warning

Unlike most tables with an INTERVENTION column, INTERVENTION is not a primary key of P5MIN_UNITSOLUTION.

For more information, see the dedicated documentation page.

SQL Type: NUMBER(2,0) Polars Type: pl.Boolean

This column is not mandatory.

Example: 0

LASTCHANGED

Last date and time record changed

For more information, see the dedicated documentation page.

SQL Type: DATE Polars Type: pl.Datetime()

This column is not mandatory.

Example: 2024/07/01 00:00:22

LOWER1SEC

Dispatched Lower1Sec - TraderSolution element L1Target attribute

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 1, 2

LOWER1SECFLAGS

TraderSolution element L1Flags attribute

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

LOWER5MIN

Lower 5 min reserve target

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 1, 17

LOWER5MINFLAGS

Lower 5min status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

LOWER6SEC

Lower 6 sec reserve target

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 17.54386, 0, 1, 17

LOWER6SECFLAGS

Lower 6sec status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

LOWER60SEC

Lower 60 sec reserve target

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 24.5614, 0, 1, 17

LOWER60SECFLAGS

Lower 60sec status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

LOWERREG

Lower Regulation reserve target

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Example: 0

LOWERREGFLAGS

Lower Reg status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

MIN_AVAILABILITY

BDU only. Load side availability (BidOfferPeriod.MAXAVAIL where DIRECTION = LOAD).

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Example: 0

RAISE1SEC

Dispatched Raise1Sec - TraderSolution element R1Target attribute

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 1, 37

RAISE1SECFLAGS

TraderSolution element R1Flags attribute

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

RAISE5MIN

Raise 5 min reserve target

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 15.50991, 0, 1, 114

RAISE5MINFLAGS

Raise 5min status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

RAISE6SEC

Raise 6 sec reserve target

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 8.93161, 0, 1, 21

RAISE6SECFLAGS

Raise 6sec status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

RAISE60SEC

Raise 60 sec reserve target

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 1, 100

RAISE60SECFLAGS

Raise 60sec status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

RAISEREG

Raise Regulation reserve target

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 1, 10

RAISEREGFLAGS

Raise Reg status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

RAMPDOWNRATE

Ramp down rate (lessor of bid or telemetered rate).

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 28.8, 0, 60, 6000

RAMPUPRATE

Ramp up rate (lessor of bid or telemetered rate).

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 28.8, 0, 60, 6000

SEMIDISPATCHCAP

Boolean representation flagging if the Target is Capped

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Example: 0

TOTALCLEARED

Target MW for end of period. Negative values when Bi-directional Unit is importing power, otherwise positive.

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0.003, 0, 2, 575

TRADETYPE

Generator or Load

SQL Type: NUMBER(2,0) Polars Type: pl.Int8

This column is not mandatory.

UIGF

For Semi-Scheduled units. Unconstrained Intermittent Generation Forecast value provided to NEMDE

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0.003, 0, 109.456

New Data Timing

Every 5 minutes for all units, even zero targets

Code Examples

Polars

This table is so large that you should explicitly enumerate and cast every column, which will speed things up and prevents some errors. Although some of the datatypes are inferred, so they may be wrong. In particular, UInt16 vs UInt8 vs Int16 etc. If you get errors, you can swap these for just int.

This code deduplicates for you. Deduplication is normally only required across multiple months.

This code assumes that all columns are present, which may not be true for older files.

import polars as pl
import polars.selectors as cs

# e.g. "2029/03/15 00:05:00"
dt_s_fmt = "%Y/%m/%d %H:%M:%S"

csv_paths = ["SOMEFILE.CSV", "OTHERFILE.CSV"]

lf = (
    pl.concat(
        [
            pl.scan_csv(
                csv_path,  # must be unzipped beforehand
                skip_rows=1,  # skip the header
                infer_schema=False,  # much faster
            )
            .filter(cs.by_index(0) == "D")  # drop the footer
            .select(~cs.by_index(range(4)))  # drop metadata columns
            for csv_path in csv_paths
        ],
        how="diagonal_relaxed",
    )
    .with_columns(
        pl.col("INTERVAL_DATETIME", "RUN_DATETIME", "LASTCHANGED").str.strptime(
            pl.Datetime, dt_s_fmt
        ),
    )
    # Polars can't cast string straight to bool. Need to go via something else.
    .cast(
        {
            "INTERVENTION": pl.UInt8,
            "LOWER1SECFLAGS": pl.UInt8,
            "LOWER5MINFLAGS": pl.UInt8,
            "LOWER6SECFLAGS": pl.UInt8,
            "LOWER60SECFLAGS": pl.UInt8,
            "LOWERREGFLAGS": pl.UInt8,
            "RAISE1SECFLAGS": pl.UInt8,
            "RAISE5MINFLAGS": pl.UInt8,
            "RAISE6SECFLAGS": pl.UInt8,
            "RAISE60SECFLAGS": pl.UInt8,
            "RAISEREGFLAGS": pl.UInt8,
            "SEMIDISPATCHCAP": pl.UInt8,
        }
    )
    .cast(
        {
            "DUID": pl.Categorical,
            "AGCSTATUS": pl.Int8,
            "AVAILABILITY": pl.Float64,
            "CONFORMANCE_MODE": pl.Int32,
            "CONNECTIONPOINTID": pl.Categorical,
            "DISPATCHMODETIME": pl.Int16,
            "ELEMENT_CAP": pl.Int32,
            "ENERGY_STORAGE": pl.Float64,
            "ENERGY_STORAGE_MAX": pl.Float64,
            "ENERGY_STORAGE_MIN": pl.Float64,
            "INITIAL_ENERGY_STORAGE": pl.Float64,
            "INITIALMW": pl.Float64,
            "INTERVENTION": pl.Boolean,
            "LOWER1SEC": pl.Float64,
            "LOWER1SECFLAGS": pl.Boolean,
            "LOWER5MIN": pl.Float64,
            "LOWER5MINFLAGS": pl.Boolean,
            "LOWER6SEC": pl.Float64,
            "LOWER6SECFLAGS": pl.Boolean,
            "LOWER60SEC": pl.Float64,
            "LOWER60SECFLAGS": pl.Boolean,
            "LOWERREG": pl.Float64,
            "LOWERREGFLAGS": pl.Boolean,
            "MIN_AVAILABILITY": pl.Float64,
            "RAISE1SEC": pl.Float64,
            "RAISE1SECFLAGS": pl.Boolean,
            "RAISE5MIN": pl.Float64,
            "RAISE5MINFLAGS": pl.Boolean,
            "RAISE6SEC": pl.Float64,
            "RAISE6SECFLAGS": pl.Boolean,
            "RAISE60SEC": pl.Float64,
            "RAISE60SECFLAGS": pl.Boolean,
            "RAISEREG": pl.Float64,
            "RAISEREGFLAGS": pl.Boolean,
            "RAMPDOWNRATE": pl.Float64,
            "RAMPUPRATE": pl.Float64,
            "SEMIDISPATCHCAP": pl.Boolean,
            "TOTALCLEARED": pl.Float64,
            "TRADETYPE": pl.Int8,
            "UIGF": pl.Float64,
        }
    )
    # Deduplicate
    # These files are so large that this step may cause your laptop to run out of memory.
    # We want one row per ['DUID', 'INTERVAL_DATETIME', 'RUN_DATETIME']
    # Tie-breaker: greatest value of ['LASTCHANGED']
    .sort(["LASTCHANGED"], descending=False)
    .unique(subset=["DUID", "INTERVAL_DATETIME", "RUN_DATETIME"], keep="last")
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_DVD_P5MIN_UNITSOLUTION_202407010000.zip

RUN_DATETIMEINTERVENTIONINTERVAL_DATETIMEDUIDCONNECTIONPOINTIDTRADETYPEAGCSTATUSINITIALMWTOTALCLEAREDRAMPDOWNRATERAMPUPRATELOWER5MINLOWER60SECLOWER6SECRAISE5MINRAISE60SECRAISE6SECLOWERREGRAISEREGAVAILABILITYRAISE6SECFLAGSRAISE60SECFLAGSRAISE5MINFLAGSRAISEREGFLAGSLOWER6SECFLAGSLOWER60SECFLAGSLOWER5MINFLAGSLOWERREGFLAGSLASTCHANGEDSEMIDISPATCHCAPDISPATCHMODETIMELOWER1SECRAISE1SECRAISE1SECFLAGSLOWER1SECFLAGSCONFORMANCE_MODEUIGFINITIAL_ENERGY_STORAGEENERGY_STORAGEENERGY_STORAGE_MINENERGY_STORAGE_MAXMIN_AVAILABILITY
2024/07/01 00:05:0002024/07/01 00:05:00ADPBA1GSMVE4D00093.1293.12000000000111000002024/07/01 00:00:22000000100
2024/07/01 00:05:0002024/07/01 00:10:00ADPBA1GSMVE4D000120120000000000111100002024/07/01 00:00:22000000100
2024/07/01 00:05:0002024/07/01 00:15:00ADPBA1GSMVE4D000120120000000000111100002024/07/01 00:00:22000000100
2024/07/01 00:05:0002024/07/01 00:05:00ADPBA1LSMVE5D00.001093.1293.12000000000000011102024/07/01 00:00:22000000100
2024/07/01 00:05:0002024/07/01 00:10:00ADPBA1LSMVE5D000120120000000000000011112024/07/01 00:00:22000000100
2024/07/01 00:05:0002024/07/01 00:15:00ADPBA1LSMVE5D000120120000000000000011112024/07/01 00:00:22000000100
2024/07/01 00:05:0002024/07/01 00:05:00ADPPV1SMVE6D000120120000000000000000002024/07/01 00:00:2200000000
2024/07/01 00:05:0002024/07/01 00:10:00ADPPV1SMVE6D000120120000000000000000002024/07/01 00:00:2200000000
2024/07/01 00:05:0002024/07/01 00:15:00ADPPV1SMVE6D000120120000000000000000002024/07/01 00:00:2200000000
2024/07/01 00:05:0002024/07/01 00:25:00ADPPV1SMVE6D000120120000000000000000002024/07/01 00:00:2200000000
2024/07/01 00:05:0002024/07/01 00:20:00ADPBA1GSMVE4D000120120000000000111100002024/07/01 00:00:22000000100
...

CSETP.WORLDDVD_P5MIN_UNITSOLUTIONAEMOPUBLIC2024/08/0618:00:0300000004286539930000000428653863
IP5MINUNITSOLUTION6RUN_DATETIMEINTERVENTIONINTERVAL_DATETIMEDUIDCONNECTIONPOINTIDTRADETYPEAGCSTATUSINITIALMWTOTALCLEAREDRAMPDOWNRATERAMPUPRATELOWER5MINLOWER60SECLOWER6SECRAISE5MINRAISE60SECRAISE6SECLOWERREGRAISEREGAVAILABILITYRAISE6SECFLAGSRAISE60SECFLAGSRAISE5MINFLAGSRAISEREGFLAGSLOWER6SECFLAGSLOWER60SECFLAGSLOWER5MINFLAGSLOWERREGFLAGSLASTCHANGEDSEMIDISPATCHCAPDISPATCHMODETIMELOWER1SECRAISE1SECRAISE1SECFLAGSLOWER1SECFLAGSCONFORMANCE_MODEUIGFINITIAL_ENERGY_STORAGEENERGY_STORAGEENERGY_STORAGE_MINENERGY_STORAGE_MAXMIN_AVAILABILITY
DP5MINUNITSOLUTION62024/07/01 00:05:0002024/07/01 00:05:00ADPBA1GSMVE4D00093.1293.12000000000111000002024/07/01 00:00:22000000100
DP5MINUNITSOLUTION62024/07/01 00:05:0002024/07/01 00:10:00ADPBA1GSMVE4D000120120000000000111100002024/07/01 00:00:22000000100
DP5MINUNITSOLUTION62024/07/01 00:05:0002024/07/01 00:15:00ADPBA1GSMVE4D000120120000000000111100002024/07/01 00:00:22000000100
DP5MINUNITSOLUTION62024/07/01 00:05:0002024/07/01 00:05:00ADPBA1LSMVE5D00.001093.1293.12000000000000011102024/07/01 00:00:22000000100
DP5MINUNITSOLUTION62024/07/01 00:05:0002024/07/01 00:10:00ADPBA1LSMVE5D000120120000000000000011112024/07/01 00:00:22000000100
DP5MINUNITSOLUTION62024/07/01 00:05:0002024/07/01 00:15:00ADPBA1LSMVE5D000120120000000000000011112024/07/01 00:00:22000000100
DP5MINUNITSOLUTION62024/07/01 00:05:0002024/07/01 00:05:00ADPPV1SMVE6D000120120000000000000000002024/07/01 00:00:2200000000
DP5MINUNITSOLUTION62024/07/01 00:05:0002024/07/01 00:10:00ADPPV1SMVE6D000120120000000000000000002024/07/01 00:00:2200000000
DP5MINUNITSOLUTION62024/07/01 00:05:0002024/07/01 00:15:00ADPPV1SMVE6D000120120000000000000000002024/07/01 00:00:2200000000
DP5MINUNITSOLUTION62024/07/01 00:05:0002024/07/01 00:25:00ADPPV1SMVE6D000120120000000000000000002024/07/01 00:00:2200000000
DP5MINUNITSOLUTION62024/07/01 00:05:0002024/07/01 00:20:00ADPBA1GSMVE4D000120120000000000111100002024/07/01 00:00:22000000100
...
CEND OF REPORT1003

RUN_DATETIME,INTERVENTION,INTERVAL_DATETIME,DUID,CONNECTIONPOINTID,TRADETYPE,AGCSTATUS,INITIALMW,TOTALCLEARED,RAMPDOWNRATE,RAMPUPRATE,LOWER5MIN,LOWER60SEC,LOWER6SEC,RAISE5MIN,RAISE60SEC,RAISE6SEC,LOWERREG,RAISEREG,AVAILABILITY,RAISE6SECFLAGS,RAISE60SECFLAGS,RAISE5MINFLAGS,RAISEREGFLAGS,LOWER6SECFLAGS,LOWER60SECFLAGS,LOWER5MINFLAGS,LOWERREGFLAGS,LASTCHANGED,SEMIDISPATCHCAP,DISPATCHMODETIME,LOWER1SEC,RAISE1SEC,RAISE1SECFLAGS,LOWER1SECFLAGS,CONFORMANCE_MODE,UIGF,INITIAL_ENERGY_STORAGE,ENERGY_STORAGE,ENERGY_STORAGE_MIN,ENERGY_STORAGE_MAX,MIN_AVAILABILITY
"2024/07/01 00:05:00",0,"2024/07/01 00:05:00",ADPBA1G,SMVE4D,,0,0,0,93.12,93.12,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
"2024/07/01 00:05:00",0,"2024/07/01 00:10:00",ADPBA1G,SMVE4D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
"2024/07/01 00:05:00",0,"2024/07/01 00:15:00",ADPBA1G,SMVE4D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
"2024/07/01 00:05:00",0,"2024/07/01 00:05:00",ADPBA1L,SMVE5D,,0,0.001,0,93.12,93.12,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
"2024/07/01 00:05:00",0,"2024/07/01 00:10:00",ADPBA1L,SMVE5D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
"2024/07/01 00:05:00",0,"2024/07/01 00:15:00",ADPBA1L,SMVE5D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
"2024/07/01 00:05:00",0,"2024/07/01 00:05:00",ADPPV1,SMVE6D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,,0,,,,,0
"2024/07/01 00:05:00",0,"2024/07/01 00:10:00",ADPPV1,SMVE6D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,,0,,,,,0
"2024/07/01 00:05:00",0,"2024/07/01 00:15:00",ADPPV1,SMVE6D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,,0,,,,,0
"2024/07/01 00:05:00",0,"2024/07/01 00:25:00",ADPPV1,SMVE6D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,,0,,,,,0
"2024/07/01 00:05:00",0,"2024/07/01 00:20:00",ADPBA1G,SMVE4D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
...

C,SETP.WORLD,DVD_P5MIN_UNITSOLUTION,AEMO,PUBLIC,2024/08/06,18:00:03,0000000428653993,,0000000428653863
I,P5MIN,UNITSOLUTION,6,RUN_DATETIME,INTERVENTION,INTERVAL_DATETIME,DUID,CONNECTIONPOINTID,TRADETYPE,AGCSTATUS,INITIALMW,TOTALCLEARED,RAMPDOWNRATE,RAMPUPRATE,LOWER5MIN,LOWER60SEC,LOWER6SEC,RAISE5MIN,RAISE60SEC,RAISE6SEC,LOWERREG,RAISEREG,AVAILABILITY,RAISE6SECFLAGS,RAISE60SECFLAGS,RAISE5MINFLAGS,RAISEREGFLAGS,LOWER6SECFLAGS,LOWER60SECFLAGS,LOWER5MINFLAGS,LOWERREGFLAGS,LASTCHANGED,SEMIDISPATCHCAP,DISPATCHMODETIME,LOWER1SEC,RAISE1SEC,RAISE1SECFLAGS,LOWER1SECFLAGS,CONFORMANCE_MODE,UIGF,INITIAL_ENERGY_STORAGE,ENERGY_STORAGE,ENERGY_STORAGE_MIN,ENERGY_STORAGE_MAX,MIN_AVAILABILITY
D,P5MIN,UNITSOLUTION,6,"2024/07/01 00:05:00",0,"2024/07/01 00:05:00",ADPBA1G,SMVE4D,,0,0,0,93.12,93.12,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
D,P5MIN,UNITSOLUTION,6,"2024/07/01 00:05:00",0,"2024/07/01 00:10:00",ADPBA1G,SMVE4D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
D,P5MIN,UNITSOLUTION,6,"2024/07/01 00:05:00",0,"2024/07/01 00:15:00",ADPBA1G,SMVE4D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
D,P5MIN,UNITSOLUTION,6,"2024/07/01 00:05:00",0,"2024/07/01 00:05:00",ADPBA1L,SMVE5D,,0,0.001,0,93.12,93.12,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
D,P5MIN,UNITSOLUTION,6,"2024/07/01 00:05:00",0,"2024/07/01 00:10:00",ADPBA1L,SMVE5D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
D,P5MIN,UNITSOLUTION,6,"2024/07/01 00:05:00",0,"2024/07/01 00:15:00",ADPBA1L,SMVE5D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
D,P5MIN,UNITSOLUTION,6,"2024/07/01 00:05:00",0,"2024/07/01 00:05:00",ADPPV1,SMVE6D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,,0,,,,,0
D,P5MIN,UNITSOLUTION,6,"2024/07/01 00:05:00",0,"2024/07/01 00:10:00",ADPPV1,SMVE6D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,,0,,,,,0
D,P5MIN,UNITSOLUTION,6,"2024/07/01 00:05:00",0,"2024/07/01 00:15:00",ADPPV1,SMVE6D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,,0,,,,,0
D,P5MIN,UNITSOLUTION,6,"2024/07/01 00:05:00",0,"2024/07/01 00:25:00",ADPPV1,SMVE6D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,,0,,,,,0
D,P5MIN,UNITSOLUTION,6,"2024/07/01 00:05:00",0,"2024/07/01 00:20:00",ADPBA1G,SMVE4D,,0,0,0,120,120,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,0,"2024/07/01 00:00:22",0,0,0,0,0,0,1,0,,,,,0
...
C,"END OF REPORT",1003

Availability

Visibility: Private

This table is in the public monthly MMSDM archive.

I have collated the list of all those files into one place, in this CSV metadata file. (Columns year, month, url, compressed_size in bytes).

The earliest available data is month 1 of 2015. The most recent available data is month 7 of 2024.

Warning

There are some months with no files.

Data Size

Each year of data is approximately 6 GB when zipped, 56 GB as unzipped CSV.

Tip

This table is large. Simply calling pd.read_csv() might fill up all the memory on your laptop. (As a rule of thumb, you need double the amount of memory as the size of the CSV.) You will need to think hard about memory optimisation. e.g. consider using Polars instead of Pandas, and selecting only the columns you care about.

Deduplication and PDR Loader Configuration

The primary keys are:

The transaction type is "insert", which means that you will usually not see duplicate data. If you do, you can deduplicate based on the primary keys, without sorting first. Rows from different files with the same primary keys should have the same values.

PDR Loader configuration is:

Report Name Report Subtype Version
P5MIN UNITSOLUTION 6
P5MIN UNITSOLUTION 7

This means that the CSV files start with metadata columns:

I,P5MIN,UNITSOLUTION,6,...
D,P5MIN,UNITSOLUTION,6,...

or

I,P5MIN,UNITSOLUTION,7,...
D,P5MIN,UNITSOLUTION,7,...

Indexes

This page as JSON (schema documented here, but may change)

Download a JSON Schema specification for this table.

Official AEMO schema documentation

Other Information

Package: P5MIN