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)	HEROMOTOCO	2781.5	2765	2780	2712.75	2721.75	585251	15986.24	53361	162275	27.729999542236328
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROMOTOCO	2721.75	2721.75	2734	2625	2648.05	688838	18267.34	52322	198649	28.84000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROMOTOCO	2648.05	2660.55	2691.65	2650	2671.95	625615	16698.23	49636	209298	33.45000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROMOTOCO	2671.95	2680.4	2736.6	2673.05	2728.85	359950	9785.07	33777	107190	29.780000686645508
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROMOTOCO	2734.1	2670	2747	2655	2718.6	1235994	33540.32	68393	411464	33.290000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROMOTOCO	2728.85	2745.4	2751	2701.05	2734.1	448648	12229.46	48403	205639	45.84000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROMOTOCO	2702.4	2704.3	2817.95	2684	2781.5	1436881	40012.3	91654	307053	21.3700008392334
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROMOTOCO	2443.05	2454.9	2462.55	2427.35	2432.55	314519	7684.15	13924	49844	15.85
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROMOTOCO	2432.55	2447.8	2452	2417.05	2429.45	546945	13319.01	25944	237041	43.34
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROMOTOCO	2429.45	2420	2449	2415	2432.35	544720	13255.05	32567	108997	20.01


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