BIDOFFERPERIOD
BIDOFFERPERIOD shows 5-minute period-based Energy and Ancillary Service bid data.BIDOFFERPERIOD is a child table of
BIDDAYOFFER
Column Schema
BIDTYPE
The type of bid, one-of ENERGY, RAISE6SEC, RAISE60SEC, RAISE5MIN, RAISEREG, LOWER6SEC, LOWER60SEC, LOWER5MIN, LOWERREG
The SQL type is VARCHAR2(10).
This is actually a factor/enum, with values:
-
ENERGY -
LOWERREG -
LOWER60SEC -
RAISE5MIN -
LOWER5MIN -
LOWER6SEC -
RAISE60SEC -
RAISE6SEC -
RAISEREG -
RAISE1SEC -
LOWER1SEC
This column is mandatory, and a primary key.
DIRECTION
The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL
Warning
Despite AEMO's documentation saying that this column is mandatory, it is missing from older files. It was added to the schema in version 5.3.
SQL Type: VARCHAR2(20)
Polars Type: str
This column is mandatory, and a primary key.
Example: BIDIRECTIONAL
DUID
Dispatchable Unit ID
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(20)
Polars Type: pl.Categorical
This column is mandatory, and a primary key.
Examples:
WDBESS1W/HOE#2
OFFERDATETIME
Time this bid was processed and loaded
SQL Type: TIMESTAMP(3)
Polars Type: pl.Datetime()
This column is mandatory, and a primary key.
Example: 2026/09/30 06:07:29.000
Unlike most datetime columns, this one includes a millisecond component.
e.g. 2029/03/15 00:00:00.123.
PERIODID
Period ID 1 to 288
SQL Type: NUMBER(3,0)
Polars Type: pl.Int16
This column is mandatory, and a primary key.
Examples:
1, 288
TRADINGDATE
The trading date this bid is for
SQL Type: DATE
Polars Type: pl.Date()
This column is mandatory, and a primary key.
Example: 2026/09/30 00:00:00
Note that AEMO represents dates as datetimes with a midnight time component.
BANDAVAIL1
Availability at price band 1
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Example: 0
BANDAVAIL2
Availability at price band 2
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Example: 0
BANDAVAIL3
Availability at price band 3
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Example: 0
BANDAVAIL4
Availability at price band 4
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Example: 6
BANDAVAIL5
Availability at price band 5
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Example: 9
BANDAVAIL6
Availability at price band 6
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Example: 5
BANDAVAIL7
Availability at price band 7
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Example: 5
BANDAVAIL8
Availability at price band 8
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Example: 5
BANDAVAIL9
Availability at price band 9
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Example: 0
BANDAVAIL10
Availability at price band 10
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Example: 110
ENABLEMENTMAX
Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only)
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Examples:
35, 255
ENABLEMENTMIN
Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only)
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Examples:
-25, -255
ENERGYLIMIT
The Energy limit applying at the end of this dispatch interval in MWh. For GEN this is a lower energy limit. For LOAD this is an upper energy limit
SQL Type: NUMBER(15,5)
Polars Type: pl.Float64
This column is not mandatory.
FIXEDLOAD
Fixed unit output MW (Energy bids only) A null value means no fixed load so the unit is dispatched according to bid and market
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
HIGHBREAKPOINT
Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only)
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Examples:
0, 1, 115
LOWBREAKPOINT
Minimum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only)
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Examples:
-25, -255
MAXAVAIL
Maximum availability for this BidType in this period
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Examples:
35, 140
PASAAVAILABILITY
Allows for future use for Energy bids, being the physical plant capability including any capability potentially available within 24 hours
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
Example: 6
PERIODIDTO
Period ID Ending
SQL Type: NUMBER(3,0)
Polars Type: pl.Int16
This column is not mandatory.
Examples:
1, 288
RAMPDOWNRATE
MW/Min for lower (Energy bids only)
SQL Type: NUMBER(6)
Polars Type: pl.Int32
This column is not mandatory.
Example: 2
RAMPUPRATE
MW/Min for raise (Energy bids only)
SQL Type: NUMBER(6)
Polars Type: pl.Int32
This column is not mandatory.
Example: 2
RECALL_PERIOD
The advance notice(in hours) that a Scheduled Resource requires to achieve the PASA Availability MW for this trading interval
SQL Type: NUMBER(8,3)
Polars Type: pl.Float64
This column is not mandatory.
New Data Timing
Data is published whenever new bid data arrives
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
# Dates are represented as datetimes at midnight
# e.g. "2029/03/15 00:00:00"
d_fmt = "%Y/%m/%d 00:00:00"
# for "TIMESTAMP" columns
# Note that Polars uses slightly different format strings for fractional seconds to `dt.strptime`
# e.g. "2029/03/15 00:00:00.123".
dt_ms_fmt = "%Y/%m/%d %H:%M:%S%.3f"
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("TRADINGDATE").str.strptime(pl.Date, d_fmt),
pl.col("OFFERDATETIME").str.strptime(pl.Datetime, dt_ms_fmt),
)
.cast(
{
"BIDTYPE": pl.Enum(
[
"ENERGY",
"LOWERREG",
"LOWER60SEC",
"RAISE5MIN",
"LOWER5MIN",
"LOWER6SEC",
"RAISE60SEC",
"RAISE6SEC",
"RAISEREG",
"RAISE1SEC",
"LOWER1SEC",
]
),
"DIRECTION": str,
"DUID": pl.Categorical,
"PERIODID": pl.Int16,
"TRADINGDATE": pl.Date(),
"BANDAVAIL1": pl.Float64,
"BANDAVAIL2": pl.Float64,
"BANDAVAIL3": pl.Float64,
"BANDAVAIL4": pl.Float64,
"BANDAVAIL5": pl.Float64,
"BANDAVAIL6": pl.Float64,
"BANDAVAIL7": pl.Float64,
"BANDAVAIL8": pl.Float64,
"BANDAVAIL9": pl.Float64,
"BANDAVAIL10": pl.Float64,
"ENABLEMENTMAX": pl.Float64,
"ENABLEMENTMIN": pl.Float64,
"ENERGYLIMIT": pl.Float64,
"FIXEDLOAD": pl.Float64,
"HIGHBREAKPOINT": pl.Float64,
"LOWBREAKPOINT": pl.Float64,
"MAXAVAIL": pl.Float64,
"PASAAVAILABILITY": pl.Float64,
"PERIODIDTO": pl.Int16,
"RAMPDOWNRATE": pl.Int32,
"RAMPUPRATE": pl.Int32,
"RECALL_PERIOD": pl.Float64,
}
)
# Deduplicate
# WARNING: This will probably use up more memory than you have.
# We want one row per ['BIDTYPE', 'DIRECTION', 'DUID', 'OFFERDATETIME', 'PERIODID', 'TRADINGDATE']
.unique(
subset=[
"BIDTYPE",
"DIRECTION",
"DUID",
"OFFERDATETIME",
"PERIODID",
"TRADINGDATE",
],
keep="any",
)
)
Nemosis
This table is not yet available in Nemosis.
Example File
From PUBLIC_ARCHIVE_BIDOFFERPERIOD_FILE64_202609010000.zip
| DUID | BIDTYPE | TRADINGDATE | OFFERDATETIME | DIRECTION | PERIODID | MAXAVAIL | FIXEDLOAD | RAMPUPRATE | RAMPDOWNRATE | ENABLEMENTMIN | ENABLEMENTMAX | LOWBREAKPOINT | HIGHBREAKPOINT | BANDAVAIL1 | BANDAVAIL2 | BANDAVAIL3 | BANDAVAIL4 | BANDAVAIL5 | BANDAVAIL6 | BANDAVAIL7 | BANDAVAIL8 | BANDAVAIL9 | BANDAVAIL10 | PASAAVAILABILITY | ENERGYLIMIT | PERIODIDTO | RECALL_PERIOD |
| WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 1 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 1 | ||||||
| WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 2 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 2 | ||||||
| WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 3 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 3 | ||||||
| WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 4 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 4 | ||||||
| WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 5 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 5 | ||||||
| WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 6 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 6 | ||||||
| WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 7 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 7 | ||||||
| WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 8 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 8 | ||||||
| WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 9 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 9 | ||||||
| WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 10 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 10 | ||||||
| WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 11 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 11 | ||||||
| ... |
| C | SETP.WORLD | DVD_BIDOFFERPERIOD | AEMO | PUBLIC | 2026/10/10 | 01:36:51 | 001791560211615 | MONTHLY_ARCHIVE | 001791560211615 | ||||||||||||||||||||||
| I | BIDS | BIDOFFERPERIOD | 3 | DUID | BIDTYPE | TRADINGDATE | OFFERDATETIME | DIRECTION | PERIODID | MAXAVAIL | FIXEDLOAD | RAMPUPRATE | RAMPDOWNRATE | ENABLEMENTMIN | ENABLEMENTMAX | LOWBREAKPOINT | HIGHBREAKPOINT | BANDAVAIL1 | BANDAVAIL2 | BANDAVAIL3 | BANDAVAIL4 | BANDAVAIL5 | BANDAVAIL6 | BANDAVAIL7 | BANDAVAIL8 | BANDAVAIL9 | BANDAVAIL10 | PASAAVAILABILITY | ENERGYLIMIT | PERIODIDTO | RECALL_PERIOD |
| D | BIDS | BIDOFFERPERIOD | 3 | WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 1 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 1 | ||||||
| D | BIDS | BIDOFFERPERIOD | 3 | WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 2 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 2 | ||||||
| D | BIDS | BIDOFFERPERIOD | 3 | WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 3 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 3 | ||||||
| D | BIDS | BIDOFFERPERIOD | 3 | WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 4 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 4 | ||||||
| D | BIDS | BIDOFFERPERIOD | 3 | WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 5 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 5 | ||||||
| D | BIDS | BIDOFFERPERIOD | 3 | WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 6 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 6 | ||||||
| D | BIDS | BIDOFFERPERIOD | 3 | WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 7 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 7 | ||||||
| D | BIDS | BIDOFFERPERIOD | 3 | WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 8 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 8 | ||||||
| D | BIDS | BIDOFFERPERIOD | 3 | WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 9 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 9 | ||||||
| D | BIDS | BIDOFFERPERIOD | 3 | WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 10 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 10 | ||||||
| D | BIDS | BIDOFFERPERIOD | 3 | WDBESS1 | RAISE1SEC | 2026/09/30 00:00:00 | 2026/09/30 06:07:29.000 | BIDIRECTIONAL | 11 | 140 | -254 | 254 | -254 | 114 | 0 | 0 | 0 | 6 | 9 | 5 | 5 | 5 | 0 | 110 | 11 | ||||||
| ... | |||||||||||||||||||||||||||||||
| C | END OF REPORT | 1003 |
DUID,BIDTYPE,TRADINGDATE,OFFERDATETIME,DIRECTION,PERIODID,MAXAVAIL,FIXEDLOAD,RAMPUPRATE,RAMPDOWNRATE,ENABLEMENTMIN,ENABLEMENTMAX,LOWBREAKPOINT,HIGHBREAKPOINT,BANDAVAIL1,BANDAVAIL2,BANDAVAIL3,BANDAVAIL4,BANDAVAIL5,BANDAVAIL6,BANDAVAIL7,BANDAVAIL8,BANDAVAIL9,BANDAVAIL10,PASAAVAILABILITY,ENERGYLIMIT,PERIODIDTO,RECALL_PERIOD
WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,1,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,1,
WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,2,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,2,
WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,3,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,3,
WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,4,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,4,
WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,5,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,5,
WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,6,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,6,
WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,7,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,7,
WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,8,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,8,
WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,9,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,9,
WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,10,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,10,
WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,11,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,11,
...
C,SETP.WORLD,DVD_BIDOFFERPERIOD,AEMO,PUBLIC,2026/10/10,01:36:51,001791560211615,MONTHLY_ARCHIVE,001791560211615
I,BIDS,BIDOFFERPERIOD,3,DUID,BIDTYPE,TRADINGDATE,OFFERDATETIME,DIRECTION,PERIODID,MAXAVAIL,FIXEDLOAD,RAMPUPRATE,RAMPDOWNRATE,ENABLEMENTMIN,ENABLEMENTMAX,LOWBREAKPOINT,HIGHBREAKPOINT,BANDAVAIL1,BANDAVAIL2,BANDAVAIL3,BANDAVAIL4,BANDAVAIL5,BANDAVAIL6,BANDAVAIL7,BANDAVAIL8,BANDAVAIL9,BANDAVAIL10,PASAAVAILABILITY,ENERGYLIMIT,PERIODIDTO,RECALL_PERIOD
D,BIDS,BIDOFFERPERIOD,3,WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,1,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,1,
D,BIDS,BIDOFFERPERIOD,3,WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,2,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,2,
D,BIDS,BIDOFFERPERIOD,3,WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,3,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,3,
D,BIDS,BIDOFFERPERIOD,3,WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,4,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,4,
D,BIDS,BIDOFFERPERIOD,3,WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,5,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,5,
D,BIDS,BIDOFFERPERIOD,3,WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,6,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,6,
D,BIDS,BIDOFFERPERIOD,3,WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,7,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,7,
D,BIDS,BIDOFFERPERIOD,3,WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,8,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,8,
D,BIDS,BIDOFFERPERIOD,3,WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,9,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,9,
D,BIDS,BIDOFFERPERIOD,3,WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,10,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,10,
D,BIDS,BIDOFFERPERIOD,3,WDBESS1,RAISE1SEC,"2026/09/30 00:00:00","2026/09/30 06:07:29.000",BIDIRECTIONAL,11,140,,,,-254,254,-254,114,0,0,0,6,9,5,5,5,0,110,,,11,
...
C,"END OF REPORT",1003
Availability
Visibility: Private & Public Next-Day
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).
Tip
There are multiple files per month, because this is such a large table.
The earliest available data is month 3 of 2021. The most recent available data is month 9 of 2026.
Every month in between has at least one file.
Warning
The filenames of zips may not correspond to the tables. These can be mixed up with BIDPEROFFER. Check column 2 and 3 inside the CSV against REPORT_NAME and REPORT_SUBTYPE to be sure. I have already done this for you, and listed all URLs in this metadata file.
Data Size
Each year of data is approximately 212 GB when zipped, 2 TB as unzipped CSV.
Warning
This table is extremely large!
Simply calling pd.read_csv() will probably require more memory than your laptop has.
You probably need to use a cloud service,
or at least a large server. (Doing it on a laptop is possible, but very hard.)
Querying this table for more than a few months of data is a hardcore endevour. Ask your local data engineer for help. Strategies include:
- predicate push-downs
- lazy queries
- hard-coded schema (e.g. the hard-coded enums and categoricals in the Polars code sample above)
- partitioning by
DUID, year etc
Deduplication and PDR Loader Configuration
The primary keys are:
Tip
Bid deduplication is particularly tricky. See the guide.
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.
| Report Name | Report Subtype | Version | Undisclosed |
|---|---|---|---|
| BIDS | BIDOFFERPERIOD | 2 | |
| BIDS | BIDOFFERPERIOD | 3 | |
| BIDS | BIDOFFERPERIOD_SPARSE | 1 | |
| BIDS | BIDOFFERPERIOD_SPARSE | 2 | |
| OFFER | BIDOFFERPERIOD | 1 | ⚠️ |
Warning
Some of these file mappings are not in the published PDR Loader configuration file, even though files for this table exist with those metadata values. Mappings marked with ⚠️ have been added by me after manually inspecting those files.
This means that the CSV files start with metadata columns:
or
or
or
or
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: BIDS