WEIM Area Real-Time Prices

CAISO's five-minute real-time prices at every location in atg.weim_locations, with the owning balancing area in ba.

One row per: WEIM area x location x 5-minute interval; 5-minute (RTD) cadence
Evidence: Observed market data; Published observations from the named source
Time basis: Interval-start records; UTC · event_time

Overview

The same price columns as every atg.<iso>_prices_rt: price_usd_mwh with its energy, congestion, loss and greenhouse-gas components. About 4.1M rows per 30 days across 24 priced areas, from 2016.

Query contract: One row per (event_time, ba, location_id) is already canonical; read it plainly.
Analysis rules: Filter ba to your scope's code with a direct WHERE; search_data returns the allowed value. One ba per query keeps a region's rows from mixing with another's.The area price is location_id = 'ELAP_<BA>-APND'. Prices are intensive: average them, never sum them.
Interpretation: These are CAISO WEIM real-time imbalance prices, not a bilateral or day-ahead price; the area runs no day-ahead market of its own.This table is a materialized MergeTree whose refresh has already collapsed source revisions. Do not add FINAL and do not re-apply argMax over ingested_at.

Access

Download: Query it in SQL, download it, or read it with an API key. Download data
MCP: Connect an MCP client and load the contract with describe_data before calling query_data.BPA MCP API reference
HTTP endpoint: POST /api/v1/datasets/weim_prices_rt/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

9 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`ba`	`LowCardinality(String)`
`location_id`	`LowCardinality(String)`
`kind`	`LowCardinality(String)`
`price_usd_mwh`	`Nullable(Float32)`
`energy_usd_mwh`	`Nullable(Float32)`
`congestion_usd_mwh`	`Nullable(Float32)`
`loss_usd_mwh`	`Nullable(Float32)`
`ghg_usd_mwh`	`Nullable(Float32)`

Sample data

event_time	ba	location_id	kind	price_usd_mwh	energy_usd_mwh
2026-11-03 16:25:00.000000	PSEI	PSEI_MINTFARM-APND	interface	52.73465	52.73465
2026-11-03 16:25:00.000000	PSEI	PSEI_MIDC_PSEI_PGE-APND	interface	0	0
2026-11-03 16:25:00.000000	PSEI	PSEI_MIDC_PSEI-APND	node	0	0
2026-11-03 16:25:00.000000	PSEI	PSEI_MIDCREMOTE-APND	interface	52.73465	52.73465
2026-11-03 16:25:00.000000	PSEI	PSEI_MIDC.AV-APND	interface	52.73465	52.73465
2026-11-03 16:25:00.000000	PNM	PNM_AMRAD115_EPE-APND	interface	41.9127	41.9127
2026-11-03 16:25:00.000000	PSEI	PSEI_MALIN-APND	node	0	0
2026-11-03 16:25:00.000000	PSEI	PSEI_KFALLSGEN-APND	interface	52.73465	52.73465
2026-11-03 16:25:00.000000	PSEI	PSEI_JOHNDAY-APND	interface	52.73465	52.73465
2026-11-03 16:25:00.000000	PSEI	PSEI_COBH-APND	interface	52.73465	52.73465
2026-11-03 16:25:00.000000	PSEI	PSEI_CAPTAINJACK-APND	interface	52.73465	52.73465
2026-11-03 16:25:00.000000	PSEI	PSEI_BPAT.PSEI-APND	interface	52.73465	52.73465
2026-11-03 16:25:00.000000	PSEI	PSEI_BCUS.BORDER-APND	interface	52.73465	52.73465
2026-11-03 16:25:00.000000	PSEI	PSEI_AVA.BPAT-APND	interface	52.73465	52.73465
2026-11-03 16:25:00.000000	PSEI	ELAP_PSEI-APND	aggregate	52.73465	52.73465
2026-11-03 16:25:00.000000	PSEI	PSEI_MALIN500-APND	interface	52.73465	52.73465
2026-11-03 16:25:00.000000	PNM	PNM_WM345_EPE-APND	interface	41.9127	41.9127
2026-11-03 16:25:00.000000	PNM	PNM_CORONAD500_PNM-APND	interface	41.9127	41.9127
2026-11-03 16:25:00.000000	PNM	PNM_FOURCORNE345_PNM-APND	interface	41.9127	41.9127
2026-11-03 16:25:00.000000	PNM	PNM_GREENLEE345-APND	interface	41.9127	41.9127
2026-11-03 16:25:00.000000	PNM	PNM_HIDALGO345_EPE-APND	interface	41.9127	41.9127
2026-11-03 16:25:00.000000	PNM	PNM_SPRINGER345_TEPC-APND	interface	41.9127	41.9127
2026-11-03 16:25:00.000000	PNM	PNM_LUNA345_EPE-APND	interface	41.9127	41.9127
2026-11-03 16:25:00.000000	PNM	PNM_LASCRCS115_EPE-APND	interface	41.9127	41.9127
2026-11-03 16:25:00.000000	PNM	PNM_SPRINGER345_PNM-APND	interface	41.9127	41.9127

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 3,960

Show coverage history

Coverage: 100.0%Days with data: 3,960Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

gaplessmore

Related data

Related prices data
Dataset	Description
CAISO Day-Ahead PricesCAISO · hourly (IFM)	CAISO day-ahead locational marginal prices, one row per interval and location. 1.21B rows, 2016-01 to the next delivery day. Carries price_usd_mwh only. The component columns exist in the raw CAISO day-ahead feed but are entirely NULL in it, so this table carries no decomposition rather than four empty columns. Locations are node (26k — including the TH_ trading hubs such as TH_SP15_GEN-APND; CAISO has no 'hub' kind), interface (the ties), zone (6 aggregates only); location_id joins atg.caiso_locations for the readable name, and kind is carried inline so a hub-only or zone-only question needs no join at all. Every market's day-ahead price table in this catalog has these same column names, so a cross-market price comparison is a UNION rather than a per-ISO rewrite. Revisions are already collapsed — read it plainly.
CAISO Real-Time PricesCAISO · 5-minute (RTD)	CAISO real-time locational marginal prices, one row per interval and location. 15.76B rows, 2016-01 to now. Carries price_usd_mwh plus energy_usd_mwh, congestion_usd_mwh, loss_usd_mwh and ghg_usd_mwh — CAISO is the only market here that publishes a greenhouse-gas component. Locations are node (26k — including the TH_ trading hubs such as TH_SP15_GEN-APND; CAISO has no 'hub' kind), interface (the ties), zone (6 aggregates only); location_id joins atg.caiso_locations for the readable name, and kind is carried inline so a hub-only or zone-only question needs no join at all. Every market's real-time price table in this catalog has these same column names, so a cross-market price comparison is a UNION rather than a per-ISO rewrite. Revisions are already collapsed — read it plainly.
Day-Ahead LMPCAISO · hourly (DAM)	Hourly locational marginal prices from CAISO's day-ahead market for pricing nodes across the California ISO footprint. These are cleared market outcomes for future delivery, not forecasts. Comparing the exact same delivery hour and pricing node with five-minute RTD prices shows day-ahead versus real-time divergence. The official source is CAISO OASIS.
Fuel Region Gas PricesCAISO · Daily (gas day)	CAISO's daily natural-gas price for each of its fuel regions, in $/MMBtu. CAISO posts this as FUEL REGION \| GAS INDEX \| TRANSPORT \| TOTAL, and the value here is that total: a published gas index plus a transport adder, i.e. the delivered cost of gas to that region, not a hub spot assessment. It is the number CAISO uses to reference and floor gas-fired energy bids, so it is the fuel-cost input underneath thermal offer behavior across the West. 201 fuel regions are currently active across 27 electric subregions, reaching well beyond California: Waha and El Paso Permian in West Texas, Opal, Kern River, Cheyenne, CIG and the San Juan points in the Rockies, Malin, Stanfield, Northwest Sumas and Kingsgate in the Pacific Northwest, Alberta AECO in Canada, and the SoCal Citygate and PG&E Citygate burner-tip regions in California. Receipt-point regions such as Waha (FRWHA1-3), El Paso Permian (FREPP1-4), Opal, Malin and Sumas track the underlying published index closely, because their transport adder is small; citygate regions are burner-tip costs and spread widely, so they are not interchangeable with a hub price — on 2026-08-20 the 40 region ids named SoCal Citygate ranged from 4.43 to 8.15 $/MMBtu on the same day. Region ids ending in GHG carry a California carbon-allowance adder on top and are a different quantity again. Negative prices are real and are concentrated in the takeaway-constrained Permian regions: 0.97% of rows are below zero, to a minimum of -10.51 $/MMBtu. Rows are stamped hourly, 24 per region per gas day, but the price is constant across a gas day, and the gas day is the America/Los_Angeles calendar date — it steps at Pacific midnight, so daily rollups must use toDate(event_time, 'America/Los_Angeles'). The current gas day is partial until the next 14:30 UTC pull, though its price is already complete. History runs from 2015-02-01 and is continuous and complete from 2026-02-01 onward; before that date it covers 1,972 of 4,018 days in whole-month blocks (February through April, June, September and November of each year), so a pre-2026 average over an arbitrary window is an average over the months that are present, not over the period requested. Hub attribution is INFERRED from CAISO's region coding, not published: CAISO's monthly fuel-region posting lists region ids with their index, transport and total and no hub names at all, and FRWHA does not appear in it — so 'Waha' here reads the id, corroborated by the price sitting where Waha sits against Henry Hub, rather than by a CAISO mapping. Treat a region as the delivered cost CAISO assigns to it; do not cite it as a hub assessment. This dataset is FUEL-COST CONTEXT, not market settlement data, and is queryable from every active grid scope: a question asked under ERCOT about West Texas gas cost answers from the Waha-region ids here, said as delivered fuel cost. The official source is CAISO OASIS report PRC_FUEL.