Published DC-Tie Flow and Shadow Price

SPP-published MW flow and constraint shadow price by DC-tie name and direction for the real-time balancing market and day-ahead market.

Interchange data SPP market

Query with the agent

Native record

event_time x market_run x dc_tie_name x direction

Daily publication (RTBM T+1 and Day-Ahead) publication cadence

Evidence

Observed market data

Published observations from the named source

Time basis

Point-in-time records

UTC · event_time

Overview

RTBM is a T+1 day archive, not a live five-minute stream; market_run distinguishes rt_5min from da_hourly. SHADOW PRICE is the marginal congestion cost of the flow constraint, not a settlement LMP. STEGALL and MILES_CITY each map to two physical settlement locations, so the source name is not a unique geographic join key.

Query contract

Preserve one canonical row per (event_time, market_run, dc_tie_name, direction) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time, market_run, dc_tie_name, direction.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

SPP MCP API reference

HTTP endpoint

POST /api/v1/datasets/spp_dc_tie_flow/query

Schema10

Column

Type

event_timeDateTime64(6, 'UTC')

market_runLowCardinality(String)

dc_tie_nameLowCardinality(String)

directionLowCardinality(String)

mwNullable(Float64)

shadow_priceNullable(Float64)

delivery_dateNullable(String)

published_atNullable(DateTime64(6, 'UTC'))

source_urlNullable(String)

ingested_atDateTime64(6, 'UTC')

Sample data

No preview available.

Coverage

No time-indexed data — coverage isn’t applicable to this dataset.

Related interchange data

Related interchange data
Dataset	Description
SPP East Actual and Scheduled InterchangeSPP · 1-minute source, polled every 5 minutes	Minute-resolution SPP East Net Actual Interchange (NAI), Net Scheduled Interchange (NSI), forward NSI, and source-published counterparty breakdown. Positive values are net imports. Forward NSI can also be populated on realized rows, so a live forward read must select the nearest event_time after the analysis cutoff rather than the last non-null value.
Actual InterchangeISONE · hourly	ISO-NE actual interchange by published external location, with signed interchange, purchase, and sale components. Preserve location and direction; do not sum a net value with its purchase and sale components.
Area Control ErrorPJM · sub-minute (~15-second source; polled every 5 minutes)	PJM area control error in MW at its native fast operating cadence. ACE is the signed instantaneous difference between scheduled and actual balancing obligation; it changes within seconds and should not be treated as a slowly varying reserve or energy quantity. Source: PJM Data Miner 2.
Ba Interchange HourlyISONE · ISO-NE source publication	ISO-NE's published Ba Interchange Hourly source feed. This catalog page exposes the physical schema, coverage, and latest source rows without inventing a normalized grain for publisher-shaped snapshot fields. Use the documented key and event time when comparing revisions or vintages.