pd7day__pricesolution__1
AEMO Description
PD7DAY price solution
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 407,380 |
| Combined Size | 4.22 MiB |
| MMS Table | pd7day_pricesolution |
| Unified View | nemwebviews.pd7day__pricesolution__1 |
Schema Evolution
| Column | Type | Description | 2dc2fead |
|---|---|---|---|
INTERVAL_DATETIME |
Nullable(DateTime64(3)) |
The unique identifier for the interval within this study | ✓ |
INTERVENTION |
Nullable(Float64) |
Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run. | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ |
LOWER1SECRRP |
Nullable(Float64) |
Regional Lower 1Sec Price - RegionSolution element L1Price attribute | ✓ |
LOWER5MINRRP |
Nullable(Float64) |
Region Reference Price (Lower5Min) | ✓ |
LOWER60SECRRP |
Nullable(Float64) |
Region Reference Price (Lower60Sec) | ✓ |
LOWER6SECRRP |
Nullable(Float64) |
Region Reference Price (Lower6Sec) | ✓ |
LOWERREGRRP |
Nullable(Float64) |
Region Reference Price (LowerReg) | ✓ |
RAISE1SECRRP |
Nullable(Float64) |
Regional Raise 1Sec Price - R1Price attribute after capping/flooring | ✓ |
RAISE5MINRRP |
Nullable(Float64) |
Region Reference Price (Raise5Min) | ✓ |
RAISE60SECRRP |
Nullable(Float64) |
Region Reference Price (Raise60Sec) | ✓ |
RAISE6SECRRP |
Nullable(Float64) |
Region Reference Price (Raise6Sec) | ✓ |
RAISEREGRRP |
Nullable(Float64) |
Region Reference Price (RaiseReg) | ✓ |
REGIONID |
LowCardinality(String) |
Region Identifier | ✓ |
RRP |
Nullable(Float64) |
Region Reference Price (Energy) | ✓ |
RUN_DATETIME |
Nullable(DateTime64(3)) |
Unique Timestamp Identifier for this study | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
2dc2fead |
407,380 | 4.22 MiB |
Last updated: 2025-12-10 08:00:07