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)	TIINDIA	1766.4	1780.85	1819	1751	1796.5	102063	1828.88	14888	47551	46.59000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIINDIA	1796.5	1809.4	1866	1786.8	1801.7	339336	6169.82	36333	132377	39.0099983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIINDIA	1801.7	1820	1824	1763.35	1780.05	116291	2082.9	15638	56574	48.650001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIINDIA	1780.05	1800	1803.85	1732.05	1772.65	145646	2566.26	17944	80440	55.22999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIINDIA	1717.9	1710	1717.9	1685.55	1700.2	96196	1638.79	9957	73974	76.9000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIINDIA	1772.65	1789.9	1789.9	1691.1	1717.9	208483	3582.12	25609	105303	50.5099983215332
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIINDIA	1746.65	1755.8	1819	1750.15	1766.4	215440	3836.03	14560	155810	72.31999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TIINDIA	481.6	480.1	492.85	480.1	490.55	17858	87.06	1689	8626	48.3
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TIINDIA	490.55	490.55	499.5	487.75	495.65	38536	191.3	3811	28492	73.94
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TIINDIA	495.65	494.9	503.3	487.25	491.15	65384	324.27	6357	38245	58.49


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