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)	3MINDIA	24868.65	24620	24806.1	24551.1	24744.3	1695	418.2	428	1304	76.93000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3MINDIA	24744.3	24968	24968	24592.15	24794	1664	412.35	1098	1011	60.7599983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3MINDIA	24794	24920	26943	22126.65	24669.9	3503	850.38	1737	954	27.229999542236328
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3MINDIA	24669.9	24948	24948	23990	24083.15	3089	748.67	1477	1822	58.97999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3MINDIA	23767.95	23667.95	23834.95	22601	23061.8	4972	1145.36	3020	2369	47.650001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3MINDIA	24083.15	24001	24347	23656.6	23767.95	2447	585.44	1206	1322	54.02999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3MINDIA	24982.75	25221.5	25221.5	24520.8	24868.65	3570	888.19	2078	1882	52.720001220703125
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3MINDIA	21304.7	21350.7	21820.9	21348.85	21721.95	773	167.29	445	461	59.64
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3MINDIA	21721.95	21621.35	21643.65	21311	21381.15	868	186.51	540	537	61.87
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3MINDIA	21381.15	21521.55	21521.55	21251	21335.85	963	206.05	610	492	51.09


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