SP500 Csv
S&P 500 5 year monthly prices and returns 20211204
@kaggle.wmcginn_sp500_csv
S&P 500 5 year monthly prices and returns 20211204
@kaggle.wmcginn_sp500_csv
CREATE TABLE prices (
"a" DOUBLE,
"aal" DOUBLE,
"aap" DOUBLE,
"aapl" DOUBLE,
"abbv" DOUBLE,
"abc" DOUBLE,
"abmd" DOUBLE,
"abt" DOUBLE,
"acn" DOUBLE,
"adbe" DOUBLE,
"adi" DOUBLE,
"adm" DOUBLE,
"adp" DOUBLE,
"adsk" DOUBLE,
"aee" DOUBLE,
"aep" DOUBLE,
"aes" DOUBLE,
"afl" DOUBLE,
"aig" DOUBLE,
"aiz" DOUBLE,
"ajg" DOUBLE,
"akam" DOUBLE,
"alb" DOUBLE,
"algn" DOUBLE,
"alk" DOUBLE,
"all" DOUBLE,
"alle" DOUBLE,
"amat" DOUBLE,
"amcr" DOUBLE,
"amd" DOUBLE,
"ame" DOUBLE,
"amgn" DOUBLE,
"amp" DOUBLE,
"amt" DOUBLE,
"amzn" DOUBLE,
"anet" DOUBLE,
"anss" DOUBLE,
"antm" DOUBLE,
"aon" DOUBLE,
"aos" DOUBLE,
"apa" DOUBLE,
"apd" DOUBLE,
"aph" DOUBLE,
"aptv" DOUBLE,
"ato" DOUBLE,
"atvi" DOUBLE,
"avb" DOUBLE,
"avgo" DOUBLE,
"avy" DOUBLE,
"awk" DOUBLE,
"axp" DOUBLE,
"azo" DOUBLE,
"ba" DOUBLE,
"bac" DOUBLE,
"bax" DOUBLE,
"bbwi" DOUBLE,
"bby" DOUBLE,
"bdx" DOUBLE,
"ben" DOUBLE,
"bf_b" DOUBLE,
"biib" DOUBLE,
"bio" DOUBLE,
"bk" DOUBLE,
"bkng" DOUBLE,
"bkr" DOUBLE,
"blk" DOUBLE,
"bll" DOUBLE,
"bmy" DOUBLE,
"br" DOUBLE,
"brk_b" DOUBLE,
"bsx" DOUBLE,
"bwa" DOUBLE,
"bxp" DOUBLE,
"c" DOUBLE,
"cag" DOUBLE,
"cah" DOUBLE,
"cat" DOUBLE,
"cb" DOUBLE,
"cboe" DOUBLE,
"cbre" DOUBLE,
"cci" DOUBLE,
"ccl" DOUBLE,
"cdns" DOUBLE,
"cdw" DOUBLE,
"ce" DOUBLE,
"cern" DOUBLE,
"cf" DOUBLE,
"cfg" DOUBLE,
"chd" DOUBLE,
"chrw" DOUBLE,
"chtr" DOUBLE,
"ci" DOUBLE,
"cinf" DOUBLE,
"cl" DOUBLE,
"clx" DOUBLE,
"cma" DOUBLE,
"cmcsa" DOUBLE,
"cme" DOUBLE,
"cmg" DOUBLE,
"cmi" DOUBLE
);
CREATE TABLE returns (
"date" TIMESTAMP,
"a" DOUBLE,
"aal" DOUBLE,
"aap" DOUBLE,
"aapl" DOUBLE,
"abbv" DOUBLE,
"abc" DOUBLE,
"abmd" DOUBLE,
"abt" DOUBLE,
"acn" DOUBLE,
"adbe" DOUBLE,
"adi" DOUBLE,
"adm" DOUBLE,
"adp" DOUBLE,
"adsk" DOUBLE,
"aee" DOUBLE,
"aep" DOUBLE,
"aes" DOUBLE,
"afl" DOUBLE,
"aig" DOUBLE,
"aiz" DOUBLE,
"ajg" DOUBLE,
"akam" DOUBLE,
"alb" DOUBLE,
"algn" DOUBLE,
"alk" DOUBLE,
"all" DOUBLE,
"alle" DOUBLE,
"amat" DOUBLE,
"amcr" DOUBLE,
"amd" DOUBLE,
"ame" DOUBLE,
"amgn" DOUBLE,
"amp" DOUBLE,
"amt" DOUBLE,
"amzn" DOUBLE,
"anet" DOUBLE,
"anss" DOUBLE,
"antm" DOUBLE,
"aon" DOUBLE,
"aos" DOUBLE,
"apa" DOUBLE,
"apd" DOUBLE,
"aph" DOUBLE,
"aptv" DOUBLE,
"ato" DOUBLE,
"atvi" DOUBLE,
"avb" DOUBLE,
"avgo" DOUBLE,
"avy" DOUBLE,
"awk" DOUBLE,
"axp" DOUBLE,
"azo" DOUBLE,
"ba" DOUBLE,
"bac" DOUBLE,
"bax" DOUBLE,
"bbwi" DOUBLE,
"bby" DOUBLE,
"bdx" DOUBLE,
"ben" DOUBLE,
"bf_b" DOUBLE,
"biib" DOUBLE,
"bio" DOUBLE,
"bk" DOUBLE,
"bkng" DOUBLE,
"bkr" DOUBLE,
"blk" DOUBLE,
"bll" DOUBLE,
"bmy" DOUBLE,
"br" DOUBLE,
"brk_b" DOUBLE,
"bsx" DOUBLE,
"bwa" DOUBLE,
"bxp" DOUBLE,
"c" DOUBLE,
"cag" DOUBLE,
"cah" DOUBLE,
"cat" DOUBLE,
"cb" DOUBLE,
"cboe" DOUBLE,
"cbre" DOUBLE,
"cci" DOUBLE,
"ccl" DOUBLE,
"cdns" DOUBLE,
"cdw" DOUBLE,
"ce" DOUBLE,
"cern" DOUBLE,
"cf" DOUBLE,
"cfg" DOUBLE,
"chd" DOUBLE,
"chrw" DOUBLE,
"chtr" DOUBLE,
"ci" DOUBLE,
"cinf" DOUBLE,
"cl" DOUBLE,
"clx" DOUBLE,
"cma" DOUBLE,
"cmcsa" DOUBLE,
"cme" DOUBLE,
"cmg" DOUBLE
);
CREATE TABLE tickerlist (
"unnamed_0" BIGINT,
"name" VARCHAR,
"ticker" VARCHAR,
"sector" VARCHAR
);
Anyone who has the link will be able to view this.