US Power Price Forecasts

Hourly CAISO real-time price actuals and price forecasts for NP15, SP15, and ZP26 trading hubs, benchmarked against CAISO's own day-ahead price.

Hourly CAISO real-time (RTM) electricity price actuals and price forecasts for the three CAISO trading hubs, benchmarked against CAISO’s own day-ahead (DAM) price — the standard baseline for this market. Available as a data product on the Snowflake Marketplace.

3 / 3hubs beat day-ahead price
-16%hourly WMAPE vs day-ahead
-31% to -46%weekly-average MAE vs day-ahead
Hourlyactuals refresh, 90-day rolling window

Coverage

NP15 SP15 ZP26

CAISO’s three trading hubs — Northern California, Southern California, and Central California (Zone 26) — the aggregated pricing points used for financial and physical power trading, not individual grid nodes.

Tables

US_POWER_PRICE_ACTUALS

Hourly actual real-time price per hub, rolling 90-day window.

ColumnTypeDescription
hubVARCHARCAISO trading hub code
hub_nameVARCHARFull hub name
utc_timeTIMESTAMP_NTZHour start, UTC
local_timeTIMESTAMP_NTZHour start, hub local time
rtm_price_mwhFLOATActual real-time hourly-average price ($/MWh)
dam_price_mwhFLOATCAISO day-ahead price ($/MWh), for benchmarking

US_POWER_PRICE_FORECASTS

Price forecast per hub, rolling 90-day window.

ColumnTypeDescription
hubVARCHARCAISO trading hub code
hub_nameVARCHARFull hub name
target_utc_timeTIMESTAMP_NTZHour being forecast, UTC
target_local_timeTIMESTAMP_NTZHour being forecast, hub local time
prediction_run_atTIMESTAMP_NTZWhen the forecast was issued
horizon_hoursFLOATLead time from issuance to target hour
aclastic_forecast_price_mwhFLOATAclastic’s real-time price forecast
dam_price_mwhFLOATCAISO day-ahead price, for benchmarking

Accuracy (365-day backtest, hourly WMAPE)

HubAclasticDay-aheadMargin
NP1519.9%23.0%+3.1pp
ZP2620.5%23.1%+2.6pp
SP1522.8%26.1%+3.3pp

On the Kalshi-relevant weekly-average metric, Aclastic reduces MAE by 31-46% versus the day-ahead price across all three hubs (e.g. NP15: $1.81/MWh vs $3.07/MWh).

Example queries

Latest actual price for a hub

SELECT hub_name, utc_time, local_time, rtm_price_mwh
FROM us_power_price_actuals
WHERE hub = 'NP15'
ORDER BY utc_time DESC
LIMIT 24;

Aclastic’s next-24h price forecast vs day-ahead

SELECT hub_name, target_local_time, aclastic_forecast_price_mwh, dam_price_mwh
FROM us_power_price_forecasts
WHERE hub = 'SP15'
  AND target_utc_time > CURRENT_TIMESTAMP()
ORDER BY target_utc_time
LIMIT 24;

Accuracy comparison by hub, last 30 days

SELECT
    f.hub,
    AVG(ABS(f.aclastic_forecast_price_mwh - a.rtm_price_mwh) / NULLIF(a.rtm_price_mwh, 0)) * 100 AS aclastic_mape,
    AVG(ABS(f.dam_price_mwh                - a.rtm_price_mwh) / NULLIF(a.rtm_price_mwh, 0)) * 100 AS dam_mape
FROM us_power_price_forecasts f
JOIN us_power_price_actuals a
  ON f.hub             = a.hub
 AND f.target_utc_time = a.utc_time
WHERE f.target_utc_time >= DATEADD(day, -30, CURRENT_TIMESTAMP())
  AND a.rtm_price_mwh <> 0
GROUP BY f.hub
ORDER BY aclastic_mape;

Weekly average price by hub

SELECT hub, DATE_TRUNC('week', utc_time) AS week, AVG(rtm_price_mwh) AS avg_price_mwh
FROM us_power_price_actuals
GROUP BY hub, week
ORDER BY week DESC, hub;

Update cadence

Actuals refresh every 4 hours from CAISO’s public OASIS feed, rolling 90-day window maintained.

Questions

Contact sales@aclastic.ai.