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)	TANLA	1760.7	1750	1794	1726.6	1738.35	109238	1919.69	15544	48247	44.16999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TANLA	1738.35	1769.95	1769.95	1695.15	1698.9	119841	2056.49	14683	65615	54.75
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TANLA	1698.9	1710.95	1719	1606.05	1639.15	232963	3819.62	24199	112915	48.470001220703125
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TANLA	1639.15	1661.95	1684.95	1601	1611.75	244264	3981.51	32590	142666	58.40999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TANLA	1610.1	1598.7	1616.2	1545.55	1558.85	319838	5024.95	28581	192132	60.06999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TANLA	1611.75	1611.75	1664	1595	1610.1	231534	3743.14	23680	122049	52.709999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TANLA	1802.6	1814.9	1819.95	1722.65	1760.7	148324	2643.91	12237	79559	53.63999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TANLA	70.5	71	71	69.65	70.05	140667	98.6	469	112924	80.28
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TANLA	70.05	70.25	71.7	68.9	69.8	154617	108.33	699	99819	64.56
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TANLA	69.8	69.15	70.75	66.6	67.2	95052	65.12	822	65016	68.4


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