Incorrect Price Data for CAKE/WBNB

GraphQL API
,
1

I executed this query to get the oldest price of CAKE with respect to WBNB

{
  ethereum(network: bsc) {
    dexTrades(
      baseCurrency: {is: "0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82"} #CAKE
      quoteCurrency: {is: "0xbb4CdB9CBd36B01bD1cBaEBF2De08d9173bc095c"} #WBNB
      options: {asc: ["block.height", "transaction.index"], limit: 20}
    ) {
      block {
        height
        timestamp {
          time(format: "%Y-%m-%d %H:%M:%S")
        }
      }
      transaction {
        index
      }
      baseCurrency {
        symbol
      }
      quoteCurrency {
        symbol
      }
      quotePrice
    }
  }
}

The relative price data shows inconsistent and extremely small values for the first few rows. The same issue happens with many other tokens in USDT.

{
  "ethereum": {
    "dexTrades": [
      {
        "block": {
          "height": 701536,
          "timestamp": {
            "time": "2020-09-22 12:06:28"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 0.02004028016071021
      },
      {
        "block": {
          "height": 702046,
          "timestamp": {
            "time": "2020-09-22 12:31:58"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 0.020240482559122298
      },
      {
        "block": {
          "height": 702140,
          "timestamp": {
            "time": "2020-09-22 12:36:40"
          }
        },
        "transaction": {
          "index": 1
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 808.0124267256822
      },
      {
        "block": {
          "height": 702222,
          "timestamp": {
            "time": "2020-09-22 12:40:46"
          }
        },
        "transaction": {
          "index": 1
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 35993005.19855432
      },
      {
        "block": {
          "height": 702232,
          "timestamp": {
            "time": "2020-09-22 12:41:16"
          }
        },
        "transaction": {
          "index": 1
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 43186025.66543202
      },
      {
        "block": {
          "height": 702239,
          "timestamp": {
            "time": "2020-09-22 12:41:37"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 46543903.74455591
      },
      {
        "block": {
          "height": 702279,
          "timestamp": {
            "time": "2020-09-22 12:43:37"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 49511973.202246964
      },
      {
        "block": {
          "height": 702307,
          "timestamp": {
            "time": "2020-09-22 12:45:01"
          }
        },
        "transaction": {
          "index": 1
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 65203430.749742344
      },
      {
        "block": {
          "height": 702346,
          "timestamp": {
            "time": "2020-09-22 12:46:58"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 94665436.07768796
      },
      {
        "block": {
          "height": 702397,
          "timestamp": {
            "time": "2020-09-22 12:49:31"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 113311580.9310489
      },
      {
        "block": {
          "height": 702569,
          "timestamp": {
            "time": "2020-09-22 12:58:07"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 119960751.0015658
      },
      {
        "block": {
          "height": 702716,
          "timestamp": {
            "time": "2020-09-22 13:05:28"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 108502806.3315455
      },
      {
        "block": {
          "height": 702738,
          "timestamp": {
            "time": "2020-09-22 13:06:34"
          }
        },
        "transaction": {
          "index": 3
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 83449234.83790848
      },
      {
        "block": {
          "height": 702752,
          "timestamp": {
            "time": "2020-09-22 13:07:16"
          }
        },
        "transaction": {
          "index": 1
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 61668499.99704604
      },
      {
        "block": {
          "height": 702908,
          "timestamp": {
            "time": "2020-09-22 13:15:04"
          }
        },
        "transaction": {
          "index": 5
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 52724985.25474609
      },
      {
        "block": {
          "height": 702923,
          "timestamp": {
            "time": "2020-09-22 13:15:49"
          }
        },
        "transaction": {
          "index": 2
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 58343860.282496385
      },
      {
        "block": {
          "height": 702935,
          "timestamp": {
            "time": "2020-09-22 13:16:25"
          }
        },
        "transaction": {
          "index": 1
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 64560491.37821527
      },
      {
        "block": {
          "height": 702964,
          "timestamp": {
            "time": "2020-09-22 13:17:52"
          }
        },
        "transaction": {
          "index": 2
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 55557425.201807156
      },
      {
        "block": {
          "height": 702969,
          "timestamp": {
            "time": "2020-09-22 13:18:07"
          }
        },
        "transaction": {
          "index": 11
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 55749592.79874139
      },
      {
        "block": {
          "height": 702984,
          "timestamp": {
            "time": "2020-09-22 13:18:52"
          }
        },
        "transaction": {
          "index": 6
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "WBNB"
        },
        "quotePrice": 55526817.425387986
      }
    ]
  }
}

Why does this happen? Is there any way to correct his?

2

Same issue with CAKE/USDT Prices

{
  "ethereum": {
    "dexTrades": [
      {
        "block": {
          "height": 806680,
          "timestamp": {
            "time": "2020-09-26 03:43:40"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 86996.85211209327
      },
      {
        "block": {
          "height": 806695,
          "timestamp": {
            "time": "2020-09-26 03:44:25"
          }
        },
        "transaction": {
          "index": 1
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 67198.1936049836
      },
      {
        "block": {
          "height": 806722,
          "timestamp": {
            "time": "2020-09-26 03:45:46"
          }
        },
        "transaction": {
          "index": 2
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 51710.05557715066
      },
      {
        "block": {
          "height": 807368,
          "timestamp": {
            "time": "2020-09-26 04:18:04"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 38315.68350729328
      },
      {
        "block": {
          "height": 807394,
          "timestamp": {
            "time": "2020-09-26 04:19:22"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 27921.43508444946
      },
      {
        "block": {
          "height": 807424,
          "timestamp": {
            "time": "2020-09-26 04:20:52"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 20485.611050123367
      },
      {
        "block": {
          "height": 807440,
          "timestamp": {
            "time": "2020-09-26 04:21:40"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 15539.902094192408
      },
      {
        "block": {
          "height": 807469,
          "timestamp": {
            "time": "2020-09-26 04:23:07"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 11901.984058878406
      },
      {
        "block": {
          "height": 807497,
          "timestamp": {
            "time": "2020-09-26 04:24:31"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 8904.35997523931
      },
      {
        "block": {
          "height": 807839,
          "timestamp": {
            "time": "2020-09-26 04:41:37"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 6727.347059156863
      },
      {
        "block": {
          "height": 809043,
          "timestamp": {
            "time": "2020-09-26 05:41:49"
          }
        },
        "transaction": {
          "index": 1
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 5265.563811216293
      },
      {
        "block": {
          "height": 809113,
          "timestamp": {
            "time": "2020-09-26 05:45:19"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 4491.708392723336
      },
      {
        "block": {
          "height": 809119,
          "timestamp": {
            "time": "2020-09-26 05:45:37"
          }
        },
        "transaction": {
          "index": 1
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 4085.151517874105
      },
      {
        "block": {
          "height": 809125,
          "timestamp": {
            "time": "2020-09-26 05:45:55"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 3697.8844644628125
      },
      {
        "block": {
          "height": 809219,
          "timestamp": {
            "time": "2020-09-26 05:50:37"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 3339.095581172398
      },
      {
        "block": {
          "height": 809229,
          "timestamp": {
            "time": "2020-09-26 05:51:07"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 3015.6536683498466
      },
      {
        "block": {
          "height": 809238,
          "timestamp": {
            "time": "2020-09-26 05:51:34"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 2724.8812644753916
      },
      {
        "block": {
          "height": 809285,
          "timestamp": {
            "time": "2020-09-26 05:53:55"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 2487.9156590666717
      },
      {
        "block": {
          "height": 809293,
          "timestamp": {
            "time": "2020-09-26 05:54:19"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 2290.718941424932
      },
      {
        "block": {
          "height": 809306,
          "timestamp": {
            "time": "2020-09-26 05:54:58"
          }
        },
        "transaction": {
          "index": 0
        },
        "baseCurrency": {
          "symbol": "Cake"
        },
        "quoteCurrency": {
          "symbol": "USDT"
        },
        "quotePrice": 2101.6676180895224
      }
    ]
  }
}
3

@gaurav can you please explain why the quotePrice for Cake @ timestamp 2020-09-26 03:34:30 shows 86996? This price data seems incorrect

4

We need to check this…will return on it

5

@vaibhav Is this solved?..

6

Yes, thank you for your help