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)	GESHIP	318.95	320.5	320.5	316.3	318.1	76516	243.25	3022	46090	60.2400016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GESHIP	318.1	319.8	321.9	317.05	319.65	100807	322.34	2857	58600	58.130001068115234
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GESHIP	319.65	321.3	321.5	315.6	320.1	158009	504.75	4143	100709	63.7400016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GESHIP	320.1	320.95	323.35	317.25	320.95	112497	360.84	4941	77795	69.1500015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GESHIP	321.55	321.9	323	317.05	321.6	769109	2453.59	18574	680649	88.5
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GESHIP	320.95	321.05	322.45	315	321.55	97526	312.54	4515	58763	60.25
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GESHIP	318.05	318.5	319.8	314.85	318.95	134833	428.61	8144	90077	66.80999755859375
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GESHIP	298.95	298.9	304.05	297.2	301.5	12240	36.85	455	7376	60.26
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GESHIP	301.5	301.1	304.75	300	300.95	31294	94.4	877	21743	69.48
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GESHIP	300.95	300.75	309.9	297.5	301.75	68315	207.17	3541	49104	71.88


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