sell-info-for-pnl

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

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

What it returns

Filters

The query

query MyQuery {
  EVM(dataset: combined) {
    DEXTrades(
      where: {Trade: {Sell: {Currency: {SmartContract: {is: "0x6982508145454ce325ddbe47a25d4ec3d2311933"}}, PriceInUSD: {ne: 0}}}, Transaction: {From: {is: "0xae2fc483527b8ef99eb5d9b44875f005ba1fae13"}}}
    ) {
      sold: sum(of: Trade_Sell_Amount)
      soldInUSD: sum(of: Trade_Sell_AmountInUSD)
      average(of:Trade_Sell_PriceInUSD)
    }
  }
}

Similar queries