Access Southwest Power Pool (SPP) Integrated Marketplace day-ahead and real-time LMP data via the SPP Marketplace portal data feeds

domain: marketplace.spp.org · 6 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. Navigate to https://marketplace.spp.org and access the Real-Time Market Data and Day-Ahead Market sections; SPP publishes LMP data as downloadable CSV files updated at regular intervals — no API key is required for public data access.
  2. For day-ahead LMPs, download the 'DA LMP By Location' report from the Day-Ahead Market section; the CSV contains columns for GMTIntervalEnd (UTC timestamp), settlement_location (pricing node), LMP (total), MLC (marginal loss component), MCC (marginal congestion component), and MEC (marginal energy component).
  3. For real-time LMPs, download the 'RT LMP By Location' report from the Real-Time Balancing Market section; data is published at 5-minute intervals for each operating interval, approximately 5 minutes before interval end.
  4. Construct a download URL by inspecting the network requests on the marketplace portal; SPP file URLs follow a consistent pattern with date and market type embedded in the path — automate downloads by constructing URLs for the desired date range and fetching each file.
  5. Parse the CSV response: SPP uses GMT timestamps (GMTIntervalEnd) — convert to local Prevailing Central Time for display but store and process in UTC; note that SPP's market operates in the Central timezone for operational purposes.
  6. For historical analysis, SPP retains several months of rolling data on the portal; longer historical archives may require a data request to SPP Market Operations — document the data retention period from the SPP market participation guide before committing to a historical backfill project.

Known gotchas

Related routes

Download SPP day-ahead and real-time LMP, load forecast, and market clearing price files from SPP's public data feeds
spp.org · 5 steps · unrated
Pull SPP (Southwest Power Pool) interconnection queue data and identify DER aggregation projects eligible under FERC Order 2222 and the SPP cluster study process
spp.org · 6 steps · unrated
Register for and consume SPP Integrated Marketplace data via the SPP Data API
spp.org · 5 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans