solana ath wrong results

Returns 10 DEX trades by token on Solana, where DEX protocol name is pump and block time after 2025-02-10, sorted by a ath, highest first: currency name, currency symbol, currency mint address, quantile of trade price in USD and sum of trade amount.

By gaurav · saved 11 February 2025 · run 4 times · Bitquery API v2

What it returns

Filters

The query

{
  Solana(dataset: archive) {
    DEXTradeByTokens(
      where: {Trade: {Dex: {ProtocolName: {is: "pump"}}}, 
        Block: {Time: {after: "2025-02-10T03:07:24.142Z"}}}
      limitBy: {by: Trade_Currency_MintAddress}
      limit: {count: 10}
      orderBy: {descendingByField: "aATH"}
    ) {
      Trade {
        Currency {
          Name
          Symbol
          MintAddress
        }
      }
      aATH: quantile(of: Trade_PriceInUSD, level: 0.99)
      maxVolume: sum(of: Trade_Amount)
    }
  }
}

Similar queries