gt in where - works

Returns the latest DEX trades by token on Solana, where currency mint address is FPK9eS…pump, DEX program address is 6EF8rr…wF6P and block time since 2024-11-12: trade amount, amount in USD, currency name, currency symbol, currency mint address, price in USD, side currency name and 8 more fields.

By Akshat · saved 12 November 2024 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  Solana {
    DEXTradeByTokens(
      orderBy: {descending: Block_Time}
      where: {Trade: {Currency: {MintAddress: {is: "FPK9eSsSAx7MhjrxTgYG3E7N97sUQB2UVAzKgghCpump"}}, Dex: {ProgramAddress: {is: "6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P"}}, Side: {AmountInUSD: {gt: "10"}}}, Block: {Time: {since: "2024-11-12T11:40:00Z", till: "2024-11-12T11:41:00Z"}}, Transaction: {Result: {Success: true}}}
    ) {
      Trade {
        Amount
        AmountInUSD
        Currency {
          Name
          Symbol
          MintAddress
        }
        PriceInUSD
        Side {
          Currency {
            Name
          }
          AmountInUSD
          Amount
          Account {
            Address
            Token {
              Owner
            }
          }
        }
        Account {
          Address
          Token {
            Owner
          }
        }
      }
      Block {
        Time
      }
      Transaction {
        Signature
      }
    }
  }
}

Similar queries