Database Schema

calculated

contingency

contingency

Table contingency in database calculated.

AEMO Description

Table Information

Property	Value
Database	`calculated`
Table	`contingency`
Engine	`ReplacingMergeTree`
Total Rows	373,983
Size	11.28 MiB
Unified View	Not available

Schema

Column	Type	Description
`contingency_date`	`Date`
`SETTLEMENTDATE`	`DateTime`
`DUID`	`LowCardinality(String)`
`market_percentage`	`Float64`
`lower5min_revenue`	`Float64`
`lower6sec_revenue`	`Float64`
`lower60sec_revenue`	`Float64`
`lowerreg_revenue`	`Float64`
`raise5min_revenue`	`Float64`
`raise6sec_revenue`	`Float64`
`raise60sec_revenue`	`Float64`
`raisereg_revenue`	`Float64`
`measured_mw`	`Float64`
`system_total_mw`	`Float64`
`LOWER5MINVOLUME`	`Float64`
`LOWER6SECVOLUME`	`Float64`
`LOWER60SECVOLUME`	`Float64`
`LOWERREGVOLUME`	`Float64`
`RAISE5MINVOLUME`	`Float64`
`RAISE6SECVOLUME`	`Float64`
`RAISE60SECVOLUME`	`Float64`
`RAISEREGVOLUME`	`Float64`
`calculated_time`	`DateTime`

Query Example

SELECT *
FROM calculated.contingency
LIMIT 10;

Last updated: 2026-01-02 16:00:04

constrained contribution_factor