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)	FRETAIL	48.2	47.6	47.95	46.5	47.35	2518548	1193.72	10110	1223909	48.59999847412109
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FRETAIL	47.35	47.35	47.9	46.9	47.1	1593436	752.39	7665	868734	54.52000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FRETAIL	47.1	47.5	49.1	47.2	48.2	2543549	1220.55	10327	816800	32.11000061035156
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FRETAIL	48.2	49.4	49.4	47.8	48.1	1209499	584.14	7097	603962	49.93000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FRETAIL	47.55	47.5	47.55	47.05	47.15	1203520	568.9	4529	520680	43.2599983215332
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FRETAIL	48.1	47.9	48	47.35	47.55	1290625	615.44	6310	562131	43.54999923706055
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FRETAIL	49.7	49.8	50.4	47.8	48.2	2621444	1283.64	11332	1322109	50.43000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FRETAIL	341.75	343.85	344.9	339.5	340.55	240809	821.52	12760	112329	46.65
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FRETAIL	340.55	342.6	343.8	330	332.15	613172	2058.47	28774	321695	52.46
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FRETAIL	332.15	332.6	336	331.1	334.1	792927	2637.92	14627	583384	73.57


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