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)	LUXIND	2905.05	2940	3172.4	2939.95	3059.25	330401	10159.04	26638	106849	32.34000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUXIND	3059.25	3072	3072	2853	2917.3	67305	1986.74	9088	33399	49.619998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUXIND	2917.3	2949.9	2968.4	2782.9	2809.85	59811	1703.22	7089	36935	61.75
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUXIND	2809.85	2848	2922.05	2800	2849.95	35951	1023.73	5115	14446	40.18000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUXIND	2873.55	2840	2894.1	2830.35	2849.4	29189	835.3	6082	14375	49.25
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUXIND	2849.95	2849.95	2892	2816.35	2873.55	38436	1096.93	6118	15120	39.34000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUXIND	2876.35	2900	2930	2852	2905.05	70886	2048.8	6854	34874	49.20000076293945
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LUXIND	1284.65	1285.45	1291.45	1271	1279.3	47428	608.38	1123	3285	6.93
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LUXIND	1279.3	1279.05	1324.8	1265.1	1316.75	80987	1050.8	2941	31313	38.66
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LUXIND	1316.75	1320	1334	1301.1	1324.75	46637	615.13	1785	14355	30.78


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