buy-info-for-pnl

Returns DEX trades, where buy currency smart contract is 0x6982…1933 and transaction from is 0xae2f…ae13: sum of trade buy amount, sum of trade buy amount in USD and average of trade buy price in USD.

By Kshitij Mahajan · saved 15 October 2024 · run 25 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(dataset: combined) {
    DEXTrades(
      where: {Trade: {Buy: {Currency: {SmartContract: {is: "0x6982508145454ce325ddbe47a25d4ec3d2311933"}}, PriceInUSD: {ne: 0}}}, Transaction: {From: {is: "0xae2fc483527b8ef99eb5d9b44875f005ba1fae13"}}}
    ) {
      bought: sum(of: Trade_Buy_Amount)
      boughtInUSD: sum(of: Trade_Buy_AmountInUSD)
      average(of:Trade_Buy_PriceInUSD)
    }
  }
}

Similar queries