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)	ALKEM	3537.95	3566.9	3600	3375.2	3514	331945	11574.22	40919	51254	15.4399995803833
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKEM	3514	3471	3557.6	3438	3486.15	44406	1553.86	7045	10845	24.420000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKEM	3486.15	3499.8	3519.95	3445.15	3490.6	50575	1763.7	9797	20026	39.59999847412109
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKEM	3490.6	3480	3539	3470.05	3519.35	66306	2327.23	6956	48048	72.45999908447266
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKEM	3500.55	3480	3488	3406	3431.45	35760	1233.24	5844	11052	30.90999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKEM	3519.35	3495	3535.95	3490	3500.55	14214	499.08	2579	3525	24.799999237060547
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKEM	3550.2	3550.2	3561.2	3514	3537.95	28211	999.41	5192	13216	46.84999847412109
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKEM	2013.9	2013.9	2100	2006.9	2082.85	94927	1973.92	17117	35470	37.37
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKEM	2082.85	2100	2100	2076.2	2085.65	33488	698.71	3081	16337	48.78
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKEM	2085.65	2094	2100	2079.95	2094.65	18082	378	2133	10586	58.54


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