Data API Glossary

Provisional endpoint. Velocity’s hosted Data API host is not yet finalized — see Data API. This glossary describes the column set inherited from Drift’s Data API; some columns describe features Velocity removed (noted inline) and are kept here only for historical/comparison reference until Velocity’s own Data API schema is confirmed.

This is extensive list for every API endpoint. Choose the category of historical data you’re analysing in the right sidebar for quick access. ➡️ ➡️ ➡️

Shared columns

Columns in the table below are part of each category:

Column	Unit	Precision	Description
ts	int	seconds(since 1970)	Unix timestamp of the event.
txSig	pubkey		Transaction signature.
slot	int		Slot number of the event.
user	pubkey
amount	int
programId	pubkey		Solana program identifier. On Velocity this is `vELoC1audYbSYVRXn1vPaV8Axoa9oU6BYmNGZZBDZ1P` on both devnet and mainnet-beta.
marketType	perp/spot		Type of market where the order was filled (“Spot”, “Perpetual”). Note: spot order-book trading (the DLOB) is disabled on Velocity — spot fill events no longer occur.
marketIndex	int		Perpetual contract market index. See the SDK’s market config (`@velocity-exchange/sdk` `configs`) rather than any Drift-specific constants file.
spotMarketIndex	int		Index of the spot market.
perpMarketIndex	int		Index of the perpetual contract market.
userAuthority	pubkey		Public key of the user’s authority account (wallet).
oraclePrice	int		Oracle price at the time of an event (provided by Pyth or Pyth Lazer on Velocity — legacy Pyth pull and Switchboard are deprecated, see Account Model).

Trades

Column	unit	description
fillerReward	int	Reward received by the filler for filling the order.
baseAssetAmountFilled	int	Amount of the base asset filled in the order.
quoteAssetAmountFilled	int	Amount of the quote asset filled in the order.
takerFee	int	Fee charged to the taker for filling the order.
makerRebate	int	Rebate provided to the maker for placing the order.
referrerReward	int	Reward received by the referrer for referring the order.
quoteAssetAmountSurplus	int	Amount of the quote asset remaining unfilled after the order is completed.
takerOrderBaseAssetAmount	int	Total amount of the base asset the taker ordered to buy or sell.
takerOrderCumulativeBaseAssetAmountFilled	int	Cumulative amount of the base asset filled for the taker’s order.
takerOrderCumulativeQuoteAssetAmountFilled	int	Cumulative amount of the quote asset filled for the taker’s order.
makerOrderBaseAssetAmount	int	Total amount of the base asset the maker ordered to buy or sell.
makerOrderCumulativeBaseAssetAmountFilled	int	Cumulative amount of the base asset filled for the maker’s order.
makerOrderCumulativeQuoteAssetAmountFilled	int	Cumulative amount of the quote asset filled for the maker’s order.
makerFee	int	Fee charged to the maker for placing the order (if not a maker rebate).
action	fill	Action type for the order fill event (e.g., “Fill”).
actionExplanation	orderExpired/orderFilledWithMatch	Explanation of the action type.
filler	pubkey	Address of the entity that filled the order.
fillRecordId	int	Unique identifier for the order fill record.
taker	pubkey	Address of the taker who placed the order.
takerOrderId	int	Unique identifier for the taker’s order.
takerOrderDirection	long/short	Direction of the taker’s order (e.g., “Buy”, “Sell”).
maker	pubkey	Address of the maker who placed the opposing order.
makerOrderId	int	Unique identifier for the maker’s order.
makerOrderDirection	long/short	Direction of the maker’s order (e.g., “Buy”, “Sell”).
~~spotFulfillmentMethodFee~~	int	Removed on Velocity. External spot fulfillment (Serum/Phoenix/OpenBook v2) was deleted and the spot DLOB is disabled (`SpotDlobTradingDisabled`); this column no longer applies.

Market Trades

Column	unit	Description
fillerReward	int	Reward received by the filler for filling the order.
baseAssetAmountFilled	int	Amount of the base asset filled in the order.
quoteAssetAmountFilled	int	Amount of the quote asset filled in the order.
takerFee	int	Fee charged to the taker for filling the order.
makerRebate	int	Rebate provided to the maker for placing the order.
referrerReward	int	Reward received by the referrer for referring the order.
quoteAssetAmountSurplus	int	Amount of the quote asset remaining unfilled after the order.
takerOrderBaseAssetAmount	int	Total amount of the base asset the taker ordered to buy or sell.
takerOrderCumulativeBaseAssetAmountFilled	int	Cumulative amount of the base asset filled for the taker’s order.
takerOrderCumulativeQuoteAssetAmountFilled	int	Cumulative amount of the quote asset filled for the taker’s order.
makerOrderBaseAssetAmount	int	Total amount of the base asset the maker ordered to buy or sell.
makerOrderCumulativeBaseAssetAmountFilled	int	Cumulative amount of the base asset filled for the maker’s order.
makerOrderCumulativeQuoteAssetAmountFilled	int	Cumulative amount of the quote asset filled for the maker’s order.
makerFee	int	Fee charged to the maker for placing the order (if not a maker rebate).
action	fill	Action type for the order fill event (e.g., “Fill”).
actionExplanation	orderFilledWithMatch/ orderFilledWithMatchJit/ orderFilledWithAmmjit	Explanation of the action type.
filler	pubkey	Address of the entity that filled the order.
fillRecordId	int	Unique identifier for the order fill record.
taker	pubkey	Address of the taker who placed the order.
takerOrderId	int	Unique identifier for the taker’s order.
takerOrderDirection	long/short	Direction of the taker’s order (e.g., “Buy”, “Sell”).
maker	pubkey	Address of the maker who placed the opposing order.
makerOrderId	int	Unique identifier for the maker’s order.
makerOrderDirection	long/short	Direction of the maker’s order (e.g., “Buy”, “Sell”).
~~spotFulfillmentMethodFee~~	int	Removed on Velocity — see note above.

Funding Rates

Column	unit	Description
recordId	int	Unique order fill identifier.
fundingRate	int	Perpetual contract funding rate (long/short).
fundingRateLong	int	Funding paid by long positions.
fundingRateShort	int	Funding paid by short positions.
cumulativeFundingRateLong	int	Long positions’ cumulative funding.
cumulativeFundingRateShort	int	Short positions’ cumulative funding.
oraclePriceTwap	int	TWAP of oracle price (period).
markPriceTwap	int	TWAP of mark price (period).
periodRevenue	int	Market revenue for a specific period.
baseAssetAmountWithAmm	int	Total base asset in the AMM pool.
baseAssetAmountWithUnsettledLp	int	Unsettled base asset with LPs.

Funding Payments

Column	unit	description
fundingPayment	int	Amount of funding paid by the user (positive for long, negative for short).
baseAssetAmount	int	Amount of the base asset involved in the funding payment.
userLastCumulativeFunding	int	User’s last cumulative funding rate at the time of the event.
ammCumulativeFundingLong	int	AMM’s cumulative funding rate for long positions at the time of the event.
ammCumulativeFundingShort	int	AMM’s cumulative funding rate for short positions at the time of the event.

Deposits

Column	unit	Description
marketDepositBalance	int	Current total market deposits.
marketWithdrawBalance	int	Current total market withdrawals.
marketCumulativeDepositInterest	int	Total deposit interest accrued.
marketCumulativeBorrowInterest	int	Total borrow interest accrued.
totalDepositsAfter	int	Total market deposits after this event.
totalWithdrawsAfter	int	Total market withdrawals after this event.
depositRecordId	int	Unique identifier for the deposit/withdrawal record.
direction	deposit/withdrawal	Deposit or withdrawal.
explanation (optional)	str

Liquidations

Column	unit	description
liquidationType	liquidatePerp/ liquidateSpot/ liquidateBorrowForPerpPnl/ liquidatePerpPnlForDeposit/ perpBankruptcy/ spotBankruptcy	Liquidation type
liquidator	pubkey	Liquidator
marginRequirement	int	Minimum collateral required
totalCollateral	int	User’s total collateral
marginFreed	int	Collateral returned to user
liquidationId	int	Unique liquidation ID
bankrupt	bool	User became bankrupt
canceledOrderIds	ListContainer	Array of canceled order IDs during liquidation
liquidatePerp (marketIndex, oraclePrice, …)	int	Liquidation type with additional details.
liquidateSpot (assetMarketIndex, assetPrice, …)	int	Liquidation type with additional details.
liquidateBorrowForPerpPnl (perpMarketIndex, marketOraclePrice, …)	int	Liquidation type with additional details.
liquidatePerpPnlForDeposit (perpMarketIndex, marketOraclePrice, …)	int	Liquidation type with additional details.
perpBankruptcy (marketIndex, pnl, …)	int	Liquidation type with additional details.
spotBankruptcy (marketIndex, borrowAmount, …)	int	Liquidation type with additional details.

Settle PNL

Column	Unit	Description
pnl	int	User’s profit or loss.
baseAssetAmount	int	Amount of base asset involved.
quoteAssetAmountAfter	int	Amount of quote asset after settlement.
quoteEntryAmount	int	Amount of quote asset before settlement.
settlePrice	int	Settlement price.
explanation	none

LP (BAL)

Removed on Velocity. Drift’s vAMM LP shares (PerpPosition.lpShares and the addLiquidity/settleLiquidity actions below) were removed entirely — there is no per-user LP-share mechanism to emit these events. Liquidity provision against a market now happens through the separate VLP module (a hedge-pool architecture configured per-market via PerpMarketAccount.hedgeConfig), which has its own accounting and does not map onto this table. This section is kept only as a historical reference for readers migrating a Drift LP-events integration.

Column	Unit	Description
action	addLiquidity / settleLiquidity
nShares	int	Number of perpetual contract shares traded.
deltaBaseAssetAmount	int	Change in base asset position due to the trade.
deltaQuoteAssetAmount	int	Change in quote asset position due to the trade.
pnl	int	Profit or loss from the trade.

Insurance Fund

The insurance fund is now 100% staker-owned on Velocity — the protocol-owned-shares path and IF rebalance instructions (transferProtocolIfSharesToRevenuePool, beginInsuranceFundSwap/endInsuranceFundSwap, IfRebalanceConfig) were removed. userIfFactor/totalIfFactor below map to the per-market insuranceFund.ifFeeFactor concept rather than a protocol/user split.

Column	Unit	Description
vaultAmountBefore	int	Total amount deposited into the vault before the event.
insuranceVaultAmountBefore	int	Total amount in the insurance vault before the event.
totalIfSharesBefore	int	Total number of IF shares in circulation before the event.
totalIfSharesAfter	int	Total number of IF shares in circulation after the event.
userIfFactor	int	User’s individual IF factor before the event.
totalIfFactor	int	Total IF factor for all users before the event.

Insurance Fund Stake

Column	Unit	Description
action	stakeTransfer
ifSharesBefore	int	Total IF shares in circulation before staking.
userIfSharesBefore	int	User’s individual IF share balance before staking.
totalIfSharesBefore	int	Total IF factor for all users before staking.
ifSharesAfter	int	Total IF shares in circulation after staking.
userIfSharesAfter	int	User’s individual IF share balance after staking.
totalIfSharesAfter	int	Total IF factor for all users after staking.
insuranceVaultAmountBefore	int	Total amount in the insurance vault before staking.