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)	SIS	527.3	527.9	538	520	525.3	244941	1294.18	19309	120560	49.220001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIS	525.3	521.4	530.05	515	525.95	148160	775.78	5895	51522	34.77000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIS	525.95	525.95	560	521.2	548.95	1459151	7981.87	45279	411127	28.18000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIS	548.95	554	557	532.35	542.85	537384	2930.21	20901	159594	29.700000762939453
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIS	547.75	542	550.5	535	543.75	250177	1361.79	14830	72346	28.920000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIS	542.85	542	551.05	538.35	547.75	338931	1855.6	13785	106706	31.479999542236328
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIS	525.55	525.55	536	516.05	527.3	103487	546.05	6572	44023	42.540000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SIS	972.3	979	984.5	956	967.55	11892	116.04	2964	6972	58.63
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SIS	967.55	969	979.5	958.25	974.35	5560	54.02	1172	3032	54.53
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SIS	974.35	974	979.55	959	963.7	6180	59.93	1352	3883	62.83


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