Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Incomplete data while fetching minute level historical data #178

Open
ankush1729 opened this issue Dec 29, 2024 · 7 comments
Open

Incomplete data while fetching minute level historical data #178

ankush1729 opened this issue Dec 29, 2024 · 7 comments

Comments

@ankush1729
Copy link

Hi,

I was testing accessing the historical data using for 1, 5 and 30 minute interval. It seems to be missing the data for certain dates altogether, while the same is present in the 1day data fetch?

Has someone else noticed the same?

@Idirect-Tech
Copy link
Owner

Idirect-Tech commented Dec 30, 2024 via email

@ankush1729
Copy link
Author

ankush1729 commented Dec 31, 2024

This is how the complete data look like for a day when I am doing a pull for 30 minute interval. It'll have 14 rows.

image

There are few days when less than 14 records are present. example:

image

image

Additionally, below are the dates for which daily data is available, but not even a single record for minute level data is coming:

2024-01-03
2024-08-23
2024-01-20
2024-09-18
2023-11-12
2023-12-18
2024-05-18
2024-03-01
2024-09-16
2022-10-24
2024-02-16
2024-02-09
2024-03-12
2023-12-12
2024-07-04
2024-03-02
2021-11-04
2024-09-30
2024-10-01
2024-09-17

Above analysis was done on just 1 script 'ICICI BANK' for period between "2021-01-01T07:00:00.000Z" and "2024-12-17T07:00:00.000Z"

I also observed that some of the above dates are falling on Saturday, in this case no data should be available even in the daily pull.

@Idirect-Tech
Copy link
Owner

Idirect-Tech commented Dec 31, 2024 via email

@ankush1729
Copy link
Author

I've attached both 30minute and daily level pull payloads.

Thanks,
Ankush
30_min_data.json
daily_data.json

@Idirect-Tech
Copy link
Owner

Idirect-Tech commented Jan 3, 2025 via email

@Idirect-Tech
Copy link
Owner

Idirect-Tech commented Jan 3, 2025 via email

@ankush1729
Copy link
Author

Missing day issue remains with get_historical_data_v2() method too. Although the number of missing days are less but issue is still there.

These are the days that are missing entirely from daily data:

2022-06-14 Tuesday
2022-03-29 Tuesday
2021-04-23 Friday
2021-07-30 Friday
2024-12-17 Tuesday

And this particular day had only 6 record for the day for 30 minute pull, instead of 13 records.

image

Moreover, get_historical_data_v2() method has 2 other major problems.

  • It only returns 1000 rows at a time. The 1000 rows that are returned contain data starting from to_date to going back 1000 records. This makes data pull a little tricky, and sharing the payload tricky as well.
  • Daily level data returned by _v2 doesn't match to official exchange (NSE) data. This makes correctness of the whole data doubtful.

I can provide with the code that I've written for 3 year worth of 30_min interval data pull and daily data pull if required so that you can recreate the issue at your end.

You can give me your email ID and I can drop a mail if you need my contact details.

Thanks,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants