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)	SUPREMEIND	2014.6	2036.8	2038.95	2004.95	2016.25	117900	2376.6	15625	94402	80.06999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPREMEIND	2016.25	2030	2088.45	2000	2019.75	37439	760.61	6454	19482	52.040000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPREMEIND	2019.75	2030.4	2045.15	1970.05	1985.7	218271	4360.58	14746	183196	83.93000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPREMEIND	1985.7	1995.55	2048.9	1952	2030.7	184656	3666.49	19604	106141	57.47999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPREMEIND	2014.9	2026.9	2026.9	1965	1977.05	81050	1609.94	11644	45314	55.90999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPREMEIND	2030.7	2024.3	2024.3	1999.9	2014.9	56553	1138.2	8811	40192	71.06999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPREMEIND	2092.65	2103.7	2118.25	1998.6	2014.6	405647	8202.65	33513	297264	73.27999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPREMEIND	1153.3	1168.2	1175	1132.55	1139.95	10859	125.04	1178	5154	47.46
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPREMEIND	1139.95	1132.6	1147.65	1121.65	1142.8	8465	96.34	1388	4592	54.25
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPREMEIND	1142.8	1142.8	1163.5	1139.2	1151.35	13482	155.43	2548	7798	57.84


CREATE TABLE supremeind (
  "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
);