bid
bidperoffer_d

bid__bidperoffer_d

AEMO Description

BIDPEROFFER_D shows the public summary of the energy and FCA

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 2
Combined Rows 385,471,778
Combined Size 1.87 GiB
MMS Table bidperoffer_d
Unified View nemwebviews.bid__bidperoffer_d

Schema Evolution

Column Type Description 1314781e f5348350
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 ✓ ✓
BIDSETTLEMENTDATE Nullable(DateTime64(3)) Market date for which the bid was submitted ✓ ✓
BIDTYPE LowCardinality(String) Bid Type Identifier ✓ ✓
DIRECTION LowCardinality(String) The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL ✓ ✓
DUID LowCardinality(String) Dispatchable Unit identifier ✓ ✓
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 value of zero means no fixed load so the unit is dispatched according to bid and market (rather than zero fixed load) ✓ ✓
HIGHBREAKPOINT Nullable(Float64) Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) ✓ ✓
INTERVAL_DATETIME Nullable(DateTime64(3)) Date and Time of the dispatch interval to which the offer applied ✓ ✓
LASTCHANGED Nullable(DateTime64(3)) Last date and time record changed ✓ ✓
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 ✓ ✓
OFFERDATE Nullable(DateTime64(3)) Offer date and time ✓ ✓
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) The trading interval period identifier (1-288) ✓ ✓
RECALL_PERIOD Nullable(Float64) - ✓
ROCDOWN Nullable(Float64) MW/Min for lower (Energy Bids Only) ✓ ✓
ROCUP Nullable(Float64) MW/min for raise (Energy Bids Only) ✓ ✓
SETTLEMENTDATE Nullable(DateTime64(3)) Market date for which the bid applied ✓ ✓
VERSIONNO Nullable(Float64) Version number of offer ✓ ✓
processed_at DateTime64(3) ✓ ✓
source_zip String ✓ ✓

Schema Versions

Version Rows Size
1314781e 176,317,442 787.88 MiB
f5348350 209,154,336 1.10 GiB

Last updated: 2026-07-16 05:00:06