count not working

Returns DEX pools on Solana, where quote currency mint address is So1111…1112 or 111111…1111, sorted by count, highest first: count, market address, base currency symbol, base currency name, base currency mint address, quote currency symbol, quote currency name and 4 more fields.

By Aleksey · saved 20 February 2025 · run 1 time · Bitquery API v2

What it returns

Filters

The query

{
  Solana {
    DEXPools(
      orderBy: {descendingByField: "count"}
      where: {Pool: {Market: {BaseCurrency: {Name: {includesCaseInsensitive: "trump"}, Symbol: {includesCaseInsensitive: "trump"}}, QuoteCurrency: {MintAddress: {in: ["So11111111111111111111111111111111111111112", "11111111111111111111111111111111"]}}}}}
    ) {
      count
      Pool {
        Market {
          MarketAddress
          BaseCurrency {
            Symbol
            Name
            MintAddress
          }
          QuoteCurrency {
            Symbol
            Name
            MintAddress
          }
        }
        Base {
          oldestPrice: Price(minimum: Block_Time)
          latestPrice: Price(maximum: Block_Time)
          HighestPrice: Price(maximum: Pool_Base_Price)
        }
        Dex {
          ProtocolName
          ProtocolFamily
        }
      }
    }
  }
}

Similar queries