financial-data icon indicating copy to clipboard operation
financial-data copied to clipboard

Time Zone of the data

Open mtlberri opened this issue 4 years ago • 4 comments

Hi, first of all, thanks for that repo, it is really a great thing.

I am using the S&P500 data, and I must confess I am a bit confused by the time zone and trading hours of the data. I just see a continuous flow of price 24h/24h. Which is strange as it trades only 9:30 am to 4 pm EST, and some pre-post hours trading. And since there is not the Volume traded in the data, I can hardly say when the trading day starts from the data.

What would help a lot would be to have an indication of which time zone is used for that data?

Thanks a lot for your help.

mtlberri avatar Apr 10 '20 04:04 mtlberri

I just see a continuous flow of price 24h/24h.

Hmm, you're right. I never noticed this. Perhaps it's a derivative of the S&P500 that trades 24/5?

In the end, the raw data files are just from Histdata. Their FAQ says the time zone is Eastern Standard Time (EST) time-zone WITHOUT Day Light Savings adjustments.

Data comes from here: https://www.histdata.com/download-free-forex-historical-data/?/ascii/1-minute-bar-quotes/SPXUSD

And according to the text it is SPX/USD = S&P 500 in USD.

If you have another data source for the real S&P 500 prices then feel free to open a PR to add them to this repo 🙂

FutureSharks avatar Apr 10 '20 10:04 FutureSharks

Thanks for the reply, and yes indeed that is what histdata mentions. I went and did a few checks for the data and I and I am confused by several things. For example, there is even data on Sundays such as 2018-04-01. I could not wrap my head around a few things on the data. And I wanted to compare it to a reference but I could not because sadly it is very hard to find SP500 intraday data.

Ok, no big deal, it was a small idea I wanted to check against data but I will give up.

Thanks for your reply anyway! Cheers

mtlberri avatar Apr 11 '20 02:04 mtlberri

it is very hard to find SP500 intraday data.

Yes I know. Please come back here to share if you find some 😃

FutureSharks avatar Apr 11 '20 08:04 FutureSharks

Will do!

mtlberri avatar Apr 12 '20 16:04 mtlberri