NSE Stock Data

Stock Prices with Volatilities for Two years

@kaggle.sunnysai12345_nse_stock_data

Table List

1 table(43.08 MB)

Complete Nse Data

@kaggle.sunnysai12345_nse_stock_data.complete_nse_data

43.08 MB
874050 rows
19 columns

unnamed_0 Unnamed: 0	symbol SYMBOL	series SERIES	date1 DATE1	prev_close PREV CLOSE	open_price OPEN PRICE	high_price HIGH PRICE	low_price LOW PRICE	last_price LAST PRICE	close_price CLOSE PRICE	avg_price AVG PRICE	n__ttl_trd_qnty TTL TRD QNTY	n__turnover_lacs TURNOVER LACS	n__no_of_trades NO OF TRADES	n__deliv_qty DELIV QTY	n__deliv_per DELIV PER	prev_day_volatility PREV DAY VOLATILITY	current_day_volatility CURRENT DAY VOLATILITY	annualised_volatility ANNUALISED VOLATILITY
	20MICRONS	EQ	16-Nov-17	49.1	49.25	50.8	49.25	50.1	49.9	50.16	125047	6272430.9	724	76773	61.4	0.0361	0.0352	0.6725
1	20MICRONS	EQ	17-Nov-17	49.9	50.5	51.2	49.2	49.45	49.55	50.03	103411	5174142.3	640	66143	63.96	0.0352	0.0342	0.6534
2	20MICRONS	EQ	20-Nov-17	49.55	49.55	51.6	49.45	50.6	50.85	50.82	165285	8399868.2	979	101726	61.55	0.0342	0.0338	0.6457
3	20MICRONS	EQ	21-Nov-17	50.85	51.2	54	51.2	52.5	52.2	52.8	474808	25071944.95	2506	280572	59.09	0.0338	0.0334	0.6381
4	20MICRONS	EQ	22-Nov-17	52.2	52.95	59.4	50.55	51.9	52.1	55.14	2699921	148882878.1	17244	722800	26.77	0.0334	0.0324	0.619
5	20MICRONS	EQ	23-Nov-17	52.1	51.95	54.7	50.1	52.3	52.05	52.47	632798	33202946.55	4753	183127	28.94	0.0324	0.0314	0.5999
6	20MICRONS	EQ	24-Nov-17	52.05	52.15	53.45	51.35	52	51.9	52.27	194310	10156060.85	1547	94962	48.87	0.0314	0.0305	0.5827
7	20MICRONS	EQ	27-Nov-17	51.9	52.25	54.2	51.65	52.7	52.8	53.21	305096	16232953.35	1961	127183	41.69	0.0305	0.0299	0.5712
8	20MICRONS	EQ	28-Nov-17	52.8	52.9	61.7	52.9	59.65	59.4	59.49	2489935	148126511.7	14196	918045	36.87	0.0299	0.0409	0.7814
9	20MICRONS	EQ	29-Nov-17	59.4	60.5	63.6	59	59.25	59.6	61.46	1002540	61616022.35	6219	439749	43.86	0.0409	0.0397	0.7585


CREATE TABLE complete_nse_data (
  "unnamed_0" BIGINT,
  "symbol" VARCHAR,
  "series" VARCHAR,
  "date1" VARCHAR,
  "prev_close" DOUBLE,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "last_price" VARCHAR,
  "close_price" DOUBLE,
  "avg_price" DOUBLE,
  "n__ttl_trd_qnty" BIGINT,
  "n__turnover_lacs" DOUBLE,
  "n__no_of_trades" BIGINT,
  "n__deliv_qty" VARCHAR,
  "n__deliv_per" VARCHAR,
  "prev_day_volatility" VARCHAR,
  "current_day_volatility" VARCHAR,
  "annualised_volatility" VARCHAR
);