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)	AMARAJABAT	638.6	637	638.55	626.15	630	622584	3937.49	22677	168602	27.07999992370605
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMARAJABAT	630	629.95	637.4	616.7	620.35	806411	5033.26	28379	296396	36.75
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMARAJABAT	620.35	620	625	609.05	615.6	719404	4430.24	28733	195326	27.149999618530277
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMARAJABAT	615.6	620.4	623.5	613.9	621.9	427741	2650.59	13900	96011	22.450000762939453
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMARAJABAT	620.25	610.5	619.4	605.35	607.6	1161718	7114.84	26514	205358	17.68000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMARAJABAT	621.9	622.45	625.25	616.6	620.25	401286	2493.09	14026	114295	28.479999542236328
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMARAJABAT	638.15	640	643.2	634.95	638.6	491024	3137.03	15287	137967	28.100000381469727
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AMARAJABAT	724.35	728.85	732.6	718.1	720.9	405425	2940.24	9562	35956	8.87
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AMARAJABAT	720.9	722	728.2	719.3	726.9	296520	2148.27	8024	54281	18.31
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AMARAJABAT	726.9	726.9	732	718.2	720.7	494404	3588.7	10859	62191	12.58


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