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)	TATAELXSI	7293.85	7300	7493	7205.3	7424.8	327785	24184.05	57499	68641	20.940000534057617
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAELXSI	7424.8	7490	7700	7425	7640.05	407494	30798.17	68643	111382	27.32999992370605
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAELXSI	7640.05	7706	7833	7578.85	7615.6	637281	49280.02	68170	104594	16.40999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAELXSI	7615.6	7660	7725	7651	7667.7	149046	11449.66	27659	58898	39.52000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAELXSI	7603.6	7455	7560	7350	7397.6	197308	14690.81	33209	95547	48.43000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAELXSI	7667.7	7700	7707.4	7560.65	7603.6	137948	10522.01	24303	66105	47.91999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAELXSI	7482.5	7504	7526.4	7260.05	7293.85	316939	23387.79	65293	100789	31.799999237060547
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAELXSI	825.95	827.9	831.4	821	827.85	263807	2180.23	9919	42403	16.07
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAELXSI	827.85	829.8	835.8	823.3	828.25	294367	2440.83	11572	62978	21.39
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAELXSI	828.25	828	842	821.55	838.1	666116	5572.25	22708	112351	16.87


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