Total buy, total sell, avg sell, last active

Returns DEX trades by token on Solana, where currency mint address is FSJYiG…pump and side currency mint address is So1111…1112 or 111111…1111: block time, sum of trade side amount in USD and average of trade price in USD.

By Akshat · saved 11 December 2025 · run 7 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery ($trader:String, $token:String){
  Solana(dataset: realtime) {
    DEXTradeByTokens(
      where: { Trade: {Currency:{MintAddress:{is:$token}} Side: {Currency: {MintAddress: {in: ["So11111111111111111111111111111111111111112", "11111111111111111111111111111111"]}}}}, any: [{Trade: {Account: {Address: {is: $trader}}}}, {Trade: {Account: {Token: {Owner: {is: $trader}}}}}]}
    ) {
      Block{
        last_active_time:Time(maximum:Block_Time)
      }
      total_buy: sum(of:Trade_Side_AmountInUSD if: {Trade: {Side: {Type: {is: buy}}}})
      total_sell: sum(of:Trade_Side_AmountInUSD if: {Trade: {Side: {Type: {is: sell}}}})
      avg_sell_price: average(of:Trade_PriceInUSD if: {Trade: {Side: {Type: {is: sell}}}})
    }
  }
}

Variables

{
  "token":"FSJYiGZhJ1wDPNhHbSHm49yJkzbFp7FykNB2SZFipump",
  "trader": "CECN4BW4DKnbyddkd9FhWVR5dotzKhQr5p7DUPhQ55Du"
}

Similar queries