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)	MARICO	501.3	496.8	511.65	492.7	510.55	1758002	8856.55	31723	689149	39.20000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARICO	510.55	521.05	524	508.75	511.4	3235609	16641.88	51421	1574722	48.66999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARICO	511.4	514.65	516.7	504.4	505.8	1564673	7980.72	37551	638172	40.790000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARICO	505.8	509.65	512.95	506	512.2	515112	2630.96	23801	262422	50.93999862670898
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARICO	507.55	507.5	507.5	494.55	499.3	1069920	5344.45	44420	489267	45.72999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARICO	512.2	514.7	514.7	505	507.55	774115	3931.76	46691	471459	60.900001525878906
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARICO	505.3	504.9	507.75	499.5	501.3	1393417	7020.72	29948	368619	26.450000762939453
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MARICO	341.6	341.85	346.85	341	345.75	1119565	3859.16	12561	538665	48.11
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MARICO	345.75	345.75	347.4	336.1	337.2	2592967	8835.96	30523	1205317	46.48
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MARICO	337.2	335.6	336.85	331.4	334.6	2007575	6696.48	29477	843010	41.99


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