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.
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.
| Column | Type | Description |
|---|---|---|
| hub | VARCHAR | CAISO trading hub code |
| hub_name | VARCHAR | Full hub name |
| utc_time | TIMESTAMP_NTZ | Hour start, UTC |
| local_time | TIMESTAMP_NTZ | Hour start, hub local time |
| rtm_price_mwh | FLOAT | Actual real-time hourly-average price ($/MWh) |
| dam_price_mwh | FLOAT | CAISO day-ahead price ($/MWh), for benchmarking |
US_POWER_PRICE_FORECASTS
Price forecast per hub, rolling 90-day window.
| Column | Type | Description |
|---|---|---|
| hub | VARCHAR | CAISO trading hub code |
| hub_name | VARCHAR | Full hub name |
| target_utc_time | TIMESTAMP_NTZ | Hour being forecast, UTC |
| target_local_time | TIMESTAMP_NTZ | Hour being forecast, hub local time |
| prediction_run_at | TIMESTAMP_NTZ | When the forecast was issued |
| horizon_hours | FLOAT | Lead time from issuance to target hour |
| aclastic_forecast_price_mwh | FLOAT | Aclastic’s real-time price forecast |
| dam_price_mwh | FLOAT | CAISO day-ahead price, for benchmarking |
Accuracy (365-day backtest, hourly WMAPE)
| Hub | Aclastic | Day-ahead | Margin |
|---|---|---|---|
NP15 | 19.9% | 23.0% | +3.1pp |
ZP26 | 20.5% | 23.1% | +2.6pp |
SP15 | 22.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.