buys_and_sells

Returns DEX trades on Ethereum, where transaction from is 0x9d65…EFa0, buy currency smart contract is 0x7E74…FbBE and DEX smart contract is 0x8C13…aD76: transaction hash, sender, buy buyer, buy seller, buy currency name, buy smart contract, buy amount and 5 more fields.

By Omkar_BQ · saved 24 June 2024 · run 16 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(dataset: combined, network: eth) {
    Sells: DEXTrades(
      where: {Transaction: {From: {is: "0x9d6581468F04e5E55876a2660b5AeAbC12e3EFa0"}}, Trade: {Buy: {Currency: {SmartContract: {is: "0x7E744BBB1a49A44dfCC795014a4BA618E418FbBE"}}}, Dex: {SmartContract: {is: "0x8C13d5a6635216513EbFB4483397bE14D494aD76"}}}}
    ) {
      Transaction {
        Hash
      }
      Trade {
        Sender
        Buy {
          Buyer
          Seller
          Currency {
            Name
            SmartContract
          }
          Amount
        }
      }
    }
    Buys: DEXTrades(
      where: {Transaction: {From: {is: "0x9d6581468F04e5E55876a2660b5AeAbC12e3EFa0"}}, Trade: {Sell: {Currency: {SmartContract: {is: "0x7E744BBB1a49A44dfCC795014a4BA618E418FbBE"}}}, Dex: {SmartContract: {is: "0x8C13d5a6635216513EbFB4483397bE14D494aD76"}}}}
    ) {
      Transaction {
        Hash
      }
      Trade {
        Sell {
          Buyer
          Seller
          Currency {
            Name
            SmartContract
          }
          Amount
        }
      }
    }
  }
}

Similar queries