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)	SHILPAMED	526.1	526.1	528.7	515.1	518.45	73015	380.65	2686	38275	52.41999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHILPAMED	518.45	519.7	521.55	508.1	510.05	60421	310.5	2573	32355	53.54999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHILPAMED	510.05	511.55	516.75	481.25	489.35	132376	653.02	6876	69725	52.66999816894531
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHILPAMED	489.35	511	515	478.2	500.7	649578	3193.51	30504	262562	40.41999816894531
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHILPAMED	475.25	472.15	509	462.3	484	1242287	5972.41	29948	622802	50.130001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHILPAMED	500.7	497	501.55	472	475.25	235949	1139.91	10489	127535	54.04999923706055
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHILPAMED	509.85	513.7	539	510.25	526.1	257327	1352.08	9052	71505	27.790000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHILPAMED	282.1	282.1	285.1	281.95	282.7	2922	8.27	208	1310	44.83
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHILPAMED	282.7	283.05	290	279.65	286.5	8888	25.41	486	6207	69.84
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHILPAMED	286.5	286.85	293.8	280.8	288.9	11826	34.15	1290	7881	66.64


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