I've been trying to calculate returns for different stocks but using Yahoo Fiance Historical price data seems to be weird. For instance, looking up the March 5th 2012 Price for APPL on the online interface gives:
Open High Low Close Adj Close 77.92 78.21 75.14 533.16 76.17
This in itself doesn't make sense, why is the close so much higher than the high/low?
To add to my confusion if I download the csv it gives different numbers entirely (except for the close):
Open High Low Close Adj Close 545.42 547.48 526.00 533.16 69.08
Am I doing something wrong and if not where can I get somewhat accurate financial data?