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)	METROPOLIS	2560.4	2545	2620	2505.25	2586.7	126659	3268.73	12724	43054	33.9900016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	METROPOLIS	2586.7	2588	2599.6	2480	2529.7	122857	3110.26	14006	60540	49.27999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	METROPOLIS	2529.7	2528.8	2567.25	2415.25	2433.6	237471	5877.71	13794	153338	64.56999969482422
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	METROPOLIS	2433.6	2459.55	2512	2428.05	2456.7	110569	2727.76	13884	46915	42.43000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	METROPOLIS	2460.55	2448	2448	2363.75	2421.65	197768	4752.89	16515	74281	37.560001373291016
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	METROPOLIS	2456.7	2456.7	2498	2431.95	2460.55	71844	1769.34	8433	29013	40.380001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	METROPOLIS	2631.4	2640	2653	2550	2560.4	131411	3412.66	16059	57690	43.900001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	METROPOLIS	1451.55	1430.2	1468	1426.8	1434.65	18404	266.42	2723	6053	32.89
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	METROPOLIS	1434.65	1443.65	1444.55	1399	1407.65	10157	144.22	1658	3384	33.32
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	METROPOLIS	1407.65	1427	1427	1395	1403.8	14950	209.92	2459	7700	51.51


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