GraphQL: the high price some tokens are incorrect

GraphQL API
1

Hi There,
My team had purchased API key.After that we query some tokens and got the high price some time is incorrect.Can you help to check ?
Query of PEPE token and the response at 2023-7-30 9:20:00 the high price too high.

2023-07-31 12.01.56_demo1
2023-07-31 12.01.56_demo11180Ă—1036 93.6 KB

1 Like
2

I checked the OHLC candles for PEPE-WETH at 5 minute interval

 {
  "ethereum": {
    "ethereum": {
      "dexTrades": [
        {
          "timeInterval": {
            "minute": "2023-07-30 09:20:00"
          },
          "sellCurrency": {
            "address": "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"
          },
          "high": 1.4211078553814367e-9,
          "low": 7.060991807946151e-10,
          "open": "7.060991807946151e-10",
          "close": "7.060991807946151e-10"
        },
        {
          "timeInterval": {
            "minute": "2023-07-30 09:15:00"
          },
          "sellCurrency": {
            "address": "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"
          },
          "high": 7.066642446601835e-10,
          "low": 7.066642446601835e-10,
          "open": "7.066642446601835e-10",
          "close": "7.066642446601835e-10"
        },
        {
          "timeInterval": {
            "minute": "2023-07-30 09:10:00"
          },
          "sellCurrency": {
            "address": "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"
          },
          "high": 1.4211078553814367e-9,
          "low": 7.10676301197588e-10,
          "open": "7.10676301197588e-10",
          "close": "7.10676301197588e-10"
        },
        {
          "timeInterval": {
            "minute": "2023-07-30 09:05:00"
          },
          "sellCurrency": {
            "address": "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"
          },
          "high": 7.102404141207973e-10,
          "low": 7.061597237952775e-10,
          "open": "7.102404141207973e-10",
          "close": "7.102404141207973e-10"
        }
      ]
    }
  }
}

The spike in the 2023-07-30 09:20:00 candle is due to this particular trade

PEPE Trade that happened at 2023-07-30 09:20:11

3

Hi @Divya ,
Thanks for your replied but I don’t understand what you mean. At the 2023-07-30 09:20:00 ,we had “high”: 1.4211078553814367e-9 can you explain more details.With the high price so the chart look too weird and other dextool I dont see this bar and dont have any transaction with that price.

image
image1289Ă—813 30.6 KB

I saw this transaction swap from PEPE to other token that isn’t USDT or ETH.

How can we know the transaction like this in bitquery and we can recalculate the price ?

Thanks

4

Please try this query

We are using PriceAsymmetry and TradeAmountUSD to filter out anomalies.

PriceAsymmetry - We take both sell amount and buy amount and convert them into USD independently and check their value. If we write PriceAsymmetry: {lt: 1} it means if there is delta between buy amount and sell amount less than 1, then consider that trade otherwise don’t consider that trade in the results.

TradeAmountUSD - Buy amount in USD + Sell Amount in USD

1 Like
5

goi it, thanks @gaurav

1 Like