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)	CADILAHC	407.7	411.05	417.7	408	409.25	1896447	7821.3	35226	455417	24.01000022888184
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CADILAHC	409.25	409.85	411.1	395.2	397.35	1302034	5223.09	31661	511775	39.310001373291016
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CADILAHC	397.35	397	403.85	393.65	400.75	1425555	5705.86	24970	513050	35.9900016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CADILAHC	400.75	402.4	406.8	401.5	405.5	904732	3660.71	20118	285868	31.600000381469727
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CADILAHC	401.3	399	399	390.55	392.35	1607589	6313.21	39320	500621	31.13999938964844
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CADILAHC	405.5	407.2	408.6	400	401.3	1645393	6640.78	31040	730974	44.43000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CADILAHC	414.5	416.65	420.55	407	407.7	3427610	14171.72	52674	597978	17.450000762939453
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CADILAHC	254.3	254.95	256.65	253.1	254.25	437875	1117.53	3832	124775	28.5
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CADILAHC	254.25	255.4	257.5	253.55	256.35	540659	1383.16	13384	160073	29.61
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CADILAHC	256.35	257	264	255.95	260	1478041	3852.35	13654	278377	18.83


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