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)	ASIANPAINT	3203	3188	3248.8	3176.05	3236.65	705765	22723.16	67026	365000	51.720001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	3236.65	3234	3251.2	3143.1	3174.7	860393	27416.6	77448	417977	48.58000183105469
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	3174.7	3179	3223.5	3166.2	3216.35	799206	25598.14	70975	413472	51.7400016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	3216.35	3230	3259	3222.75	3228.35	472725	15304.85	61184	251973	53.29999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	3238.75	3229.95	3229.95	3182.5	3216.3	587840	18843.45	73168	294533	50.09999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	3228.35	3220	3248	3176	3238.75	728666	23435.16	91293	341335	46.84000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	3197.7	3212.85	3241.6	3190.2	3203	899753	28940.66	78300	500223	55.59999847412109
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	1784.95	1790.2	1802.55	1783.2	1793.2	397285	7128.46	15386	79648	20.05
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	1793.2	1791	1799.9	1783.4	1790.65	411266	7369.17	22042	130259	31.67
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	1790.65	1779.8	1779.8	1747.05	1751.4	1318628	23181.57	66172	466498	35.38


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