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	3202	3220.8	3187.8	3199.5	3201.741251039536	88982	8297	284897340	42721	48.01	33	-2.5
8-June-2021	3200	3231.55	3190.2	3200.5	3212.9166894374107	65874	5621	211647674	16901	25.66	41.35	0.5
7-June-2021	3155	3189.95	3134	3181.8	3156.9672028736527	38418	3693	121284366	13703	35.67	55.95	26.8
4-June-2021	3130	3156.95	3125.1	3143.15	3140.935705142932	60938	5713	191402340	27227	44.68	31.85	13.15
3-June-2021	3150	3154.95	3122.4	3141.45	3136.121666587441	42074	3464	131949183	10994	26.13	32.55	-8.55
2-June-2021	3154	3155.7	3116.15	3129.3	3126.452987140304	69364	8094	216863285	28575	41.2	39.55	-24.7
1-June-2021	3170	3170	3132	3153.4	3148.5083617963314	39525	4052	124444793	14477	36.63	38	-16.6
31-May-2021	3150	3170	3129	3158.95	3154.1929605408186	81654	8309	257552472	39348	48.19	41	8.95
28-May-2021	3190	3197.65	3137	3144.1	3162.179615900351	90237	9404	285345602	34916	38.69	60.65	-45.9
27-May-2021	3165.4	3218	3162.95	3180.2	3198.589443339516	89498	6613	286267358	21493	24.02	55.05	14.8


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