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)	JKLAKSHMI	558.55	561.95	565	549.45	551.6	196298	1090.17	10445	124007	63.16999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKLAKSHMI	551.6	555	566.55	549.25	559.4	218417	1217.17	17096	80323	36.77999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKLAKSHMI	559.4	563	564.85	546	547.25	180049	994.04	11423	88795	49.31999969482422
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKLAKSHMI	547.25	550.1	554.7	525.2	528.25	342543	1827.62	21482	199345	58.20000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKLAKSHMI	533.05	528.9	529.45	514.1	519.1	262863	1362.97	23771	132354	50.34999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKLAKSHMI	528.25	536.15	538.7	528.5	533.05	125214	667.29	8246	40399	32.2599983215332
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKLAKSHMI	569.9	561.6	576.2	555.3	558.55	310364	1747.61	19712	158672	51.119998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKLAKSHMI	279.95	282	289.3	281.15	288.05	23659	67.5	1325	16032	67.76
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKLAKSHMI	288.05	289.8	305.5	284	303.7	287246	865.48	5619	119360	41.55
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKLAKSHMI	303.7	303	309.5	295.1	306.3	156458	474.79	5814	99829	63.81


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