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)	BAJAJ-AUTO	3621.1	3621.1	3621.1	3550	3565.35	296588	10603.15	31715	132177	44.56999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	3565.35	3570	3570	3468	3476	286849	10034.05	28190	119399	41.619998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	3476	3476.1	3512.95	3445.9	3458.65	397493	13786.08	45747	216209	54.38999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	3458.65	3452	3570	3452	3563.55	352729	12490.38	42105	92616	26.26000022888184
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	3569.35	3530	3575	3508	3566.65	339577	12053.15	30740	164010	48.29999923706055
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	3563.55	3563.35	3581.55	3545.65	3569.35	239918	8557.34	33142	122711	51.150001525878906
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	3535	3550	3650.95	3521	3621.1	760774	27520.17	65617	263630	34.650001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	3185	3183	3193.75	3142.1	3150.1	320021	10143.99	16092	55953	17.48
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	3150.1	3154.95	3172.5	3112.05	3121	452413	14158.7	25354	145229	32.1
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	3121	3125.5	3128.25	3065	3072.05	424311	13112.63	27302	162278	38.25


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