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)	RELAXO	1301.85	1299	1318	1295.3	1310.3	119036	1551.87	12752	75263	63.22999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELAXO	1310.3	1319.15	1319.15	1282.65	1293.9	161902	2098.42	20801	98239	60.68000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELAXO	1293.9	1302.95	1315	1285	1305.45	991705	12844.24	9560	950425	95.83999633789062
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELAXO	1305.45	1314.25	1332.5	1305	1309.2	388071	5084.45	12015	131996	34.0099983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELAXO	1310.15	1285.2	1311.1	1285.2	1295.2	62169	806.6	8563	25467	40.959999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELAXO	1309.2	1319	1332	1303.65	1310.15	81666	1075.09	8968	35658	43.65999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELAXO	1307.7	1323.65	1339.85	1286.25	1301.85	143451	1895.4	15491	70888	49.41999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RELAXO	615.75	618.25	622	614.1	615.15	146160	904.14	5198	125831	86.09
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RELAXO	615.15	618.7	625.85	615.5	621.8	223722	1395.15	7833	182431	81.54
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RELAXO	621.8	624.2	631.15	621.5	629.4	120926	759.67	6923	77575	64.15


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