Ask the Grid

Overview

CAISO OASIS 5-minute real-time interval shadow prices on nomogram constraints. A nomogram is a multi-element stability or transfer limit (a relationship across several branches or interfaces rather than a single line), so a binding nomogram shadow price flags where a security constraint — not just one overloaded line — is driving congestion cost. Useful for understanding structural transmission limits and stability-driven congestion in the CAISO footprint, complementing the single-branch and intertie shadow prices. History spans 2015 to present at ~99% daily coverage. The official source is CAISO OASIS.

Use with MCP

This table is available through the signed-in, read-only Ask the Grid MCP server. Connect a market below, then use search_data or describe_data to load its query contract before calling query_data.

Schema5

Column
Type
event_timeDateTime64(6, 'UTC')
nomogram_idLowCardinality(String)
prcNullable(Float64)
constraint_causeNullable(String)
ingested_atDateTime64(6, 'UTC')

Sample rows

event_timenomogram_idprcconstraint_causeingested_at
2026-08-15 06:25:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _138.90719Base Case2026-08-15 06:27:48.363370
2026-08-15 06:20:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _138.87431Base Case2026-08-15 06:27:48.363370
2026-08-15 06:15:00.0000007690-CONTRL-INYOKN_EXP_NG-15.5617Base Case2026-08-15 06:27:48.363370
2026-08-15 06:15:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _138.9211Base Case2026-08-15 06:27:48.363370
2026-08-15 06:15:00.0000007690-CONTRL-INYOKN_EXP_NG-15.5617Base Case2026-08-15 06:17:46.049021
2026-08-15 06:15:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _138.9211Base Case2026-08-15 06:17:46.049021
2026-08-15 06:10:00.0000007690-CONTRL-INYOKN_EXP_NG-75.48342Base Case2026-08-15 06:27:48.363370
2026-08-15 06:10:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _139.46213Base Case2026-08-15 06:27:48.363370
2026-08-15 06:10:00.0000007690-CONTRL-INYOKN_EXP_NG-75.48342Base Case2026-08-15 06:17:46.049021
2026-08-15 06:10:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _139.46213Base Case2026-08-15 06:17:46.049021
2026-08-15 06:05:00.0000007690-CONTRL-INYOKN_EXP_NG-349.44615Base Case2026-08-15 06:27:48.363370
2026-08-15 06:05:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _139.78248Base Case2026-08-15 06:27:48.363370
2026-08-15 06:05:00.0000007690-CONTRL-INYOKN_EXP_NG-349.44615Base Case2026-08-15 06:17:46.049021
2026-08-15 06:05:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _139.78248Base Case2026-08-15 06:17:46.049021
2026-08-15 06:00:00.0000007690-CONTRL-INYOKN_EXP_NG-306.78568Base Case2026-08-15 06:27:48.363370
2026-08-15 06:00:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _138.91084Base Case2026-08-15 06:27:48.363370
2026-08-15 06:00:00.0000007690-CONTRL-INYOKN_EXP_NG-306.78568Base Case2026-08-15 06:17:46.049021
2026-08-15 06:00:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _138.91084Base Case2026-08-15 06:17:46.049021
2026-08-15 05:55:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _137.99068Base Case2026-08-15 06:27:48.363370
2026-08-15 05:55:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _137.99068Base Case2026-08-15 06:17:46.049021
2026-08-15 05:50:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _138.18594Base Case2026-08-15 06:27:48.363370
2026-08-15 05:50:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _138.18594Base Case2026-08-15 06:17:46.049021
2026-08-15 05:45:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _138.15147Base Case2026-08-15 06:27:48.363370
2026-08-15 05:45:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _138.15147Base Case2026-08-15 06:17:46.049021
2026-08-15 05:40:00.00000035202_USWP-WKR_60.0_33777_SBTAP _60.0_BR_1 _138.45724Base Case2026-08-15 06:27:48.363370

Coverage

99.2% complete32 gap days4,213 days with data
Show coverage history ▾
Coverage: 99.2%Days with data: 4,213Gaps: 32
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
gaplessmore