Saudi Daily Stocks History (Tadawul)
Daily Historical Data for All Saudi Stocks
@kaggle.aldukhi2_saudi_daily_stocks_history_test
Daily Historical Data for All Saudi Stocks
@kaggle.aldukhi2_saudi_daily_stocks_history_test
The motive behind collecting this dataset is to provide a historical data for all Saudi stocks, where you can build your own predictive models in the hope of making millions of SARs.
The dataset was collected using Selenium on Python from Tadawul. For some stocks, the website can go back until 2001. The stocks vary in their starting time period but end on March 19, 2020, the day in which the dataset was collected.
The dataset was generated to satisfy requirements for General Assembly Data Science Immersive Program.
Few things might be interesting to investigate:
The dataset only gives information about daily trends (opening, closing, change, etc.) Unfortunately, the information about hourly prices cannot be found on Tadawul website.
CREATE TABLE dur_4010 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE eic_1303 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE emaar_ec_4220 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE enaya_8311 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE epcco_3080 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE etihad_etisalat_7020 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE extra_4003 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE farm_superstores_4006 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE fipco_2180 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE fitaihi_group_4180 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE fitness_time_1830 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE gaco_6020 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE gasco_2080 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE gulf_general_8260 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE gulf_union_8120 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE hb_6001 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE hcc_3001 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE herfy_foods_6002 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE jabal_omar_4250 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE jadwa_reit_alharamain_4332 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE jadwa_reit_saudi_4342 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE jarir_4190 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE jazadco_6090 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE jazira_takaful_8012 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);CREATE TABLE jouf_cement_3091 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"change" DOUBLE,
"change_percent" DOUBLE,
"volume_traded" DOUBLE,
"value_traded_sar" DOUBLE,
"number_trades" BIGINT
);Anyone who has the link will be able to view this.