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)	DHANUKA	780	794.3	815.95	788	800.05	200194	1605.35	12671	65934	32.939998626708984
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANUKA	800.05	808	812	781	785.7	39925	316.73	5334	19398	48.59000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANUKA	785.7	799.9	804.9	765	775.75	23828	186.02	3042	8847	37.130001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANUKA	775.75	765.6	786.45	765.6	777.45	14153	110.02	2222	7035	49.709999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANUKA	768.25	756.1	773.85	745	751.1	18308	138.52	2296	10314	56.34000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANUKA	777.45	777.25	779.9	762	768.25	10168	78.56	1661	5225	51.38999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANUKA	776.8	771	783.75	762	780	60661	470.47	4492	36505	60.18000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANUKA	405.55	402.75	423	397	420	27691	113.18	2459	14827	53.54
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANUKA	420	423.3	423.8	411.25	415.15	11535	48.27	994	5707	49.48
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANUKA	415.15	410.15	423	410.1	416.3	21169	88.59	1474	10783	50.94


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