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)	INFIBEAM	42.9	43.15	43.45	42.5	42.95	1722040	739.97	6829	859085	49.88999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFIBEAM	42.95	44	44.7	43.55	43.65	3311876	1453.86	13829	1687835	50.959999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFIBEAM	43.65	43.55	43.9	41.8	43.2	1934147	829.5	7886	790472	40.869998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFIBEAM	43.2	43	43.4	41.6	41.75	2711403	1142.03	9449	1574880	58.08000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFIBEAM	44.3	43.4	43.7	42.2	42.65	4369794	1871.45	10955	2090128	47.83000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFIBEAM	41.75	41.75	45.3	41.4	44.3	6080202	2622.78	14277	3107462	51.11000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFIBEAM	42.5	42.5	43.5	42.4	42.9	3311047	1422.09	8564	1835669	55.43999862670898
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INFIBEAM	54.95	54.95	55.25	54	54.1	2002046	1093.39	6824	810542	40.49
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INFIBEAM	54.1	54.5	55.4	54	54.7	3543299	1945.37	5048	2178154	61.47
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INFIBEAM	54.7	55	55.2	53.8	54.15	1568540	851.18	5417	649058	41.38


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