Dataset: US Equity Market & Covid-19

About this Dataset

US Equity Market & Covid-19

Context

90 days of comprehensive stock market data for the end of 2020.

Content

Values gathered at EOD for each equity.

Acknowledgements

Data synthesized from IEX, Yahoo Finance, Google Finance, and the SEC

Tables

Equities

@kaggle.nroll12_us_equity_market_covid19.equities

290.69 MB
690323 rows
100 columns


CREATE TABLE equities (
  "symbol" VARCHAR,
  "date" VARCHAR,
  "ceo" VARCHAR,
  "address" VARCHAR,
  "address2" VARCHAR,
  "avg10volume" DOUBLE,
  "avg30volume" DOUBLE,
  "avgtotalvolume" DOUBLE,
  "beta" DOUBLE,
  "calculationprice" VARCHAR,
  "change" DOUBLE,
  "changepercent" DOUBLE,
  "city" VARCHAR,
  "close" DOUBLE,
  "closesource" VARCHAR,
  "closetime" DOUBLE,
  "companyname" VARCHAR,
  "country" VARCHAR,
  "day200movingavg" DOUBLE,
  "day30changepercent" DOUBLE,
  "day50movingavg" DOUBLE,
  "day5changepercent" DOUBLE,
  "delayedprice" DOUBLE,
  "delayedpricetime" DOUBLE,
  "description" VARCHAR,
  "dividendyield" DOUBLE,
  "employees" DOUBLE,
  "exdividenddate" VARCHAR,
  "exchange" VARCHAR,
  "extendedchange" DOUBLE,
  "extendedchangepercent" DOUBLE,
  "extendedprice" DOUBLE,
  "extendedpricetime" DOUBLE,
  "float" BIGINT,
  "high" DOUBLE,
  "highsource" VARCHAR,
  "hightime" DOUBLE,
  "iexaskprice" DOUBLE,
  "iexasksize" BIGINT,
  "iexbidprice" DOUBLE,
  "iexbidsize" BIGINT,
  "iexclose" DOUBLE,
  "iexclosetime" DOUBLE,
  "iexlastupdated" DOUBLE,
  "iexmarketpercent" DOUBLE,
  "iexopen" DOUBLE,
  "iexopentime" DOUBLE,
  "iexrealtimeprice" DOUBLE,
  "iexrealtimesize" BIGINT,
  "iexvolume" BIGINT,
  "industry" VARCHAR,
  "isusmarketopen" VARCHAR,
  "issuetype" VARCHAR,
  "lasttradetime" DOUBLE,
  "latestprice" DOUBLE,
  "latestsource" VARCHAR,
  "latesttime" VARCHAR,
  "latestupdate" DOUBLE,
  "latestvolume" BIGINT,
  "low" DOUBLE,
  "lowsource" VARCHAR,
  "lowtime" DOUBLE,
  "marketcap" DOUBLE,
  "marketcap_db2c1a" DOUBLE,
  "maxchangepercent" DOUBLE,
  "month1changepercent" DOUBLE,
  "month3changepercent" DOUBLE,
  "month6changepercent" DOUBLE,
  "nextdividenddate" VARCHAR,
  "nextearningsdate" VARCHAR,
  "nextprice" DOUBLE,
  "oddlotdelayedprice" DOUBLE,
  "oddlotdelayedpricetime" DOUBLE,
  "open" DOUBLE,
  "opensource" VARCHAR,
  "opentime" DOUBLE,
  "peratio" DOUBLE,
  "phone" VARCHAR,
  "previousclose" DOUBLE,
  "previousvolume" DOUBLE,
  "primaryexchange" VARCHAR,
  "primarysiccode" BIGINT,
  "sector" VARCHAR,
  "securityname" VARCHAR,
  "sharesoutstanding" BIGINT,
  "state" VARCHAR,
  "tags" VARCHAR,
  "ttmdividendrate" DOUBLE,
  "ttmeps" DOUBLE,
  "volume" BIGINT,
  "website" VARCHAR,
  "week52high" DOUBLE,
  "week52low" DOUBLE,
  "week52change" DOUBLE,
  "year1changepercent" DOUBLE,
  "year2changepercent" DOUBLE,
  "year5changepercent" DOUBLE,
  "ytdchange" DOUBLE,
  "ytdchangepercent" DOUBLE,
  "zip" VARCHAR
);