# Example: Building a Sample Stock Trade Database

This tutorial shows you how to build a sample database containing millions of simulated stock trade data rows. You can use this database to test the features and functionality of SingleStore Helios. Some sample queries are also provided to show you how SingleStore Helios performs when doing concurrent reads while data is being written to disk.

## In this section

* [Step 1: Create the database](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/step-1-create-the-database.md)
* [Step 2: Load company profile data](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/step-2-load-company-profile-data.md)
* [Step 3: Create data generator functionality](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/step-3-create-data-generator-functionality.md)
* [Step 4: Generate trade data](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/step-4-generate-trade-data.md)
* [Step 5: Run analytic queries](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/step-5-run-analytic-queries.md)
* [Query 1](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/query-1.md)
* [Query 2](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/query-2.md)
* [Query 3](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/query-3.md)
* [Query 4](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/query-4.md)

***

Modified at: November 20, 2024

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

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