Reference

Generated from source — do not hand-edit. Rendered from platform/src/lib/adapters/alpaca/AlpacaBrokerAdapter.ts, platform/src/lib/adapters/coinbase/CoinbaseBrokerAdapter.ts, platform/src/lib/adapters/hyperliquid/HyperliquidBrokerAdapter.ts, platform/src/lib/adapters/kalshi/KalshiBrokerAdapter.ts, platform/src/lib/adapters/kraken/KrakenBrokerAdapter.ts, platform/src/lib/adapters/polymarket/PolymarketGlobalAdapter.ts, platform/src/lib/adapters/polymarket/us/PolymarketUsAdapter.ts, platform/src/lib/adapters/schwab/SchwabBrokerAdapter.ts, platform/src/lib/adapters/tradier/TradierBrokerAdapter.ts, platform/src/lib/adapters/tradovate/TradovateBrokerAdapter.ts by pnpm --filter docsite gen:reference; a test fails when it drifts.

VectarisQL collections by broker

Collections are tabular data declared by the broker adapter you are connected to — the ORDERS, POSITIONS, ACCOUNTS, BALANCES rows in a DataGrid. Project columns with [COL, ...], filter with WHERE, sort with ORDER BY, cap with LIMIT:N (see the grammar). Column names are matched case-insensitively and aliases resolve to the canonical column.

Availability

Collection	Alpaca	Coinbase	Hyperliquid	Kalshi	Kraken	Polymarket	Polymarket US	Schwab	Tradier	Tradovate
`ACCOUNTS`	✓	—	—	—	—	—	—	✓	✓	✓
`BALANCES`	✓	✓	✓	✓	✓	✓	✓	✓	✓	—
`FILLS`	—	✓	✓	✓	—	✓	✓	—	—	—
`ORDERS`	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
`POSITIONS`	✓	—	✓	✓	✓	✓	✓	✓	✓	✓

Alpaca

Intervals: 1m, 5m, 15m, 30m, 1H, 4H, 1D, 1W, 1M

ACCOUNTS

Alpaca broker accounts

Column	Type	Aliases
`id`	string
`name`	string
`broker`	string
`type`	string
`status`	string
`equity`	number
`buyingPower`	number	`bp`
`cashBalance`	number

Default columns: name, broker, type, status, equity, buyingPower

ORDER BY: yes · LIMIT: yes · Parameter: no

BALANCES

Account balances

Column	Type	Aliases
`accountId`	string
`equity`	number
`buyingPower`	number	`bp`
`cashBalance`	number
`currency`	string

Default columns: accountId, equity, buyingPower, cashBalance

ORDER BY: yes · LIMIT: yes · Parameter: no

ORDERS

Recent orders

Column	Type	Aliases
`accountId`	string
`id`	string
`symbol`	string
`side`	string
`type`	string
`quantity`	number	`qty`
`price`	number
`stopPrice`	number
`filledQuantity`	number	`filledQty`
`avgFillPrice`	number
`status`	string
`time`	string	`submittedAt`
`duration`	string

Default columns: symbol, side, type, quantity, status, price, time

ORDER BY: yes · LIMIT: yes · Parameter: no

POSITIONS

Open positions

Column	Type	Aliases
`accountId`	string
`symbol`	string
`side`	string
`quantity`	number	`qty`
`avgCost`	number	`avgEntryPrice`
`lastPrice`	number	`currentPrice`
`marketValue`	number
`unrealizedPnL`	number	`pnl`
`unrealizedPnLPct`	number
`realizedPnL`	number

Default columns: symbol, side, quantity, marketValue, unrealizedPnL, lastPrice

ORDER BY: yes · LIMIT: yes · Parameter: no

Coinbase

Intervals: 1m, 5m, 15m, 30m, 1H, 2H, 6H, 1D

BALANCES

Coinbase account balances

Column	Type	Aliases
`asset`	string
`available`	number
`hold`	number
`total`	number
`currency`	string

Default columns: asset, available, hold, total

ORDER BY: yes · LIMIT: yes · Parameter: no

FILLS

Trade fills

Column	Type	Aliases
`tradeId`	string
`orderId`	string
`productId`	string
`side`	string
`price`	number
`size`	number
`commission`	number
`tradeTime`	date

Default columns: productId, side, price, size, commission, tradeTime

ORDER BY: yes · LIMIT: yes · Parameter: no

ORDERS

Historical orders

Column	Type	Aliases
`accountId`	string
`id`	string	`orderId`
`symbol`	string	`productId`
`side`	string
`type`	string
`quantity`	number
`price`	number
`stopPrice`	number
`filledQuantity`	number	`filledSize`
`avgFillPrice`	number	`avgPrice`
`status`	string
`time`	string	`createdAt`
`duration`	string

Default columns: symbol, side, type, status, filledQuantity, avgFillPrice

ORDER BY: yes · LIMIT: yes · Parameter: no

Hyperliquid

Intervals: 1m, 3m, 5m, 15m, 30m, 1H, 2H, 4H, 8H, 12H, 1D, 3D, 1W, 1M

BALANCES

Perps margin account and spot holdings

Column	Type	Aliases
`asset`	string	`coin`
`balance`	number	`total`
`available`	number	`withdrawable`
`held`	number	`hold`, `marginUsed`
`currency`	string
`account`	string

Default columns: asset, balance, available, account

ORDER BY: yes · LIMIT: yes · Parameter: no

FILLS

Trade fill history (most recent 2000)

Column	Type	Aliases
`trade_id`	string	`tid`
`order_id`	string	`oid`
`symbol`	string	`coin`
`side`	string
`direction`	string	`dir`
`price`	number	`px`
`size`	number	`sz`
`fee`	number
`fee_token`	string
`closed_pnl`	number	`closedPnl`
`is_taker`	boolean	`crossed`
`time`	date
`hash`	string

Default columns: symbol, side, direction, price, size, fee, time

ORDER BY: yes · LIMIT: yes · Parameter: no

ORDERS

Open orders, including resting triggers

Column	Type	Aliases
`accountId`	string
`id`	string	`oid`, `orderId`
`symbol`	string	`coin`
`side`	string
`type`	string
`quantity`	number	`size`, `sz`
`price`	number	`limitPx`
`stopPrice`	number	`triggerPx`
`filledQuantity`	number	`filled`
`avgFillPrice`	number
`status`	string
`time`	string	`timestamp`
`duration`	string	`tif`

Default columns: symbol, side, type, quantity, price, status, time

ORDER BY: yes · LIMIT: yes · Parameter: no

POSITIONS

Open perpetual positions and spot holdings

Column	Type	Aliases
`accountId`	string
`symbol`	string	`coin`
`side`	string
`quantity`	number	`size`, `szi`
`avgCost`	number	`entryPx`
`lastPrice`	number	`markPx`
`marketValue`	number	`positionValue`
`unrealizedPnL`	number	`unrealizedPnl`, `pnl`
`unrealizedPnLPct`	number	`returnOnEquity`
`realizedPnL`	number
`leverage`	number
`liquidationPrice`	number	`liquidationPx`
`marginUsed`	number

Default columns: symbol, side, quantity, avgCost, unrealizedPnL, leverage, liquidationPrice

ORDER BY: yes · LIMIT: yes · Parameter: no

Kalshi

Intervals: 1m, 5m, 15m, 30m, 1H, 2H, 4H, 12H, 1D, 1W

BALANCES

Account balance

Column	Type	Aliases
`balance`	number
`payout`	number
`currency`	string

Default columns: balance, payout, currency

ORDER BY: no · LIMIT: yes · Parameter: no

FILLS

Trade fill history

Column	Type	Aliases
`trade_id`	string
`order_id`	string
`ticker`	string
`action`	string
`side`	string
`count`	number
`yes_price`	number
`no_price`	number
`created_time`	date
`is_taker`	boolean

Default columns: ticker, action, side, count, yes_price, created_time

ORDER BY: yes · LIMIT: yes · Parameter: no

ORDERS

Active and recent orders

Column	Type	Aliases
`accountId`	string
`id`	string	`order_id`
`symbol`	string	`ticker`
`side`	string
`type`	string
`quantity`	number	`count`
`price`	number
`stopPrice`	number
`filledQuantity`	number
`avgFillPrice`	number
`status`	string
`time`	string	`created_time`
`duration`	string

Default columns: symbol, side, type, quantity, price, status, time

ORDER BY: yes · LIMIT: yes · Parameter: no

POSITIONS

Open positions in prediction markets

Column	Type	Aliases
`accountId`	string
`symbol`	string	`ticker`
`side`	string
`quantity`	number	`qty`
`avgCost`	number	`average_price`
`lastPrice`	number
`marketValue`	number	`market_value`
`unrealizedPnL`	number	`unrealized_pnl`
`unrealizedPnLPct`	number
`realizedPnL`	number	`realized_pnl`

Default columns: symbol, side, quantity, avgCost, unrealizedPnL

ORDER BY: yes · LIMIT: yes · Parameter: no

Kraken

Intervals: 1m, 5m, 15m, 30m, 1H, 4H, 1D, 1W

BALANCES

Kraken account balances

Column	Type	Aliases
`asset`	string
`balance`	number
`currency`	string

Default columns: asset, balance

ORDER BY: yes · LIMIT: yes · Parameter: no

ORDERS

Open orders

Column	Type	Aliases
`id`	string	`orderId`
`symbol`	string	`pair`
`side`	string
`type`	string
`quantity`	number
`price`	number
`stopPrice`	number
`filledQuantity`	number	`filled`
`avgFillPrice`	number
`status`	string
`time`	string	`openedAt`
`duration`	string
`accountId`	string

Default columns: symbol, side, type, price, quantity, filledQuantity, status

ORDER BY: yes · LIMIT: yes · Parameter: no

POSITIONS

Open positions

Column	Type	Aliases
`symbol`	string	`pair`
`side`	string
`quantity`	number
`avgCost`	number	`cost`
`lastPrice`	number
`marketValue`	number	`value`
`unrealizedPnL`	number	`pnl`
`unrealizedPnLPct`	number
`realizedPnL`	number
`accountId`	string

Default columns: symbol, side, quantity, avgCost, marketValue, unrealizedPnL

ORDER BY: yes · LIMIT: yes · Parameter: no

Polymarket

Intervals: 1m, 5m, 15m, 30m, 1H, 2H, 4H, 12H, 1D, 1W

BALANCES

USDC balance and the value of open positions

Column	Type	Aliases
`balance`	number
`payout`	number	`positions_value`
`currency`	string

Default columns: balance, payout, currency

ORDER BY: no · LIMIT: yes · Parameter: no

FILLS

Trade fill history

Column	Type	Aliases
`trade_id`	string
`order_id`	string
`symbol`	string	`slug`
`outcome`	string
`side`	string
`size`	number	`shares`
`price`	number
`fee_rate_bps`	number
`status`	string
`match_time`	date
`is_taker`	boolean

Default columns: symbol, outcome, side, size, price, match_time

ORDER BY: yes · LIMIT: yes · Parameter: no

ORDERS

Open orders

Column	Type	Aliases
`accountId`	string
`id`	string	`order_id`
`symbol`	string	`slug`
`side`	string
`type`	string
`quantity`	number	`size`, `shares`
`price`	number
`stopPrice`	number
`filledQuantity`	number
`avgFillPrice`	number
`status`	string
`time`	string	`created_at`
`duration`	string

Default columns: symbol, side, type, quantity, price, status, time

ORDER BY: yes · LIMIT: yes · Parameter: no

POSITIONS

Open positions in prediction markets

Column	Type	Aliases
`accountId`	string
`symbol`	string	`slug`
`side`	string
`quantity`	number	`qty`, `shares`
`avgCost`	number	`average_price`
`lastPrice`	number
`marketValue`	number	`market_value`
`unrealizedPnL`	number	`unrealized_pnl`
`unrealizedPnLPct`	number
`realizedPnL`	number	`realized_pnl`

Default columns: symbol, side, quantity, avgCost, unrealizedPnL

ORDER BY: yes · LIMIT: yes · Parameter: no

Polymarket US

Intervals: 1m, 5m, 15m, 30m, 1H, 2H, 4H, 12H, 1D, 1W

BALANCES

USD balance, buying power and the value of open positions

Column	Type	Aliases
`balance`	number
`buyingPower`	number	`buying_power`
`payout`	number	`positions_value`, `assetNotional`
`openOrders`	number	`open_orders`
`unsettledFunds`	number	`unsettled_funds`
`currency`	string

Default columns: balance, buyingPower, payout, currency

ORDER BY: no · LIMIT: yes · Parameter: no

FILLS

Trade fill history

Column	Type	Aliases
`trade_id`	string
`order_id`	string
`symbol`	string	`slug`
`outcome`	string
`side`	string
`size`	number	`contracts`, `shares`
`price`	number
`fee`	number	`commission`
`status`	string
`match_time`	date
`is_taker`	boolean
`realized_pnl`	number

Default columns: symbol, outcome, side, size, price, match_time

ORDER BY: yes · LIMIT: yes · Parameter: no

ORDERS

Open orders

Column	Type	Aliases
`accountId`	string
`id`	string	`order_id`
`symbol`	string	`slug`
`side`	string
`outcome`	string
`type`	string
`quantity`	number	`size`, `contracts`, `shares`
`price`	number
`stopPrice`	number
`filledQuantity`	number
`avgFillPrice`	number
`status`	string
`time`	string	`created_at`
`duration`	string

Default columns: symbol, side, outcome, type, quantity, price, status, time

ORDER BY: yes · LIMIT: yes · Parameter: no

POSITIONS

Open positions in prediction markets

Column	Type	Aliases
`accountId`	string
`symbol`	string	`slug`
`side`	string
`quantity`	number	`qty`, `contracts`, `shares`
`avgCost`	number	`average_price`
`lastPrice`	number
`marketValue`	number	`market_value`
`unrealizedPnL`	number	`unrealized_pnl`
`unrealizedPnLPct`	number
`realizedPnL`	number	`realized_pnl`

Default columns: symbol, side, quantity, avgCost, unrealizedPnL

ORDER BY: yes · LIMIT: yes · Parameter: no

Schwab

Intervals: 1m, 5m, 10m, 15m, 30m, 1D, 1W, 1M

ACCOUNTS

Charles Schwab broker accounts

Column	Type	Aliases
`id`	string
`name`	string
`broker`	string
`type`	string
`status`	string
`equity`	number
`buyingPower`	number	`bp`
`cashBalance`	number

Default columns: name, broker, type, status, equity, buyingPower

ORDER BY: yes · LIMIT: yes · Parameter: no

BALANCES

Account balances

Column	Type	Aliases
`accountId`	string
`equity`	number
`buyingPower`	number	`bp`
`cashBalance`	number
`currency`	string

Default columns: accountId, equity, buyingPower, cashBalance

ORDER BY: yes · LIMIT: yes · Parameter: no

ORDERS

Orders

Column	Type	Aliases
`id`	string
`symbol`	string
`side`	string
`type`	string
`quantity`	number	`qty`
`price`	number
`stopPrice`	number
`filledQuantity`	number	`filledQty`
`avgFillPrice`	number
`status`	string
`time`	string
`duration`	string
`accountId`	string

Default columns: symbol, side, type, quantity, price, status

ORDER BY: yes · LIMIT: yes · Parameter: no

POSITIONS

Open positions

Column	Type	Aliases
`symbol`	string
`side`	string
`quantity`	number	`qty`
`avgCost`	number	`avgEntryPrice`
`lastPrice`	number	`currentPrice`
`marketValue`	number
`unrealizedPnL`	number
`unrealizedPnLPct`	number
`realizedPnL`	number
`accountId`	string

Default columns: symbol, side, quantity, avgCost, marketValue, unrealizedPnL

ORDER BY: yes · LIMIT: yes · Parameter: no

Tradier

Intervals: 1T, 1m, 5m, 15m, 1H, 1D, 1W, 1M

ACCOUNTS

Tradier broker accounts

Column	Type	Aliases
`id`	string
`name`	string
`broker`	string
`type`	string
`status`	string
`equity`	number
`buyingPower`	number	`bp`
`cashBalance`	number

Default columns: name, broker, type, status, equity, buyingPower

ORDER BY: yes · LIMIT: yes · Parameter: no

BALANCES

Account balances

Column	Type	Aliases
`accountId`	string
`equity`	number
`buyingPower`	number	`bp`
`cashBalance`	number
`currency`	string

Default columns: accountId, equity, buyingPower, cashBalance

ORDER BY: yes · LIMIT: yes · Parameter: no

ORDERS

Orders

Column	Type	Aliases
`id`	string
`symbol`	string
`side`	string
`type`	string
`quantity`	number	`qty`
`price`	number
`stopPrice`	number
`filledQuantity`	number	`filledQty`
`avgFillPrice`	number
`status`	string
`time`	string
`duration`	string
`accountId`	string

Default columns: symbol, side, type, quantity, price, status

ORDER BY: yes · LIMIT: yes · Parameter: no

POSITIONS

Open positions

Column	Type	Aliases
`symbol`	string
`side`	string
`quantity`	number	`qty`
`avgCost`	number
`lastPrice`	number
`marketValue`	number
`unrealizedPnL`	number
`unrealizedPnLPct`	number
`realizedPnL`	number
`accountId`	string

Default columns: symbol, side, quantity, avgCost, marketValue, unrealizedPnL

ORDER BY: yes · LIMIT: yes · Parameter: no

Tradovate

Intervals: 1m, 5m, 15m, 30m, 1H, 4H, 1D, 1W, 1M

ACCOUNTS

Tradovate futures accounts

Column	Type	Aliases
`id`	string
`name`	string
`broker`	string
`type`	string
`status`	string
`cashBalance`	number

Default columns: name, broker, type, status, cashBalance

ORDER BY: yes · LIMIT: yes · Parameter: no

ORDERS

Futures orders

Column	Type	Aliases
`id`	string
`symbol`	string
`side`	string	`action`
`type`	string	`ordType`
`quantity`	number	`orderQty`
`price`	number
`stopPrice`	number
`filledQuantity`	number	`filledQty`
`avgFillPrice`	number
`status`	string	`ordStatus`
`time`	string	`timestamp`
`duration`	string
`accountId`	string

Default columns: symbol, side, type, price, quantity, filledQuantity, status

ORDER BY: yes · LIMIT: yes · Parameter: no

POSITIONS

Open futures positions

Column	Type	Aliases
`symbol`	string
`side`	string
`quantity`	number	`netPos`
`avgCost`	number	`netPrice`
`lastPrice`	number
`marketValue`	number
`unrealizedPnL`	number
`unrealizedPnLPct`	number
`realizedPnL`	number
`accountId`	string

Default columns: symbol, side, quantity, avgCost, marketValue, unrealizedPnL

ORDER BY: yes · LIMIT: yes · Parameter: no

← Previous

VectarisQL options

Brokers