Tata Steel Stock Dataset (2015-2021)

TATA STEEL - NSE Stock Data - India

@kaggle.ankitthebemer_tata_steel_stock_dataset_20152021

Table List

1 table(114.39 KB)

Tata Steel

@kaggle.ankitthebemer_tata_steel_stock_dataset_20152021.tata_steel

114.39 KB
1485 rows
13 columns

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
03-Jul-15	308	308	299.75	300.95	302.7081797	499554	6430	151219082	118810	23.78	8.25	-7.05
06-Jul-15	294.9	299.6	292.3	298.75	295.6463382	663354	9184	196118181	117663	17.74	7.3	3.85
07-Jul-15	300.75	303.25	296	297.45	299.4776911	877207	8581	262703927	211277	24.09	7.25	-3.3
08-Jul-15	293.8	294	282	283.4	286.8751048	1446189	20272	414875621	563505	38.96	12	-10.4
09-Jul-15	285.2	287.25	279.6	280.55	282.860975	974983	13946	275784642	330248	33.87	7.65	-4.65
10-Jul-15	282	284.6	279	280.95	281.4063217	702436	9268	197669931	135447	19.28	5.6	-1.05
13-Jul-15	281.9	285.6	279.15	284.45	282.9054475	658957	8413	186422525	136197	20.67	6.45	2.55
14-Jul-15	285	286.9	281.05	281.7	283.2753122	561904	7309	159173531	140665	25.03	5.85	-3.3
15-Jul-15	283	284.9	279.4	280.7	281.9298044	564323	7346	159099473	139267	24.68	5.5	-2.3
16-Jul-15	285	286.75	280.6	281.5	282.7526205	932539	10996	263677846	230537	24.72	6.15	-3.5


CREATE TABLE tata_steel (
  "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" BIGINT,
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);