top traders query

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

By Divyasshree · saved 4 November 2024 · run 5 times · Bitquery API v2

What it returns

Filters

The query

query TopTraders($token: String, $base: String) {
  Solana(dataset: archive) {
    DEXTradeByTokens(
      orderBy: {descendingByField: "volumeUsd"}
      limit: {count: 100}
      where: {Trade: {Currency: {MintAddress: {is: $token}}, Side: {Amount: {gt: "0"}, Currency: {MintAddress: {is: $base}}}}, Transaction: {Result: {Success: true}}}
    ) {
      Trade {
        Account {
          Owner
        }
        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}}}})
      volume: sum(of: Trade_Amount)
      volumeUsd: sum(of: Trade_Side_AmountInUSD)
    }
  }
}

Variables

{
  "token": "59VxMU35CaHHBTndQQWDkChprM5FMw7YQi5aPE5rfSHN",
  "base": "So11111111111111111111111111111111111111112"
}

Similar queries