# Create Database and Tables

Connect to your SingleStore deployment and run the following SQL commands to create a database named **trades** and two associated tables.

> **📝 Note**: The **SQL Editor** only runs the queries that you select, so ensure you have them all selected before selecting **Run**.

```sql
DROP DATABASE IF EXISTS trades;
CREATE DATABASE trades;
USE trades;

CREATE TABLE company (
  symbol char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  name varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  last_sale varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  market_cap varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  IPO_year float DEFAULT NULL,
  sector varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  industry varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  summary_quote varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  extra varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  SORT KEY __UNORDERED ()
  , SHARD KEY () 
);

CREATE TABLE trade (
  id bigint(20) NOT NULL,
  stock_symbol char(5) CHARACTER SET utf8 COLLATE utf8_general_ci 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 (stock_symbol),
  SHARD KEY __SHARDKEY (stock_symbol)
);

```

***

Modified at: May 22, 2026

Source: [/db/v9.1/introduction/sample-data/load-stock-trading-data-into-singlestore/create-database-and-tables/](https://docs.singlestore.com/db/v9.1/introduction/sample-data/load-stock-trading-data-into-singlestore/create-database-and-tables/)

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