Top 48 Automakers Daily Stock Prices 2010-2022

CREATE TABLE automakers_stocks_2010_2022 (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "adj_close" DOUBLE,
  "close" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "volume" DOUBLE
);

CREATE TABLE largest_automakers_by_market_capitalization (
  "rank" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "marketcap" BIGINT,
  "price_usd" DOUBLE,
  "country" VARCHAR
);