Latest price of a token - does not work for some

GraphQL API
1

Hi Folks,

I’m trying to fetch the price of some tokens. Poocoin got data points and it’s also old enough to be within bitquery’s dataset. Deleting the quotecurrency didn’t help.

That would be an non working example query for token: 0x7f77cc163c5cb572aa6851557398e296bad95e5b. However it works for other tokens with more trades

{
  ethereum(network: bsc) {
    dexTrades(
      options: {desc: ["block.height","tradeIndex"], limit: 1}
      exchangeName: {in: ["Pancake", "Pancake v2"]}
      baseCurrency: {is: "0x7f77cc163c5cb572aa6851557398e296bad95e5b"}
      quoteCurrency: {is: "0xe9e7cea3dedca5984780bafc599bd69add087d56"}
      date: {after: "2021-04-28"}
    ) {
      transaction {
        hash
      }
      tradeIndex
      smartContract {
        address {
          address
        }
        contractType
        currency {
          name
        }
      }
      tradeIndex
      block {
        height
      }
      baseCurrency {
        symbol
        address
      }
      quoteCurrency {
        symbol
        address
      }
      quotePrice
   
    }
  }
}

Any hints are appreciated! Thanks!

2

Should have removed the date filter too

{
  ethereum(network: bsc) {
    dexTrades(
      options: {desc: ["block.height","tradeIndex"], limit: 1}
      exchangeName: {in: ["Pancake", "Pancake v2"]}
      baseCurrency: {is: "0x7f77cc163c5cb572aa6851557398e296bad95e5b"}
    ) {
      transaction {
        hash
      }
      tradeIndex
      smartContract {
        address {
          address
        }
        contractType
        currency {
          name
        }
      }
      tradeIndex
      block {
        height
      }
      baseCurrency {
        symbol
        address
      }
      quoteCurrency {
        symbol
        address
      }
      quotePrice
   
    }
  }
}
3

Thanks for your answer. Actually datapoints are within the posted query now. I might should wait longer to fetch the prices

4

didn’t understand, is that a question or you need a more optimized query?

5

No, I think the tokens I want to get the price info for are not within bitquerys dataset. They will get into sometime after however.

Another example for the moment would be this token: 0x6b882a1949101acfcbf0f8ebe5daf769a2d37de2

For now poocoin shows me something, bitquery says there are no datapoints (regardless which query I use).

Thus I just need to wait till the data are within your dataset.

Poocoin Screenshot
Bitquery Screenshot

6

Is this token only on Pancake? We have a little delay check here https://bloxy.info/status

However, we are building a new real-time system which will solve this.