bids__bidofferperiod_sparse
AEMO Description
BIDOFFERPERIOD shows 5-minute period-based Energy and Ancill
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 2 |
| Combined Rows | 4,335,652,487 |
| Combined Size | 11.09 GiB |
| MMS Table | bidofferperiod |
| Unified View | nemwebviews.bids__bidofferperiod_sparse |
Schema Evolution
| Column | Type | Description | a616f52d | 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 |
|---|---|---|
a616f52d |
1,678,882,947 | 4.00 GiB |
ffcf1803 |
2,656,769,540 | 7.09 GiB |
Last updated: 2026-07-16 05:00:06