Name: S&P 500 Stocks Info
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

S&P 500 Stocks Info

Context

This is a Dataset of the underlying stocks of SP500. The Data is Updated to September 2021 and was taken by yahoo finance.

Tables

Sp500 Stocks Info

@kaggle.davidemattioli_sp_500_stocks_info.sp500_stocks_info

807.97 KB
505 rows
166 columns


CREATE TABLE sp500_stocks_info (
  "zip" VARCHAR,
  "sector" VARCHAR,
  "fulltimeemployees" DOUBLE,
  "longbusinesssummary" VARCHAR,
  "city" VARCHAR,
  "phone" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "companyofficers" VARCHAR,
  "website" VARCHAR,
  "maxage" BIGINT,
  "address1" VARCHAR,
  "industry" VARCHAR,
  "ebitdamargins" DOUBLE,
  "profitmargins" DOUBLE,
  "grossmargins" DOUBLE,
  "operatingcashflow" DOUBLE,
  "revenuegrowth" DOUBLE,
  "operatingmargins" DOUBLE,
  "ebitda" DOUBLE,
  "targetlowprice" DOUBLE,
  "recommendationkey" VARCHAR,
  "grossprofits" DOUBLE,
  "freecashflow" DOUBLE,
  "targetmedianprice" DOUBLE,
  "currentprice" DOUBLE,
  "earningsgrowth" DOUBLE,
  "currentratio" DOUBLE,
  "returnonassets" DOUBLE,
  "numberofanalystopinions" DOUBLE,
  "targetmeanprice" DOUBLE,
  "debttoequity" DOUBLE,
  "returnonequity" DOUBLE,
  "targethighprice" DOUBLE,
  "totalcash" DOUBLE,
  "totaldebt" DOUBLE,
  "totalrevenue" DOUBLE,
  "totalcashpershare" DOUBLE,
  "financialcurrency" VARCHAR,
  "revenuepershare" DOUBLE,
  "quickratio" DOUBLE,
  "recommendationmean" DOUBLE,
  "exchange" VARCHAR,
  "shortname" VARCHAR,
  "longname" VARCHAR,
  "exchangetimezonename" VARCHAR,
  "exchangetimezoneshortname" VARCHAR,
  "isesgpopulated" BOOLEAN,
  "gmtoffsetmilliseconds" DOUBLE,
  "underlyingsymbol" VARCHAR,
  "quotetype" VARCHAR,
  "symbol" VARCHAR,
  "underlyingexchangesymbol" VARCHAR,
  "headsymbol" VARCHAR,
  "messageboardid" VARCHAR,
  "uuid" VARCHAR,
  "market" VARCHAR,
  "annualholdingsturnover" VARCHAR,
  "enterprisetorevenue" DOUBLE,
  "beta3year" VARCHAR,
  "enterprisetoebitda" DOUBLE,
  "n_52weekchange" VARCHAR,
  "morningstarriskrating" VARCHAR,
  "forwardeps" DOUBLE,
  "revenuequarterlygrowth" VARCHAR,
  "sharesoutstanding" DOUBLE,
  "fundinceptiondate" VARCHAR,
  "annualreportexpenseratio" VARCHAR,
  "totalassets" VARCHAR,
  "bookvalue" DOUBLE,
  "sharesshort" DOUBLE,
  "sharespercentsharesout" DOUBLE,
  "fundfamily" VARCHAR,
  "lastfiscalyearend" DOUBLE,
  "heldpercentinstitutions" DOUBLE,
  "netincometocommon" DOUBLE,
  "trailingeps" DOUBLE,
  "lastdividendvalue" VARCHAR,
  "sandp52weekchange" VARCHAR,
  "pricetobook" DOUBLE,
  "heldpercentinsiders" DOUBLE,
  "nextfiscalyearend" DOUBLE,
  "yield" VARCHAR,
  "mostrecentquarter" DOUBLE,
  "shortratio" DOUBLE,
  "sharesshortpreviousmonthdate" DOUBLE,
  "floatshares" DOUBLE,
  "beta" DOUBLE,
  "enterprisevalue" DOUBLE,
  "pricehint" BIGINT,
  "threeyearaveragereturn" VARCHAR,
  "lastsplitdate" DOUBLE,
  "lastsplitfactor" VARCHAR,
  "legaltype" VARCHAR,
  "morningstaroverallrating" VARCHAR,
  "earningsquarterlygrowth" DOUBLE,
  "pricetosalestrailing12months" DOUBLE,
  "dateshortinterest" DOUBLE,
  "pegratio" DOUBLE,
  "ytdreturn" VARCHAR
);