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)	ZEEL	287.5	287.7	288.75	276.6	278.3	10466445	29362.11	81965	2482680	23.71999931335449
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEEL	278.3	276	280.65	273.85	275.5	5716433	15869.11	70999	1275602	22.309999465942383
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEEL	275.5	276.05	278	267.3	270.8	6048793	16464.89	53013	1113443	18.40999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEEL	270.8	273	276.3	267.1	268.1	8165778	22065.24	65224	3762686	46.08000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEEL	263.8	263.5	267.5	260.7	261.9	11096932	29324.6	94283	4209759	37.93999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEEL	268.1	269.9	270.6	263	263.8	12375550	32904.86	110776	6232226	50.36000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEEL	292.55	284.3	292	278.6	287.5	12970686	37310.55	78764	3616527	27.8799991607666
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEEL	292.2	294	296.45	286.6	288.65	9363059	27275.49	71575	925244	9.88
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEEL	288.65	282	291.7	279.2	289.6	15563216	44615	133753	1688867	10.85
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEEL	289.6	289	289	272.3	273.7	23061627	64053.47	180431	5552912	24.08


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