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)	VTL	2422.05	2428.6	2577	2424.9	2551.55	344370	8741.35	28956	121431	35.2599983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VTL	2551.55	2574	2630	2490	2506.2	176486	4511.46	19505	71634	40.59000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VTL	2506.2	2503.1	2529.1	2410.9	2418.85	117788	2879.27	20436	57374	48.709999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VTL	2418.85	2462.4	2498	2438.7	2486.2	88947	2199.46	9287	43337	48.720001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VTL	2549.8	2512.2	2561.9	2496	2509.85	122883	3108.95	18213	74502	60.630001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VTL	2486.2	2506	2613.95	2490.9	2549.8	169505	4327.26	15671	89513	52.810001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VTL	2445.25	2464.4	2474.95	2408	2422.05	76370	1857.85	12289	39484	51.70000076293945
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VTL	992.45	990.1	999.9	982	994.7	3017	29.92	322	2477	82.1
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VTL	994.7	994.75	997.9	981	983.25	2763	27.3	281	2228	80.64
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VTL	983.25	991.95	1000	988.5	996.35	4348	43.17	569	3814	87.72


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