NIFTY ALL STOCK Dataset

date Date	symbol Symbol	pre_close Pre Close	open Open	high High	low Low	close Close	volume Volume	turnover_lacs Turnover Lacs	no_of_trades No Of Trades	deliv_volume Deliv Volume	deliv Deliv %
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRESTIGE	491.15	492.5	493.8	467.3	469.95	589399	2819.33	22534	253875	43.06999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRESTIGE	469.95	467	473.85	453.35	458.25	683285	3166.53	15271	407123	59.58000183105469
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRESTIGE	458.25	458	466.65	455.5	459.55	490462	2264.5	12474	226409	46.15999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRESTIGE	459.55	463	465.85	458	463.2	252056	1163.77	18245	117055	46.43999862670898
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRESTIGE	460.95	457	462.95	450	454.1	496072	2275.51	12257	348507	70.25
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRESTIGE	463.2	464.95	467.5	455.05	460.95	406057	1875.62	15056	181951	44.810001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRESTIGE	491.7	493.8	498	483.55	491.15	391341	1920.07	11928	104346	26.65999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRESTIGE	338.35	338.6	339.55	330.8	333.3	98627	329.46	3537	35711	36.21
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRESTIGE	333.3	333.3	335.6	326.35	329.75	120094	398.91	2743	56557	47.09
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRESTIGE	329.75	329.3	339.35	325	331	265572	882.52	10060	65895	24.81


CREATE TABLE prestige (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE
);