# Step 1: Create the database

Run the following SQL statements to create a new `trades` database with two tables: `trade` and `company`. The trade table is a columnstore table that contains analytical trading related data for each company and the `company` table is a rowstore table that stores details about each company.

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

```

***

Modified at: November 20, 2024

Source: [/cloud/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/step-1-create-the-database/](https://docs.singlestore.com/cloud/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/step-1-create-the-database/)

(An index of the documentation is available at /llms.txt)