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	5781	5786.95	5626.25	5674.15	5722.507799861029	377058	14495	2157717346	289534	76.79	160.7	-106.85
8-June-2021	5765	5817.55	5720.05	5756.5	5771.343461491117	48742	5920	281306823	8467	17.37	97.5	-8.5
7-June-2021	5813.6	5847.35	5681.2	5728.2	5734.833626114881	162237	24121	930402203	56313	34.71	166.15	-85.4
4-June-2021	5914	6009	5890.3	5993.55	5959.400743003833	110632	12231	659300423	30186	27.28	118.7	79.55
3-June-2021	5844.45	5916.45	5780	5901.65	5865.055105562079	83458	7871	489485769	11572	13.87	136.45	57.2
2-June-2021	5767	5844.8	5740	5808	5794.018897174476	88373	11029	512034832	23029	26.06	104.8	41
1-June-2021	5625	5817	5625	5786.1	5739.293114334321	114034	11446	654474551	21196	18.59	192	161.1
31-May-2021	5617	5662.15	5562.15	5621.15	5614.915690565065	54383	5506	305355960	6987	12.85	100	4.15
28-May-2021	5742	5750	5591.85	5609.55	5658.927667900582	94550	10357	535051611	16948	17.92	158.15	-132.45
27-May-2021	5775.35	5782.95	5652	5683.3	5696.880325785039	84964	11685	484029740	17490	20.59	130.95	-92.05


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