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)	FACT	137.8	140	141.15	129.5	134.25	1069845	1434.05	15730	94222	8.8100004196167
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FACT	134.25	136	136.55	130.2	131.55	272346	364.59	4271	69505	25.520000457763672
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FACT	131.55	131.75	133.2	127.3	131.4	563942	735.88	9526	62635	11.109999656677246
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FACT	131.4	131.4	132.9	129	131.15	211791	278.46	4349	45483	21.479999542236328
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FACT	129.95	127.2	131.85	126.6	127.35	282545	364.37	4732	56519	20
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FACT	131.15	131.4	132	129	129.95	179158	233.35	3488	53717	29.979999542236328
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FACT	136.7	137.65	140.8	136.5	137.8	384869	535.42	6570	86384	22.450000762939453
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FACT	39.65	39.6	39.65	39.05	39.2	78655	30.92	479	44283	56.3
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FACT	39.2	39.2	42.5	39.15	42.05	564101	232.56	2763	304338	53.95
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FACT	42.05	41.4	42.5	40.55	42.1	437716	183.27	2276	149301	34.11


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