polygon-io / issues

Quickly track and report problems with polygon.io
29 stars 0 forks source link

Duplicate Rows in Returned Forex Data & Overflow #215

Closed eqTom closed 2 years ago

eqTom commented 2 years ago

URL https://api.polygon.io/v2/aggs/ticker/C:AUDUSD/range/1/minute/2022-05-01/2022-05-31?unadjusted=true&sort=asc&limit=50000

Result Query of 1 min Forex data (such as C:AUDUSD), is returning the same timestamp/data twice within the response, which also means some data is chopped, as the total monthly minuets then overflow the limit of 50,000 rows.

As an example screenshot below, you can see the first date returned "1651431900000" is duplicated a bit further down the API response.

Expected Result I would expect each sample to only appear once within the response.

Screenshots Screenshot

Desktop (please complete the following information):

Additional context None

stopdesign commented 2 years ago

Not only Forex data. Stocks as well. https://api.polygon.io/v2/aggs/ticker/URA/range/1/minute/1658393040000/1658393100000

{
  "ticker": "URA",
  "queryCount": 4,
  "resultsCount": 4,
  "adjusted": true,
  "results": [
    {
      "v": 600,
      "vw": 20.28,
      "o": 20.28,
      "c": 20.28,
      "h": 20.28,
      "l": 20.28,
      "t": 1658393040000,
      "n": 1
    },
    {
      "v": 949,
      "vw": 20.2741,
      "o": 20.28,
      "c": 20.27,
      "h": 20.28,
      "l": 20.27,
      "t": 1658393100000,
      "n": 3
    },
    {
      "v": 600,
      "vw": 20.28,
      "o": 20.28,
      "c": 20.28,
      "h": 20.28,
      "l": 20.28,
      "t": 1658393040000,
      "n": 1
    },
    {
      "v": 949,
      "vw": 20.2741,
      "o": 20.28,
      "c": 20.27,
      "h": 20.28,
      "l": 20.27,
      "t": 1658393100000,
      "n": 3
    }
  ],
  "status": "OK",
  "request_id": "xxx",
  "count": 4
}
Stormy110 commented 2 years ago

Hi there, apologies for the delayed response! These duplicates should be resolved. Please let us know if you continue to see any errant behavior!