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)	HINDPETRO	284.55	286	286.25	280.3	281.1	3858006	10903.22	55526	1949213	50.52000045776367
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDPETRO	281.1	281.65	286.25	278.55	285.05	3656235	10354.32	63381	1725894	47.20000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDPETRO	285.05	286.15	287.95	281.55	287.2	4430556	12618.9	48438	1718529	38.790000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDPETRO	287.2	288.8	296.95	287.2	295.8	4618523	13542.33	64576	2444817	52.93999862670898
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDPETRO	299.5	296	304	295.55	301.65	3903257	11765.52	38906	1946552	49.869998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDPETRO	295.8	296.65	300.85	295.2	299.5	3321223	9920.92	70172	1977220	59.52999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDPETRO	290.65	291	291.45	283.9	284.55	3847964	11035.15	78813	1705413	44.31999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDPETRO	264.5	264.9	266.55	263.6	265.5	765044	2030.54	7759	106685	13.94
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDPETRO	265.5	266.5	270.65	264.55	269.5	2336221	6267.52	18904	1043355	44.66
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDPETRO	269.5	264.9	266.15	261.5	263.7	4110082	10845.14	36332	1057319	25.73


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