# Step 2: Load company profile data

Download [companylist.csv](https://s3.amazonaws.com/memsql-tutorial-files/companylist.csv) onto your local machine and then load it into [Stage](https://docs.singlestore.com/cloud/load-data/load-data-from-files/stage.md). Run the following command to load data into the company table using a [Pipeline](https://docs.singlestore.com/cloud/load-data/about-singlestore-pipelines.md).

```sql
USE trades;

CREATE OR REPLACE PIPELINE trades.`company`
AS LOAD DATA STAGE 'companylist.csv'
BATCH_INTERVAL 2500
DISABLE OUT_OF_ORDER OPTIMIZATION
DISABLE OFFSETS METADATA GC
SKIP DUPLICATE KEY ERRORS 
INTO TABLE `company`
FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' 
LINES TERMINATED BY '\r\n' STARTING BY '' 
FORMAT CSV
IGNORE 1 LINES
(
	`company`.`Symbol`,
	`company`.`Name`,
	`company`.`LastSale`,
	`company`.`MarketCap`,
	`company`.`IPOyear`,
	`company`.`Sector`,
	`company`.`industry`,
	`company`.`Summary Quote`,
       `company`.`extra`
);

```

```sql
START PIPELINE company;
```

***

Modified at: April 29, 2025

Source: [/cloud/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/step-2-load-company-profile-data/](https://docs.singlestore.com/cloud/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/step-2-load-company-profile-data/)

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