Baselight

US Equity Market & Covid-19

How has the U.S. Stock market been impacted by Covid-19?

@kaggle.nroll12_us_equity_market_covid19

Loading...
Loading...

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
Loading...

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
);

Share link

Anyone who has the link will be able to view this.