Power pricing texas -- 2
Budget: $1,500 – $3,000 USD
Download 5 minute price files. Each file has the same following convention by column. Each file has ~15,000 rows (15,000 different electrical bus names). You can download the files via API (with documentation on how to do it attached)
SCEDTimestamp RepeatedHourFlag ElectricalBus LMP
Each day will have 720 (every 5 min) files each with the same column structure.
I need you to pull down the last 365 days of files So that’s 262,000 files each with 15,000 rows in each file
The data then needs to be organized into a database with the following column structure:
Hour of day (1-24)
Month of Year (1-12)
Electrical Bus name
LMP (average of the 12, 5 min intervals)
Then the entire data base by ElectricalBus needs to be ranked from highest average LMP in hours 13-15
Then the entire data base by ElectricalBus needs to be ranked from lowest average LMP in hours 2-5
I dont mind paying for a database license since this is going to go beyond the capabilities of excel.
please see attached file for sample file data and API documentation
SCEDTimestamp RepeatedHourFlag ElectricalBus LMP
Each day will have 720 (every 5 min) files each with the same column structure.
I need you to pull down the last 365 days of files So that’s 262,000 files each with 15,000 rows in each file
The data then needs to be organized into a database with the following column structure:
Hour of day (1-24)
Month of Year (1-12)
Electrical Bus name
LMP (average of the 12, 5 min intervals)
Then the entire data base by ElectricalBus needs to be ranked from highest average LMP in hours 13-15
Then the entire data base by ElectricalBus needs to be ranked from lowest average LMP in hours 2-5
I dont mind paying for a database license since this is going to go beyond the capabilities of excel.
please see attached file for sample file data and API documentation