bids__bidofferperiod_sparse__2
AEMO Description
BIDOFFERPERIOD shows 5-minute period-based Energy and Ancill
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 973,918,681 |
| Combined Size | 2.42 GiB |
| MMS Table | bidofferperiod |
| Unified View | nemwebviews.bids__bidofferperiod_sparse__2 |
Schema Evolution
| Column | Type | Description | ffcf1803 |
|---|---|---|---|
BANDAVAIL1 |
Nullable(Float64) |
Availability at price band 1 | ✓ |
BANDAVAIL10 |
Nullable(Float64) |
Availability at price band 10 | ✓ |
BANDAVAIL2 |
Nullable(Float64) |
Availability at price band 2 | ✓ |
BANDAVAIL3 |
Nullable(Float64) |
Availability at price band 3 | ✓ |
BANDAVAIL4 |
Nullable(Float64) |
Availability at price band 4 | ✓ |
BANDAVAIL5 |
Nullable(Float64) |
Availability at price band 5 | ✓ |
BANDAVAIL6 |
Nullable(Float64) |
Availability at price band 6 | ✓ |
BANDAVAIL7 |
Nullable(Float64) |
Availability at price band 7 | ✓ |
BANDAVAIL8 |
Nullable(Float64) |
Availability at price band 8 | ✓ |
BANDAVAIL9 |
Nullable(Float64) |
Availability at price band 9 | ✓ |
BIDTYPE |
LowCardinality(String) |
The type of bid, one-of ENERGY, RAISE6SEC, RAISE60SEC, RAISE5MIN, RAISEREG, LOWER6SEC, LOWER60SEC, LOWER5MIN, LOWERREG | ✓ |
DIRECTION |
LowCardinality(String) |
The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL | ✓ |
DUID |
LowCardinality(String) |
Dispatchable Unit ID | ✓ |
ENABLEMENTMAX |
Nullable(Float64) |
Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only) | ✓ |
ENABLEMENTMIN |
Nullable(Float64) |
Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only) | ✓ |
ENERGYLIMIT |
Nullable(Float64) |
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 | ✓ |
FIXEDLOAD |
Nullable(Float64) |
Fixed unit output MW (Energy bids only) A null value means no fixed load so the unit is dispatched according to bid and market | ✓ |
HIGHBREAKPOINT |
Nullable(Float64) |
Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) | ✓ |
LOWBREAKPOINT |
Nullable(Float64) |
Minimum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) | ✓ |
MAXAVAIL |
Nullable(Float64) |
Maximum availability for this BidType in this period | ✓ |
OFFERDATETIME |
Nullable(DateTime64(3)) |
Time this bid was processed and loaded | ✓ |
PASAAVAILABILITY |
Nullable(Float64) |
Allows for future use for Energy bids, being the physical plant capability including any capability potentially available within 24 hours | ✓ |
PERIODID |
Nullable(Float64) |
Period ID 1 to 288 | ✓ |
PERIODIDTO |
Nullable(Float64) |
Period ID Ending | ✓ |
RAMPDOWNRATE |
Nullable(Float64) |
MW/Min for lower (Energy bids only) | ✓ |
RAMPUPRATE |
Nullable(Float64) |
MW/Min for raise (Energy bids only) | ✓ |
RECALL_PERIOD |
Nullable(Float64) |
The advance notice(in hours) that a Scheduled Resource requires to achieve the PASA Availability MW for this trading interval | ✓ |
TRADINGDATE |
Nullable(DateTime64(3)) |
The trading date this bid is for | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
ffcf1803 |
973,918,681 | 2.42 GiB |
Last updated: 2025-12-10 08:00:03