[V2] Transactions (debug)

Returns 1000 DEX trades on BNB Chain, where buy currency smart contract is 0xbb4c…095c, sell currency smart contract is 0xe9e7…7d56 and DEX protocol name is pancake_swap_v3, sorted by block number: buy amount, buy amount in USD, buy decimals, buy currency symbol, buy smart contract, buy buyer, buy price in USD and 17 more fields.

By Andrej Narozny · saved 26 July 2024 · run 10 times · Bitquery API v2

What it returns

Filters

The query

{
  EVM(dataset: combined, network: bsc) {
    DEXTrades(
      where: {Block: {Time: {since: "2024-07-26T09:40:00Z", before: "2024-07-26T09:45:00Z"}}, Trade: {Buy: {Currency: {SmartContract: {is: "0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c"}}, PriceInUSD: {}}, Sell: {Currency: {SmartContract: {is: "0xe9e7cea3dedca5984780bafc599bd69add087d56"}}, PriceInUSD: {}}, Dex: {ProtocolName: {is: "pancake_swap_v3"}}}}
      limit: {count: 1000}
      orderBy: {ascending: Block_Number}
    ) {
      Trade {
        Buy {
          Amount
          AmountInUSD
          Currency {
            Decimals
            Symbol
            SmartContract
          }
          Buyer
          PriceInUSD
        }
        Sell {
          Amount
          AmountInUSD
          Currency {
            Decimals
            Name
            SmartContract
            Symbol
          }
          Seller
          PriceInUSD
        }
        Dex {
          ProtocolFamily
          ProtocolName
          SmartContract
        }
      }
      Block {
        Number
        Time
        Hash
      }
      Transaction {
        Hash
        Index
      }
      TransactionStatus {
        Success
      }
    }
  }
}

Variables

{
  "from": "2022-07-20T01:36:32Z",
  "to": "2022-07-20T01:37:32Z"
}

Similar queries