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)	WHIRLPOOL	1810.85	1803	1834.85	1792	1799.55	104585	1903.45	7119	46991	44.93000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WHIRLPOOL	1799.55	1807	1813.05	1762.05	1788.35	131127	2341.52	9894	66608	50.79999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WHIRLPOOL	1788.35	1788.35	1805	1772.15	1796	71096	1273.85	6089	34382	48.36000061035156
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WHIRLPOOL	1796	1801	1829	1772.2	1775.55	61679	1100.62	5345	28820	46.72999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WHIRLPOOL	1797.55	1758	1788.8	1742.5	1758.9	174508	3087.42	13058	84289	48.29999923706055
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WHIRLPOOL	1775.55	1784.9	1822.7	1751	1797.55	443909	7888.99	24521	152858	34.43000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WHIRLPOOL	1838.85	1848.45	1848.7	1790.55	1810.85	160645	2935.56	7242	40736	25.36000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WHIRLPOOL	2373.5	2386	2387.25	2325	2333.25	32427	762.73	3640	16813	51.85
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WHIRLPOOL	2333.25	2335	2350	2301	2332.7	44580	1037.22	5409	21551	48.34
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WHIRLPOOL	2332.7	2344	2384	2305.7	2320.6	48755	1140.18	6099	21549	44.2


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