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)	TCS	3824.6	3815.3	3824.7	3769	3814.9	2307366	87772.84	160651	1415833	61.36000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	3814.9	3791	3831.8	3756.15	3779	1919149	72758.64	159690	1160277	60.459999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	3779	3791.55	3799.7	3721	3743.45	2946443	110240.98	209984	2092329	71.01000213623047
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	3743.45	3750	3777.95	3746.1	3760.55	1638721	61648.6	124222	1190875	72.66999816894531
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	3770.35	3752.5	3752.5	3690	3694.95	3851488	142645.53	242420	2684979	69.70999908447266
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	3760.55	3789.8	3789.8	3758	3770.35	2112459	79669.59	127158	1512559	71.5999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	3856.2	3851	3882.5	3816.05	3824.6	1960538	75491.83	137513	1242614	63.380001068115234
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	2161.7	2168	2183.9	2154	2167.6	1354908	29408.82	44438	164490	12.14
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	2167.6	2179.95	2179.95	2149.2	2157.65	2380752	51391.56	99242	1204079	50.58
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	2157.65	2164	2223	2164	2200.65	4655761	102392.06	123516	1833823	39.39


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