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)	KOTAKBANK	1909.05	1914	1918	1880.25	1884.2	1771267	33534.58	91389	1011785	57.119998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKBANK	1884.2	1850	1890	1820	1828.45	2053959	37975.77	99014	1023232	49.81999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKBANK	1828.45	1835	1848.05	1793.1	1817.8	3569370	64727.16	124566	2245569	62.90999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKBANK	1817.8	1835.6	1847.8	1822.65	1835	1624058	29770.36	90180	801217	49.33000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKBANK	1867.2	1854.1	1854.1	1822	1828.25	1859755	34121.54	134369	993029	53.400001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKBANK	1835	1835	1888.9	1830.25	1867.2	2508081	46817.38	116003	1102409	43.95000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKBANK	1942.6	1939.9	1942.45	1896.05	1909.05	2239713	42944.34	85944	1261492	56.31999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKBANK	1684.35	1689	1696.75	1672	1674.05	1475056	24766.25	43248	671941	45.55
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKBANK	1674.05	1680	1683.5	1664.65	1671.55	1852089	30929.52	56954	1213158	65.5
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKBANK	1671.55	1670.95	1673	1645.55	1657.1	1594089	26425.96	83688	845118	53.02


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