S&P BSE SENSEX 50

date Date	open_price Open Price	high_price High Price	low_price Low Price	close_price Close Price	wap WAP	no_of_shares No.of Shares	no_of_trades No. Of Trades	total_turnover_rs Total Turnover (Rs.)	deliverable_quantity Deliverable Quantity	n__deli_qty_to_traded_qty % Deli. Qty To Traded Qty	spread_high_low Spread High-Low	spread_close_open Spread Close-Open
9-June-2021	4271.3	4271.3	4201	4222.3	4233.456301531212	8490	1212	35942044	1634	19.25	70.3	-49
8-June-2021	4250	4275	4237.8	4269.55	4262.542088438999	7508	1322	32003166	2836	37.77	37.2	19.55
7-June-2021	4288.7	4288.7	4241.6	4249.85	4261.676475003753	6661	937	28387027	1600	24.02	47.1	-38.85
4-June-2021	4273	4294.45	4241.9	4249.35	4257.600207792208	9625	1735	40979402	2892	30.05	52.55	-23.65
3-June-2021	4306	4306	4244.5	4274.35	4261.245391378332	14104	1691	60100605	3184	22.58	61.5	-31.65
2-June-2021	4230.05	4310	4195.8	4294.75	4258.389587426326	15270	2422	65025609	6274	41.09	114.2	64.7
1-June-2021	4229	4347.95	4225	4239.2	4283.838462059468	44293	5889	189744057	4642	10.48	122.95	10.2
31-May-2021	4190	4229.9	4167.05	4189.5	4192.346341772955	15759	2241	66067186	4738	30.07	62.85	-0.5
28-May-2021	4177.3	4258.15	4177.3	4200.3	4217.603479367773	9427	1933	39759348	3243	34.4	80.85	23
27-May-2021	4191	4265	4152	4246.2	4221.930001308387	15286	2241	64536422	3065	20.05	113	55.2


CREATE TABLE bajajauto (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT,
  "total_turnover_rs" DOUBLE,
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);