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	116.9	121	115.85	118.15	119.13020775772432	2126371	12634	253315019	396281	18.64	5.15	1.25
8-June-2021	117.2	118.5	116	116.15	117.39093506426248	2201207	14838	258401748	773370	35.13	2.5	-1.05
7-June-2021	112.5	116.75	112	116.4	114.98629168771188	1859091	13095	213769980	1046766	56.31	4.75	3.9
4-June-2021	111.1	113	111.1	111.85	112.1201640769084	471730	4900	52890445	217062	46.01	1.9	0.75
3-June-2021	111.2	112.25	110.45	111.8	111.51893803383928	275715	2130	30747444	53047	19.24	1.8	0.6
2-June-2021	111	111.35	110.15	111.1	110.87972059179005	161341	1815	17889445	48274	29.92	1.2	0.1
1-June-2021	110.65	111.4	109.55	110.1	110.39157008825708	319861	2408	35309958	74204	23.2	1.85	-0.55
31-May-2021	109	111.4	107.8	110.5	109.83643793912076	437522	3076	48055858	75814	17.33	3.6	1.5
28-May-2021	110.05	111	108.3	108.95	109.57405895179436	460444	3553	50452718	130606	28.37	2.7	-1.1
27-May-2021	111.25	111.6	109.25	110.2	110.7157673189594	630494	5555	69805627	185759	29.46	2.35	-1.05


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