Top traders

Returns 100 DEX trades by token on Solana, where currency mint address is 2kRKcw…AHzy, side currency mint address is So1111…1112 and side amount is above 0, sorted by sold USD, highest first: account owner and sum of trade side amount in USD.

By sylvadorr · saved 24 February 2025 · run 4 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
        }
      }
      boughtUSD: sum(of: Trade_Side_AmountInUSD, if: {Trade: {Side: {Type: {is: buy}}}})
      soldUSD: sum(of: Trade_Side_AmountInUSD, if: {Trade: {Side: {Type: {is: sell}}}})
    }
  }
}

Variables

{
  "token": "2kRKcwvdaAacsEsNnb6xpUb3PxHYjWXUMR7TYBKEAHzy",
  "base": "So11111111111111111111111111111111111111112"
}

Similar queries