hello @tomoya.suzuki.lab

There's a limit of the Eikon Data API, for more detail, please check Eikon Data API Usage and Limits Guideline. This case is about "Call-based Limits"

Datapoints returned per request - A datapoint is a 'cell', or a unique field value for a unique instrument on a unique time stamp. Datapoint limits vary by the content set being retrieved (for example, timeseries limits are different from news headline limits), but all are throttled on a per request basis and are not aggregated across all applications. Here are Datapoint limit examples per Eikon Data API function type 

get_timeseries: The current limit value (10-Oct-2019) is 3,000 data points (rows) for interday intervals and 50,000 data points for intraday intervals. This limit applies to the whole request, whatever the number of requested instrument.

the length of the list "code" from your code is 225 RICs, and there're 13 rows of the date in the output (mean there's 225 * 13 = 2925 rows returned)

qna-001.png

To get the data of all the dates, you may loop the request and merge the output datasets together later. Each loop can either loop through the RIC list or date list.

For example, to loop through the RIC list,

• get the maximum number of RIC that can be called in a request 3000, divided by the number of dates you'd like to request the data
  • for 2017-01-01 and 2021-02-18, there are 1510 dates
  • 3000/1510 = 1 so only 1 RIC can be called per the request
• below is an example code to get data and merge the output data frames of the first 3 RICs

df = ek.get_timeseries(code[0],start_date = '2017-01-01', end_date = '2021-02-18')
df = df.add_prefix(f'{code[0]}_')

for _ in code[1:3]:
    df_temp = ek.get_timeseries(_,start_date = '2017-01-01', end_date = '2021-02-18')
    df_temp = df_temp.add_prefix(f'{_}_')
    df = df.merge(df_temp, how='outer', on='Date')
display(df)

• an output qna-002.png

Hope this could help

ご回答ありがとうございました。
参考にさせていただきます。

Hello @tomoya.suzuki.lab and all,

Per Google translate "Thank you for your answer. I am going to use it as an example." I am marking answer by @raksina.samasiri as correct in answering the question.