I'd like some help with extracting tick data from a time series ....

I have S&P500 Index tick daily data on one minute intervals for the last 12 years. The file is an CSV file.

I'd like to extract the following fields :

Date, Opening price, Price 1 hour after the open, price 1.5 hours after the open, price 2 hours after the open, Closing Price.

Here is a sample of 4 of the minutes from 2007, time 5pm, 5:01pm, 5:02 pm, 5:03pm. I just need the next field with the index level.

I'm not sure if the Time Stamp is local time (Chicago or New York) so that will need to be cross-referenced. Also not sure if daylight-saving time is incorporated into the time stamp.

Thanks !