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)	CRISIL	2867.6	2874	2874	2780	2798.3	15371	433.05	4243	6174	40.16999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CRISIL	2798.3	2805.8	2824.35	2742.65	2761.9	10859	301.59	3023	4526	41.68000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CRISIL	2761.9	2764	2784.7	2705	2712.4	14081	383.75	3597	5477	38.900001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CRISIL	2712.4	2726	2750.9	2700.1	2728.65	38401	1041.87	5477	26237	68.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CRISIL	2763.3	2755	2771.2	2725.55	2744.15	7970	218.74	2672	3092	38.79999923706055
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CRISIL	2728.65	2730	2781.55	2720	2763.3	10388	285.39	3260	3211	30.90999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CRISIL	2811.55	2810	2874.9	2785	2867.6	18202	514.35	3764	7996	43.93000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CRISIL	1907.6	1900	1978.7	1872.05	1947.85	199897	3888.98	15066	33376	16.7
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CRISIL	1947.85	1947.85	1955.75	1918	1928.9	35794	691.61	4374	8013	22.39
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CRISIL	1928.9	1932	1932	1885.45	1891.45	28412	539.52	3481	10005	35.21


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