Order flow, executions, positions, and margin for a retail broker
Industry
Online Brokerage
Company size
Growth-stage retail broker with 8,000 funded accounts held by 6,000 customers across five US regions
Tradeable universe
240 fictional instruments spanning equities, ETFs, listed options, crypto, and mutual funds
Packaged scale
About 2.1 million rows across 13 Professional-tier tables, including 1,075,000 executed trades
Trading activity
Roughly 537,000 trades per year on about $1.2B of notional, with Platinum accounts trading at six times the Bronze ticket
Trading revenue
About $1.0M per year in commission and order-flow revenue plus roughly $3.2M in margin interest
Assets and flows
Customer equity near $0.38B, with about $159M of deposits and $63M of withdrawals per year
Vantroe Securities is a fictional growth-stage online brokerage used for synthetic BI analysis. The company story is built around self-directed retail trading: the funded accounts customers open, the orders they place across mobile, web, desktop, and API channels, the trades that fill, the revenue those trades earn, the cash that moves, the positions held at month-end, and the margin some accounts borrow. Everything here is invented for analytics practice. No real broker, exchange, market maker, clearing firm, security, ticker symbol, account holder, or person is represented, and the tickers and security names are entirely fictional.
These are the operating questions this kit is optimized to answer first.
Revenue rises through spring and eases in midsummer, while options, crypto, and fund buys each peak at different times.
Equities carry most of the flow while options and crypto, a seventh of trades, earn nearly two-thirds of revenue.
Risk tolerance gates options and crypto approval, so conservative customers trade and hold neither.
Higher tiers trade more often and in larger size, so activity, ticket, and revenue per account rise together.
Dormant, restricted, and suspended accounts stop trading at their own cutoff, so lifecycle views agree with the blotter.
Margin balances earn interest while a small share of accounts fall below their maintenance requirement.