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)	CHALET	251.05	250.75	262.5	247.3	260.3	764905	1981.27	15955	216444	28.299999237060547
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHALET	260.3	262	271.35	261.6	265.55	426364	1136.11	15010	135399	31.76000022888184
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHALET	265.55	265.2	275	256.55	265.15	632864	1695.04	24057	180684	28.549999237060547
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHALET	265.15	267.9	269.05	257	258.5	120172	313.77	6620	37374	31.100000381469727
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHALET	254.05	251	264.8	251	256.15	211842	545.91	8914	41933	19.790000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHALET	258.5	259.9	261.2	251.95	254.05	150582	386.54	4546	56004	37.18999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHALET	246.5	244.3	256.8	244.3	251.05	276080	692.82	11415	76687	27.780000686645508
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHALET	348.95	350.1	350.25	336	342	58180	199.06	3463	11516	19.79
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHALET	342	346	346.45	337	339.5	51476	175.94	5794	9695	18.83
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHALET	339.5	345.75	345.75	327	334.3	31120	104.27	2639	15184	48.79


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