gt in where- doesnt work for ohlc

Returns the latest 300 DEX trades by token on Solana, where currency mint address is FPK9eS…pump, DEX program address is 6EF8rr…wF6P and side amount in USD is above 10: block time, sum of trade amount, price in USD and count.

By Akshat · saved 12 November 2024 · Bitquery API v2

What it returns

Filters

The query

{
  Solana {
    DEXTradeByTokens(
      limit: {count: 300}
      orderBy: {descendingByField: "Block_Timefield"}
      where: {Trade: {Currency: {MintAddress: {is: "FPK9eSsSAx7MhjrxTgYG3E7N97sUQB2UVAzKgghCpump"}}, Dex: {ProgramAddress: {is: "6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P"}},  Side: {AmountInUSD: {gt: "10"}}}, Transaction: {Result: {Success: true}}}
    ) {
      Block {
        Timefield: Time(interval: {in: minutes, count: 1})
      }
      volume: sum(of: Trade_Amount)
      Trade {
        high: PriceInUSD(maximum: Trade_Price)
        low: PriceInUSD(minimum: Trade_Price)
        open: PriceInUSD(minimum: Block_Slot)
        close: PriceInUSD(maximum: Block_Slot)
      }
      count
    }
  }
}

Similar queries