PJM Capacity Auction Results (RPM Base Residual Auction)
PJM's Base Residual Auction results workbook for each delivery year from 2020/2021: resource clearing prices by LDA with their system marginal price and locational adders, load capacity prices, RPM parameters, and capacity transfer rights, in $/MW-day and MW.
publisher period x document x sheet/archive member x source row x collected revision
Publisher snapshot cadence
Evidence
Mixed evidence
Multiple evidence types kept distinct in the contract
Time basis
Date-labelled records
UTC · report_date
Overview
Each row preserves a publisher record, workbook row, or report document with its source member and row index. Source timestamps, units, geographic scope, and revision qualifiers are retained in record_json; event_time is collection time; completed_at is when the entire document became available.
Query contract
The view admits a document only when its completion record and exact mirrored row count agree. Select a report_date, source_url and source_sha256 revision before joining source_member and row_index. Interpret observation times from the source record, never from the collection clock.
Analysis rules
Decode the report's source headers and units before aggregating. Never sum report_date, row_index, snapshots, revisions, regional totals and components, or forecast vintages.
Interpretation
report_date identifies the requested publisher period. It is not an observation timestamp. event_time records collection, not source publication or delivery.The serving mirror keeps the latest row for each publisher record; older collected revisions may no longer be queryable.
Access
Plans
See available download and API access options. View pricing
MCP
Connect an MCP client and load the contract with describe_data before calling query_data.PJM MCPAPI reference
HTTP endpoint
POST /api/v1/datasets/pjm_report_rpm_bra_results/query
Full history
Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
Cleared day-ahead locational marginal prices for each PJM pricing node by delivery hour, with total LMP and its system-energy, congestion, and marginal-loss components in dollars per MWh. The table supports the posted next-day hourly curve, day-ahead-to-real-time basis, and node-level component attribution. A congestion component does not by itself identify which facility is expected to bind or establish a node-to-constraint relationship. Source: PJM Market Data.
PJM day-ahead locational marginal prices, one row per interval and location. 1.00B rows, 2018-01 to the next delivery day. Carries price_usd_mwh plus energy_usd_mwh, congestion_usd_mwh and loss_usd_mwh. Locations are load, generator, aggregate, bus, interface, zone, hub; location_id joins atg.pjm_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.
Locational marginal prices from PJM's real-time energy market, published every five minutes for each pricing node (pnode) before settlement verification. Each row carries total LMP plus congestion and marginal-loss components in dollars per MWh. Components support node-level price decomposition, but price differences do not identify a named binding facility or prove topology. This is the freshest PJM price feed; use the settled hourly feed for the verified record published roughly 18 hours later. Point classes span transmission zones, trading hubs, external interfaces, and aggregate nodes. Source: PJM Market Data.
PJM's verified real-time locational marginal prices at hourly granularity for every pricing node, with total LMP and its system-energy, congestion, and marginal-loss components in dollars per MWh. These are the settled, authoritative real-time prices — published on roughly an 18-hour lag behind the operating hour — and history reaches back to 1998-04, making this the table for real-time price history, day-over-day basis, and volatility studies. For prices in the current hour use the unverified 5-minute feed instead. Source: PJM Market Data.
