Rolling SWPW tie flows

SPP's Rolling SWPW tie flows.

Interchange data SPP market

Query with the agent

Native record

publisher period x document x sheet/archive member x source row x collected revision

Publisher snapshot publication 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

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_report_swpw_interchange/query

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

Schema11

Column

Type

event_timeDateTime64(6, 'UTC')

datasetLowCardinality(String)

report_dateDate32

source_urlString

source_memberString

source_sha256String

row_indexInt64

record_jsonString

response_metadataString

ingested_atDateTime64(6, 'UTC')

completed_atDateTime64(6, 'UTC')

Sample data

event_time	dataset	report_date	source_url	source_member	source_sha256	row_index	record_json	response_metadata	ingested_at	completed_at
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	952	["2026-10-10T20:11:00Z", "-335.000000", "-370.070000", "234.290000", "-73.900000", "313.880000", "-410.230000", "-117.470000", "-520.020000", "322.380000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	951	["2026-10-10T20:10:00Z", "-331.000000", "-363.540000", "228.800000", "-73.600000", "307.830000", "-396.880000", "-106.920000", "-528.040000", "320.270000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	950	["2026-10-10T20:09:00Z", "-333.730000", "-367.130000", "231.790000", "-70.900000", "303.320000", "-372.660000", "-107.510000", "-559.460000", "318.300000", "-256.500000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	949	["2026-10-10T20:08:00Z", "-336.730000", "-385.990000", "226.790000", "-75.700000", "301.000000", "-387.700000", "-116.180000", "-545.790000", "316.590000", "-256.500000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	948	["2026-10-10T20:07:00Z", "-339.830000", "-372.380000", "220.690000", "-83.400000", "297.940000", "-401.670000", "-123.070000", "-495.090000", "312.320000", "-256.500000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	947	["2026-10-10T20:06:00Z", "-342.730000", "-366.490000", "214.400000", "-80.700000", "290.610000", "-426.190000", "-119.950000", "-461.390000", "311.730000", "-256.500000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	946	["2026-10-10T20:05:00Z", "-344.730000", "-343.610000", "220.190000", "-71.500000", "284.480000", "-412.960000", "-116.130000", "-472.610000", "313.930000", "-256.500000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	959	["2026-10-10T20:18:00Z", "-353.000000", "-328.590000", "258.700000", "-60.300000", "328.290000", "-307.170000", "-151.610000", "-567.690000", "308.190000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	958	["2026-10-10T20:17:00Z", "-353.000000", "-312.480000", "261.000000", "-65.600000", "333.930000", "-338.280000", "-158.480000", "-520.760000", "312.700000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	957	["2026-10-10T20:16:00Z", "-353.000000", "-338.790000", "253.500000", "-69.900000", "333.300000", "-361.910000", "-160.130000", "-507.130000", "310.480000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	956	["2026-10-10T20:15:00Z", "-353.000000", "-367.880000", "244.790000", "-74.300000", "330.960000", "-379.420000", "-142.200000", "-525.190000", "314.470000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	955	["2026-10-10T20:14:00Z", "-349.000000", "-374.910000", "241.700000", "-72.200000", "328.400000", "-378.040000", "-126.510000", "-554.220000", "318.950000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	954	["2026-10-10T20:13:00Z", "-344.000000", "-375.030000", "237.690000", "-73.000000", "329.840000", "-377.120000", "-120.570000", "-561.130000", "317.260000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	953	["2026-10-10T20:12:00Z", "-341.000000", "-377.850000", "242.310000", "-71.300000", "318.110000", "-379.060000", "-124.830000", "-557.740000", "319.670000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	966	["2026-10-10T20:25:00Z", "-377.000000", "-372.550000", "231.790000", "-51.000000", "343.540000", "-271.670000", "-134.520000", "-623.100000", "293.400000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	965	["2026-10-10T20:24:00Z", "-375.000000", "-386.850000", "252.400000", "-45.800000", "350.460000", "-260.400000", "-131.060000", "-695.670000", "302.220000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	964	["2026-10-10T20:23:00Z", "-370.000000", "-378.530000", "253.890000", "-49.100000", "340.640000", "-266.610000", "-134.910000", "-669.580000", "301.150000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	963	["2026-10-10T20:22:00Z", "-365.000000", "-394.610000", "247.300000", "-54.200000", "336.080000", "-291.690000", "-147.130000", "-636.190000", "300.230000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	962	["2026-10-10T20:21:00Z", "-360.000000", "-387.800000", "239.600000", "-60.700000", "328.990000", "-316.960000", "-144.970000", "-590.600000", "300.840000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	961	["2026-10-10T20:20:00Z", "-355.000000", "-355.780000", "242.110000", "-65.900000", "324.560000", "-330.580000", "-147.850000", "-541.500000", "302.390000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	960	["2026-10-10T20:19:00Z", "-354.000000", "-348.680000", "250.800000", "-68.200000", "328.900000", "-341.950000", "-151.330000", "-533.800000", "304.900000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	991	["2026-10-10T20:50:00Z", "-413.000000", "-389.560000", "259.910000", "-37.500000", "367.250000", "-260.350000", "-115.010000", "-716.630000", "309.770000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	972	["2026-10-10T20:31:00Z", "-393.000000", "-373.100000", "218.310000", "-66.400000", "347.730000", "-329.010000", "-144.720000", "-512.880000", "290.890000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	973	["2026-10-10T20:32:00Z", "-398.000000", "-375.250000", "221.600000", "-66.600000", "354.230000", "-314.450000", "-127.470000", "-556.340000", "295.780000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109
2026-10-11 04:20:16.229730	swpw_interchange	2026-10-10	ftp://pubftp.spp.org/Operational_Data/TIE_FLOW/TieFlows_SWPW.csv	TieFlows_SWPW.csv	a815bf43ad8283532dde5f53be0f39eb3e29ed00fb43b5e729ec0e4836aaf65d	983	["2026-10-10T20:42:00Z", "-413.000000", "-397.670000", "228.890000", "-61.900000", "364.320000", "-300.230000", "-103.030000", "-630.090000", "301.380000", "-216.000000"]	{}	2026-10-11 04:20:16.356266	2026-10-11 04:20:17.099109

Coverage

100.0% complete0 gap days1 days with data

Show coverage history

Coverage: 100.0%Days with data: 1Gaps: 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.
Published DC-Tie Flow and Shadow PriceSPP · Daily publication (RTBM T+1 and Day-Ahead)	SPP-published MW flow and constraint shadow price by DC-tie name and direction for the real-time balancing market and day-ahead market. 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.
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.