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)	BALAMINES	3604.9	3642	3686.9	3457	3509.1	91816	3294.51	12968	36394	39.63999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALAMINES	3509.1	3500	3546.8	3400.05	3422.1	52937	1835.35	8415	24920	47.06999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALAMINES	3422.1	3448	3462.5	3199	3222.8	129036	4214.21	16921	80504	62.38999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALAMINES	3222.8	3255	3295	3093.55	3120.45	159824	5019.53	21229	89752	56.15999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALAMINES	3127	3126	3158.85	2959	2996.05	145229	4421.89	20568	94379	64.98999786376953
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALAMINES	3120.45	3148	3225	3105.4	3127	97436	3082.71	10991	47632	48.88999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALAMINES	3374.05	3636	3714.75	3552	3604.9	270536	9780.8	35430	88740	32.79999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BALAMINES	399.3	404.7	420	399	415.85	124076	511.86	6374	45145	36.38
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BALAMINES	415.85	415	423	408.5	412.15	74358	309.5	2977	29918	40.24
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BALAMINES	412.15	412	412.95	401.25	404.65	27363	111.32	1589	12266	44.83


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