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)	TECHM	1454.3	1464	1464.95	1435	1448.2	2406272	34953.3	101406	1018937	42.34999847412109
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	1448.2	1450	1465.75	1434	1444.3	2741520	39757.66	81890	1337214	48.77999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	1444.3	1446.5	1456.15	1420.2	1434.2	1981111	28481.04	82074	765905	38.65999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	1434.2	1440.05	1470.95	1440.05	1454.8	2282701	33246.46	79469	1084664	47.52000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	1468.5	1449.85	1449.95	1421	1424.9	2426039	34659.42	130837	1172866	48.34000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	1454.8	1465	1472	1450.3	1468.5	1850405	27082.67	119114	1087966	58.79999923706055
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	1482.95	1478.9	1479.8	1449.1	1454.3	2433692	35630.44	119685	1025732	42.150001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	762.3	766	766.8	760.35	762.1	746371	5697.75	17126	147395	19.75
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	762.1	762.1	769.15	761	766.05	1133488	8686.3	50776	518229	45.72
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	766.05	766	779.9	763.55	775.1	2121704	16446.08	54537	881327	41.54


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