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)	PEL	2500.35	2514.65	2525	2452.5	2465.45	402932	10018.86	23571	153904	38.20000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PEL	2465.45	2475	2493.95	2425.05	2442.7	250755	6157.08	20609	51907	20.700000762939453
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PEL	2442.7	2454.05	2473.7	2396	2437.35	271474	6598.52	18297	45531	16.770000457763672
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PEL	2437.35	2466	2480	2429	2466.2	567614	13951.1	26279	282783	49.81999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PEL	2496.25	2495	2528.9	2406.5	2422.4	986499	24240.32	51975	381004	38.619998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PEL	2466.2	2487	2526	2445	2496.25	1195915	29710.92	71706	388828	32.5099983215332
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PEL	2517.45	2530	2535.9	2456.55	2500.35	900757	22467.96	51996	366913	40.72999954223633
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PEL	1523.55	1533	1553.2	1504.65	1536.7	1536500	23482.51	40673	91324	5.94
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PEL	1536.7	1533	1545	1504.75	1524.9	927676	14168.76	26440	125057	13.48
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PEL	1524.9	1525.9	1548.45	1512.25	1523.9	858923	13162.01	27951	120294	14.01


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