Query new pairs created and volume greater than 10k on BSC

GraphQL API
1

Hi, I would like to query the latest pancake v2 pairs with volume greater than 10k, limit is 100. Would be grateful if anyone can do this for me. Thank you

2

Check this

{
  ethereum(network: bsc) {
    dexTrades(options: {limit: 100, desc: ["block.height", "tradeIndex"]},
      date: {since: "2021-06-05"}
      tradeAmountUsd : {gt: 10000}
      exchangeName: {in: ["Pancake", "Pancake v2"]}) {
      transaction {
        hash
      }
      smartContract{
        address{
          address
        }
        contractType
        currency{
          name
        }
      }
      tradeIndex
      date {
        date
      }
      block {
        height
      }
      buyAmount
      buyAmountInUsd: buyAmount(in: USD)
      buyCurrency {
        symbol
        address
      }
      sellAmount
    	sellAmountInUsd: sellAmount(in: USD)
      sellCurrency {
        symbol
        address
      }
      sellAmountInUsd: sellAmount(in: USD)
      tradeAmount(in: USD)
      transaction{
        gasValue
        gasPrice
        gas
      }
    }
  }
}
3

Thank you. However I would like a query 24Hr Volume (above 10k) for New Pairs Created, using date query

4

Then you need two things,

1- Get the latest pancake pairs

2- Check their daily trading volume

2nd part is only mentioned above

1st part example is here - Latest Pair Created on Pancake Swap

5

Awesome. But is there a way to query for volume of multiple token addresses in one query?

6

Yes… It’s easy just pass multiple address in the filter…

Or another way is following

7

Thank you for the responses. I’m a newbie to this. I would like you to send me a sample query of 24hr volume of multiple token addresses.

8

Sorry it didn’t work for me.
Could you please help me :

  1. Latest pair on pancake (100)
  2. Trade volume overall > 10000
  3. Holders > 100

It would be great to have this query.

9

Would be great to have this query

10

What do you have so far ? Can you please share ?

11
  1. Latest pair on pancake (100)

Use this as example - Latest Pair Created on Pancake Swap

  1. Trade volume overall > 10000

Pairs with more than 10k in trading volume

  1. Holders > 100
    This is not possible with any direct query

  2. volume of multiple token addresses in one query
    2nd points provide that, but let’s say you want volume for specific addresses. use the following query (replace address1 and address2).

{
  ethereum(network: bsc) {
    dexTrades(
      options: {limit: 100, desc: ["block.height", "tradeIndex"]}
      date: {since: "2021-06-05"}
      tradeAmountUsd: {gt: 10000}
      smartContractAddress: {in: ["address1", "address2"]}
      exchangeName: {in: ["Pancake", "Pancake v2"]}
    ) {
      transaction {
        hash
      }
      smartContract {
        address {
          address
        }
        contractType
        currency {
          name
        }
      }
      tradeIndex
      date {
        date
      }
      block {
        height
      }
      buyAmount
      buyAmountInUsd: buyAmount(in: USD)
      buyCurrency {
        symbol
        address
      }
      sellAmount
      sellAmountInUsd: sellAmount(in: USD)
      sellCurrency {
        symbol
        address
      }
      sellAmountInUsd: sellAmount(in: USD)
      tradeAmount(in: USD)
      transaction {
        gasValue
        gasPrice
        gas
      }
    }
  }
}
  1. Query of 24hr volume of multiple token addresses

Change the time accordingly.

{
  ethereum(network: bsc) {
    dexTrades(
      options: {limit: 100, desc: ["block.height", "tradeIndex"]}
      time: {since: "2020-11-24T00:00:00", till: "2020-11-25T00:00:00"}
      tradeAmountUsd: {gt: 10000}
      smartContractAddress: {in: ["address1", "address2"]}
      exchangeName: {in: ["Pancake", "Pancake v2"]}
    ) {
      transaction {
        hash
      }
      smartContract {
        address {
          address
        }
        contractType
        currency {
          name
        }
      }
      tradeIndex
      date {
        date
      }
      block {
        height
      }
      buyAmount
      buyAmountInUsd: buyAmount(in: USD)
      buyCurrency {
        symbol
        address
      }
      sellAmount
      sellAmountInUsd: sellAmount(in: USD)
      sellCurrency {
        symbol
        address
      }
      sellAmountInUsd: sellAmount(in: USD)
      tradeAmount(in: USD)
      transaction {
        gasValue
        gasPrice
        gas
      }
    }
  }
}
12

great
thank you so much.

Is it possible to use
arguments and dexTrades in single query ?