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)	ASHOKA	98.5	98.55	99.45	97.4	97.95	727618	714.5	5239	374658	51.4900016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKA	97.95	99.75	99.85	98.05	98.5	847210	835.84	6528	324038	38.25
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKA	98.5	98.9	98.9	94.2	94.6	1497852	1436.95	9282	708968	47.33000183105469
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKA	94.6	95.6	96.55	94.2	96	738706	704.55	5952	419650	56.810001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKA	96.15	95.5	95.95	93.5	94.2	488450	463.48	4434	265792	54.41999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKA	96	96.05	96.75	95.2	96.15	447999	431.02	4584	166431	37.150001525878906
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKA	100.35	100.3	100.75	98.15	98.5	751296	746.4	6057	373048	49.650001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKA	102.45	102.7	104.7	102.05	103.1	412580	427	5964	131638	31.91
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKA	103.1	103.65	111.65	102.35	108.85	1634658	1733.27	11809	1003262	61.37
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKA	108.85	109.9	111.5	105.8	106.75	897851	975.64	8472	479400	53.39


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