Access the NYISO MIS public data at http://mis.nyiso.com/public/; NYISO publishes market data as ZIP-compressed CSV files organized by report type and date — no registration or API key is required for public access.
Construct the download URL for zonal day-ahead LBMPs: the base path follows the pattern http://mis.nyiso.com/public/P-24DAMLBMP{date}csv.zip where {date} is formatted as YYYYMMDD — for real-time LBMPs, the report prefix is P-2AHourl (hourly) or P-5RTLBMP (5-minute).
Download and decompress the ZIP file; the CSV inside contains columns including Name (zone or node), PTID (pricing node ID), Timestamp (Eastern Prevailing Time), and LBMP (total price in $/MWh), with separate rows for energy, congestion, and loss components in some report variants.
Map NYISO zone names to PTID values using the NYISO Load Zone and PTID reference table available on the NYISO website; there are 11 load zones (A through K) plus the NYC metro zone — note that PTID values are used for nodal (generator) prices, not load zone prices.
Handle Eastern Prevailing Time (EPT): NYISO timestamps are in local time and switch between EST (UTC-5) and EDT (UTC-4) at DST boundaries; on the spring-forward day there are 23 hours and on the fall-back day 25 hours — adjust interval count validation accordingly and convert to UTC for storage.
For automated daily ingestion, schedule downloads after NYISO publishes the previous day's data (typically by early morning EPT); implement a retry for cases where the file is not yet available and log the retrieval timestamp alongside the data for audit trails.
Known gotchas
NYISO publishes separate report files for load zones (aggregated) and generator buses (nodal); the zonal LBMP files cover the 11 standard load zones while the nodal files contain thousands of pricing points — do not substitute one for the other in settlement or dispatch calculations.
NYISO real-time 5-minute LBMP data (P-5RTLBMP) is the most granular available and is published approximately 10 minutes after each interval; the hourly real-time LBMP (P-2AHourl) is a derived hourly average and should not be used for sub-hourly analysis.
NYISO data files are published on mis.nyiso.com using HTTP (not HTTPS) for legacy reasons; if your data pipeline enforces HTTPS-only, you will need to either use a proxy or verify whether NYISO has published an HTTPS equivalent — do not downgrade your pipeline's TLS enforcement without understanding the security implications.
Give your agent this knowledge — and 200+ more routes
One MCP install gives any agent live access to the full route map, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp