Solana - Phoenix collateral deposits and withdrawals
Deposits and withdrawals of collateral on Phoenix perpetuals, newest first, with trader, signer and fee. Filter by Type for one side only.
What it returns
- block time
- transaction signature
- collateral movement type
- collateral movement amount
- currency symbol
- currency mint address
- trader
- signer
- collateral movement fee
The query
# Solana - Perpetuals (Phoenix) - Collateral deposits and withdrawals
#
# Money in and money out of Phoenix perpetuals. CollateralMovement.Type is
# either Deposit or Withdraw, denominated in PhUsd, with the trader, the
# signer that submitted it, and the fee charged.
#
# Filter one side with Type, or follow one account with Trader, for example:
# where: {CollateralMovement: {Type: {is: "Withdraw"}}}
#
# Useful for net-flow dashboards, whale withdrawal alerts, and reconciling a
# trader's realised PnL against what they actually took off the venue.
#
# Bitquery V2 query - send it to https://streaming.bitquery.io/graphql
#
# Datasets: https://docs.bitquery.io/docs/graphql/dataset/archive/
# Retention: https://docs.bitquery.io/docs/graphql/data-coverage-retention/
{
Solana {
PerpetualCollateralMovements(
limit: {count: 25}
orderBy: {descending: Block_Time}
) {
Block { Time }
Transaction { Signature }
CollateralMovement {
Type
Amount
Currency { Symbol MintAddress }
Trader
Signer
Fee
}
}
}
}
Similar queries
- sol_perp_deps_withdrawals · Solana · PerpetualCollateralMovements
- SOL Transfers · Solana · Transfers
- ANSEM daily traders, June 16 to 26, 2026 · Solana · DEXTradeByTokens
- Pumpfun tokens created historically on specific date · Solana · Transfers
- Inflows and Outflows calculation - Solana · Solana · Transfers