in Excel have data for all dayes. Python api get_data giving only 1 data record.
Same result after adding start and end date.
History is not captured for every field available. For example, you are requesting for CF_BID which is a realtime field coming from the realtime database. Instead, you will want to find which fields history is available within the Data Item Browser. For example, I requested for this simple query for bid value and the date of the bid:
Within the Data Item Browser, you can find the fields that may suit your requirements and determine which one has historical values.