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)	PIIND	2490.2	2485	2591.95	2443.35	2552.2	1024598	25880.87	65358	473889	46.25
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIIND	2552.2	2552.2	2643.95	2549.25	2605.05	661733	17158.04	56147	281868	42.59999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIIND	2605.05	2617.65	2684.4	2586.55	2664	431625	11432.2	38620	153910	35.65999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIIND	2664	2663.95	2683.95	2618	2642.25	249787	6589.41	20084	120199	48.119998931884766
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIIND	2625.25	2619	2623.35	2527.05	2554.15	286000	7344.18	33245	150770	52.720001220703125
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIIND	2642.25	2661.8	2661.8	2589.45	2625.25	203281	5335.6	22454	109654	53.93999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIIND	2519.9	2530	2537.3	2453.95	2490.2	275530	6868.38	28899	130105	47.220001220703125
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PIIND	1445.9	1450.9	1459.2	1443.55	1451.2	23503	341.42	1903	14143	60.18
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PIIND	1451.2	1454.4	1457.7	1422.1	1440.65	70833	1019.98	12092	36533	51.58
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PIIND	1440.65	1441.9	1453	1430	1444.3	38530	556.78	4022	22782	59.13


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