S&P 500 Companies Price Dynamics
Price Dynamics for S&P500 companies, S&P 500 Index, and UST10Y rates
@kaggle.alexanderkuznetsovow_s_and_p_500_companies_price_dynamics
Price Dynamics for S&P500 companies, S&P 500 Index, and UST10Y rates
@kaggle.alexanderkuznetsovow_s_and_p_500_companies_price_dynamics
CREATE TABLE yearly_returns_stocks_2018_2023 (
"company" VARCHAR,
"year" BIGINT,
"yearly_return" DOUBLE,
"risk_free_r" DOUBLE,
"excess_return" DOUBLE,
"stdev_return" DOUBLE,
"sector" VARCHAR,
"industry" VARCHAR,
"stdev_excess_return" DOUBLE,
"sharpe_ratio" DOUBLE
);
CREATE TABLE yearly_returns_index_2018_2023 (
"company" VARCHAR,
"year" BIGINT,
"yearly_return" DOUBLE,
"risk_free_r" DOUBLE,
"excess_return" DOUBLE,
"stdev_return" DOUBLE,
"sector" VARCHAR,
"industry" VARCHAR,
"stdev_excess_return" DOUBLE,
"sharpe_ratio" DOUBLE
);
CREATE TABLE clean_sp500_index_2018_2023 (
"company" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"mo_return" DOUBLE,
"gics_sector" VARCHAR,
"gics_sub_industry" VARCHAR
);
CREATE TABLE ust_10_2018_2023 (
"company" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT
);
CREATE TABLE clean_sp500_stock_2018_2023 (
"company" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"dividends" DOUBLE,
"stock_splits" DOUBLE,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"security" VARCHAR,
"gics_sector" VARCHAR,
"gics_sub_industry" VARCHAR,
"founded" VARCHAR,
"mo_return" DOUBLE,
"perform_vs_sp" DOUBLE,
"perform_flag" BIGINT,
"time_higher_sp" DOUBLE
);
Anyone who has the link will be able to view this.