unisw

Returns 100 DEX trades by token on Arbitrum, where DEX protocol family is Uniswap and block time after 2025-02-24, sorted by USD, highest first: currency symbol, currency name, smart contract, fungible, side currency symbol, side currency name, side smart contract and 4 more fields.

By Emadalshamery · saved 27 February 2025 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query DexMarkets($network: evm_network, $market: String, $time_10min_ago: DateTime, $time_1h_ago: DateTime, $time_3h_ago: DateTime, $time_ago: DateTime) {
  EVM(network: $network) {
    DEXTradeByTokens(
      orderBy: {descendingByField: "usd"}
      where: {TransactionStatus: {Success: true}, Trade: {Dex: {ProtocolFamily: {is: $market}}}, Block: {Time: {after: $time_ago}}}
      limit: {count: 100}
    ) {
      Trade {
        Currency {
          Symbol
          Name
          SmartContract
          Fungible
        }
        Side {
          Currency {
            Symbol
            Name
            SmartContract
          }
        }
        price_usd: PriceInUSD(maximum: Block_Number)
        price_last: Price(maximum: Block_Number)
        price_10min_ago: Price(
          maximum: Block_Number
          if: {Block: {Time: {before: $time_10min_ago}}}
        )
        price_1h_ago: Price(
          maximum: Block_Number
          if: {Block: {Time: {before: $time_1h_ago}}}
        )
        price_3h_ago: Price(
          maximum: Block_Number
          if: {Block: {Time: {before: $time_3h_ago}}}
        )
      }
      usd: sum(of: Trade_AmountInUSD)
      count
    }
  }
}

Variables

{
  "market": "Uniswap",
  "network": "arbitrum",
  "time_10min_ago": "2025-02-27T18:49:22Z",
  "time_1h_ago": "2025-02-27T17:59:22Z",
  "time_3h_ago": "2025-02-27T15:59:22Z",
  "time_ago": "2025-02-24T18:59:22Z"
}

Similar queries