NIFTY 50 Stocks Historical Data
Historical data for different time intervals for all the stocks in NIFTY 50
@kaggle.gawdofdawgs_nifty_50_stocks_historical_data
Historical data for different time intervals for all the stocks in NIFTY 50
@kaggle.gawdofdawgs_nifty_50_stocks_historical_data
The data for the stocks in the NIFTY 50 index is from the NSE website.
Then for each ticker in the index, the data is downloaded for different time intervals using yfinance.
For the daily and greater time intervals like 5 days, 1 week, 1 month and 3 month, the historical data is for the maximum period possible.
For the 1 minute time interval, the historical data is for the maximum period that yfinance can provide us with.
The Dividends and Stock Splits columns are only present in the historical data for the daily time interval.
CREATE TABLE nifty_50_data (
"ticker" VARCHAR,
"open_inr" DOUBLE -- Open (INR),
"high_inr" DOUBLE -- High (INR),
"low_inr" DOUBLE -- Low (INR),
"prev_close_inr" DOUBLE -- Prev Close (INR),
"last_traded_price_inr" DOUBLE -- Last Traded Price (INR),
"change_inr" DOUBLE -- Change (INR),
"n__change" DOUBLE -- % Change,
"volume_shares" BIGINT -- Volume (Shares),
"value_billion_inr" DOUBLE -- Value (Billion INR),
"n_52w_high_inr" DOUBLE -- 52W High (INR),
"n_52w_low_inr" DOUBLE -- 52W Low (INR),
"n_30d_change" DOUBLE -- 30D % Change
);Anyone who has the link will be able to view this.