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)	BIRLACORPN	1358.9	1365	1396	1342	1353.45	76383	1046.97	9593	28745	37.630001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIRLACORPN	1353.45	1340	1340	1201.2	1318.7	188336	2459	14272	96528	51.25
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIRLACORPN	1318.7	1320	1350	1320	1328.1	127494	1704.8	12114	62512	49.02999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIRLACORPN	1328.1	1341.8	1351	1272.1	1292.1	203786	2652.02	13855	114589	56.22999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIRLACORPN	1276.4	1276.4	1276.4	1188.05	1198.4	312435	3798.3	23292	187310	59.95000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIRLACORPN	1292.1	1299.1	1317.4	1259.85	1276.4	89019	1144.93	10270	40113	45.060001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIRLACORPN	1399.8	1405	1405	1350	1358.9	70634	974.02	7161	38501	54.5099983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BIRLACORPN	610.15	610.1	615	601.35	606.7	44859	272.5	2554	32884	73.31
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BIRLACORPN	606.7	609.2	633	604.3	629.2	81768	510.6	4473	46050	56.32
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BIRLACORPN	629.2	622	629.9	620	624.3	35229	220.05	2421	25684	72.91


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