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)	INGERRAND	1423.55	1430.7	1445.9	1420	1427.6	10048	143.71	2348	4201	41.810001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INGERRAND	1427.6	1430	1450	1419	1423.1	16291	232.95	2310	4930	30.26000022888184
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INGERRAND	1423.1	1442.35	1442.35	1413	1435.05	13380	191.04	2026	4681	34.9900016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INGERRAND	1435.05	1445	1502.85	1421.05	1495.25	98468	1443.42	10688	45776	46.4900016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INGERRAND	1447.6	1440	1440	1375	1383.3	25301	355.6	5515	16111	63.68000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INGERRAND	1495.25	1500	1500	1438	1447.6	28458	416.77	4763	14923	52.43999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INGERRAND	1441.7	1459	1459	1420	1423.55	9600	137.51	1934	3600	37.5
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INGERRAND	653.5	653.5	657.9	643.25	651.05	25537	166	2293	11937	46.74
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INGERRAND	651.05	647	654.6	646.05	648.1	12673	82.34	1788	8049	63.51
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INGERRAND	648.1	648.1	653	645	648	18089	117.31	1198	12632	69.83


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