Name: US Equity Market & Covid-19
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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

304.81 MB
690,323 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  -- Marketcap,
  "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
);