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)	IDEA	11.35	11.35	11.85	11.2	11.3	303446679	34684.87	189275	58509936	19.280000686645508
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDEA	11.3	11.25	11.4	10.85	10.95	165475780	18358.8	110194	48025520	29.020000457763672
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDEA	10.95	11.1	11.2	10.8	10.85	158896027	17382.81	159287	35852000	22.559999465942383
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDEA	10.85	11	11.15	10.7	10.8	172831139	18886.32	132849	35740348	20.68000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDEA	11.15	11	11.15	10.75	10.8	145093038	15833.87	162408	53581776	36.93000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDEA	10.8	10.9	11.45	10.65	11.15	258923751	28701.88	156135	66390376	25.63999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDEA	11.4	11.4	11.65	11.1	11.35	191781527	21819.13	139553	39419848	20.549999237060547
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDEA	6.15	6.2	6.3	6	6.1	55777825	3427.19	91021	14689240	26.34
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDEA	6.1	6	6.2	5.95	6.1	67004549	4066.73	106978	26838188	40.05
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDEA	6.1	6.1	6.2	6	6.1	77256216	4717.65	135875	24783548	32.08


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