Skip to content

NEM Schema

P5MIN_INTERSENSITIVITIES

P5MIN_INTERSENSITIVITIES

Price Sensitivies for 5MinPD solution. New solution every 5 minutes. Current Scenarios defined in P5MIN_SCENARIODEMANDTRK/P5MIN_SCENARIODEMAND

Column Schema

INTERCONNECTORID

Interconnector identifier

SQL Type: VARCHAR2(20) 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

Definitive Run from which this solution derives

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

This column is mandatory, and a primary key.

Example: 2026/09/01 00:05:00

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

For more information, see the dedicated documentation page.

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

This column is mandatory (but not a primary key).

Example: 0

INTERVENTION_ACTIVE

Flag to indicate if the sensitivity run contains an active intervention constraint: 0 = No, 1 = Yes

For more information, see the dedicated documentation page.

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

This column is not mandatory.

Example: 0

LASTCHANGED

Timestamp when this record was last modified

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:01:29

MWFLOW1

MW Flow value. Flow1 = MW flow for given Interconnector for Scenario 1

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

This column is not mandatory.

Examples: -5.66, 9.6, 0, -1069

MWFLOW2

MW Flow value. Flow2 = MW flow for given Interconnector for Scenario 2

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

This column is not mandatory.

Examples: -29.35, 3.69, 0, 1043

MWFLOW3

MW Flow value. Flow3 = MW flow for given Interconnector for Scenario 3

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

This column is not mandatory.

Examples: -5.66, 9.6, 0, 50

MWFLOW4

MW Flow value. Flow4 = MW flow for given Interconnector for Scenario 4

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

This column is not mandatory.

Examples: -10.59, 2.56, 0, 1056

MWFLOW5

MW Flow value. Flow5 = MW flow for given Interconnector for Scenario 5

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

This column is not mandatory.

Examples: -28.28, 5.25, 0, 1087

MWFLOW6

MW Flow value. Flow6 = MW flow for given Interconnector for Scenario 6

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

This column is not mandatory.

Examples: -3.27, 2.78, 0, -1003

MWFLOW7

MW Flow value. Flow7 = MW flow for given Interconnector for Scenario 7

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

This column is not mandatory.

Examples: -2.86, 1.97, 0, 1056

MWFLOW8

MW Flow value. Flow8 = MW flow for given Interconnector for Scenario 8

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

This column is not mandatory.

Examples: -7.9, 3.66, 0, 1056

MWFLOW9

MW Flow value. Flow9 = MW flow for given Interconnector for Scenario 9

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

This column is not mandatory.

Examples: -12.21, 5.04, 0, 1058

MWFLOW10

MW Flow value. Flow10 = MW flow for given Interconnector for Scenario 10

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

This column is not mandatory.

Examples: -14.21, 5.25, 0, 105

MWFLOW11

MW Flow value. Flow11 = MW flow for given Interconnector for Scenario 11

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

This column is not mandatory.

Examples: -14.21, 12.38, 0, -1003

MWFLOW12

MW Flow value. Flow12 = MW flow for given Interconnector for Scenario 12

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

This column is not mandatory.

Examples: -5.66, 5.25, 0, -833

MWFLOW13

MW Flow value. Flow13 = MW flow for given Interconnector for Scenario 13

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

This column is not mandatory.

Examples: -14.21, 7.11, 0, 1056

MWFLOW14

MW Flow value. Flow14 = MW flow for given Interconnector for Scenario 14

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

This column is not mandatory.

Examples: -25.52, 7.11, 0, 1056

MWFLOW15

MW Flow value. Flow15 = MW flow for given Interconnector for Scenario 15

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

This column is not mandatory.

Examples: -14.21, 0.43, 0, 1056

MWFLOW16

MW Flow value. Flow16 = MW flow for given Interconnector for Scenario 16

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

This column is not mandatory.

Example: 0

MWFLOW17

MW Flow value. Flow17 = MW flow for given Interconnector for Scenario 17

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

This column is not mandatory.

Example: 0

MWFLOW18

MW Flow value. Flow18 = MW flow for given Interconnector for Scenario 18

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

This column is not mandatory.

Example: 0

MWFLOW19

MW Flow value. Flow19 = MW flow for given Interconnector for Scenario 19

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

This column is not mandatory.

Example: 0

MWFLOW20

MW Flow value. Flow20 = MW flow for given Interconnector for Scenario 20

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

This column is not mandatory.

Example: 0

MWFLOW21

MW Flow value. Flow21 = MW flow for given Interconnector for Scenario 21

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

This column is not mandatory.

Example: 0

MWFLOW22

MW Flow value. Flow22 = MW flow for given Interconnector for Scenario 22

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

This column is not mandatory.

Example: 0

MWFLOW23

MW Flow value. Flow23 = MW flow for given Interconnector for Scenario 23

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

This column is not mandatory.

Example: 0

MWFLOW24

MW Flow value. Flow24 = MW flow for given Interconnector for Scenario 24

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

This column is not mandatory.

Example: 0

MWFLOW25

MW Flow value. Flow25 = MW flow for given Interconnector for Scenario 25

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

This column is not mandatory.

Example: 0

MWFLOW26

MW Flow value. Flow26 = MW flow for given Interconnector for Scenario 26

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

This column is not mandatory.

Example: 0

MWFLOW27

MW Flow value. Flow27 = MW flow for given Interconnector for Scenario 27

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

This column is not mandatory.

Example: 0

MWFLOW28

MW Flow value. Flow28 = MW flow for given Interconnector for Scenario 28

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

This column is not mandatory.

Example: 0

MWFLOW29

MW Flow value. Flow29 = MW flow for given Interconnector for Scenario 29

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

This column is not mandatory.

Example: 0

MWFLOW30

MW Flow value. Flow30 = MW flow for given Interconnector for Scenario 30

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

This column is not mandatory.

Example: 0

MWFLOW31

MW Flow value. Flow31 = MW flow for given Interconnector for Scenario 31

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

This column is not mandatory.

Example: 0

MWFLOW32

MW Flow value. Flow32 = MW flow for given Interconnector for Scenario 32

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

This column is not mandatory.

Example: 0

MWFLOW33

MW Flow value. Flow33 = MW flow for given Interconnector for Scenario 33

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

This column is not mandatory.

Example: 0

MWFLOW34

MW Flow value. Flow34 = MW flow for given Interconnector for Scenario 34

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

This column is not mandatory.

Example: 0

MWFLOW35

MW Flow value. Flow35 = MW flow for given Interconnector for Scenario 35

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

This column is not mandatory.

Example: 0

MWFLOW36

MW Flow value. Flow36 = MW flow for given Interconnector for Scenario 36

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

This column is not mandatory.

Example: 0

MWFLOW37

MW Flow value. Flow37 = MW flow for given Interconnector for Scenario 37

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

This column is not mandatory.

Example: 0

MWFLOW38

MW Flow value. Flow38 = MW flow for given Interconnector for Scenario 38

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

This column is not mandatory.

Example: 0

MWFLOW39

MW Flow value. Flow39 = MW flow for given Interconnector for Scenario 39

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

This column is not mandatory.

Example: 0

MWFLOW40

MW Flow value. Flow40 = MW flow for given Interconnector for Scenario 40

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

This column is not mandatory.

Example: 0

MWFLOW41

MW Flow value. Flow41 = MW flow for given Interconnector for Scenario 41

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

This column is not mandatory.

Example: 0

MWFLOW42

MW Flow value. Flow42 = MW flow for given Interconnector for Scenario 42

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

This column is not mandatory.

Example: 0

MWFLOW43

MW Flow value. Flow43 = MW flow for given Interconnector for Scenario 43

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, "INTERVENTION_ACTIVE": pl.UInt8})
    .cast(
        {
            "INTERCONNECTORID": pl.Categorical,
            "INTERVENTION": pl.Boolean,
            "INTERVENTION_ACTIVE": pl.Boolean,
            "MWFLOW1": pl.Float64,
            "MWFLOW2": pl.Float64,
            "MWFLOW3": pl.Float64,
            "MWFLOW4": pl.Float64,
            "MWFLOW5": pl.Float64,
            "MWFLOW6": pl.Float64,
            "MWFLOW7": pl.Float64,
            "MWFLOW8": pl.Float64,
            "MWFLOW9": pl.Float64,
            "MWFLOW10": pl.Float64,
            "MWFLOW11": pl.Float64,
            "MWFLOW12": pl.Float64,
            "MWFLOW13": pl.Float64,
            "MWFLOW14": pl.Float64,
            "MWFLOW15": pl.Float64,
            "MWFLOW16": pl.Float64,
            "MWFLOW17": pl.Float64,
            "MWFLOW18": pl.Float64,
            "MWFLOW19": pl.Float64,
            "MWFLOW20": pl.Float64,
            "MWFLOW21": pl.Float64,
            "MWFLOW22": pl.Float64,
            "MWFLOW23": pl.Float64,
            "MWFLOW24": pl.Float64,
            "MWFLOW25": pl.Float64,
            "MWFLOW26": pl.Float64,
            "MWFLOW27": pl.Float64,
            "MWFLOW28": pl.Float64,
            "MWFLOW29": pl.Float64,
            "MWFLOW30": pl.Float64,
            "MWFLOW31": pl.Float64,
            "MWFLOW32": pl.Float64,
            "MWFLOW33": pl.Float64,
            "MWFLOW34": pl.Float64,
            "MWFLOW35": pl.Float64,
            "MWFLOW36": pl.Float64,
            "MWFLOW37": pl.Float64,
            "MWFLOW38": pl.Float64,
            "MWFLOW39": pl.Float64,
            "MWFLOW40": pl.Float64,
            "MWFLOW41": pl.Float64,
            "MWFLOW42": pl.Float64,
            "MWFLOW43": 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_INTERSENSITIVITIES_FILE01_202609010000.zip

Table without MetadataTable with MetadataRaw Text without Metadata

RUN_DATETIME	INTERCONNECTORID	INTERVAL_DATETIME	INTERVENTION	INTERVENTION_ACTIVE	MWFLOW1	MWFLOW2	MWFLOW3	MWFLOW4	MWFLOW5	MWFLOW6	MWFLOW7	MWFLOW8	MWFLOW9	MWFLOW10	MWFLOW11	MWFLOW12	MWFLOW13	MWFLOW14	MWFLOW15	MWFLOW16	MWFLOW17	MWFLOW18	MWFLOW19	MWFLOW20	MWFLOW21	MWFLOW22	MWFLOW23	MWFLOW24	MWFLOW25	MWFLOW26	MWFLOW27	MWFLOW28	MWFLOW29	MWFLOW30	MWFLOW31	MWFLOW32	MWFLOW33	MWFLOW34	MWFLOW35	MWFLOW36	MWFLOW37	MWFLOW38	MWFLOW39	MWFLOW40	MWFLOW41	MWFLOW42	MWFLOW43	LASTCHANGED
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:05:00	0	0	-49	-33	-49.24	-41	-41	-41	-41	-41	-41	-33	-41	-33	-41	-41	-41	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:10:00	0	0	-57	-49	-60.02	-57	-49	-57	-57	-57	-57	-49	-57	-49	-57	-57	-57	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:15:00	0	0	-57	-49	-57	-57	-49	-57	-57	-49	-57	-49	-49	-49	-49	-49	-53.73	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:20:00	0	0	-57	-49	-57	-57	-49	-57	-49.43	-49	-57	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:25:00	0	0	-57	-49	-57	-49	-49	-57	-49	-49	-49	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:30:00	0	0	-57	-49	-57	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:35:00	0	0	-57	-49	-65	-56.63	-49	-57	-49	-49	-57	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:40:00	0	0	-57	-49	-65	-57	-49	-57	-57	-49	-57	-49	-49	-49	-51.4	-49	-57	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:45:00	0	0	-57	-49	-65	-49	-49	-57	-49	-49	-57	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:50:00	0	0	-57	-49	-57.85	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:55:00	0	0	-57	-49	-65	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
...

C	SETP.WORLD	DVD_P5MIN_INTERSENSITIVITIES	AEMO	PUBLIC	2026/10/09	16:11:49	001791526309817	MONTHLY_ARCHIVE	001791526309817
I	P5MIN	INTERSENSITIVITIES	1	RUN_DATETIME	INTERCONNECTORID	INTERVAL_DATETIME	INTERVENTION	INTERVENTION_ACTIVE	MWFLOW1	MWFLOW2	MWFLOW3	MWFLOW4	MWFLOW5	MWFLOW6	MWFLOW7	MWFLOW8	MWFLOW9	MWFLOW10	MWFLOW11	MWFLOW12	MWFLOW13	MWFLOW14	MWFLOW15	MWFLOW16	MWFLOW17	MWFLOW18	MWFLOW19	MWFLOW20	MWFLOW21	MWFLOW22	MWFLOW23	MWFLOW24	MWFLOW25	MWFLOW26	MWFLOW27	MWFLOW28	MWFLOW29	MWFLOW30	MWFLOW31	MWFLOW32	MWFLOW33	MWFLOW34	MWFLOW35	MWFLOW36	MWFLOW37	MWFLOW38	MWFLOW39	MWFLOW40	MWFLOW41	MWFLOW42	MWFLOW43	LASTCHANGED
D	P5MIN	INTERSENSITIVITIES	1	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:05:00	0	0	-49	-33	-49.24	-41	-41	-41	-41	-41	-41	-33	-41	-33	-41	-41	-41	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
D	P5MIN	INTERSENSITIVITIES	1	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:10:00	0	0	-57	-49	-60.02	-57	-49	-57	-57	-57	-57	-49	-57	-49	-57	-57	-57	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
D	P5MIN	INTERSENSITIVITIES	1	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:15:00	0	0	-57	-49	-57	-57	-49	-57	-57	-49	-57	-49	-49	-49	-49	-49	-53.73	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
D	P5MIN	INTERSENSITIVITIES	1	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:20:00	0	0	-57	-49	-57	-57	-49	-57	-49.43	-49	-57	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
D	P5MIN	INTERSENSITIVITIES	1	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:25:00	0	0	-57	-49	-57	-49	-49	-57	-49	-49	-49	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
D	P5MIN	INTERSENSITIVITIES	1	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:30:00	0	0	-57	-49	-57	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
D	P5MIN	INTERSENSITIVITIES	1	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:35:00	0	0	-57	-49	-65	-56.63	-49	-57	-49	-49	-57	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
D	P5MIN	INTERSENSITIVITIES	1	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:40:00	0	0	-57	-49	-65	-57	-49	-57	-57	-49	-57	-49	-49	-49	-51.4	-49	-57	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
D	P5MIN	INTERSENSITIVITIES	1	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:45:00	0	0	-57	-49	-65	-49	-49	-57	-49	-49	-57	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
D	P5MIN	INTERSENSITIVITIES	1	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:50:00	0	0	-57	-49	-57.85	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
D	P5MIN	INTERSENSITIVITIES	1	2026/09/01 00:05:00	N-Q-MNSP1	2026/09/01 00:55:00	0	0	-57	-49	-65	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	-49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2026/09/01 00:01:29
...
C	END OF REPORT	1003

RUN_DATETIME,INTERCONNECTORID,INTERVAL_DATETIME,INTERVENTION,INTERVENTION_ACTIVE,MWFLOW1,MWFLOW2,MWFLOW3,MWFLOW4,MWFLOW5,MWFLOW6,MWFLOW7,MWFLOW8,MWFLOW9,MWFLOW10,MWFLOW11,MWFLOW12,MWFLOW13,MWFLOW14,MWFLOW15,MWFLOW16,MWFLOW17,MWFLOW18,MWFLOW19,MWFLOW20,MWFLOW21,MWFLOW22,MWFLOW23,MWFLOW24,MWFLOW25,MWFLOW26,MWFLOW27,MWFLOW28,MWFLOW29,MWFLOW30,MWFLOW31,MWFLOW32,MWFLOW33,MWFLOW34,MWFLOW35,MWFLOW36,MWFLOW37,MWFLOW38,MWFLOW39,MWFLOW40,MWFLOW41,MWFLOW42,MWFLOW43,LASTCHANGED
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:05:00",0,0,-49,-33,-49.24,-41,-41,-41,-41,-41,-41,-33,-41,-33,-41,-41,-41,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:10:00",0,0,-57,-49,-60.02,-57,-49,-57,-57,-57,-57,-49,-57,-49,-57,-57,-57,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:15:00",0,0,-57,-49,-57,-57,-49,-57,-57,-49,-57,-49,-49,-49,-49,-49,-53.73,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:20:00",0,0,-57,-49,-57,-57,-49,-57,-49.43,-49,-57,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:25:00",0,0,-57,-49,-57,-49,-49,-57,-49,-49,-49,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:30:00",0,0,-57,-49,-57,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:35:00",0,0,-57,-49,-65,-56.63,-49,-57,-49,-49,-57,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:40:00",0,0,-57,-49,-65,-57,-49,-57,-57,-49,-57,-49,-49,-49,-51.4,-49,-57,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:45:00",0,0,-57,-49,-65,-49,-49,-57,-49,-49,-57,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:50:00",0,0,-57,-49,-57.85,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:55:00",0,0,-57,-49,-65,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
...

Raw Text with Metadata

C,SETP.WORLD,DVD_P5MIN_INTERSENSITIVITIES,AEMO,PUBLIC,2026/10/09,16:11:49,001791526309817,MONTHLY_ARCHIVE,001791526309817
I,P5MIN,INTERSENSITIVITIES,1,RUN_DATETIME,INTERCONNECTORID,INTERVAL_DATETIME,INTERVENTION,INTERVENTION_ACTIVE,MWFLOW1,MWFLOW2,MWFLOW3,MWFLOW4,MWFLOW5,MWFLOW6,MWFLOW7,MWFLOW8,MWFLOW9,MWFLOW10,MWFLOW11,MWFLOW12,MWFLOW13,MWFLOW14,MWFLOW15,MWFLOW16,MWFLOW17,MWFLOW18,MWFLOW19,MWFLOW20,MWFLOW21,MWFLOW22,MWFLOW23,MWFLOW24,MWFLOW25,MWFLOW26,MWFLOW27,MWFLOW28,MWFLOW29,MWFLOW30,MWFLOW31,MWFLOW32,MWFLOW33,MWFLOW34,MWFLOW35,MWFLOW36,MWFLOW37,MWFLOW38,MWFLOW39,MWFLOW40,MWFLOW41,MWFLOW42,MWFLOW43,LASTCHANGED
D,P5MIN,INTERSENSITIVITIES,1,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:05:00",0,0,-49,-33,-49.24,-41,-41,-41,-41,-41,-41,-33,-41,-33,-41,-41,-41,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
D,P5MIN,INTERSENSITIVITIES,1,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:10:00",0,0,-57,-49,-60.02,-57,-49,-57,-57,-57,-57,-49,-57,-49,-57,-57,-57,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
D,P5MIN,INTERSENSITIVITIES,1,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:15:00",0,0,-57,-49,-57,-57,-49,-57,-57,-49,-57,-49,-49,-49,-49,-49,-53.73,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
D,P5MIN,INTERSENSITIVITIES,1,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:20:00",0,0,-57,-49,-57,-57,-49,-57,-49.43,-49,-57,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
D,P5MIN,INTERSENSITIVITIES,1,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:25:00",0,0,-57,-49,-57,-49,-49,-57,-49,-49,-49,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
D,P5MIN,INTERSENSITIVITIES,1,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:30:00",0,0,-57,-49,-57,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
D,P5MIN,INTERSENSITIVITIES,1,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:35:00",0,0,-57,-49,-65,-56.63,-49,-57,-49,-49,-57,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
D,P5MIN,INTERSENSITIVITIES,1,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:40:00",0,0,-57,-49,-65,-57,-49,-57,-57,-49,-57,-49,-49,-49,-51.4,-49,-57,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
D,P5MIN,INTERSENSITIVITIES,1,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:45:00",0,0,-57,-49,-65,-49,-49,-57,-49,-49,-57,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
D,P5MIN,INTERSENSITIVITIES,1,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:50:00",0,0,-57,-49,-57.85,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
D,P5MIN,INTERSENSITIVITIES,1,"2026/09/01 00:05:00",N-Q-MNSP1,"2026/09/01 00:55:00",0,0,-57,-49,-65,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,-49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2026/09/01 00:01:29"
...
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 8 of 2024. 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 205 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	INTERSENSITIVITIES	1

This means that the CSV files start with metadata columns:

I,P5MIN,INTERSENSITIVITIES,1,...
D,P5MIN,INTERSENSITIVITIES,1,...

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