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)	AVANTIFEED	598.85	599	601.75	585.55	587.3	110728	656.46	5394	58109	52.47999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AVANTIFEED	587.3	586.95	595	580.8	590.35	124146	728.84	6253	65129	52.459999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AVANTIFEED	590.35	592	602	587.55	597.1	92542	550.47	5449	42463	45.88999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AVANTIFEED	597.1	600.2	606.95	595.2	599.35	133574	802.72	7151	58196	43.56999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AVANTIFEED	600.3	597	615	566.85	582.15	356440	2120.6	19087	85339	23.940000534057617
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AVANTIFEED	599.35	595.5	605	593.45	600.3	65919	394.64	4585	31747	48.15999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AVANTIFEED	599.85	600.2	609	592	598.85	119395	714.28	7158	54502	45.650001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AVANTIFEED	584	592	612.5	590.2	607.45	2387460	14449.7	48872	309553	12.97
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AVANTIFEED	607.45	612.2	624.8	609.25	613.8	979306	6051.38	24593	201444	20.57
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AVANTIFEED	613.8	610	617.3	601.1	603.7	405978	2462.96	12854	117696	28.99


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