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)	BEML	1846.25	1847	1869.7	1814	1821.65	91603	1685.07	7999	24935	27.21999931335449
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEML	1821.65	1831	1831.15	1795.5	1822.35	88631	1606.98	8192	25156	28.3799991607666
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEML	1822.35	1829.95	1859	1783.6	1839.7	208857	3818.5	16780	56365	26.989999771118164
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEML	1839.7	1849.9	1884	1845.05	1863.15	264300	4934.43	19108	46853	17.729999542236328
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEML	1860.75	1875	1896.9	1842.6	1858.1	206737	3876.02	13825	50237	24.299999237060547
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEML	1863.15	1863	1925	1837.2	1860.75	769734	14552.31	58150	110283	14.329999923706056
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEML	1842.6	1850	1864	1837.1	1846.25	87191	1611.73	6130	30320	34.77000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BEML	984	984.25	997	975	990.85	260469	2568.19	8311	37515	14.4
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BEML	990.85	988	994.65	981	987.8	197561	1951.39	6014	31467	15.93
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BEML	987.8	981.3	987.8	971.7	974.95	184280	1804.55	8027	51067	27.71


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