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)	SRF	2439.8	2426	2474.8	2426	2435.9	348955	8554.05	44135	126956	36.380001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRF	2435.9	2444.8	2521.85	2410.15	2450.8	1243759	30782.57	87321	377976	30.38999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRF	2450.8	2462.25	2548	2429	2531.3	1232058	30700.48	71697	484384	39.31999969482422
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRF	2531.3	2549.9	2594	2543.4	2583.8	811882	20905.34	59873	332581	40.959999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRF	2584.55	2560	2578.95	2460.6	2476.55	792095	19906.17	72425	370701	46.79999923706055
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRF	2583.8	2598.8	2611.85	2550.1	2584.55	698527	18035.28	53380	346370	49.59000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRF	2453.5	2475	2488.05	2425	2439.8	625410	15415.09	45878	289479	46.290000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SRF	3436.1	3431.5	3453	3425.3	3439.55	106572	3665.77	4662	15352	14.41
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SRF	3439.55	3441	3469.5	3435	3463.3	152503	5271.26	7288	26664	17.48
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SRF	3463.3	3458.2	3475.85	3435.3	3452.65	121856	4202.57	5751	12306	10.1


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