Monthly SWPW tie-flow archive

SPP's Monthly SWPW tie-flow archive.

Interchange data SPP market

Query with the agent

Native record

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

month publication 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_monthly/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

No preview available.

Coverage

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

Related interchange data

Related interchange data
Dataset	Description
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.
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.