price of the token against other than BNB, BUSD in different pools on PankcakeSwap v2

Returns 10 DEX trades on BNB Chain, where buy currency smart contract is not 0xbb4c…095c, 0x55d3…7955 or 1 more, sell currency smart contract is not 0xbb4c…095c, 0x55d3…7955 or 1 more and DEX owner address is 0xca14…0c73: buy amount, buy buyer, buy currency name, buy smart contract, buy currency symbol, buy price, buy price in USD and 10 more fields.

By Vishal · saved 28 May 2024 · run 8 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(dataset: combined, network: bsc) {
    DEXTrades(
      where: {Block: {Date: {is: "2024-05-27"}}, Trade: {Buy: 
        {Currency: 
          {SmartContract: 
            {notIn: 
              ["0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c", 
                "0x55d398326f99059ff775485246999027b3197955", 
                "0xe9e7cea3dedca5984780bafc599bd69add087d56"]}}}, 
        Sell: {Currency: 
          {SmartContract: 
          {notIn: ["0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c", "0x55d398326f99059ff775485246999027b3197955", "0xe9e7cea3dedca5984780bafc599bd69add087d56"]}}}, Dex: {OwnerAddress: {is: "0xca143ce32fe78f1f7019d7d551a6402fc5350c73"}}}, 
        any: [{Trade: {Buy: 
          {Currency: {SmartContract: 
            {is: "0xba2ae424d960c26247dd6c32edc70b295c744c43"}}}}}, {Trade: {Sell: {Currency: {SmartContract: {is: "0xba2ae424d960c26247dd6c32edc70b295c744c43"}}}}}]}
      limitBy: {by: Trade_Dex_Pair_Name}
      limit: {count: 10}
    ) {
      Trade {
        Buy {
          Amount
          Buyer
          Currency {
            Name
            SmartContract
            Symbol
          }
          Price
          PriceInUSD
          Seller
        }
        Sell {
          Amount
          Buyer
          Price
          PriceInUSD
          Seller
          Currency {
            Name
            SmartContract
          }
        }
        Dex {
          Exchange_Address: OwnerAddress
          Pool_Address: SmartContract
        }
      }
    }
  }
}

Similar queries