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	7335	7335	7200	7240	7251.424240267596	14051	2961	101889762	3996	28.44	135	-95
8-June-2021	7305	7364	7290	7335.7	7331.204714865765	33002	6449	241944418	17434	52.83	74	30.7
7-June-2021	7231	7329.25	7211.5	7279.3	7281.60687096155	15631	2588	113818797	4382	28.03	117.75	48.3
4-June-2021	7199	7270	7158.35	7213.95	7222.247845011521	11717	2131	84623078	3077	26.26	111.65	14.95
3-June-2021	7185	7277.05	7166.5	7207.45	7204.185294339908	13233	2428	95332984	4096	30.95	110.55	22.45
2-June-2021	7079	7198.9	7044.55	7183.1	7141.249549489421	14983	3424	106997342	5402	36.05	154.35	104.1
1-June-2021	7100	7141.9	7047.05	7091.05	7102.617334107177	36183	9074	256994003	16296	45.04	94.85	-8.95
31-May-2021	6984	7099.8	6926.05	7087.35	7043.334760705289	35730	4303	251658351	17836	49.92	173.75	103.35
28-May-2021	6980	7051.2	6928.2	6955.95	6975.29318083104	13814	2382	96356700	3675	26.6	123	-24.05
27-May-2021	7039	7068.75	6945	6964.15	7012.612878595062	23574	2883	165315336	4821	20.45	123.75	-74.85


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