Daily Indian Stock Price Dataset
This Dataset contains daily stock prices of some stocks in the Indian market
@kaggle.pathikghugare_daily_indian_stock_price_dataset
This Dataset contains daily stock prices of some stocks in the Indian market
@kaggle.pathikghugare_daily_indian_stock_price_dataset
The successful prediction of a stock's future price could yield significant profit.
Stock market prediction aims to determine the future movement of the stock value of a financial exchange. The accurate prediction of share price movement will lead to more profit investors can make. So in order to do analysis and predictions we need data .
The data is obtained from the API .
The Dataset contains a daily timeseries data of 10 different Indian companies listed in BSE .
Each company dataset contains the information in the period of Jan-2005 to July-2021 (except for OIL , it ranges from 2009-09-30 to 2021-07-30)
Every company file has the same structure with the same columns:
date: It is the date on which the prices were recorded.
close: Is the last price at which a stock trades during a regular trading session.
open: Is the price at which a stock started trading when the opening bell rang.
high: Is the highest price at which a stock traded during the course of the trading day.
low: Is the lowest price at which a stock traded during the course of the trading day.
volume: Is the number of shares or contracts traded in an asset during the course of the trading day
dividend_amount: Is the dividend amount given by the company at that day
I would like to thanks Alpha Vantage for providing an API for free to gather this data .
CREATE TABLE axisbank_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);CREATE TABLE cipla_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);CREATE TABLE infy_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);CREATE TABLE ioc_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);CREATE TABLE itc_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);CREATE TABLE oil_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);CREATE TABLE ongc_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);CREATE TABLE reliance_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);CREATE TABLE sbin_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);CREATE TABLE sunpharma_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);CREATE TABLE tatachem_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);CREATE TABLE tcs_bse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividend_amount" DOUBLE
);Anyone who has the link will be able to view this.