<p>这个问题有两个答案</p>
<ol>
<li>这将创建一个数据帧</li>
</ol>
<pre><code>import alpaca_trade_api as tradeapi #see https://alpaca.markets/
import pandas as pd
api = tradeapi.REST(key_id, secret_key, base_url)
symbol = 'AAPL'
bar= api.get_barset(symbol, 'day', limit=60).df
</code></pre>
<ol start=“2”>
<li>这是一种更为野蛮的方法,但也做了同样的事情</李>
</ol>
<pre><code>import alpaca_trade_api as tradeapi #see https://alpaca.markets/
import pandas as pd
api = tradeapi.REST(key_id, secret_key, base_url)
symbol = 'AAPL'
bar= api.get_barset(symbol, 'day', limit=60)
c = []
h = []
l = []
o = []
t = []
v = []
idx = []
i = 0
for i in range(len(bar[symbol])):
temp_c = c.append(bar[symbol][i].c)
temp_h = h.append(bar[symbol][i].h)
temp_l = l.append(bar[symbol][i].l)
temp_o = o.append(bar[symbol][i].o)
temp_t = t.append(bar[symbol][i].t)
temp_v = v.append(bar[symbol][i].v)
temp_idx = idx.append(i)
i = i + 1
df_bar_t = pd.DataFrame(t, idx,columns = ['Datetime'])
df_bar_c = pd.DataFrame(c, idx, columns = ['Close'])
df_bar_h = pd.DataFrame(h, idx, columns = ['High'])
df_bar_l = pd.DataFrame(l, idx, columns = ['Low'])
df_bar_o = pd.DataFrame(o, idx, columns = ['Open'])
df_bar_v = pd.DataFrame(v, idx, columns = ['Volume'])
mdf1 = pd.merge(df_bar_t,df_bar_c, left_index = True, right_index = True)
mdf2 = pd.merge(mdf1,df_bar_h, left_index = True, right_index = True )
mdf3 = pd.merge(mdf2,df_bar_l, left_index = True, right_index = True )
mdf4 = pd.merge(mdf3,df_bar_o, left_index = True, right_index = True )
mdf4 = pd.merge(mdf4,df_bar_v, left_index = True, right_index = True )
</code></pre>