P5MIN_INTERCONNECTORSOLN

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_INTERCONNECTORSOLN sets out the results of the capacity evaluation for Interconnectors, including the calculated limits for the interval.

P5MIN_INTERCONNECTORSOLN is public data, so is available to all participants.

Source

P5MIN_INTERCONNECTORSOLN updates every 5 minutes.

Volume

Rows per day: 1440

Based on 200 interconnector/binding constraints per interval

Column Schema

INTERCONNECTORID

Interconnector identifier

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

This column is mandatory, and a primary key.

Examples:

N-Q-MNSP1
NSW1-QLD1
T-V-MNSP1
V-S-MNSP1
V-SA
VIC1-NSW1

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: 2026/09/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: 2026/09/01 00:05:00

EXPORTGENCONID

Generic Constraint setting the export limit

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Examples:

F_T++NIL_ML_L6
N::Q_BWMP_LDTW
NQTE_ROC
TVBL_ROC
V::N_NIL_O2
V::N_NIL_V2
V>>NIL_SMTX_SMTX_R5
VSML_ZERO
V^^N_NIL_1

EXPORTLIMIT

Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit

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

This column is not mandatory.

Examples: -0.00001, 0.39022, 0, 39

FCASEXPORTLIMIT

Calculated export limit applying to energy + Frequency Controlled Ancillary Services.

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

This column is not mandatory.

Examples: -0.00001, 25.58031, 0, 2399

FCASIMPORTLIMIT

Calculated import limit applying to energy + Frequency Controlled Ancillary Services.

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

This column is not mandatory.

Examples: -119.69971, 0, -121, -2478

IMPORTGENCONID

Generic Constraint setting the import limit

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Examples:

F_MAIN++APD_TL_L5
F_MAIN++APD_TL_L6
F_MAIN++BIP_ML_L1
F_MAIN++LREG_0210
F_T++NIL_MG_R6
I_6F_SN_150
N^^V_MLNK_ARWBBA
QNTE_ROC
Q^^N_NIL_SRAR
S:V_700_HY_TEST

IMPORTLIMIT

Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit. Note unlike the input interconnector import limit this is a directional quantity and should be defined with respect to the interconnector flow.

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

This column is not mandatory.

Examples: -14.20862, 7.10995, 0, -700

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_INTERCONNECTORSOLN.

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 changed date of this record

For more information, see the dedicated documentation page.

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

This column is not mandatory.

Example: 2026/09/01 00:00:33

LOCAL_PRICE_ADJUSTMENT_EXPORT

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Export (Factor >= 0)

SQL Type: NUMBER(10,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: -0.36, 4.51, 0, -49

LOCAL_PRICE_ADJUSTMENT_IMPORT

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Import (Factor >= 0)

SQL Type: NUMBER(10,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0.31, 0, 26912000, 15.84

LOCALLY_CONSTRAINED_EXPORT

Key for Local_Price_Adjustment_Export: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

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

This column is not mandatory.

Examples: 0, 1

LOCALLY_CONSTRAINED_IMPORT

Key for Local_Price_Adjustment_Import: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

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

This column is not mandatory.

Examples: 0, 1, 2

MARGINALLOSS

Marginal loss factor at the cleared flow

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

This column is not mandatory.

Examples: 0.78351, 1.29601

MARGINALVALUE

Marginal cost of Interconnector standing data limits (if binding)

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

This column is not mandatory.

Example: 0

METEREDMWFLOW

SCADA MW Flow measured at Run start. 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.

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

This column is not mandatory.

Examples: -0.3, 0.3, 0, 224

MNSP

Flag indicating MNSP registration

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

This column is not mandatory.

Example: 0

MWFLOW

Cleared Interconnector loading level (MW)

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

This column is not mandatory.

Examples: -14.20861, 7.10994, 0, -969

MWLOSSES

Interconnector Losses at cleared flow

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

This column is not mandatory.

Examples: -0.02722, 0.03335, 0, 184.36565

VIOLATIONDEGREE

Violation of Interconnector standing data limits

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

This column is not mandatory.

Example: 0

New Data Timing

Every 5 minutes

Code Examples

Polars

Casting is enums, categoricals etc is not essential, but may speed up parsing. Swapping int for pl.UInt16, pl.Int32 would also speed up parsing. However some of the datatypes are inferred, so they may be wrong.

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, "MNSP": pl.UInt8})
    .cast(
        {
            "INTERCONNECTORID": pl.Categorical,
            "EXPORTGENCONID": str,
            "EXPORTLIMIT": pl.Float64,
            "FCASEXPORTLIMIT": pl.Float64,
            "FCASIMPORTLIMIT": pl.Float64,
            "IMPORTGENCONID": str,
            "IMPORTLIMIT": pl.Float64,
            "INTERVENTION": pl.Boolean,
            "LOCAL_PRICE_ADJUSTMENT_EXPORT": pl.Float64,
            "LOCAL_PRICE_ADJUSTMENT_IMPORT": pl.Float64,
            "LOCALLY_CONSTRAINED_EXPORT": int,  # or pl.Int8
            "LOCALLY_CONSTRAINED_IMPORT": int,  # or pl.Int8
            "MARGINALLOSS": pl.Float64,
            "MARGINALVALUE": pl.Float64,
            "METEREDMWFLOW": pl.Float64,
            "MNSP": pl.Boolean,
            "MWFLOW": pl.Float64,
            "MWLOSSES": pl.Float64,
            "VIOLATIONDEGREE": pl.Float64,
        }
    )
    # Deduplicate
    # We want one row per ['INTERCONNECTORID', 'INTERVAL_DATETIME', 'RUN_DATETIME']
    # Tie-breaker: greatest value of ['LASTCHANGED']
    .sort(["LASTCHANGED"], descending=False)
    .unique(
        subset=["INTERCONNECTORID", "INTERVAL_DATETIME", "RUN_DATETIME"], keep="last"
    )
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_P5MIN_INTERCONNECTORSOLN_FILE01_202609010000.zip

Table without MetadataTable with MetadataRaw Text without Metadata

RUN_DATETIME	INTERCONNECTORID	INTERVAL_DATETIME	METEREDMWFLOW	MWFLOW	MWLOSSES	MARGINALVALUE	VIOLATIONDEGREE	MNSP	EXPORTLIMIT	IMPORTLIMIT	MARGINALLOSS	EXPORTGENCONID	IMPORTGENCONID	FCASEXPORTLIMIT	FCASIMPORTLIMIT	LASTCHANGED	LOCAL_PRICE_ADJUSTMENT_EXPORT	LOCALLY_CONSTRAINED_EXPORT	LOCAL_PRICE_ADJUSTMENT_IMPORT	LOCALLY_CONSTRAINED_IMPORT	INTERVENTION
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:05:00	-40.19971	-41	3.06127	0	0	0	39.80029	-120.19971	0.86671	NQTE_ROC	QNTE_ROC	39.80029	-120.19971	2026/09/01 00:00:33	0	0	0	0	0
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:10:00	-41	-57	6.13919	0	0	0	39	-121	0.81086	NQTE_ROC	QNTE_ROC	39	-121	2026/09/01 00:00:33	0	0	0	0	0
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:15:00	-57	-49	4.46807	0	0	0	23	-137	0.83836	NQTE_ROC	QNTE_ROC	23	-137	2026/09/01 00:00:33	0	0	0	0	0
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:20:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:25:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:30:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:35:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:40:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:45:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:50:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:55:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
...

C	SETP.WORLD	DVD_P5MIN_INTERCONNECTORSOLN	AEMO	PUBLIC	2026/10/09	16:11:05	001791526265724	MONTHLY_ARCHIVE	001791526265724
I	P5MIN	INTERCONNECTORSOLN	4	RUN_DATETIME	INTERCONNECTORID	INTERVAL_DATETIME	METEREDMWFLOW	MWFLOW	MWLOSSES	MARGINALVALUE	VIOLATIONDEGREE	MNSP	EXPORTLIMIT	IMPORTLIMIT	MARGINALLOSS	EXPORTGENCONID	IMPORTGENCONID	FCASEXPORTLIMIT	FCASIMPORTLIMIT	LASTCHANGED	LOCAL_PRICE_ADJUSTMENT_EXPORT	LOCALLY_CONSTRAINED_EXPORT	LOCAL_PRICE_ADJUSTMENT_IMPORT	LOCALLY_CONSTRAINED_IMPORT	INTERVENTION
D	P5MIN	INTERCONNECTORSOLN	4	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:05:00	-40.19971	-41	3.06127	0	0	0	39.80029	-120.19971	0.86671	NQTE_ROC	QNTE_ROC	39.80029	-120.19971	2026/09/01 00:00:33	0	0	0	0	0
D	P5MIN	INTERCONNECTORSOLN	4	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:10:00	-41	-57	6.13919	0	0	0	39	-121	0.81086	NQTE_ROC	QNTE_ROC	39	-121	2026/09/01 00:00:33	0	0	0	0	0
D	P5MIN	INTERCONNECTORSOLN	4	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:15:00	-57	-49	4.46807	0	0	0	23	-137	0.83836	NQTE_ROC	QNTE_ROC	23	-137	2026/09/01 00:00:33	0	0	0	0	0
D	P5MIN	INTERCONNECTORSOLN	4	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:20:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
D	P5MIN	INTERCONNECTORSOLN	4	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:25:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
D	P5MIN	INTERCONNECTORSOLN	4	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:30:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
D	P5MIN	INTERCONNECTORSOLN	4	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:35:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
D	P5MIN	INTERCONNECTORSOLN	4	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:40:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
D	P5MIN	INTERCONNECTORSOLN	4	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:45:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
D	P5MIN	INTERCONNECTORSOLN	4	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:50:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
D	P5MIN	INTERCONNECTORSOLN	4	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:55:00	-49	-49	4.46807	0	0	0	31	-129	0.83836	NQTE_ROC	QNTE_ROC	31	-129	2026/09/01 00:00:33	0	0	0	0	0
...
C	END OF REPORT	1003

RUN_DATETIME,INTERCONNECTORID,INTERVAL_DATETIME,METEREDMWFLOW,MWFLOW,MWLOSSES,MARGINALVALUE,VIOLATIONDEGREE,MNSP,EXPORTLIMIT,IMPORTLIMIT,MARGINALLOSS,EXPORTGENCONID,IMPORTGENCONID,FCASEXPORTLIMIT,FCASIMPORTLIMIT,LASTCHANGED,LOCAL_PRICE_ADJUSTMENT_EXPORT,LOCALLY_CONSTRAINED_EXPORT,LOCAL_PRICE_ADJUSTMENT_IMPORT,LOCALLY_CONSTRAINED_IMPORT,INTERVENTION
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:05:00",-40.19971,-41,3.06127,0,0,0,39.80029,-120.19971,0.86671,NQTE_ROC,QNTE_ROC,39.80029,-120.19971,"2026/09/01 00:00:33",0,0,0,0,0
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:10:00",-41,-57,6.13919,0,0,0,39,-121,0.81086,NQTE_ROC,QNTE_ROC,39,-121,"2026/09/01 00:00:33",0,0,0,0,0
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:15:00",-57,-49,4.46807,0,0,0,23,-137,0.83836,NQTE_ROC,QNTE_ROC,23,-137,"2026/09/01 00:00:33",0,0,0,0,0
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:20:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:25:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:30:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:35:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:40:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:45:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:50:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:55:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
...

Raw Text with Metadata

C,SETP.WORLD,DVD_P5MIN_INTERCONNECTORSOLN,AEMO,PUBLIC,2026/10/09,16:11:05,001791526265724,MONTHLY_ARCHIVE,001791526265724
I,P5MIN,INTERCONNECTORSOLN,4,RUN_DATETIME,INTERCONNECTORID,INTERVAL_DATETIME,METEREDMWFLOW,MWFLOW,MWLOSSES,MARGINALVALUE,VIOLATIONDEGREE,MNSP,EXPORTLIMIT,IMPORTLIMIT,MARGINALLOSS,EXPORTGENCONID,IMPORTGENCONID,FCASEXPORTLIMIT,FCASIMPORTLIMIT,LASTCHANGED,LOCAL_PRICE_ADJUSTMENT_EXPORT,LOCALLY_CONSTRAINED_EXPORT,LOCAL_PRICE_ADJUSTMENT_IMPORT,LOCALLY_CONSTRAINED_IMPORT,INTERVENTION
D,P5MIN,INTERCONNECTORSOLN,4,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:05:00",-40.19971,-41,3.06127,0,0,0,39.80029,-120.19971,0.86671,NQTE_ROC,QNTE_ROC,39.80029,-120.19971,"2026/09/01 00:00:33",0,0,0,0,0
D,P5MIN,INTERCONNECTORSOLN,4,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:10:00",-41,-57,6.13919,0,0,0,39,-121,0.81086,NQTE_ROC,QNTE_ROC,39,-121,"2026/09/01 00:00:33",0,0,0,0,0
D,P5MIN,INTERCONNECTORSOLN,4,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:15:00",-57,-49,4.46807,0,0,0,23,-137,0.83836,NQTE_ROC,QNTE_ROC,23,-137,"2026/09/01 00:00:33",0,0,0,0,0
D,P5MIN,INTERCONNECTORSOLN,4,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:20:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
D,P5MIN,INTERCONNECTORSOLN,4,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:25:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
D,P5MIN,INTERCONNECTORSOLN,4,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:30:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
D,P5MIN,INTERCONNECTORSOLN,4,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:35:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
D,P5MIN,INTERCONNECTORSOLN,4,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:40:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
D,P5MIN,INTERCONNECTORSOLN,4,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:45:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
D,P5MIN,INTERCONNECTORSOLN,4,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:50:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
D,P5MIN,INTERCONNECTORSOLN,4,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:55:00",-49,-49,4.46807,0,0,0,31,-129,0.83836,NQTE_ROC,QNTE_ROC,31,-129,"2026/09/01 00:00:33",0,0,0,0,0
...
C,"END OF REPORT",1003

Availability

Visibility: Public

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 9 of 2026.

Every month in between has a file. (No gaps.)

Data Size

Each year of data is approximately 186 MB when zipped, 2 GB as unzipped CSV.

Deduplication and PDR Loader Configuration

The primary keys are:

INTERCONNECTORID
INTERVAL_DATETIME
RUN_DATETIME

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	INTERCONNECTORSOLN	4

This means that the CSV files start with metadata columns:

I,P5MIN,INTERCONNECTORSOLN,4,...
D,P5MIN,INTERCONNECTORSOLN,4,...

Indexes

LASTCHANGED

Links

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