е1

Returns 20 DEX trades by token on Ethereum, where block time since 2025-01-30, sorted by USD, highest first: currency name, currency symbol, smart contract, side currency name, side smart contract, side currency symbol, protocol name and 5 more fields.

By Romario · saved 2 February 2025 · Bitquery API v2

What it returns

Filters

The query

query pairs($time_ago: DateTime, $eth: String!, $weth: String!, $usdc: String!, $usdt: String!) {
  EVM(network: eth) {
    DEXTradeByTokens(
      limit: {count: 20}
      orderBy: {descendingByField: "usd"}
      where: {Block: {Time: {since: $time_ago}}, any: [{Trade: {Side: {Currency: {SmartContract: {is: $eth}}}}}, {Trade: {Side: {Currency: {SmartContract: {is: $usdt}}}, Currency: {SmartContract: {notIn: [$eth]}}}}, {Trade: {Side: {Currency: {SmartContract: {is: $usdc}}}, Currency: {SmartContract: {notIn: [$eth, $usdt]}}}}, {Trade: {Side: {Currency: {SmartContract: {is: $weth}}}, Currency: {SmartContract: {notIn: [$eth, $usdc, $usdt]}}}}, {Trade: {Side: {Currency: {SmartContract: {notIn: [$usdc, $usdt, $weth, $eth]}}}, Currency: {SmartContract: {notIn: [$usdc, $usdt, $weth, $eth]}}}}]}
    ) {
      Trade {
        Currency {
          Name
          Symbol
          SmartContract
        }
        Side {
          Currency {
            Name
            SmartContract
            Symbol
          }
        }
        Dex {
          ProtocolName
        }
        price_usd: PriceInUSD(maximum: Block_Number)
      }
      usd: sum(of: Trade_Side_AmountInUSD)
      sellers: uniq(of: Trade_Seller)
      buyers: uniq(of: Trade_Buyer)
      count(selectWhere: {ge: $min_count})
    }
  }
}

Variables

{
            "network": "eth",
            "time_10min_ago": "2025-02-02T11:47:35Z",
            "time_1h_ago": "2025-02-02T10:57:35Z",
            "time_3h_ago": "2025-02-02T08:57:35Z",
            "time_ago": "2025-01-30T11:57:35Z",
            "usdc": "0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48",
            "usdt": "0xdac17f958d2ee523a2206206994597c13d831ec7",
            "weth": "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2",
            "eth": "0x",
            "min_count": "100"
}

Similar queries