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)	SUVENPHAR	553.7	551.8	565.05	551	558.95	162992	909.48	8009	94675	58.09000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUVENPHAR	558.95	557	566.35	555	558.9	221658	1240.55	7150	141271	63.72999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUVENPHAR	558.9	563	574.5	555	569.6	1100713	6247.96	26719	529693	48.119998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUVENPHAR	569.6	571	577.35	538.7	540.45	343006	1898.29	15461	152530	44.470001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUVENPHAR	540.25	538	539.4	524.1	526.35	100275	531.36	6781	48078	47.95000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUVENPHAR	540.45	544.95	545.65	531.3	540.25	197409	1063.47	8198	102379	51.86000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUVENPHAR	551.45	550	567.8	545.4	553.7	315330	1762.94	12272	167528	53.130001068115234
Mon Mar 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUVENPHAR	301.45	321	337.05	321	337.05	416907	1395.82	1207
Wed Mar 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUVENPHAR	337.05	353.9	353.9	320.2	322.7	875368	3019.7	4629
Thu Mar 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUVENPHAR	322.7	306.6	306.6	306.6	306.6	38619	118.41	60


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