Sample data

The small made-up stock market dataset that most help examples use, with a few rows of each.

• Category: Getting started
• Keywords: sample, fixture, demo data, example data, stock market, tutorial data, schema.sql, sample-data.sql, securities, brokers, ochl_day, ochl_minutes, trade_log, live_data, candles, trades
• See also: Quick start, CREATE TABLE, SAMPLE BY, LATEST ON, Joins

Most examples in this help use a small made-up stock market dataset: companies, brokers, price candles, trades and live prices. The names and prices only look real. It is just one example of what KDB stores; the same SQL works for sensor readings, logs and metrics, accounting, users and logins, or any app's data. The examples call it the fixture sample. Every example starts with a fresh copy, so an example that changes rows does not change the next one.

To load the same data into your own database, see quick start. The files are docs/tutorial/examples/setup/schema.sql and sample-data.sql.

Example: All tables and their row counts (sample data: sample)

SHOW TABLES;

Result:

(6 rows)

securities

Syntax:

CREATE TABLE securities (
  symbol SYMBOL PRIMARY KEY,
  name   STRING NOT NULL,
  sector STRING
);

One row per listed company. symbol is the key.

Example: All companies (sample data: sample)

SELECT symbol, name, sector FROM securities ORDER BY symbol;

Result:

(5 rows)

Example: Last daily close with the company name (a join) (sample data: sample)

SELECT s.symbol, s.name, d.close
FROM ochl_day d JOIN securities s ON s.symbol = d.symbol
WHERE d.time IN '2026-09-10'
ORDER BY s.symbol;

Result:

(3 rows)

brokers

Syntax:

CREATE TABLE brokers (
  id   INT PRIMARY KEY,
  name STRING NOT NULL
);

One row per broker. trade_log.buyer and trade_log.seller point to brokers(id) with REFERENCES.

Example: All brokers (sample data: sample)

SELECT id, name FROM brokers ORDER BY id;

Result:

(5 rows)

ochl_day

Syntax:

CREATE TABLE ochl_day (
  time   TIMESTAMP ROUND 1d,
  symbol SYMBOL,
  open   DOUBLE,
  high   DOUBLE,
  low    DOUBLE,
  close  DOUBLE,
  volume DOUBLE
) TIMESERIES(time) PARTITION BY YEAR DEDUP KEY (symbol, time);

Daily candles (open, high, low, close and volume). time is the trading date at 00:00 UTC. ROUND 1d cuts every time down to the day, and DEDUP KEY (symbol, time) allows one row per symbol per day.

• Notes: the data has two parts: 2025-12-28 to 2025-12-31, and 2026-08-23 to 2026-09-10 (trading days of a Sunday-to-Thursday trading week, as on some exchanges). So there are two partitions: 2025 and 2026.

Example: Daily candles of one day (sample data: sample)

SELECT time, symbol, open, high, low, close, volume FROM ochl_day WHERE time IN '2026-09-10' ORDER BY symbol;

Result:

(3 rows)

Example: How many days per symbol (sample data: sample)

SELECT symbol, count(*) AS days, min(time) AS first_day, max(time) AS last_day FROM ochl_day GROUP BY symbol ORDER BY symbol;

Result:

(3 rows)

ochl_minutes

Syntax:

CREATE TABLE ochl_minutes (
  time   TIMESTAMP ROUND 1m,
  symbol SYMBOL,
  open   DOUBLE,
  high   DOUBLE,
  low    DOUBLE,
  close  DOUBLE,
  volume DOUBLE
) TIMESERIES(time) PARTITION BY MONTH DEDUP KEY (symbol, time);

One-minute candles. The market is open 11:00 to 15:00 local time (+05:45, Nepal time), which is 05:15 to 09:15 UTC, so a full day has 240 minutes.

• Notes: only CITY (480 rows) and COAST (476 rows) have minute candles, on 2026-09-09 and 2026-09-10.

Example: The first 5 minutes of CITY on 2026-09-10 (11:00 Nepal time) (sample data: sample)

SELECT time, symbol, open, high, low, close, volume
FROM ochl_minutes
WHERE symbol = 'CITY' AND time >= '2026-09-10T11:00:00+05:45'
ORDER BY time
LIMIT 5;

Result:

(5 rows)

Example: Minute candles turned into hourly candles (sample data: sample)

SELECT time, first(open) AS open, max(high) AS high, min(low) AS low, last(close) AS close, sum(volume) AS volume
FROM ochl_minutes
WHERE symbol = 'COAST' AND time IN '2026-09-09'
SAMPLE BY 1h;

Result:

(5 rows)

trade_log

Syntax:

CREATE TABLE trade_log (
  date           TIMESTAMP ROUND 1d,
  transaction_id LONG,
  symbol         SYMBOL,
  buyer          INT REFERENCES brokers(id),
  seller         INT REFERENCES brokers(id),
  quantity       LONG,
  rate           DOUBLE,
  amount         DOUBLE AS (quantity * rate)
) TIMESERIES(date) PARTITION BY DAY DEDUP KEY (date, transaction_id);

Every trade of the day: who bought, who sold, how many shares and at what rate. amount is a computed column: it is not stored, KDB works it out from quantity * rate when you read it.

• Notes: a broker that trades point to cannot be deleted from brokers.

Example: The first trades of 2026-09-10 with broker names (sample data: sample)

SELECT f.transaction_id, f.symbol, b.name AS buyer, s.name AS seller, f.quantity, f.rate, f.amount
FROM trade_log f
JOIN brokers b ON b.id = f.buyer
JOIN brokers s ON s.id = f.seller
WHERE f.date IN '2026-09-10'
ORDER BY f.transaction_id
LIMIT 5;

Result:

(5 rows)

Example: Turnover per symbol (sample data: sample)

SELECT symbol, count(*) AS trades, sum(quantity) AS shares, sum(amount) AS turnover
FROM trade_log
GROUP BY symbol
ORDER BY turnover DESC;

Result:

(4 rows)

live_data

Syntax:

CREATE TABLE live_data (
  timestamp        TIMESTAMP,
  symbol           SYMBOL,
  ltp              DOUBLE,
  ltv              LONG,
  point_change     DOUBLE,
  pct_change       DOUBLE,
  open             DOUBLE,
  high             DOUBLE,
  low              DOUBLE,
  avg_traded_price DOUBLE,
  prev_close       DOUBLE,
  volume           LONG
) TIMESERIES(timestamp) PARTITION BY DAY DEDUP KEY (timestamp, symbol);

Snapshots of live market prices: last traded price (ltp), last traded volume (ltv), change from the previous close, and the day's open, high, low and volume so far.

• Notes: the snapshots are at 11:05, 13:00 and 14:59 Nepal time on 2026-09-10. The time column is called timestamp; that word is not reserved.

Example: The latest price of every symbol (sample data: sample)

SELECT timestamp, symbol, ltp, pct_change, volume
FROM live_data
LATEST ON timestamp PARTITION BY symbol
ORDER BY symbol;

Result:

(4 rows)

Example: All snapshots of TELCO (sample data: sample)

SELECT timestamp, ltp, point_change, pct_change FROM live_data WHERE symbol = 'TELCO' ORDER BY timestamp;

Result:

(3 rows)