Does anyone have the historical short availability and fee data of IB since 2020?
ColName CanNull ColType
======================== ======= =============
SHORTABLESTOCK_ID N NUMBER(22)
FILEDATE N DATE(7)
SYMBOL N VARCHAR2(16)
EXCHANGE N VARCHAR2(16)
COUNTRY Y VARCHAR2(16)
SOURCE N VARCHAR2(16)
CCY N VARCHAR2(6)
FULLNAME N VARCHAR2(64)
IBCONTRACTNUM N NUMBER(22)
PARTIALISIN N VARCHAR2(16)
REBATERATE Y NUMBER(22)
FEERATE Y NUMBER(22)
SHARESAVAILABLE N NUMBER(22)
BENCHMARKRATE Y NUMBER(22)
SHORTABLESTOCK_TSTAMP Y TIMESTAMP(3)(11)
I have this data back to 20170811, what date range are you interested in?
Let me know date range and desired fields and I will post it here.
Available fields:
Code:ColName CanNull ColType ======================== ======= ============= SHORTABLESTOCK_ID N NUMBER(22) FILEDATE N DATE(7) SYMBOL N VARCHAR2(16) EXCHANGE N VARCHAR2(16) COUNTRY Y VARCHAR2(16) SOURCE N VARCHAR2(16) CCY N VARCHAR2(6) FULLNAME N VARCHAR2(64) IBCONTRACTNUM N NUMBER(22) PARTIALISIN N VARCHAR2(16) REBATERATE Y NUMBER(22) FEERATE Y NUMBER(22) SHARESAVAILABLE N NUMBER(22) BENCHMARKRATE Y NUMBER(22) SHORTABLESTOCK_TSTAMP Y TIMESTAMP(3)(11)
Thank you so much. I am interested in data after 01/01/2020 at the moment. I need 4 fields: ticker, rebate rate, fee rate and shares available. Again, thank you for your generous help!