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	3620	3620	3556.55	3577.6	3582.4741732337657	29059	2810	104103117	15069	51.86	63.45	-42.4
8-June-2021	3520	3622	3520	3600.35	3596.810851622424	58277	9044	209611346	40736	69.9	102	80.35
7-June-2021	3500	3554	3477	3542.7	3521.137458247641	68559	6446	241405663	37781	55.11	77	42.7
4-June-2021	3498	3512	3480.05	3490.65	3495.4062841198593	8243	1254	28812634	4055	49.19	31.95	-7.35
3-June-2021	3485.85	3499.45	3469.05	3495.95	3488.4715387823185	9592	1418	33461419	6918	72.12	30.4	10.1
2-June-2021	3459	3485	3448	3474.8	3472.897112264763	30820	3900	107034689	24294	78.83	37	15.8
1-June-2021	3454	3468.95	3442.25	3448.55	3454.117559912854	11475	1390	39635999	4071	35.48	26.7	-5.45
31-May-2021	3425.2	3458	3425.2	3447.7	3444.8869993962567	19876	1976	68470574	13197	66.4	32.8	22.5
28-May-2021	3420	3448.95	3410.05	3421.55	3426.6576822029774	30831	4371	105647283	17556	56.94	38.9	1.55
27-May-2021	3420.1	3437.25	3400	3417.25	3416.579448144624	42040	6950	143633000	28023	66.66	37.25	-2.85


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