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)	LEMONTREE	50.9	51.15	53.7	50.2	50.45	6600699	3400.87	25353	1879919	28.479999542236328
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LEMONTREE	50.45	50.4	51.4	50	50.5	2727080	1383.98	10508	781482	28.65999984741211
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LEMONTREE	50.5	50.7	51.15	48.15	49.45	2569126	1274.91	12212	800135	31.13999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LEMONTREE	49.45	49.8	50.05	48.95	49.45	1820052	899.78	9839	742845	40.810001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LEMONTREE	49.95	49.8	49.8	47.85	48.25	3699895	1792.12	15116	1465698	39.61000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LEMONTREE	49.45	49.6	52.3	49.2	49.95	4298436	2169.2	23156	1748896	40.68999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LEMONTREE	52.2	52.95	52.95	50.5	50.9	2383842	1229.75	11007	932180	39.09999847412109
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LEMONTREE	64	64.25	64.25	62.7	63.3	256945	162.78	2244	68292	26.58
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LEMONTREE	63.3	63.85	64.2	63	63.3	318440	202	3561	137021	43.03
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LEMONTREE	63.3	63.3	63.4	61.8	61.95	217424	135.56	3617	111571	51.31


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