US Equity Market & Covid-19
How has the U.S. Stock market been impacted by Covid-19?
@kaggle.nroll12_us_equity_market_covid19
How has the U.S. Stock market been impacted by Covid-19?
@kaggle.nroll12_us_equity_market_covid19
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
);
Anyone who has the link will be able to view this.