Data Catalog
Overview
ERCOT's hourly day-ahead system lambda, the system-wide marginal energy component in the cleared Day-Ahead Market. For the same delivery hour and settlement point, day-ahead SPP minus DAM system lambda is the point's cleared day-ahead congestion component. Paired with SCED system lambda and real-time LMP, it supports day-ahead-versus-real-time congestion basis by point. It does not identify a binding constraint's effect on a point without direct attribution evidence.
Schema6
Column
Type
event_timeDateTime64(6, 'UTC')system_lambdaNullable(Float64)dst_flagNullable(Bool)emil_idNullable(String)doc_idNullable(Int64)ingested_atDateTime64(6, 'UTC')Sample rows
| event_time | system_lambda | dst_flag | emil_id | doc_id | ingested_at |
|---|---|---|---|---|---|
| 2026-07-16 05:00:00.000000 | 29.2112 | false | ∅ | ∅ | 2026-07-15 18:16:18.397136 |
| 2026-07-16 05:00:00.000000 | 29.2112 | false | ∅ | ∅ | 2026-07-15 17:17:05.447141 |
| 2026-07-16 05:00:00.000000 | 29.2112 | false | ∅ | ∅ | 2026-07-15 16:17:25.538484 |
| 2026-07-16 04:00:00.000000 | 29.6844 | false | ∅ | ∅ | 2026-07-15 18:16:18.397136 |
| 2026-07-16 04:00:00.000000 | 29.6844 | false | ∅ | ∅ | 2026-07-15 17:17:05.447141 |
| 2026-07-16 04:00:00.000000 | 29.6844 | false | ∅ | ∅ | 2026-07-15 16:17:25.538484 |
| 2026-07-16 03:00:00.000000 | 30.337 | false | ∅ | ∅ | 2026-07-15 18:16:18.397136 |
| 2026-07-16 03:00:00.000000 | 30.337 | false | ∅ | ∅ | 2026-07-15 17:17:05.447141 |
| 2026-07-16 03:00:00.000000 | 30.337 | false | ∅ | ∅ | 2026-07-15 16:17:25.538484 |
| 2026-07-16 02:00:00.000000 | 32.7237 | false | ∅ | ∅ | 2026-07-15 18:16:18.397136 |
| 2026-07-16 02:00:00.000000 | 32.7237 | false | ∅ | ∅ | 2026-07-15 17:17:05.447141 |
| 2026-07-16 02:00:00.000000 | 32.7237 | false | ∅ | ∅ | 2026-07-15 16:17:25.538484 |
| 2026-07-16 01:00:00.000000 | 29.4467 | false | ∅ | ∅ | 2026-07-15 18:16:18.397136 |
| 2026-07-16 01:00:00.000000 | 29.4467 | false | ∅ | ∅ | 2026-07-15 17:17:05.447141 |
| 2026-07-16 01:00:00.000000 | 29.4467 | false | ∅ | ∅ | 2026-07-15 16:17:25.538484 |
| 2026-07-16 00:00:00.000000 | 24.4994 | false | ∅ | ∅ | 2026-07-15 18:16:18.397136 |
| 2026-07-16 00:00:00.000000 | 24.4994 | false | ∅ | ∅ | 2026-07-15 17:17:05.447141 |
| 2026-07-16 00:00:00.000000 | 24.4994 | false | ∅ | ∅ | 2026-07-15 16:17:25.538484 |
| 2026-07-15 23:00:00.000000 | 23.8958 | false | ∅ | ∅ | 2026-07-15 18:16:18.397136 |
| 2026-07-15 23:00:00.000000 | 23.8958 | false | ∅ | ∅ | 2026-07-15 17:17:05.447141 |
| 2026-07-15 23:00:00.000000 | 23.8958 | false | ∅ | ∅ | 2026-07-15 16:17:25.538484 |
| 2026-07-15 22:00:00.000000 | 24.1906 | false | ∅ | ∅ | 2026-07-15 18:16:18.397136 |
| 2026-07-15 22:00:00.000000 | 24.1906 | false | ∅ | ∅ | 2026-07-15 17:17:05.447141 |
| 2026-07-15 22:00:00.000000 | 24.1906 | false | ∅ | ∅ | 2026-07-15 16:17:25.538484 |
| 2026-07-15 21:00:00.000000 | 24.4433 | false | ∅ | ∅ | 2026-07-15 18:16:18.397136 |
Coverage
100.0% complete0 gap days3,483 days with data
Show coverage history ▾
Coverage: 100.0%Days with data: 3,483Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
gaplessmore