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)	CENTURYPLY	637.4	645	659.55	638.8	642	296842	1921.36	18919	76725	25.850000381469727
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYPLY	642	644.9	645.25	624.2	636.35	114344	724.73	11438	48353	42.290000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYPLY	636.35	643	649.15	626.2	638.65	228050	1464.31	24243	112446	49.310001373291016
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYPLY	638.65	641.35	648.9	632.15	639.25	129229	830.23	12199	56373	43.619998931884766
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYPLY	636.4	633	641	624.3	630.6	75488	478.95	10406	32206	42.65999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYPLY	639.25	644.9	648	630.6	636.4	83347	532.91	8694	35882	43.04999923706055
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYPLY	607.2	613.65	645	607.25	637.4	257029	1607.54	15538	83762	32.59000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYPLY	160.6	161.4	166.2	160.1	165.5	77570	126.37	1891	46459	59.89
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYPLY	165.5	168	169.4	164.65	167	169510	284.86	2680	100750	59.44
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYPLY	167	167	170.9	164.05	167.35	152013	255.04	4318	69161	45.5


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