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)	AAVAS	3194.25	3185	3185	3024.1	3054.4	136992	4211.23	13071	90718	66.22000122070312
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AAVAS	3054.4	3076.3	3109.5	2962.05	2983.65	214113	6417.66	23855	149348	69.75
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AAVAS	2983.65	2970	3019.5	2890.85	2961.8	153630	4567.55	17743	107248	69.80999755859375
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AAVAS	2961.8	2993.4	3018.5	2962	2994.6	170633	5112.03	10559	145206	85.0999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AAVAS	3099	3056.5	3110	2965.35	3020.8	218215	6683.17	23887	132924	60.90999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AAVAS	2994.6	2990	3139.7	2985	3099	268592	8288.81	28574	152690	56.84999847412109
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AAVAS	3195.8	3208.95	3218	3138.7	3194.25	209731	6635.52	18611	138152	65.87000274658203
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AAVAS	1981.1	1981.1	1998	1925	1969.2	45666	893.72	4459	25277	55.35
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AAVAS	1969.2	1961	2007.8	1936.05	1987.9	31631	628.2	4015	14170	44.8
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AAVAS	1987.9	1989.3	2050.1	1965	2039.9	65539	1332.11	8072	34137	52.09


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