all_pairs_filtering

Returns 1000 DEX trades on Ethereum and BNB Chain, where quote currency is 0xbb4c…095c, 0x55d3…7955 or 1 more, exchange address is 0xca14…0c73, 0x0bfb…1865 or 1 more and time since 2024-05-28, sorted by trade amount, highest first: base currency symbol, base currency name, decimals, base currency address, quote currency name, quote currency address, minimum of block and 6 more fields.

By strikex admin acct · saved 29 May 2024 · run 88 times · Bitquery API v1

What it returns

Filters

The query

query ($network: EthereumNetwork!, $limit: Int, $from: ISO8601DateTime, $till: ISO8601DateTime, $quoteCurrencies: [String!], $exchangeAddresses: [String!]) {
  ethereum(network: $network) {
    dexTrades(
      quoteCurrency: {in: $quoteCurrencies}
      time: {since: $from, till: $till}
      options: {limit: $limit, desc: "tradeAmount", limitBy: {each: "baseCurrency.address, quoteCurrency.address", limit: 1}}
      exchangeAddress: {in: $exchangeAddresses}
      tradeAmountUsd: {gt: 1.5, lt: 10000}
    ) {
      baseCurrency {
        symbol
        name
        decimals
        address
      }
      quoteCurrency {
        name
        address
      }
      open_price: minimum(of: block, get: quote_price)
      close_price: maximum(of: block, get: quote_price)
      open_price_time: minimum(of: block, get: time)
      close_price_time: maximum(of: block, get: time)
      diff: expression(get: "close_price - open_price")
      div: expression(get: "diff / open_price")
      final: expression(get: "div * 100")
      count
      tradeAmount(in: USD)
      quotePrice
      quoteAmount
      volume: quoteAmount(in: USD)
    }
  }
}

Variables

{
  "network": "bsc",
  "limit": 1000,
  "from": "2024-05-28",
  "till": "2024-05-29",
  "quoteCurrencies": ["0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c", "0x55d398326f99059ff775485246999027b3197955", "0xe9e7cea3dedca5984780bafc599bd69add087d56"],
  "exchangeAddresses": ["0xca143ce32fe78f1f7019d7d551a6402fc5350c73", "0x0bfbcf9fa4f9c56b0f40a671ad40e0805a091865", "0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7"]
  
}

Similar queries