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

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

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

event_time	market_run	dc_tie_name	direction	mw	shadow_price	delivery_date	published_at	source_url	ingested_at
2026-10-20 04:00:00.000000	da_hourly	STEGALL	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 04:00:00.000000	da_hourly	STEGALL	EW	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 04:00:00.000000	da_hourly	MILES_CITY	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 04:00:00.000000	da_hourly	MILES_CITY	EW	197.476	-14.698	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 03:00:00.000000	da_hourly	STEGALL	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 03:00:00.000000	da_hourly	STEGALL	EW	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 03:00:00.000000	da_hourly	MILES_CITY	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 03:00:00.000000	da_hourly	MILES_CITY	EW	197.476	-12.952	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 02:00:00.000000	da_hourly	STEGALL	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 02:00:00.000000	da_hourly	STEGALL	EW	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 02:00:00.000000	da_hourly	MILES_CITY	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 02:00:00.000000	da_hourly	MILES_CITY	EW	197.476	-25.346	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 01:00:00.000000	da_hourly	STEGALL	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 01:00:00.000000	da_hourly	STEGALL	EW	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 01:00:00.000000	da_hourly	MILES_CITY	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 01:00:00.000000	da_hourly	MILES_CITY	EW	172.033	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 00:00:00.000000	da_hourly	STEGALL	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 00:00:00.000000	da_hourly	STEGALL	EW	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 00:00:00.000000	da_hourly	MILES_CITY	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-20 00:00:00.000000	da_hourly	MILES_CITY	EW	196.653	-12.074	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-19 23:00:00.000000	da_hourly	STEGALL	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-19 23:00:00.000000	da_hourly	STEGALL	EW	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-19 23:00:00.000000	da_hourly	MILES_CITY	WE	-123.181	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-19 23:00:00.000000	da_hourly	MILES_CITY	EW	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051
2026-10-19 22:00:00.000000	da_hourly	STEGALL	WE	0	0	20261019	∅	ftp://pubftp.spp.org/Markets/DA/DCTIE_FLOW/2026/10/DA-DC-TIEFLOW-20261019.csv	2026-10-19 15:55:41.223051

Coverage

100.0% complete0 gap days203 days with data

Show coverage history

Coverage: 100.0%Days with data: 203Gaps: 0

2026

gaplessmore

Related interchange data

Related interchange data
Dataset	Description
Monthly SWPW tie-flow archiveSPP · month publication	SPP's Monthly SWPW tie-flow archive. 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.
Rolling SWPW tie flowsSPP · Publisher snapshot	SPP's Rolling SWPW tie flows. 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.
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.