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)	ATUL	9578.35	9578.35	9699.95	9415.2	9452.2	34067	3264.94	8417	14812	43.47999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATUL	9452.2	9519.9	9519.9	9168.65	9268.1	26763	2484.43	6397	8312	31.059999465942383
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATUL	9268.1	9319	9382.45	9203.2	9329.5	20583	1912.22	4622	5412	26.290000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATUL	9329.5	9350	9671	9350	9635.4	24564	2343.35	5403	6525	26.559999465942383
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATUL	9688.7	9511.2	9631.45	9462.1	9526.85	15601	1488.44	4115	4558	29.21999931335449
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATUL	9635.4	9670	9796.5	9595.05	9688.7	12909	1251.1	3940	2608	20.200000762939453
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATUL	9665.05	9729	9749.9	9540	9578.35	17124	1647.82	4549	4239	24.75
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ATUL	4050.8	4099.9	4100	4052.1	4060.8	1661	67.62	551	625	37.63
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ATUL	4060.8	4061	4121	4050	4106.8	5370	219.59	838	3761	70.04
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ATUL	4106.8	4133.3	4149.95	4099	4132.6	3468	142.96	1082	2001	57.7


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