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)	EICHERMOT	2670.85	2676.15	2677.9	2616	2631.4	380540	10023.53	30010	117279	30.81999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EICHERMOT	2631.4	2631.5	2646.1	2561.7	2601.35	448637	11674.14	37719	129223	28.799999237060547
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EICHERMOT	2601.35	2615	2645	2581.7	2589.15	386391	10078.11	27030	99430	25.729999542236328
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EICHERMOT	2589.15	2598.95	2636.9	2587.35	2625.65	677550	17680.43	36051	306510	45.2400016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EICHERMOT	2640.35	2625	2625.4	2582.35	2598.15	731373	18991.43	56034	436256	59.650001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EICHERMOT	2625.65	2625.8	2664	2615.55	2640.35	558179	14773.93	37358	244873	43.869998931884766
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EICHERMOT	2669.75	2675.1	2709.85	2640	2670.85	664625	17796.6	32203	267206	40.20000076293945
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EICHERMOT	22515.25	22515.25	22594.75	22001	22075.8	108648	24135.8	24089	12325	11.34
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EICHERMOT	22075.8	22090	22341.85	21471.1	21600.85	228582	49789.65	49509	24910	10.9
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EICHERMOT	21600.85	21650	21665.95	21110	21189.25	157297	33411.85	39542	36689	23.32


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