Notebook
In [27]:
print get_pricing(['xlb', 'xle', 'xlf', 'xli', 'xlk', 'xlp', 'xlu', 'xlv',
                   'xly', 'vnq', 'efa', 'eem', 'gld', 'hyg', 'lqd', 'tlt'],
                   fields=['close_price'],
                   start_date='2016-02-28',
                   end_date='2017-03-01').transpose(2, 1, 0).to_frame().tail()
                                       Equity(19654 [XLB])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price               52.530   
2017-02-15 00:00:00+00:00 close_price               52.460   
2017-02-16 00:00:00+00:00 close_price               52.440   
2017-02-17 00:00:00+00:00 close_price               52.290   
2017-02-21 00:00:00+00:00 close_price               52.465   

                                       Equity(19655 [XLE])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price               73.660   
2017-02-15 00:00:00+00:00 close_price               73.350   
2017-02-16 00:00:00+00:00 close_price               72.330   
2017-02-17 00:00:00+00:00 close_price               71.950   
2017-02-21 00:00:00+00:00 close_price               72.485   

                                       Equity(19656 [XLF])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price               24.325   
2017-02-15 00:00:00+00:00 close_price               24.510   
2017-02-16 00:00:00+00:00 close_price               24.470   
2017-02-17 00:00:00+00:00 close_price               24.470   
2017-02-21 00:00:00+00:00 close_price               24.580   

                                       Equity(19657 [XLI])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price                65.39   
2017-02-15 00:00:00+00:00 close_price                65.74   
2017-02-16 00:00:00+00:00 close_price                65.77   
2017-02-17 00:00:00+00:00 close_price                65.88   
2017-02-21 00:00:00+00:00 close_price                66.19   

                                       Equity(19658 [XLK])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price                51.70   
2017-02-15 00:00:00+00:00 close_price                51.90   
2017-02-16 00:00:00+00:00 close_price                52.03   
2017-02-17 00:00:00+00:00 close_price                52.17   
2017-02-21 00:00:00+00:00 close_price                52.44   

                                       Equity(19659 [XLP])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price                53.66   
2017-02-15 00:00:00+00:00 close_price                54.10   
2017-02-16 00:00:00+00:00 close_price                54.15   
2017-02-17 00:00:00+00:00 close_price                54.48   
2017-02-21 00:00:00+00:00 close_price                55.01   

                                       Equity(19660 [XLU])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price                49.19   
2017-02-15 00:00:00+00:00 close_price                49.05   
2017-02-16 00:00:00+00:00 close_price                49.56   
2017-02-17 00:00:00+00:00 close_price                49.58   
2017-02-21 00:00:00+00:00 close_price                50.10   

                                       Equity(19661 [XLV])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price                72.84   
2017-02-15 00:00:00+00:00 close_price                73.68   
2017-02-16 00:00:00+00:00 close_price                73.59   
2017-02-17 00:00:00+00:00 close_price                73.65   
2017-02-21 00:00:00+00:00 close_price                73.98   

                                       Equity(19662 [XLY])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price                86.31   
2017-02-15 00:00:00+00:00 close_price                86.75   
2017-02-16 00:00:00+00:00 close_price                86.35   
2017-02-17 00:00:00+00:00 close_price                86.58   
2017-02-21 00:00:00+00:00 close_price                87.10   

                                       Equity(26669 [VNQ])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price                83.40   
2017-02-15 00:00:00+00:00 close_price                83.12   
2017-02-16 00:00:00+00:00 close_price                83.60   
2017-02-17 00:00:00+00:00 close_price                83.77   
2017-02-21 00:00:00+00:00 close_price                84.84   

                                       Equity(22972 [EFA])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price                60.27   
2017-02-15 00:00:00+00:00 close_price                60.51   
2017-02-16 00:00:00+00:00 close_price                60.65   
2017-02-17 00:00:00+00:00 close_price                60.48   
2017-02-21 00:00:00+00:00 close_price                60.69   

                                       Equity(24705 [EEM])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price               38.375   
2017-02-15 00:00:00+00:00 close_price               38.690   
2017-02-16 00:00:00+00:00 close_price               38.540   
2017-02-17 00:00:00+00:00 close_price               38.370   
2017-02-21 00:00:00+00:00 close_price               38.800   

                                       Equity(26807 [GLD])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price               116.93   
2017-02-15 00:00:00+00:00 close_price               117.44   
2017-02-16 00:00:00+00:00 close_price               118.06   
2017-02-17 00:00:00+00:00 close_price               117.67   
2017-02-21 00:00:00+00:00 close_price               117.74   

                                       Equity(33655 [HYG])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price               87.720   
2017-02-15 00:00:00+00:00 close_price               87.745   
2017-02-16 00:00:00+00:00 close_price               87.670   
2017-02-17 00:00:00+00:00 close_price               87.760   
2017-02-21 00:00:00+00:00 close_price               88.050   

                                       Equity(23881 [LQD])  \
major                     minor                              
2017-02-14 00:00:00+00:00 close_price               117.20   
2017-02-15 00:00:00+00:00 close_price               117.08   
2017-02-16 00:00:00+00:00 close_price               117.43   
2017-02-17 00:00:00+00:00 close_price               117.73   
2017-02-21 00:00:00+00:00 close_price               117.77   

                                       Equity(23921 [TLT])  
major                     minor                             
2017-02-14 00:00:00+00:00 close_price               119.51  
2017-02-15 00:00:00+00:00 close_price               118.97  
2017-02-16 00:00:00+00:00 close_price               119.61  
2017-02-17 00:00:00+00:00 close_price               120.34  
2017-02-21 00:00:00+00:00 close_price               120.10  
In [ ]:
 
In [ ]: