Variation in prices count

Technical Help
#1

Hi

I have a history db that stores 1 minutes ticks for FXEURUSD sid from IBKR.

Ideally i should get 1425 rows of prices for all days of week except friday, saturday, and sunday.
And on Friday i should get 1020 when i do get_prices.

But I am getting following counts. For some days.

[708, 768, 960, 1357]

How to know why it is showing above count.

708, 2021-11-17, Wednesday
768, 2022-03-15, Tuesday
1020 ,2021-11-19, Friday
1425, 2021-11-16, Tuesday
1357, 2022-08-09, Tuesday
960, 2023-12-29, Friday

#2

My generic advice with troubleshooting something like this is to pick a particular day and investigate it in more detail. Right now it’s difficult to offer help based on the information you’ve provided. Try to home in on where exactly the unexpected result is coming in.

#3

I tried investigating it but Unable to come to any conclusion why prices are missing for certain dates and time. Its completely random. I Also tried to recollect the data still receiving the same number of ticks.

My DB Config is

{'universes': ['idealpro-fx'],
'vendor': 'ibkr',
'bar_size': '1 min',
'bar_type': 'ASK',
'shard': 'off',
'fields': {'Open': 'float',
'High': 'float',
'Low': 'float',
'Close': 'float',
'Volume': 'int',
'Wap': 'float',
'TradeCount': 'int',
'DayHigh': 'float',
'DayLow': 'float',
'DayVolume': 'int'}}

I am collecting data for SID FXEURUSD from IBKR broker .

#4

I would suggest pulling up a chart of the same time period and bar type (ASK) in Trader Workstation. If you recollected and got the same bar counts per day, that may mean that the data you're getting reflects what's available from IBKR. The API will generally only return the same thing that you can see in Trader Workstation, so it can be useful to cross-reference them with each other.