no pool

Returns 5000 DEX trades by token on Solana, where currency mint address is 3ESf6d…pump and token owner is not GRkieH…XPJR, sorted by volume USD, highest first: token owner, side account address, side type, sum of trade amount and sum of trade side amount in USD.

By Nadia · saved 9 July 2024 · run 2 times · Bitquery API v2

What it returns

Filters

The query

query TopTraders($token: String, $pool: String) {
  Solana {
    DEXTradeByTokens(
      orderBy: {descendingByField: "volumeUsd"}
      limit: {count: 5000}
      where: {Trade: {Currency: {MintAddress: {is: $token}}, Account: {Token: {Owner: {not: $pool}}}}, Transaction: {Result: {Success: true}}}
    ) {
      Trade {
        Account {
          Token {
            Owner
          }
        }
        Side {
          Account {
            Address
          }
          Type
        }
      }
      bought: sum(of: Trade_Amount, if: {Trade: {Side: {Type: {is: buy}}}})
      sold: sum(of: Trade_Amount, if: {Trade: {Side: {Type: {is: sell}}}})
      volume: sum(of: Trade_Amount)
      volumeUsd: sum(of: Trade_Side_AmountInUSD)
    }
  }
}

Variables

{
  "token": "3ESf6dqpT3G5zEbWAqmFbvpwaU21mkrL3TFfg73Zpump",
  "pool": "GRkieHGxWAYrY6NnSf5wgi2YdZoWKfFMoZaNAqoxXPJR"
}

Similar queries