Open jcsalterego opened 1 year ago
SPP historical LMP data is available in various compacted forms:
DAM LMP by Location
2013.zip
DA-LMP-MONTHLY-SL-202112.csv
DA-LMP-SL-202112010100.csv
RTM LMP by Location
RTBM-LMP-MONTHLY-SL-202201.csv
RTBM-LMP-DAILY-SL-20221201.csv
RTBM-LMP-SL-202212270015.csv
Daily compaction seems to lag by 5 days in both example data sets.
Based on the requested range of historical data, SPP::get_lmp will need to piece together the right list of files to fetch after fetching the candidate directories.
SPP::get_lmp
Related work: #105.
jcsalterego
commented
1 year ago
SPP historical LMP data is available in various compacted forms:
DAM LMP by Location
2013.ziphttps://marketplace.spp.org/pages/da-lmp-by-location#%2F2013DA-LMP-MONTHLY-SL-202112.csvhttps://marketplace.spp.org/pages/da-lmp-by-location#%2F2021%2F12DA-LMP-SL-202112010100.csvhttps://marketplace.spp.org/pages/da-lmp-by-location#%2F2021%2F12%2FBy_DayRTM LMP by Location
RTBM-LMP-MONTHLY-SL-202201.csvhttps://marketplace.spp.org/pages/da-lmp-by-location#%2F2021%2F12RTBM-LMP-DAILY-SL-20221201.csvhttps://marketplace.spp.org/pages/rtbm-lmp-by-location#%2F2022%2F12%2FBy_DayRTBM-LMP-SL-202212270015.csvhttps://marketplace.spp.org/pages/rtbm-lmp-by-location#%2F2022%2F12%2FBy_Interval%2F27Daily compaction seems to lag by 5 days in both example data sets.
Based on the requested range of historical data,
SPP::get_lmpwill need to piece together the right list of files to fetch after fetching the candidate directories.