Step 1: Create the database

CREATE DATABASE trades;

USE trades;

DROP TABLE IF EXISTS trade;
CREATE TABLE trade(
 id BIGINT NOT NULL,
 stock_symbol CHAR(5) NOT NULL,
 shares DECIMAL(18,4) NOT NULL,
 share_price DECIMAL(18,4) NOT NULL,
 trade_time DATETIME(6) NOT NULL,
 SORT KEY(stock_symbol),
 SHARD KEY(stock_symbol)
);


DROP TABLE IF EXISTS company;
CREATE ROWSTORE TABLE company(
  `Symbol` VARCHAR(50) NOT NULL,  
  `Name` VARCHAR(255),            
  `LastSale` VARCHAR(10),
  `MarketCap` VARCHAR(15),
  `IPOyear` VARCHAR(10),          
  `Sector` VARCHAR(80),
  `industry` VARCHAR(80),
  `Summary Quote` VARCHAR(50),
  `extra` VARCHAR(50)
);