Back to Query Agent

Database Schema

accounts

Synthetic brokerage accounts.

account_idINTEGER
name		TEXT
country		TEXT
account_type		TEXT
created_at		TEXT

instruments

Real NASDAQ/NYSE tickers with company names.

tickerTEXT
name		TEXT
asset_class		TEXT
exchange		TEXT

orders

Historical trade orders.

order_idINTEGER
account_idINTEGER→ accounts.account_id
tickerTEXT→ instruments.ticker
side		TEXT
qty		INTEGER
price		REAL
status		TEXT
created_at		TEXT

positions

Aggregated positions derived from filled orders.

account_idINTEGER→ accounts.account_id
tickerTEXT→ instruments.ticker
shares_held		INTEGER
avg_cost		REAL
last_updated		TEXT

prices

Historical OHLCV market data.

tickerTEXT→ instruments.ticker
date		TEXT
open		REAL
high		REAL
low		REAL
close		REAL
volume		INTEGER