Pool trades2

Returns the latest 10 DEX trades on Ethereum and BNB Chain, where smart contract address is 0x58f8…dc16, exchange name is Pancake v2 and date since 2022-08-26: timestamp time, block height, trade index, protocol, full name, address address, annotation and 8 more fields.

By Niceface · saved 4 July 2024 · run 8 times · Bitquery API v1

What it returns

Filters

The query

query ($network: EthereumNetwork!, $limit: Int!, $offset: Int!, $exchange: String!, $from: ISO8601DateTime, $till: ISO8601DateTime) {
  ethereum(network: $network) {
    dexTrades(
      options: {desc: ["block.height", "tradeIndex"], limit: $limit, offset: $offset}
      date: {since: $from, till: $till}
      exchangeName: {is: $exchange}
      smartContractAddress: {is: "0x58f876857a02d6762e0101bb5c46a8c1ed44dc16"}
    ) {
      block {
        timestamp {
          time(format: "%Y-%m-%d %H:%M:%S")
        }
        height
      }
      tradeIndex
      protocol
      exchange {
        fullName
      }
      smartContract {
        address {
          address
          annotation
        }
      }
      buyAmount
      buy_amount_usd: buyAmount(in: USD)
      buyCurrency {
        address
        symbol
      }
      sellAmount
      sell_amount_usd: sellAmount(in: USD)
      sellCurrency {
        address
        symbol
      }
      transaction {
        hash
        gasValue
        
      }
    }
  }
}

Variables

{
  "limit": 10,
  "offset": 0,
  "network": "bsc",
  "exchange": "Pancake v2",
  "from": "2022-08-26",
  "till": "2022-09-02T23:59:59",
  "dateFormat": "%Y-%m-%d"
}

Similar queries