Copy of Markten voor Mark 2

Returns DEX trades on Ethereum, where DEX protocol name is uniswap_v2 and block time since 2024-10-01, sorted by trade buy amount in USD, highest first: buy currency symbol, buy price, buy amount in USD, sell currency symbol, sell price, sell amount in USD, smart contract and 6 more fields.

By Coinranking · saved 2 October 2024 · run 5 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(dataset: realtime, network: eth) {
    DEXTrades(
      where: {Trade: {Dex: {ProtocolName: {is: "uniswap_v2"}}}, Block: {Time: {since: "2024-10-01T10:51:31.046Z"}}}
      orderBy: {descending: Trade_Buy_AmountInUSD}
    ) {
      Trade {
        Buy {
          Currency {
            Symbol
          }
          High: Price(maximum: Trade_Buy_Price)
          AmountInUSD
        }
        Sell {
          Currency {
            Symbol
          }
          High: Price(maximum: Trade_Sell_Price)
          Low: Price(minimum: Trade_Sell_Price)
          Open: Price(minimum: Block_Number)
          Close: Price(maximum: Block_Number)
          AmountInUSD
        }
        Dex {
          Pair {
            SmartContract
            Name
          }
          SmartContract
          ProtocolFamily
          ProtocolName
          ProtocolVersion
        }
      }
      volumeBuy: sum(of: Trade_Buy_Amount)
      volumeSell: sum(of: Trade_Sell_Amount)
    }
  }
}

Similar queries