Top traders

Returns 100 DEX trades by token on Solana, where currency mint address is YHD9qW…giga, side currency mint address is So1111…1112 and side amount is above 0, sorted by sold USD, highest first: account owner, account address, program address, protocol family, protocol name, sum of trade amount and sum of trade side amount in USD.

By Aleksei · saved 15 February 2025 · run 42 times · Bitquery API v2

What it returns

Filters

The query

query TopTraders($token: String, $base: String) {
  Solana {
    DEXTradeByTokens(
      orderBy: {descendingByField: "soldUSD"}
      limit: {count: 100}
      where: {Trade: {Currency: {MintAddress: {is: $token}}, Side: {Amount: {gt: "0"}, Currency: {MintAddress: {is: $base}}}}, Transaction: {Result: {Success: true}}}
    ) {
      Trade {
        Account {
          Owner
          Address
        }
        Dex {
          ProgramAddress
          ProtocolFamily
          ProtocolName
        }
      }
      bought: sum(of: Trade_Amount, if: {Trade: {Side: {Type: {is: buy}}}})
      sold: sum(of: Trade_Amount, if: {Trade: {Side: {Type: {is: sell}}}})
      boughtUSD: sum(of: Trade_Side_AmountInUSD, if: {Trade: {Side: {Type: {is: buy}}}})
      soldUSD: sum(of: Trade_Side_AmountInUSD, if: {Trade: {Side: {Type: {is: sell}}}})
      volume: sum(of: Trade_Amount)
      volumeUsd: sum(of: Trade_Side_AmountInUSD)
    }
  }
}

Variables

{
  "token": "YHD9qWuRBTPo4wznPTYBD17Xyg49wMMS7kRm2s6giga",
  "base": "So11111111111111111111111111111111111111112"
}

Similar queries