example_code.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "1987-06-16    2.0\n",
       "2000-06-21    2.0\n",
       "2005-02-28    2.0\n",
       "2014-06-09    7.0\n",
       "Name: Stock Splits, dtype: float64"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import yfinance as yf\n",
    "\n",
    "apple = yf.Ticker(\"aapl\")\n",
    "\n",
    "# show actions (dividends, splits)\n",
    "apple.actions\n",
    "\n",
    "# show dividends\n",
    "apple.dividends\n",
    "\n",
    "# show splits\n",
    "apple.splits"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "yfinance.Ticker object <AAPL>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import yfinance as yf\n",
    "\n",
    "aapl = yf.Ticker(\"aapl\")\n",
    "aapl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Dividends</th>\n",
       "      <th>Stock Splits</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-06-02 09:30:00-04:00</th>\n",
       "      <td>320.74</td>\n",
       "      <td>321.68</td>\n",
       "      <td>320.62</td>\n",
       "      <td>321.22</td>\n",
       "      <td>952792</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-02 09:31:00-04:00</th>\n",
       "      <td>321.23</td>\n",
       "      <td>321.31</td>\n",
       "      <td>320.78</td>\n",
       "      <td>321.03</td>\n",
       "      <td>90413</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-02 09:32:00-04:00</th>\n",
       "      <td>321.02</td>\n",
       "      <td>321.93</td>\n",
       "      <td>321.02</td>\n",
       "      <td>321.67</td>\n",
       "      <td>192949</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-02 09:33:00-04:00</th>\n",
       "      <td>321.71</td>\n",
       "      <td>321.74</td>\n",
       "      <td>321.28</td>\n",
       "      <td>321.44</td>\n",
       "      <td>113366</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-02 09:34:00-04:00</th>\n",
       "      <td>321.43</td>\n",
       "      <td>321.94</td>\n",
       "      <td>321.43</td>\n",
       "      <td>321.55</td>\n",
       "      <td>101503</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-05 15:55:00-04:00</th>\n",
       "      <td>330.62</td>\n",
       "      <td>330.88</td>\n",
       "      <td>330.47</td>\n",
       "      <td>330.76</td>\n",
       "      <td>187683</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-05 15:56:00-04:00</th>\n",
       "      <td>330.75</td>\n",
       "      <td>330.81</td>\n",
       "      <td>330.35</td>\n",
       "      <td>330.50</td>\n",
       "      <td>153105</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-05 15:57:00-04:00</th>\n",
       "      <td>330.50</td>\n",
       "      <td>330.80</td>\n",
       "      <td>330.40</td>\n",
       "      <td>330.45</td>\n",
       "      <td>144010</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-05 15:58:00-04:00</th>\n",
       "      <td>330.45</td>\n",
       "      <td>330.99</td>\n",
       "      <td>330.35</td>\n",
       "      <td>330.93</td>\n",
       "      <td>253691</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-05 15:59:00-04:00</th>\n",
       "      <td>330.92</td>\n",
       "      <td>331.63</td>\n",
       "      <td>330.91</td>\n",
       "      <td>331.63</td>\n",
       "      <td>473898</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1553 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Open    High     Low   Close  Volume  Dividends  \\\n",
       "Datetime                                                                       \n",
       "2020-06-02 09:30:00-04:00  320.74  321.68  320.62  321.22  952792          0   \n",
       "2020-06-02 09:31:00-04:00  321.23  321.31  320.78  321.03   90413          0   \n",
       "2020-06-02 09:32:00-04:00  321.02  321.93  321.02  321.67  192949          0   \n",
       "2020-06-02 09:33:00-04:00  321.71  321.74  321.28  321.44  113366          0   \n",
       "2020-06-02 09:34:00-04:00  321.43  321.94  321.43  321.55  101503          0   \n",
       "...                           ...     ...     ...     ...     ...        ...   \n",
       "2020-06-05 15:55:00-04:00  330.62  330.88  330.47  330.76  187683          0   \n",
       "2020-06-05 15:56:00-04:00  330.75  330.81  330.35  330.50  153105          0   \n",
       "2020-06-05 15:57:00-04:00  330.50  330.80  330.40  330.45  144010          0   \n",
       "2020-06-05 15:58:00-04:00  330.45  330.99  330.35  330.93  253691          0   \n",
       "2020-06-05 15:59:00-04:00  330.92  331.63  330.91  331.63  473898          0   \n",
       "\n",
       "                           Stock Splits  \n",
       "Datetime                                 \n",
       "2020-06-02 09:30:00-04:00             0  \n",
       "2020-06-02 09:31:00-04:00             0  \n",
       "2020-06-02 09:32:00-04:00             0  \n",
       "2020-06-02 09:33:00-04:00             0  \n",
       "2020-06-02 09:34:00-04:00             0  \n",
       "...                                 ...  \n",
       "2020-06-05 15:55:00-04:00             0  \n",
       "2020-06-05 15:56:00-04:00             0  \n",
       "2020-06-05 15:57:00-04:00             0  \n",
       "2020-06-05 15:58:00-04:00             0  \n",
       "2020-06-05 15:59:00-04:00             0  \n",
       "\n",
       "[1553 rows x 7 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import yfinance as yf\n",
    "\n",
    "aapl = yf.Ticker(\"aapl\")\n",
    "\n",
    "# get stock info\n",
    "aapl_historical = aapl.history(start=\"2020-06-02\", end=\"2020-06-07\", interval=\"1m\")\n",
    "aapl_historical"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "tickers = yf.Tickers('msft aapl goog')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "yfinance.Tickers object <MSFT,AAPL,GOOG>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tickers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'Tickers' object has no attribute 'msft'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-100-956e879287e2>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[1;31m# TICKERS OBJECT IS BROKEN\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0mtickers\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mmsft\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0minfo\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m: 'Tickers' object has no attribute 'msft'"
     ]
    }
   ],
   "source": [
    "# TICKERS OBJECT IS BROKEN\n",
    "tickers.msft.info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  3 of 3 completed\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"3\" halign=\"left\">Adj Close</th>\n",
       "      <th colspan=\"3\" halign=\"left\">Close</th>\n",
       "      <th colspan=\"3\" halign=\"left\">High</th>\n",
       "      <th colspan=\"3\" halign=\"left\">Low</th>\n",
       "      <th colspan=\"3\" halign=\"left\">Open</th>\n",
       "      <th colspan=\"3\" halign=\"left\">Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>AAPL</th>\n",
       "      <th>AMZN</th>\n",
       "      <th>GOOG</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>AMZN</th>\n",
       "      <th>GOOG</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>AMZN</th>\n",
       "      <th>GOOG</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>AMZN</th>\n",
       "      <th>GOOG</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>AMZN</th>\n",
       "      <th>GOOG</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>AMZN</th>\n",
       "      <th>GOOG</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2017-01-03</th>\n",
       "      <td>110.392334</td>\n",
       "      <td>753.669983</td>\n",
       "      <td>786.140015</td>\n",
       "      <td>116.150002</td>\n",
       "      <td>753.669983</td>\n",
       "      <td>786.140015</td>\n",
       "      <td>116.330002</td>\n",
       "      <td>758.760010</td>\n",
       "      <td>789.630005</td>\n",
       "      <td>114.760002</td>\n",
       "      <td>747.700012</td>\n",
       "      <td>775.799988</td>\n",
       "      <td>115.800003</td>\n",
       "      <td>757.919983</td>\n",
       "      <td>778.809998</td>\n",
       "      <td>28781900</td>\n",
       "      <td>3521100</td>\n",
       "      <td>1657300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-04</th>\n",
       "      <td>110.268791</td>\n",
       "      <td>757.179993</td>\n",
       "      <td>786.900024</td>\n",
       "      <td>116.019997</td>\n",
       "      <td>757.179993</td>\n",
       "      <td>786.900024</td>\n",
       "      <td>116.510002</td>\n",
       "      <td>759.679993</td>\n",
       "      <td>791.340027</td>\n",
       "      <td>115.750000</td>\n",
       "      <td>754.200012</td>\n",
       "      <td>783.159973</td>\n",
       "      <td>115.849998</td>\n",
       "      <td>758.390015</td>\n",
       "      <td>788.359985</td>\n",
       "      <td>21118100</td>\n",
       "      <td>2510500</td>\n",
       "      <td>1073000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-05</th>\n",
       "      <td>110.829552</td>\n",
       "      <td>780.450012</td>\n",
       "      <td>794.020020</td>\n",
       "      <td>116.610001</td>\n",
       "      <td>780.450012</td>\n",
       "      <td>794.020020</td>\n",
       "      <td>116.860001</td>\n",
       "      <td>782.400024</td>\n",
       "      <td>794.479980</td>\n",
       "      <td>115.809998</td>\n",
       "      <td>760.260010</td>\n",
       "      <td>785.020020</td>\n",
       "      <td>115.919998</td>\n",
       "      <td>761.549988</td>\n",
       "      <td>786.080017</td>\n",
       "      <td>22193600</td>\n",
       "      <td>5830100</td>\n",
       "      <td>1335200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-06</th>\n",
       "      <td>112.065109</td>\n",
       "      <td>795.989990</td>\n",
       "      <td>806.150024</td>\n",
       "      <td>117.910004</td>\n",
       "      <td>795.989990</td>\n",
       "      <td>806.150024</td>\n",
       "      <td>118.160004</td>\n",
       "      <td>799.440002</td>\n",
       "      <td>807.900024</td>\n",
       "      <td>116.470001</td>\n",
       "      <td>778.479980</td>\n",
       "      <td>792.203979</td>\n",
       "      <td>116.779999</td>\n",
       "      <td>782.359985</td>\n",
       "      <td>795.260010</td>\n",
       "      <td>31751900</td>\n",
       "      <td>5986200</td>\n",
       "      <td>1640200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-09</th>\n",
       "      <td>113.091560</td>\n",
       "      <td>796.919983</td>\n",
       "      <td>806.650024</td>\n",
       "      <td>118.989998</td>\n",
       "      <td>796.919983</td>\n",
       "      <td>806.650024</td>\n",
       "      <td>119.430000</td>\n",
       "      <td>801.770020</td>\n",
       "      <td>809.966003</td>\n",
       "      <td>117.940002</td>\n",
       "      <td>791.770020</td>\n",
       "      <td>802.830017</td>\n",
       "      <td>117.949997</td>\n",
       "      <td>798.000000</td>\n",
       "      <td>806.400024</td>\n",
       "      <td>33561900</td>\n",
       "      <td>3446100</td>\n",
       "      <td>1274600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-24</th>\n",
       "      <td>137.111542</td>\n",
       "      <td>907.409973</td>\n",
       "      <td>862.760010</td>\n",
       "      <td>143.639999</td>\n",
       "      <td>907.409973</td>\n",
       "      <td>862.760010</td>\n",
       "      <td>143.949997</td>\n",
       "      <td>909.989990</td>\n",
       "      <td>863.450012</td>\n",
       "      <td>143.179993</td>\n",
       "      <td>903.820007</td>\n",
       "      <td>849.859985</td>\n",
       "      <td>143.500000</td>\n",
       "      <td>908.679993</td>\n",
       "      <td>851.200012</td>\n",
       "      <td>17134300</td>\n",
       "      <td>3122900</td>\n",
       "      <td>1372500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-25</th>\n",
       "      <td>137.961105</td>\n",
       "      <td>907.619995</td>\n",
       "      <td>872.299988</td>\n",
       "      <td>144.529999</td>\n",
       "      <td>907.619995</td>\n",
       "      <td>872.299988</td>\n",
       "      <td>144.899994</td>\n",
       "      <td>909.479980</td>\n",
       "      <td>875.000000</td>\n",
       "      <td>143.869995</td>\n",
       "      <td>903.000000</td>\n",
       "      <td>862.809998</td>\n",
       "      <td>143.910004</td>\n",
       "      <td>907.039978</td>\n",
       "      <td>865.000000</td>\n",
       "      <td>18871500</td>\n",
       "      <td>3380600</td>\n",
       "      <td>1672000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-26</th>\n",
       "      <td>137.149704</td>\n",
       "      <td>909.289978</td>\n",
       "      <td>871.729980</td>\n",
       "      <td>143.679993</td>\n",
       "      <td>909.289978</td>\n",
       "      <td>871.729980</td>\n",
       "      <td>144.600006</td>\n",
       "      <td>915.750000</td>\n",
       "      <td>876.049988</td>\n",
       "      <td>143.380005</td>\n",
       "      <td>907.559998</td>\n",
       "      <td>867.747986</td>\n",
       "      <td>144.470001</td>\n",
       "      <td>910.299988</td>\n",
       "      <td>874.229980</td>\n",
       "      <td>20041200</td>\n",
       "      <td>2608900</td>\n",
       "      <td>1237200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-27</th>\n",
       "      <td>137.254684</td>\n",
       "      <td>918.380005</td>\n",
       "      <td>874.250000</td>\n",
       "      <td>143.789993</td>\n",
       "      <td>918.380005</td>\n",
       "      <td>874.250000</td>\n",
       "      <td>144.160004</td>\n",
       "      <td>921.859985</td>\n",
       "      <td>875.400024</td>\n",
       "      <td>143.309998</td>\n",
       "      <td>912.109985</td>\n",
       "      <td>870.380005</td>\n",
       "      <td>143.919998</td>\n",
       "      <td>914.390015</td>\n",
       "      <td>873.599976</td>\n",
       "      <td>14246300</td>\n",
       "      <td>5305500</td>\n",
       "      <td>2026800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-28</th>\n",
       "      <td>137.121063</td>\n",
       "      <td>924.989990</td>\n",
       "      <td>905.960022</td>\n",
       "      <td>143.649994</td>\n",
       "      <td>924.989990</td>\n",
       "      <td>905.960022</td>\n",
       "      <td>144.300003</td>\n",
       "      <td>949.590027</td>\n",
       "      <td>916.849976</td>\n",
       "      <td>143.270004</td>\n",
       "      <td>924.330017</td>\n",
       "      <td>905.770020</td>\n",
       "      <td>144.089996</td>\n",
       "      <td>948.830017</td>\n",
       "      <td>910.659973</td>\n",
       "      <td>20860400</td>\n",
       "      <td>7364700</td>\n",
       "      <td>3276300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>81 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Adj Close                               Close              \\\n",
       "                  AAPL        AMZN        GOOG        AAPL        AMZN   \n",
       "Date                                                                     \n",
       "2017-01-03  110.392334  753.669983  786.140015  116.150002  753.669983   \n",
       "2017-01-04  110.268791  757.179993  786.900024  116.019997  757.179993   \n",
       "2017-01-05  110.829552  780.450012  794.020020  116.610001  780.450012   \n",
       "2017-01-06  112.065109  795.989990  806.150024  117.910004  795.989990   \n",
       "2017-01-09  113.091560  796.919983  806.650024  118.989998  796.919983   \n",
       "...                ...         ...         ...         ...         ...   \n",
       "2017-04-24  137.111542  907.409973  862.760010  143.639999  907.409973   \n",
       "2017-04-25  137.961105  907.619995  872.299988  144.529999  907.619995   \n",
       "2017-04-26  137.149704  909.289978  871.729980  143.679993  909.289978   \n",
       "2017-04-27  137.254684  918.380005  874.250000  143.789993  918.380005   \n",
       "2017-04-28  137.121063  924.989990  905.960022  143.649994  924.989990   \n",
       "\n",
       "                              High                                 Low  \\\n",
       "                  GOOG        AAPL        AMZN        GOOG        AAPL   \n",
       "Date                                                                     \n",
       "2017-01-03  786.140015  116.330002  758.760010  789.630005  114.760002   \n",
       "2017-01-04  786.900024  116.510002  759.679993  791.340027  115.750000   \n",
       "2017-01-05  794.020020  116.860001  782.400024  794.479980  115.809998   \n",
       "2017-01-06  806.150024  118.160004  799.440002  807.900024  116.470001   \n",
       "2017-01-09  806.650024  119.430000  801.770020  809.966003  117.940002   \n",
       "...                ...         ...         ...         ...         ...   \n",
       "2017-04-24  862.760010  143.949997  909.989990  863.450012  143.179993   \n",
       "2017-04-25  872.299988  144.899994  909.479980  875.000000  143.869995   \n",
       "2017-04-26  871.729980  144.600006  915.750000  876.049988  143.380005   \n",
       "2017-04-27  874.250000  144.160004  921.859985  875.400024  143.309998   \n",
       "2017-04-28  905.960022  144.300003  949.590027  916.849976  143.270004   \n",
       "\n",
       "                                          Open                          \\\n",
       "                  AMZN        GOOG        AAPL        AMZN        GOOG   \n",
       "Date                                                                     \n",
       "2017-01-03  747.700012  775.799988  115.800003  757.919983  778.809998   \n",
       "2017-01-04  754.200012  783.159973  115.849998  758.390015  788.359985   \n",
       "2017-01-05  760.260010  785.020020  115.919998  761.549988  786.080017   \n",
       "2017-01-06  778.479980  792.203979  116.779999  782.359985  795.260010   \n",
       "2017-01-09  791.770020  802.830017  117.949997  798.000000  806.400024   \n",
       "...                ...         ...         ...         ...         ...   \n",
       "2017-04-24  903.820007  849.859985  143.500000  908.679993  851.200012   \n",
       "2017-04-25  903.000000  862.809998  143.910004  907.039978  865.000000   \n",
       "2017-04-26  907.559998  867.747986  144.470001  910.299988  874.229980   \n",
       "2017-04-27  912.109985  870.380005  143.919998  914.390015  873.599976   \n",
       "2017-04-28  924.330017  905.770020  144.089996  948.830017  910.659973   \n",
       "\n",
       "              Volume                    \n",
       "                AAPL     AMZN     GOOG  \n",
       "Date                                    \n",
       "2017-01-03  28781900  3521100  1657300  \n",
       "2017-01-04  21118100  2510500  1073000  \n",
       "2017-01-05  22193600  5830100  1335200  \n",
       "2017-01-06  31751900  5986200  1640200  \n",
       "2017-01-09  33561900  3446100  1274600  \n",
       "...              ...      ...      ...  \n",
       "2017-04-24  17134300  3122900  1372500  \n",
       "2017-04-25  18871500  3380600  1672000  \n",
       "2017-04-26  20041200  2608900  1237200  \n",
       "2017-04-27  14246300  5305500  2026800  \n",
       "2017-04-28  20860400  7364700  3276300  \n",
       "\n",
       "[81 rows x 18 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = yf.download(\"AMZN AAPL GOOG\", start=\"2017-01-01\", end=\"2017-04-30\", group_by = 'column')\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  3 of 3 completed\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"6\" halign=\"left\">GOOG</th>\n",
       "      <th colspan=\"6\" halign=\"left\">AMZN</th>\n",
       "      <th colspan=\"6\" halign=\"left\">AAPL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2017-01-03</th>\n",
       "      <td>778.809998</td>\n",
       "      <td>789.630005</td>\n",
       "      <td>775.799988</td>\n",
       "      <td>786.140015</td>\n",
       "      <td>786.140015</td>\n",
       "      <td>1657300</td>\n",
       "      <td>757.919983</td>\n",
       "      <td>758.760010</td>\n",
       "      <td>747.700012</td>\n",
       "      <td>753.669983</td>\n",
       "      <td>753.669983</td>\n",
       "      <td>3521100</td>\n",
       "      <td>115.800003</td>\n",
       "      <td>116.330002</td>\n",
       "      <td>114.760002</td>\n",
       "      <td>116.150002</td>\n",
       "      <td>110.392334</td>\n",
       "      <td>28781900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-04</th>\n",
       "      <td>788.359985</td>\n",
       "      <td>791.340027</td>\n",
       "      <td>783.159973</td>\n",
       "      <td>786.900024</td>\n",
       "      <td>786.900024</td>\n",
       "      <td>1073000</td>\n",
       "      <td>758.390015</td>\n",
       "      <td>759.679993</td>\n",
       "      <td>754.200012</td>\n",
       "      <td>757.179993</td>\n",
       "      <td>757.179993</td>\n",
       "      <td>2510500</td>\n",
       "      <td>115.849998</td>\n",
       "      <td>116.510002</td>\n",
       "      <td>115.750000</td>\n",
       "      <td>116.019997</td>\n",
       "      <td>110.268791</td>\n",
       "      <td>21118100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-05</th>\n",
       "      <td>786.080017</td>\n",
       "      <td>794.479980</td>\n",
       "      <td>785.020020</td>\n",
       "      <td>794.020020</td>\n",
       "      <td>794.020020</td>\n",
       "      <td>1335200</td>\n",
       "      <td>761.549988</td>\n",
       "      <td>782.400024</td>\n",
       "      <td>760.260010</td>\n",
       "      <td>780.450012</td>\n",
       "      <td>780.450012</td>\n",
       "      <td>5830100</td>\n",
       "      <td>115.919998</td>\n",
       "      <td>116.860001</td>\n",
       "      <td>115.809998</td>\n",
       "      <td>116.610001</td>\n",
       "      <td>110.829552</td>\n",
       "      <td>22193600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-06</th>\n",
       "      <td>795.260010</td>\n",
       "      <td>807.900024</td>\n",
       "      <td>792.203979</td>\n",
       "      <td>806.150024</td>\n",
       "      <td>806.150024</td>\n",
       "      <td>1640200</td>\n",
       "      <td>782.359985</td>\n",
       "      <td>799.440002</td>\n",
       "      <td>778.479980</td>\n",
       "      <td>795.989990</td>\n",
       "      <td>795.989990</td>\n",
       "      <td>5986200</td>\n",
       "      <td>116.779999</td>\n",
       "      <td>118.160004</td>\n",
       "      <td>116.470001</td>\n",
       "      <td>117.910004</td>\n",
       "      <td>112.065109</td>\n",
       "      <td>31751900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-09</th>\n",
       "      <td>806.400024</td>\n",
       "      <td>809.966003</td>\n",
       "      <td>802.830017</td>\n",
       "      <td>806.650024</td>\n",
       "      <td>806.650024</td>\n",
       "      <td>1274600</td>\n",
       "      <td>798.000000</td>\n",
       "      <td>801.770020</td>\n",
       "      <td>791.770020</td>\n",
       "      <td>796.919983</td>\n",
       "      <td>796.919983</td>\n",
       "      <td>3446100</td>\n",
       "      <td>117.949997</td>\n",
       "      <td>119.430000</td>\n",
       "      <td>117.940002</td>\n",
       "      <td>118.989998</td>\n",
       "      <td>113.091560</td>\n",
       "      <td>33561900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-24</th>\n",
       "      <td>851.200012</td>\n",
       "      <td>863.450012</td>\n",
       "      <td>849.859985</td>\n",
       "      <td>862.760010</td>\n",
       "      <td>862.760010</td>\n",
       "      <td>1372500</td>\n",
       "      <td>908.679993</td>\n",
       "      <td>909.989990</td>\n",
       "      <td>903.820007</td>\n",
       "      <td>907.409973</td>\n",
       "      <td>907.409973</td>\n",
       "      <td>3122900</td>\n",
       "      <td>143.500000</td>\n",
       "      <td>143.949997</td>\n",
       "      <td>143.179993</td>\n",
       "      <td>143.639999</td>\n",
       "      <td>137.111542</td>\n",
       "      <td>17134300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-25</th>\n",
       "      <td>865.000000</td>\n",
       "      <td>875.000000</td>\n",
       "      <td>862.809998</td>\n",
       "      <td>872.299988</td>\n",
       "      <td>872.299988</td>\n",
       "      <td>1672000</td>\n",
       "      <td>907.039978</td>\n",
       "      <td>909.479980</td>\n",
       "      <td>903.000000</td>\n",
       "      <td>907.619995</td>\n",
       "      <td>907.619995</td>\n",
       "      <td>3380600</td>\n",
       "      <td>143.910004</td>\n",
       "      <td>144.899994</td>\n",
       "      <td>143.869995</td>\n",
       "      <td>144.529999</td>\n",
       "      <td>137.961105</td>\n",
       "      <td>18871500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-26</th>\n",
       "      <td>874.229980</td>\n",
       "      <td>876.049988</td>\n",
       "      <td>867.747986</td>\n",
       "      <td>871.729980</td>\n",
       "      <td>871.729980</td>\n",
       "      <td>1237200</td>\n",
       "      <td>910.299988</td>\n",
       "      <td>915.750000</td>\n",
       "      <td>907.559998</td>\n",
       "      <td>909.289978</td>\n",
       "      <td>909.289978</td>\n",
       "      <td>2608900</td>\n",
       "      <td>144.470001</td>\n",
       "      <td>144.600006</td>\n",
       "      <td>143.380005</td>\n",
       "      <td>143.679993</td>\n",
       "      <td>137.149704</td>\n",
       "      <td>20041200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-27</th>\n",
       "      <td>873.599976</td>\n",
       "      <td>875.400024</td>\n",
       "      <td>870.380005</td>\n",
       "      <td>874.250000</td>\n",
       "      <td>874.250000</td>\n",
       "      <td>2026800</td>\n",
       "      <td>914.390015</td>\n",
       "      <td>921.859985</td>\n",
       "      <td>912.109985</td>\n",
       "      <td>918.380005</td>\n",
       "      <td>918.380005</td>\n",
       "      <td>5305500</td>\n",
       "      <td>143.919998</td>\n",
       "      <td>144.160004</td>\n",
       "      <td>143.309998</td>\n",
       "      <td>143.789993</td>\n",
       "      <td>137.254684</td>\n",
       "      <td>14246300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-28</th>\n",
       "      <td>910.659973</td>\n",
       "      <td>916.849976</td>\n",
       "      <td>905.770020</td>\n",
       "      <td>905.960022</td>\n",
       "      <td>905.960022</td>\n",
       "      <td>3276300</td>\n",
       "      <td>948.830017</td>\n",
       "      <td>949.590027</td>\n",
       "      <td>924.330017</td>\n",
       "      <td>924.989990</td>\n",
       "      <td>924.989990</td>\n",
       "      <td>7364700</td>\n",
       "      <td>144.089996</td>\n",
       "      <td>144.300003</td>\n",
       "      <td>143.270004</td>\n",
       "      <td>143.649994</td>\n",
       "      <td>137.121063</td>\n",
       "      <td>20860400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>81 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  GOOG                                                  \\\n",
       "                  Open        High         Low       Close   Adj Close   \n",
       "Date                                                                     \n",
       "2017-01-03  778.809998  789.630005  775.799988  786.140015  786.140015   \n",
       "2017-01-04  788.359985  791.340027  783.159973  786.900024  786.900024   \n",
       "2017-01-05  786.080017  794.479980  785.020020  794.020020  794.020020   \n",
       "2017-01-06  795.260010  807.900024  792.203979  806.150024  806.150024   \n",
       "2017-01-09  806.400024  809.966003  802.830017  806.650024  806.650024   \n",
       "...                ...         ...         ...         ...         ...   \n",
       "2017-04-24  851.200012  863.450012  849.859985  862.760010  862.760010   \n",
       "2017-04-25  865.000000  875.000000  862.809998  872.299988  872.299988   \n",
       "2017-04-26  874.229980  876.049988  867.747986  871.729980  871.729980   \n",
       "2017-04-27  873.599976  875.400024  870.380005  874.250000  874.250000   \n",
       "2017-04-28  910.659973  916.849976  905.770020  905.960022  905.960022   \n",
       "\n",
       "                           AMZN                                      \\\n",
       "             Volume        Open        High         Low       Close   \n",
       "Date                                                                  \n",
       "2017-01-03  1657300  757.919983  758.760010  747.700012  753.669983   \n",
       "2017-01-04  1073000  758.390015  759.679993  754.200012  757.179993   \n",
       "2017-01-05  1335200  761.549988  782.400024  760.260010  780.450012   \n",
       "2017-01-06  1640200  782.359985  799.440002  778.479980  795.989990   \n",
       "2017-01-09  1274600  798.000000  801.770020  791.770020  796.919983   \n",
       "...             ...         ...         ...         ...         ...   \n",
       "2017-04-24  1372500  908.679993  909.989990  903.820007  907.409973   \n",
       "2017-04-25  1672000  907.039978  909.479980  903.000000  907.619995   \n",
       "2017-04-26  1237200  910.299988  915.750000  907.559998  909.289978   \n",
       "2017-04-27  2026800  914.390015  921.859985  912.109985  918.380005   \n",
       "2017-04-28  3276300  948.830017  949.590027  924.330017  924.989990   \n",
       "\n",
       "                                       AAPL                          \\\n",
       "             Adj Close   Volume        Open        High         Low   \n",
       "Date                                                                  \n",
       "2017-01-03  753.669983  3521100  115.800003  116.330002  114.760002   \n",
       "2017-01-04  757.179993  2510500  115.849998  116.510002  115.750000   \n",
       "2017-01-05  780.450012  5830100  115.919998  116.860001  115.809998   \n",
       "2017-01-06  795.989990  5986200  116.779999  118.160004  116.470001   \n",
       "2017-01-09  796.919983  3446100  117.949997  119.430000  117.940002   \n",
       "...                ...      ...         ...         ...         ...   \n",
       "2017-04-24  907.409973  3122900  143.500000  143.949997  143.179993   \n",
       "2017-04-25  907.619995  3380600  143.910004  144.899994  143.869995   \n",
       "2017-04-26  909.289978  2608900  144.470001  144.600006  143.380005   \n",
       "2017-04-27  918.380005  5305500  143.919998  144.160004  143.309998   \n",
       "2017-04-28  924.989990  7364700  144.089996  144.300003  143.270004   \n",
       "\n",
       "                                              \n",
       "                 Close   Adj Close    Volume  \n",
       "Date                                          \n",
       "2017-01-03  116.150002  110.392334  28781900  \n",
       "2017-01-04  116.019997  110.268791  21118100  \n",
       "2017-01-05  116.610001  110.829552  22193600  \n",
       "2017-01-06  117.910004  112.065109  31751900  \n",
       "2017-01-09  118.989998  113.091560  33561900  \n",
       "...                ...         ...       ...  \n",
       "2017-04-24  143.639999  137.111542  17134300  \n",
       "2017-04-25  144.529999  137.961105  18871500  \n",
       "2017-04-26  143.679993  137.149704  20041200  \n",
       "2017-04-27  143.789993  137.254684  14246300  \n",
       "2017-04-28  143.649994  137.121063  20860400  \n",
       "\n",
       "[81 rows x 18 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = yf.download(\"AMZN AAPL GOOG\", start=\"2017-01-01\", end=\"2017-04-30\", group_by='tickers')\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'zip': '95014',\n",
       " 'sector': 'Technology',\n",
       " 'fullTimeEmployees': 137000,\n",
       " 'longBusinessSummary': 'Apple Inc. designs, manufactures, and markets smartphones, personal computers, tablets, wearables, and accessories worldwide. It also sells various related services. The company offers iPhone, a line of smartphones; Mac, a line of personal computers; iPad, a line of multi-purpose tablets; and wearables, home, and accessories comprising AirPods, Apple TV, Apple Watch, Beats products, HomePod, iPod touch, and other Apple-branded and third-party accessories. It also provides digital content stores and streaming services; AppleCare support services; and iCloud, a cloud service, which stores music, photos, contacts, calendars, mail, documents, and others. In addition, the company offers various service, such as Apple Arcade, a game subscription service; Apple Card, a co-branded credit card; Apple News+, a subscription news and magazine service; and Apple Pay, a cashless payment service, as well as licenses its intellectual property, and provides other related services. The company serves consumers, and small and mid-sized businesses; and the education, enterprise, and government markets. It sells and delivers third-party applications for its products through the App Store, Mac App Store, and Watch App Store. The company also sells its products through its retail and online stores, and direct sales force; and third-party cellular network carriers, wholesalers, retailers, and resellers. Apple Inc. has a collaboration with Google to develop COVID-19 tracking system for Android and iOS devices. Apple Inc. was founded in 1977 and is headquartered in Cupertino, California.',\n",
       " 'city': 'Cupertino',\n",
       " 'phone': '408-996-1010',\n",
       " 'state': 'CA',\n",
       " 'country': 'United States',\n",
       " 'companyOfficers': [],\n",
       " 'website': 'http://www.apple.com',\n",
       " 'maxAge': 1,\n",
       " 'address1': 'One Apple Park Way',\n",
       " 'industry': 'Consumer Electronics',\n",
       " 'previousClose': 342.99,\n",
       " 'regularMarketOpen': 351.46,\n",
       " 'twoHundredDayAverage': 293.4145,\n",
       " 'trailingAnnualDividendYield': 0.008979853000000001,\n",
       " 'payoutRatio': 0.24080000000000001,\n",
       " 'volume24Hr': None,\n",
       " 'regularMarketDayHigh': 353.0201,\n",
       " 'navPrice': None,\n",
       " 'averageDailyVolume10Day': 39594100,\n",
       " 'totalAssets': None,\n",
       " 'regularMarketPreviousClose': 342.99,\n",
       " 'fiftyDayAverage': 314.71713,\n",
       " 'trailingAnnualDividendRate': 3.08,\n",
       " 'open': 351.46,\n",
       " 'toCurrency': None,\n",
       " 'averageVolume10days': 39594100,\n",
       " 'expireDate': None,\n",
       " 'yield': None,\n",
       " 'algorithm': None,\n",
       " 'dividendRate': 3.2800000000000002,\n",
       " 'exDividendDate': 1588896000,\n",
       " 'beta': 1.170435,\n",
       " 'circulatingSupply': None,\n",
       " 'startDate': None,\n",
       " 'regularMarketDayLow': 349.07,\n",
       " 'priceHint': 2,\n",
       " 'currency': 'USD',\n",
       " 'trailingPE': 27.65242,\n",
       " 'regularMarketVolume': 8021292,\n",
       " 'lastMarket': None,\n",
       " 'maxSupply': None,\n",
       " 'openInterest': None,\n",
       " 'marketCap': 1525510701056,\n",
       " 'volumeAllCurrencies': None,\n",
       " 'strikePrice': None,\n",
       " 'averageVolume': 42532806,\n",
       " 'priceToSalesTrailing12Months': 5.692608,\n",
       " 'dayLow': 349.07,\n",
       " 'ask': 350.9,\n",
       " 'ytdReturn': None,\n",
       " 'askSize': 900,\n",
       " 'volume': 8021292,\n",
       " 'fiftyTwoWeekHigh': 354.77,\n",
       " 'forwardPE': 23.68506,\n",
       " 'fromCurrency': None,\n",
       " 'fiveYearAvgDividendYield': 1.58,\n",
       " 'fiftyTwoWeekLow': 192.58,\n",
       " 'bid': 350.58,\n",
       " 'tradeable': False,\n",
       " 'dividendYield': 0.009599999500000001,\n",
       " 'bidSize': 800,\n",
       " 'dayHigh': 353.0201,\n",
       " 'exchange': 'NMS',\n",
       " 'shortName': 'Apple Inc.',\n",
       " 'longName': 'Apple Inc.',\n",
       " 'exchangeTimezoneName': 'America/New_York',\n",
       " 'exchangeTimezoneShortName': 'EDT',\n",
       " 'isEsgPopulated': False,\n",
       " 'gmtOffSetMilliseconds': '-14400000',\n",
       " 'quoteType': 'EQUITY',\n",
       " 'symbol': 'AAPL',\n",
       " 'messageBoardId': 'finmb_24937',\n",
       " 'market': 'us_market',\n",
       " 'annualHoldingsTurnover': None,\n",
       " 'enterpriseToRevenue': 5.572,\n",
       " 'beta3Year': None,\n",
       " 'profitMargins': 0.21350001000000002,\n",
       " 'enterpriseToEbitda': 19.315,\n",
       " '52WeekChange': 0.7283447,\n",
       " 'morningStarRiskRating': None,\n",
       " 'forwardEps': 14.86,\n",
       " 'revenueQuarterlyGrowth': None,\n",
       " 'sharesOutstanding': 4334329856,\n",
       " 'fundInceptionDate': None,\n",
       " 'annualReportExpenseRatio': None,\n",
       " 'bookValue': 18.137,\n",
       " 'sharesShort': 34194077,\n",
       " 'sharesPercentSharesOut': 0.007900001,\n",
       " 'fundFamily': None,\n",
       " 'lastFiscalYearEnd': 1569628800,\n",
       " 'heldPercentInstitutions': 0.6211500000000001,\n",
       " 'netIncomeToCommon': 57215000576,\n",
       " 'trailingEps': 12.728,\n",
       " 'lastDividendValue': None,\n",
       " 'SandP52WeekChange': 0.05101192,\n",
       " 'priceToBook': 19.405636,\n",
       " 'heldPercentInsiders': 0.0006600000000000001,\n",
       " 'nextFiscalYearEnd': 1632787200,\n",
       " 'mostRecentQuarter': 1585353600,\n",
       " 'shortRatio': 0.96,\n",
       " 'sharesShortPreviousMonthDate': 1588204800,\n",
       " 'floatShares': 4329870635,\n",
       " 'enterpriseValue': 1493182709760,\n",
       " 'threeYearAverageReturn': None,\n",
       " 'lastSplitDate': 1402272000,\n",
       " 'lastSplitFactor': '7:1',\n",
       " 'legalType': None,\n",
       " 'morningStarOverallRating': None,\n",
       " 'earningsQuarterlyGrowth': -0.027,\n",
       " 'dateShortInterest': 1590710400,\n",
       " 'pegRatio': 2.42,\n",
       " 'lastCapGain': None,\n",
       " 'shortPercentOfFloat': 0.007900001,\n",
       " 'sharesShortPriorMonth': 30124922,\n",
       " 'category': None,\n",
       " 'fiveYearAverageReturn': None,\n",
       " 'regularMarketPrice': 351.46,\n",
       " 'logo_url': 'https://logo.clearbit.com/apple.com'}"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl = yf.Ticker(\"aapl\") \n",
    "aapl.info      "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "23.081427"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl = yf.Ticker(\"aapl\")\n",
    "aapl.info['forwardPE']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3.2800000000000002"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl.info['dividendRate']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "1987-05-11    0.00214\n",
       "1987-08-10    0.00214\n",
       "1987-11-17    0.00286\n",
       "1988-02-12    0.00286\n",
       "1988-05-16    0.00286\n",
       "               ...   \n",
       "2019-05-10    0.77000\n",
       "2019-08-09    0.77000\n",
       "2019-11-07    0.77000\n",
       "2020-02-07    0.77000\n",
       "2020-05-08    0.82000\n",
       "Name: Dividends, Length: 67, dtype: float64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl.dividends"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "tickers_list = [\"aapl\", \"goog\", \"amzn\", \"BAC\", \"BA\"] # example list\n",
    "tickers_data = {} # empty dictionary"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'aapl':                  Attribute                                             Recent\n",
       " 0                      zip                                              95014\n",
       " 1                   sector                                         Technology\n",
       " 2        fullTimeEmployees                                             137000\n",
       " 3      longBusinessSummary  Apple Inc. designs, manufactures, and markets ...\n",
       " 4                     city                                          Cupertino\n",
       " ..                     ...                                                ...\n",
       " 116  sharesShortPriorMonth                                           30124922\n",
       " 117               category                                               None\n",
       " 118  fiveYearAverageReturn                                               None\n",
       " 119     regularMarketPrice                                             344.72\n",
       " 120               logo_url                https://logo.clearbit.com/apple.com\n",
       " \n",
       " [121 rows x 2 columns],\n",
       " 'goog':                  Attribute                                             Recent\n",
       " 0                      zip                                              94043\n",
       " 1                   sector                             Communication Services\n",
       " 2        fullTimeEmployees                                             123048\n",
       " 3      longBusinessSummary  Alphabet Inc. provides online advertising serv...\n",
       " 4                     city                                      Mountain View\n",
       " ..                     ...                                                ...\n",
       " 116  sharesShortPriorMonth                                            3496044\n",
       " 117               category                                               None\n",
       " 118  fiveYearAverageReturn                                               None\n",
       " 119     regularMarketPrice                                             1390.8\n",
       " 120               logo_url                  https://logo.clearbit.com/abc.xyz\n",
       " \n",
       " [121 rows x 2 columns],\n",
       " 'amzn':                  Attribute                                             Recent\n",
       " 0                      zip                                         98109-5210\n",
       " 1                   sector                                  Consumer Cyclical\n",
       " 2        fullTimeEmployees                                             840400\n",
       " 3      longBusinessSummary  Amazon.com, Inc. engages in the retail sale of...\n",
       " 4                     city                                            Seattle\n",
       " ..                     ...                                                ...\n",
       " 116  sharesShortPriorMonth                                            3505745\n",
       " 117               category                                               None\n",
       " 118  fiveYearAverageReturn                                               None\n",
       " 119     regularMarketPrice                                             2526.6\n",
       " 120               logo_url               https://logo.clearbit.com/amazon.com\n",
       " \n",
       " [121 rows x 2 columns],\n",
       " 'BAC':                  Attribute                                             Recent\n",
       " 0                      zip                                              28255\n",
       " 1                   sector                                 Financial Services\n",
       " 2        fullTimeEmployees                                             209000\n",
       " 3      longBusinessSummary  Bank of America Corporation, through its subsi...\n",
       " 4                     city                                          Charlotte\n",
       " ..                     ...                                                ...\n",
       " 117  sharesShortPriorMonth                                          111069451\n",
       " 118               category                                               None\n",
       " 119  fiveYearAverageReturn                                               None\n",
       " 120     regularMarketPrice                                              23.76\n",
       " 121               logo_url        https://logo.clearbit.com/bankofamerica.com\n",
       " \n",
       " [122 rows x 2 columns],\n",
       " 'BA':                  Attribute                                             Recent\n",
       " 0                      zip                                         60606-1596\n",
       " 1                   sector                                        Industrials\n",
       " 2        fullTimeEmployees                                             161100\n",
       " 3      longBusinessSummary  The Boeing Company, together with its subsidia...\n",
       " 4                     city                                            Chicago\n",
       " ..                     ...                                                ...\n",
       " 115  sharesShortPriorMonth                                           17995687\n",
       " 116               category                                               None\n",
       " 117  fiveYearAverageReturn                                               None\n",
       " 118     regularMarketPrice                                             177.18\n",
       " 119               logo_url               https://logo.clearbit.com/boeing.com\n",
       " \n",
       " [120 rows x 2 columns]}"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for ticker in tickers_list:\n",
    "    ticker_object = yf.Ticker(ticker)\n",
    "\n",
    "    #convert info() output from dictionary to dataframe\n",
    "    temp = pd.DataFrame.from_dict(ticker_object.info, orient=\"index\")\n",
    "    temp.reset_index(inplace=True)\n",
    "    temp.columns = [\"Attribute\", \"Recent\"]\n",
    "    \n",
    "    # add (ticker, dataframe) to main dictionary\n",
    "    tickers_data[ticker] = temp\n",
    "\n",
    "tickers_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>level_0</th>\n",
       "      <th>level_1</th>\n",
       "      <th>Attribute</th>\n",
       "      <th>Recent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>aapl</td>\n",
       "      <td>0</td>\n",
       "      <td>zip</td>\n",
       "      <td>95014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>aapl</td>\n",
       "      <td>1</td>\n",
       "      <td>sector</td>\n",
       "      <td>Technology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>aapl</td>\n",
       "      <td>2</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>137000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>aapl</td>\n",
       "      <td>3</td>\n",
       "      <td>longBusinessSummary</td>\n",
       "      <td>Apple Inc. designs, manufactures, and markets ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>aapl</td>\n",
       "      <td>4</td>\n",
       "      <td>city</td>\n",
       "      <td>Cupertino</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>BA</td>\n",
       "      <td>115</td>\n",
       "      <td>sharesShortPriorMonth</td>\n",
       "      <td>17995687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601</th>\n",
       "      <td>BA</td>\n",
       "      <td>116</td>\n",
       "      <td>category</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>602</th>\n",
       "      <td>BA</td>\n",
       "      <td>117</td>\n",
       "      <td>fiveYearAverageReturn</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603</th>\n",
       "      <td>BA</td>\n",
       "      <td>118</td>\n",
       "      <td>regularMarketPrice</td>\n",
       "      <td>177.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>604</th>\n",
       "      <td>BA</td>\n",
       "      <td>119</td>\n",
       "      <td>logo_url</td>\n",
       "      <td>https://logo.clearbit.com/boeing.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>605 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    level_0  level_1              Attribute  \\\n",
       "0      aapl        0                    zip   \n",
       "1      aapl        1                 sector   \n",
       "2      aapl        2      fullTimeEmployees   \n",
       "3      aapl        3    longBusinessSummary   \n",
       "4      aapl        4                   city   \n",
       "..      ...      ...                    ...   \n",
       "600      BA      115  sharesShortPriorMonth   \n",
       "601      BA      116               category   \n",
       "602      BA      117  fiveYearAverageReturn   \n",
       "603      BA      118     regularMarketPrice   \n",
       "604      BA      119               logo_url   \n",
       "\n",
       "                                                Recent  \n",
       "0                                                95014  \n",
       "1                                           Technology  \n",
       "2                                               137000  \n",
       "3    Apple Inc. designs, manufactures, and markets ...  \n",
       "4                                            Cupertino  \n",
       "..                                                 ...  \n",
       "600                                           17995687  \n",
       "601                                               None  \n",
       "602                                               None  \n",
       "603                                             177.18  \n",
       "604               https://logo.clearbit.com/boeing.com  \n",
       "\n",
       "[605 rows x 4 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# combine all the info dataframes for each ticker into a single data frame\n",
    "combined_data = pd.concat(tickers_data)\n",
    "combined_data = combined_data.reset_index()\n",
    "combined_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Ticker</th>\n",
       "      <th>Attribute</th>\n",
       "      <th>Recent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>aapl</td>\n",
       "      <td>zip</td>\n",
       "      <td>95014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>aapl</td>\n",
       "      <td>sector</td>\n",
       "      <td>Technology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>aapl</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>137000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>aapl</td>\n",
       "      <td>longBusinessSummary</td>\n",
       "      <td>Apple Inc. designs, manufactures, and markets ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>aapl</td>\n",
       "      <td>city</td>\n",
       "      <td>Cupertino</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>BA</td>\n",
       "      <td>sharesShortPriorMonth</td>\n",
       "      <td>17995687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601</th>\n",
       "      <td>BA</td>\n",
       "      <td>category</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>602</th>\n",
       "      <td>BA</td>\n",
       "      <td>fiveYearAverageReturn</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603</th>\n",
       "      <td>BA</td>\n",
       "      <td>regularMarketPrice</td>\n",
       "      <td>177.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>604</th>\n",
       "      <td>BA</td>\n",
       "      <td>logo_url</td>\n",
       "      <td>https://logo.clearbit.com/boeing.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>605 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Ticker              Attribute  \\\n",
       "0     aapl                    zip   \n",
       "1     aapl                 sector   \n",
       "2     aapl      fullTimeEmployees   \n",
       "3     aapl    longBusinessSummary   \n",
       "4     aapl                   city   \n",
       "..     ...                    ...   \n",
       "600     BA  sharesShortPriorMonth   \n",
       "601     BA               category   \n",
       "602     BA  fiveYearAverageReturn   \n",
       "603     BA     regularMarketPrice   \n",
       "604     BA               logo_url   \n",
       "\n",
       "                                                Recent  \n",
       "0                                                95014  \n",
       "1                                           Technology  \n",
       "2                                               137000  \n",
       "3    Apple Inc. designs, manufactures, and markets ...  \n",
       "4                                            Cupertino  \n",
       "..                                                 ...  \n",
       "600                                           17995687  \n",
       "601                                               None  \n",
       "602                                               None  \n",
       "603                                             177.18  \n",
       "604               https://logo.clearbit.com/boeing.com  \n",
       "\n",
       "[605 rows x 3 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "del combined_data[\"level_1\"] # clean up unnecessary column\n",
    "combined_data.columns = [\"Ticker\", \"Attribute\", \"Recent\"] # update column names\n",
    "\n",
    "combined_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Ticker</th>\n",
       "      <th>Attribute</th>\n",
       "      <th>Recent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>aapl</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>137000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>goog</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>123048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>amzn</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>840400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BAC</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>209000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BA</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>161100</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Ticker          Attribute  Recent\n",
       "0   aapl  fullTimeEmployees  137000\n",
       "1   goog  fullTimeEmployees  123048\n",
       "2   amzn  fullTimeEmployees  840400\n",
       "3    BAC  fullTimeEmployees  209000\n",
       "4     BA  fullTimeEmployees  161100"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "employees = combined_data[combined_data[\"Attribute\"]==\"fullTimeEmployees\"].reset_index()\n",
    "del employees[\"index\"] # clean up unnecessary column\n",
    "\n",
    "employees"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Ticker</th>\n",
       "      <th>Attribute</th>\n",
       "      <th>Recent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>amzn</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>840400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BAC</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>209000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BA</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>161100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>aapl</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>137000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>goog</td>\n",
       "      <td>fullTimeEmployees</td>\n",
       "      <td>123048</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Ticker          Attribute  Recent\n",
       "2   amzn  fullTimeEmployees  840400\n",
       "3    BAC  fullTimeEmployees  209000\n",
       "4     BA  fullTimeEmployees  161100\n",
       "0   aapl  fullTimeEmployees  137000\n",
       "1   goog  fullTimeEmployees  123048"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "employees_sorted = employees.sort_values('Recent',ascending=False)\n",
    "employees_sorted"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1525510701056"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl.info[\"marketCap\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "8021292"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl.info[\"volume\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "42532806"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl.info[\"averageVolume\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "39594100"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl.info[\"averageVolume10days\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Dividends</th>\n",
       "      <th>Stock Splits</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1980-12-08</th>\n",
       "      <td>0.41</td>\n",
       "      <td>0.41</td>\n",
       "      <td>0.41</td>\n",
       "      <td>0.41</td>\n",
       "      <td>117258400.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-15</th>\n",
       "      <td>0.39</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.40</td>\n",
       "      <td>122533600.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-22</th>\n",
       "      <td>0.42</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.50</td>\n",
       "      <td>46972800.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-29</th>\n",
       "      <td>0.51</td>\n",
       "      <td>0.51</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.49</td>\n",
       "      <td>54863200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-05</th>\n",
       "      <td>0.48</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.45</td>\n",
       "      <td>49476000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-25</th>\n",
       "      <td>323.50</td>\n",
       "      <td>324.24</td>\n",
       "      <td>313.09</td>\n",
       "      <td>317.94</td>\n",
       "      <td>131406500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-01</th>\n",
       "      <td>317.75</td>\n",
       "      <td>331.75</td>\n",
       "      <td>317.21</td>\n",
       "      <td>331.50</td>\n",
       "      <td>124434000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-08</th>\n",
       "      <td>330.25</td>\n",
       "      <td>354.77</td>\n",
       "      <td>327.32</td>\n",
       "      <td>338.80</td>\n",
       "      <td>202921700.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-15</th>\n",
       "      <td>333.25</td>\n",
       "      <td>345.68</td>\n",
       "      <td>332.58</td>\n",
       "      <td>342.99</td>\n",
       "      <td>34642900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-16</th>\n",
       "      <td>333.25</td>\n",
       "      <td>353.02</td>\n",
       "      <td>349.07</td>\n",
       "      <td>351.53</td>\n",
       "      <td>10708995.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2135 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Open    High     Low   Close       Volume  Dividends  \\\n",
       "Date                                                                 \n",
       "1980-12-08    0.41    0.41    0.41    0.41  117258400.0        0.0   \n",
       "1980-12-15    0.39    0.40    0.36    0.40  122533600.0        0.0   \n",
       "1980-12-22    0.42    0.50    0.42    0.50   46972800.0        0.0   \n",
       "1980-12-29    0.51    0.51    0.48    0.49   54863200.0        0.0   \n",
       "1981-01-05    0.48    0.48    0.43    0.45   49476000.0        0.0   \n",
       "...            ...     ...     ...     ...          ...        ...   \n",
       "2020-05-25  323.50  324.24  313.09  317.94  131406500.0        0.0   \n",
       "2020-06-01  317.75  331.75  317.21  331.50  124434000.0        0.0   \n",
       "2020-06-08  330.25  354.77  327.32  338.80  202921700.0        0.0   \n",
       "2020-06-15  333.25  345.68  332.58  342.99   34642900.0        0.0   \n",
       "2020-06-16  333.25  353.02  349.07  351.53   10708995.0        0.0   \n",
       "\n",
       "            Stock Splits  \n",
       "Date                      \n",
       "1980-12-08           0.0  \n",
       "1980-12-15           0.0  \n",
       "1980-12-22           0.0  \n",
       "1980-12-29           0.0  \n",
       "1981-01-05           0.0  \n",
       "...                  ...  \n",
       "2020-05-25           0.0  \n",
       "2020-06-01           0.0  \n",
       "2020-06-08           0.0  \n",
       "2020-06-15           0.0  \n",
       "2020-06-16           0.0  \n",
       "\n",
       "[2135 rows x 7 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl_historical = aapl.history(period=\"max\", interval=\"1wk\")\n",
    "aapl_historical"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "354.77"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl.info[\"fiftyTwoWeekHigh\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('2020-06-19',\n",
       " '2020-06-26',\n",
       " '2020-07-02',\n",
       " '2020-07-10',\n",
       " '2020-07-17',\n",
       " '2020-07-24',\n",
       " '2020-07-31',\n",
       " '2020-08-21',\n",
       " '2020-09-18',\n",
       " '2020-10-16',\n",
       " '2020-11-20',\n",
       " '2020-12-18',\n",
       " '2021-01-15',\n",
       " '2021-06-18',\n",
       " '2021-09-17',\n",
       " '2022-01-21',\n",
       " '2022-06-17',\n",
       " '2022-09-16')"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl.options"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>contractSymbol</th>\n",
       "      <th>lastTradeDate</th>\n",
       "      <th>strike</th>\n",
       "      <th>lastPrice</th>\n",
       "      <th>bid</th>\n",
       "      <th>ask</th>\n",
       "      <th>change</th>\n",
       "      <th>percentChange</th>\n",
       "      <th>volume</th>\n",
       "      <th>openInterest</th>\n",
       "      <th>impliedVolatility</th>\n",
       "      <th>inTheMoney</th>\n",
       "      <th>contractSize</th>\n",
       "      <th>currency</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAPL200724C00170000</td>\n",
       "      <td>2020-06-12 13:38:07</td>\n",
       "      <td>170.0</td>\n",
       "      <td>175.11</td>\n",
       "      <td>178.50</td>\n",
       "      <td>181.85</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.240971</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAPL200724C00230000</td>\n",
       "      <td>2020-06-09 19:19:41</td>\n",
       "      <td>230.0</td>\n",
       "      <td>115.11</td>\n",
       "      <td>118.35</td>\n",
       "      <td>121.55</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.749514</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AAPL200724C00250000</td>\n",
       "      <td>2020-06-15 15:35:19</td>\n",
       "      <td>250.0</td>\n",
       "      <td>88.60</td>\n",
       "      <td>99.40</td>\n",
       "      <td>102.15</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.692874</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AAPL200724C00255000</td>\n",
       "      <td>2020-06-12 13:50:07</td>\n",
       "      <td>255.0</td>\n",
       "      <td>92.60</td>\n",
       "      <td>93.60</td>\n",
       "      <td>96.90</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.617680</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AAPL200724C00260000</td>\n",
       "      <td>2020-06-16 13:46:57</td>\n",
       "      <td>260.0</td>\n",
       "      <td>93.00</td>\n",
       "      <td>88.80</td>\n",
       "      <td>92.00</td>\n",
       "      <td>4.160004</td>\n",
       "      <td>4.682580</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.598271</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>AAPL200724C00265000</td>\n",
       "      <td>2020-06-16 14:49:37</td>\n",
       "      <td>265.0</td>\n",
       "      <td>85.98</td>\n",
       "      <td>83.20</td>\n",
       "      <td>86.70</td>\n",
       "      <td>8.750000</td>\n",
       "      <td>11.329794</td>\n",
       "      <td>2.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>0.530034</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AAPL200724C00270000</td>\n",
       "      <td>2020-06-10 14:26:57</td>\n",
       "      <td>270.0</td>\n",
       "      <td>80.50</td>\n",
       "      <td>79.70</td>\n",
       "      <td>82.85</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.593144</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AAPL200724C00275000</td>\n",
       "      <td>2020-06-12 14:44:44</td>\n",
       "      <td>275.0</td>\n",
       "      <td>67.92</td>\n",
       "      <td>74.30</td>\n",
       "      <td>77.30</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.531499</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>AAPL200724C00280000</td>\n",
       "      <td>2020-06-12 17:59:03</td>\n",
       "      <td>280.0</td>\n",
       "      <td>59.02</td>\n",
       "      <td>69.60</td>\n",
       "      <td>72.30</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.508794</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AAPL200724C00285000</td>\n",
       "      <td>2020-06-10 18:32:31</td>\n",
       "      <td>285.0</td>\n",
       "      <td>70.35</td>\n",
       "      <td>64.60</td>\n",
       "      <td>67.35</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.547856</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AAPL200724C00290000</td>\n",
       "      <td>2020-06-15 16:22:57</td>\n",
       "      <td>290.0</td>\n",
       "      <td>52.80</td>\n",
       "      <td>59.85</td>\n",
       "      <td>63.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>0.541264</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>AAPL200724C00295000</td>\n",
       "      <td>2020-06-10 19:12:42</td>\n",
       "      <td>295.0</td>\n",
       "      <td>59.85</td>\n",
       "      <td>55.30</td>\n",
       "      <td>57.90</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>28.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.501836</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>AAPL200724C00300000</td>\n",
       "      <td>2020-06-12 17:46:57</td>\n",
       "      <td>300.0</td>\n",
       "      <td>41.50</td>\n",
       "      <td>51.25</td>\n",
       "      <td>52.80</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>8.0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>0.462896</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>AAPL200724C00302500</td>\n",
       "      <td>2020-06-11 15:14:49</td>\n",
       "      <td>302.5</td>\n",
       "      <td>48.30</td>\n",
       "      <td>49.10</td>\n",
       "      <td>50.80</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.464117</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AAPL200724C00305000</td>\n",
       "      <td>2020-06-16 13:56:31</td>\n",
       "      <td>305.0</td>\n",
       "      <td>49.10</td>\n",
       "      <td>46.75</td>\n",
       "      <td>48.55</td>\n",
       "      <td>9.570000</td>\n",
       "      <td>24.209461</td>\n",
       "      <td>2.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.455145</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AAPL200724C00307500</td>\n",
       "      <td>2020-06-15 13:54:30</td>\n",
       "      <td>307.5</td>\n",
       "      <td>34.47</td>\n",
       "      <td>45.60</td>\n",
       "      <td>46.90</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.465765</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>AAPL200724C00310000</td>\n",
       "      <td>2020-06-16 14:51:57</td>\n",
       "      <td>310.0</td>\n",
       "      <td>42.50</td>\n",
       "      <td>42.40</td>\n",
       "      <td>44.05</td>\n",
       "      <td>5.049999</td>\n",
       "      <td>13.484644</td>\n",
       "      <td>1.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0.435553</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>AAPL200724C00312500</td>\n",
       "      <td>2020-06-15 16:24:56</td>\n",
       "      <td>312.5</td>\n",
       "      <td>33.75</td>\n",
       "      <td>40.10</td>\n",
       "      <td>42.70</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.453069</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>AAPL200724C00315000</td>\n",
       "      <td>2020-06-15 14:30:16</td>\n",
       "      <td>315.0</td>\n",
       "      <td>29.05</td>\n",
       "      <td>37.20</td>\n",
       "      <td>40.05</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.429205</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>AAPL200724C00317500</td>\n",
       "      <td>2020-06-10 19:56:01</td>\n",
       "      <td>317.5</td>\n",
       "      <td>39.27</td>\n",
       "      <td>36.00</td>\n",
       "      <td>38.15</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.427313</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>AAPL200724C00320000</td>\n",
       "      <td>2020-06-16 14:13:55</td>\n",
       "      <td>320.0</td>\n",
       "      <td>36.42</td>\n",
       "      <td>33.95</td>\n",
       "      <td>36.00</td>\n",
       "      <td>5.349998</td>\n",
       "      <td>17.219180</td>\n",
       "      <td>5.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>0.417303</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>AAPL200724C00322500</td>\n",
       "      <td>2020-06-16 13:35:26</td>\n",
       "      <td>322.5</td>\n",
       "      <td>33.15</td>\n",
       "      <td>32.20</td>\n",
       "      <td>33.60</td>\n",
       "      <td>7.040001</td>\n",
       "      <td>26.962854</td>\n",
       "      <td>1.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>0.399847</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>AAPL200724C00325000</td>\n",
       "      <td>2020-06-15 18:48:28</td>\n",
       "      <td>325.0</td>\n",
       "      <td>27.38</td>\n",
       "      <td>30.25</td>\n",
       "      <td>31.50</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>15.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>0.390051</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>AAPL200724C00327500</td>\n",
       "      <td>2020-06-16 14:44:27</td>\n",
       "      <td>327.5</td>\n",
       "      <td>29.40</td>\n",
       "      <td>28.35</td>\n",
       "      <td>29.25</td>\n",
       "      <td>8.600000</td>\n",
       "      <td>41.346157</td>\n",
       "      <td>2.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>0.375617</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>AAPL200724C00330000</td>\n",
       "      <td>2020-06-16 14:44:27</td>\n",
       "      <td>330.0</td>\n",
       "      <td>27.44</td>\n",
       "      <td>25.70</td>\n",
       "      <td>26.60</td>\n",
       "      <td>4.840000</td>\n",
       "      <td>21.415930</td>\n",
       "      <td>18.0</td>\n",
       "      <td>236.0</td>\n",
       "      <td>0.350531</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>AAPL200724C00332500</td>\n",
       "      <td>2020-06-16 14:44:27</td>\n",
       "      <td>332.5</td>\n",
       "      <td>25.25</td>\n",
       "      <td>24.25</td>\n",
       "      <td>24.60</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>26.250000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.341437</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>AAPL200724C00335000</td>\n",
       "      <td>2020-06-16 14:53:06</td>\n",
       "      <td>335.0</td>\n",
       "      <td>22.48</td>\n",
       "      <td>22.65</td>\n",
       "      <td>23.00</td>\n",
       "      <td>3.359999</td>\n",
       "      <td>17.573214</td>\n",
       "      <td>15.0</td>\n",
       "      <td>447.0</td>\n",
       "      <td>0.340918</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>AAPL200724C00337500</td>\n",
       "      <td>2020-06-16 14:43:40</td>\n",
       "      <td>337.5</td>\n",
       "      <td>22.05</td>\n",
       "      <td>21.80</td>\n",
       "      <td>22.10</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>24.929176</td>\n",
       "      <td>25.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>0.355292</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>AAPL200724C00340000</td>\n",
       "      <td>2020-06-16 14:55:08</td>\n",
       "      <td>340.0</td>\n",
       "      <td>19.00</td>\n",
       "      <td>19.55</td>\n",
       "      <td>19.80</td>\n",
       "      <td>2.700001</td>\n",
       "      <td>16.564423</td>\n",
       "      <td>72.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>0.335608</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>AAPL200724C00342500</td>\n",
       "      <td>2020-06-16 14:21:25</td>\n",
       "      <td>342.5</td>\n",
       "      <td>19.30</td>\n",
       "      <td>18.50</td>\n",
       "      <td>18.75</td>\n",
       "      <td>4.449999</td>\n",
       "      <td>29.966320</td>\n",
       "      <td>27.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>0.343268</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>AAPL200724C00345000</td>\n",
       "      <td>2020-06-16 14:54:50</td>\n",
       "      <td>345.0</td>\n",
       "      <td>15.90</td>\n",
       "      <td>17.10</td>\n",
       "      <td>17.35</td>\n",
       "      <td>2.349999</td>\n",
       "      <td>17.343168</td>\n",
       "      <td>64.0</td>\n",
       "      <td>390.0</td>\n",
       "      <td>0.341498</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>AAPL200724C00347500</td>\n",
       "      <td>2020-06-16 14:40:46</td>\n",
       "      <td>347.5</td>\n",
       "      <td>16.15</td>\n",
       "      <td>15.55</td>\n",
       "      <td>15.75</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>32.921810</td>\n",
       "      <td>39.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>0.333930</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>AAPL200724C00350000</td>\n",
       "      <td>2020-06-16 14:52:50</td>\n",
       "      <td>350.0</td>\n",
       "      <td>13.50</td>\n",
       "      <td>14.30</td>\n",
       "      <td>14.50</td>\n",
       "      <td>2.450000</td>\n",
       "      <td>22.171944</td>\n",
       "      <td>344.0</td>\n",
       "      <td>1053.0</td>\n",
       "      <td>0.332709</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>AAPL200724C00352500</td>\n",
       "      <td>2020-06-16 14:52:37</td>\n",
       "      <td>352.5</td>\n",
       "      <td>12.40</td>\n",
       "      <td>13.00</td>\n",
       "      <td>13.25</td>\n",
       "      <td>3.900000</td>\n",
       "      <td>45.882347</td>\n",
       "      <td>113.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.330024</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>AAPL200724C00355000</td>\n",
       "      <td>2020-06-16 14:46:06</td>\n",
       "      <td>355.0</td>\n",
       "      <td>11.35</td>\n",
       "      <td>11.55</td>\n",
       "      <td>11.75</td>\n",
       "      <td>2.350000</td>\n",
       "      <td>26.111115</td>\n",
       "      <td>83.0</td>\n",
       "      <td>514.0</td>\n",
       "      <td>0.320380</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>AAPL200724C00357500</td>\n",
       "      <td>2020-06-16 14:52:57</td>\n",
       "      <td>357.5</td>\n",
       "      <td>9.75</td>\n",
       "      <td>10.60</td>\n",
       "      <td>10.90</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>11.428572</td>\n",
       "      <td>12.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>0.323646</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>AAPL200724C00360000</td>\n",
       "      <td>2020-06-16 14:53:24</td>\n",
       "      <td>360.0</td>\n",
       "      <td>8.85</td>\n",
       "      <td>9.35</td>\n",
       "      <td>9.50</td>\n",
       "      <td>1.560000</td>\n",
       "      <td>21.399183</td>\n",
       "      <td>131.0</td>\n",
       "      <td>579.0</td>\n",
       "      <td>0.313056</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>AAPL200724C00362500</td>\n",
       "      <td>2020-06-16 14:53:13</td>\n",
       "      <td>362.5</td>\n",
       "      <td>8.05</td>\n",
       "      <td>8.50</td>\n",
       "      <td>8.70</td>\n",
       "      <td>2.100000</td>\n",
       "      <td>35.294125</td>\n",
       "      <td>15.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.314582</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>AAPL200724C00365000</td>\n",
       "      <td>2020-06-16 14:52:06</td>\n",
       "      <td>365.0</td>\n",
       "      <td>7.40</td>\n",
       "      <td>7.55</td>\n",
       "      <td>7.80</td>\n",
       "      <td>1.350000</td>\n",
       "      <td>22.314047</td>\n",
       "      <td>32.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>0.312293</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>AAPL200724C00367500</td>\n",
       "      <td>2020-06-16 14:45:06</td>\n",
       "      <td>367.5</td>\n",
       "      <td>6.69</td>\n",
       "      <td>6.75</td>\n",
       "      <td>6.95</td>\n",
       "      <td>1.290000</td>\n",
       "      <td>23.888890</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.309669</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>AAPL200724C00370000</td>\n",
       "      <td>2020-06-16 14:39:05</td>\n",
       "      <td>370.0</td>\n",
       "      <td>6.47</td>\n",
       "      <td>5.95</td>\n",
       "      <td>6.15</td>\n",
       "      <td>2.120000</td>\n",
       "      <td>48.735630</td>\n",
       "      <td>54.0</td>\n",
       "      <td>594.0</td>\n",
       "      <td>0.306709</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>AAPL200724C00372500</td>\n",
       "      <td>2020-06-16 13:57:32</td>\n",
       "      <td>372.5</td>\n",
       "      <td>6.00</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.30</td>\n",
       "      <td>2.090000</td>\n",
       "      <td>53.452680</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.300666</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>AAPL200724C00375000</td>\n",
       "      <td>2020-06-16 14:45:48</td>\n",
       "      <td>375.0</td>\n",
       "      <td>4.45</td>\n",
       "      <td>4.60</td>\n",
       "      <td>4.80</td>\n",
       "      <td>0.650000</td>\n",
       "      <td>17.105259</td>\n",
       "      <td>46.0</td>\n",
       "      <td>248.0</td>\n",
       "      <td>0.302436</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>AAPL200724C00380000</td>\n",
       "      <td>2020-06-16 14:41:32</td>\n",
       "      <td>380.0</td>\n",
       "      <td>3.75</td>\n",
       "      <td>3.45</td>\n",
       "      <td>3.65</td>\n",
       "      <td>1.190000</td>\n",
       "      <td>46.484380</td>\n",
       "      <td>19.0</td>\n",
       "      <td>257.0</td>\n",
       "      <td>0.297370</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>AAPL200724C00385000</td>\n",
       "      <td>2020-06-16 14:51:10</td>\n",
       "      <td>385.0</td>\n",
       "      <td>2.69</td>\n",
       "      <td>2.71</td>\n",
       "      <td>2.82</td>\n",
       "      <td>0.630000</td>\n",
       "      <td>30.582531</td>\n",
       "      <td>11.0</td>\n",
       "      <td>263.0</td>\n",
       "      <td>0.296028</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>AAPL200724C00390000</td>\n",
       "      <td>2020-06-16 14:39:43</td>\n",
       "      <td>390.0</td>\n",
       "      <td>2.38</td>\n",
       "      <td>1.96</td>\n",
       "      <td>2.25</td>\n",
       "      <td>0.760000</td>\n",
       "      <td>46.913586</td>\n",
       "      <td>18.0</td>\n",
       "      <td>191.0</td>\n",
       "      <td>0.298774</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>AAPL200724C00395000</td>\n",
       "      <td>2020-06-16 14:54:59</td>\n",
       "      <td>395.0</td>\n",
       "      <td>1.53</td>\n",
       "      <td>1.54</td>\n",
       "      <td>1.78</td>\n",
       "      <td>0.310000</td>\n",
       "      <td>25.409830</td>\n",
       "      <td>146.0</td>\n",
       "      <td>658.0</td>\n",
       "      <td>0.301032</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>AAPL200724C00400000</td>\n",
       "      <td>2020-06-16 14:49:52</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.34</td>\n",
       "      <td>1.22</td>\n",
       "      <td>1.30</td>\n",
       "      <td>0.290000</td>\n",
       "      <td>27.619057</td>\n",
       "      <td>267.0</td>\n",
       "      <td>921.0</td>\n",
       "      <td>0.297737</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>AAPL200724C00405000</td>\n",
       "      <td>2020-06-16 14:21:16</td>\n",
       "      <td>405.0</td>\n",
       "      <td>1.21</td>\n",
       "      <td>1.02</td>\n",
       "      <td>1.13</td>\n",
       "      <td>0.390000</td>\n",
       "      <td>47.560980</td>\n",
       "      <td>19.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>0.307380</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>AAPL200724C00410000</td>\n",
       "      <td>2020-06-16 14:54:00</td>\n",
       "      <td>410.0</td>\n",
       "      <td>0.82</td>\n",
       "      <td>0.83</td>\n",
       "      <td>0.93</td>\n",
       "      <td>0.070000</td>\n",
       "      <td>9.333332</td>\n",
       "      <td>20.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>0.312751</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>AAPL200724C00415000</td>\n",
       "      <td>2020-06-16 14:39:07</td>\n",
       "      <td>415.0</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.71</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>60.000004</td>\n",
       "      <td>6.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.320563</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>AAPL200724C00420000</td>\n",
       "      <td>2020-06-16 14:18:26</td>\n",
       "      <td>420.0</td>\n",
       "      <td>0.71</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.170000</td>\n",
       "      <td>31.481474</td>\n",
       "      <td>5.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>0.333503</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>AAPL200724C00425000</td>\n",
       "      <td>2020-06-16 14:19:08</td>\n",
       "      <td>425.0</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.54</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.140000</td>\n",
       "      <td>29.166672</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0.338996</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>AAPL200724C00435000</td>\n",
       "      <td>2020-06-15 16:28:26</td>\n",
       "      <td>435.0</td>\n",
       "      <td>0.37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         contractSymbol       lastTradeDate  strike  lastPrice     bid  \\\n",
       "0   AAPL200724C00170000 2020-06-12 13:38:07   170.0     175.11  178.50   \n",
       "1   AAPL200724C00230000 2020-06-09 19:19:41   230.0     115.11  118.35   \n",
       "2   AAPL200724C00250000 2020-06-15 15:35:19   250.0      88.60   99.40   \n",
       "3   AAPL200724C00255000 2020-06-12 13:50:07   255.0      92.60   93.60   \n",
       "4   AAPL200724C00260000 2020-06-16 13:46:57   260.0      93.00   88.80   \n",
       "5   AAPL200724C00265000 2020-06-16 14:49:37   265.0      85.98   83.20   \n",
       "6   AAPL200724C00270000 2020-06-10 14:26:57   270.0      80.50   79.70   \n",
       "7   AAPL200724C00275000 2020-06-12 14:44:44   275.0      67.92   74.30   \n",
       "8   AAPL200724C00280000 2020-06-12 17:59:03   280.0      59.02   69.60   \n",
       "9   AAPL200724C00285000 2020-06-10 18:32:31   285.0      70.35   64.60   \n",
       "10  AAPL200724C00290000 2020-06-15 16:22:57   290.0      52.80   59.85   \n",
       "11  AAPL200724C00295000 2020-06-10 19:12:42   295.0      59.85   55.30   \n",
       "12  AAPL200724C00300000 2020-06-12 17:46:57   300.0      41.50   51.25   \n",
       "13  AAPL200724C00302500 2020-06-11 15:14:49   302.5      48.30   49.10   \n",
       "14  AAPL200724C00305000 2020-06-16 13:56:31   305.0      49.10   46.75   \n",
       "15  AAPL200724C00307500 2020-06-15 13:54:30   307.5      34.47   45.60   \n",
       "16  AAPL200724C00310000 2020-06-16 14:51:57   310.0      42.50   42.40   \n",
       "17  AAPL200724C00312500 2020-06-15 16:24:56   312.5      33.75   40.10   \n",
       "18  AAPL200724C00315000 2020-06-15 14:30:16   315.0      29.05   37.20   \n",
       "19  AAPL200724C00317500 2020-06-10 19:56:01   317.5      39.27   36.00   \n",
       "20  AAPL200724C00320000 2020-06-16 14:13:55   320.0      36.42   33.95   \n",
       "21  AAPL200724C00322500 2020-06-16 13:35:26   322.5      33.15   32.20   \n",
       "22  AAPL200724C00325000 2020-06-15 18:48:28   325.0      27.38   30.25   \n",
       "23  AAPL200724C00327500 2020-06-16 14:44:27   327.5      29.40   28.35   \n",
       "24  AAPL200724C00330000 2020-06-16 14:44:27   330.0      27.44   25.70   \n",
       "25  AAPL200724C00332500 2020-06-16 14:44:27   332.5      25.25   24.25   \n",
       "26  AAPL200724C00335000 2020-06-16 14:53:06   335.0      22.48   22.65   \n",
       "27  AAPL200724C00337500 2020-06-16 14:43:40   337.5      22.05   21.80   \n",
       "28  AAPL200724C00340000 2020-06-16 14:55:08   340.0      19.00   19.55   \n",
       "29  AAPL200724C00342500 2020-06-16 14:21:25   342.5      19.30   18.50   \n",
       "30  AAPL200724C00345000 2020-06-16 14:54:50   345.0      15.90   17.10   \n",
       "31  AAPL200724C00347500 2020-06-16 14:40:46   347.5      16.15   15.55   \n",
       "32  AAPL200724C00350000 2020-06-16 14:52:50   350.0      13.50   14.30   \n",
       "33  AAPL200724C00352500 2020-06-16 14:52:37   352.5      12.40   13.00   \n",
       "34  AAPL200724C00355000 2020-06-16 14:46:06   355.0      11.35   11.55   \n",
       "35  AAPL200724C00357500 2020-06-16 14:52:57   357.5       9.75   10.60   \n",
       "36  AAPL200724C00360000 2020-06-16 14:53:24   360.0       8.85    9.35   \n",
       "37  AAPL200724C00362500 2020-06-16 14:53:13   362.5       8.05    8.50   \n",
       "38  AAPL200724C00365000 2020-06-16 14:52:06   365.0       7.40    7.55   \n",
       "39  AAPL200724C00367500 2020-06-16 14:45:06   367.5       6.69    6.75   \n",
       "40  AAPL200724C00370000 2020-06-16 14:39:05   370.0       6.47    5.95   \n",
       "41  AAPL200724C00372500 2020-06-16 13:57:32   372.5       6.00    5.15   \n",
       "42  AAPL200724C00375000 2020-06-16 14:45:48   375.0       4.45    4.60   \n",
       "43  AAPL200724C00380000 2020-06-16 14:41:32   380.0       3.75    3.45   \n",
       "44  AAPL200724C00385000 2020-06-16 14:51:10   385.0       2.69    2.71   \n",
       "45  AAPL200724C00390000 2020-06-16 14:39:43   390.0       2.38    1.96   \n",
       "46  AAPL200724C00395000 2020-06-16 14:54:59   395.0       1.53    1.54   \n",
       "47  AAPL200724C00400000 2020-06-16 14:49:52   400.0       1.34    1.22   \n",
       "48  AAPL200724C00405000 2020-06-16 14:21:16   405.0       1.21    1.02   \n",
       "49  AAPL200724C00410000 2020-06-16 14:54:00   410.0       0.82    0.83   \n",
       "50  AAPL200724C00415000 2020-06-16 14:39:07   415.0       0.80    0.71   \n",
       "51  AAPL200724C00420000 2020-06-16 14:18:26   420.0       0.71    0.56   \n",
       "52  AAPL200724C00425000 2020-06-16 14:19:08   425.0       0.62    0.54   \n",
       "53  AAPL200724C00435000 2020-06-15 16:28:26   435.0       0.37     NaN   \n",
       "\n",
       "       ask    change  percentChange  volume  openInterest  impliedVolatility  \\\n",
       "0   181.85  0.000000       0.000000     1.0           0.0           1.240971   \n",
       "1   121.55  0.000000       0.000000     NaN           1.0           0.749514   \n",
       "2   102.15  0.000000       0.000000     1.0           3.0           0.692874   \n",
       "3    96.90  0.000000       0.000000     1.0           0.0           0.617680   \n",
       "4    92.00  4.160004       4.682580     1.0           5.0           0.598271   \n",
       "5    86.70  8.750000      11.329794     2.0          54.0           0.530034   \n",
       "6    82.85  0.000000       0.000000     NaN          11.0           0.593144   \n",
       "7    77.30  0.000000       0.000000     2.0           6.0           0.531499   \n",
       "8    72.30  0.000000       0.000000     2.0          18.0           0.508794   \n",
       "9    67.35  0.000000       0.000000     1.0          10.0           0.547856   \n",
       "10   63.00  0.000000       0.000000     2.0         113.0           0.541264   \n",
       "11   57.90  0.000000       0.000000    28.0          35.0           0.501836   \n",
       "12   52.80  0.000000       0.000000     8.0         117.0           0.462896   \n",
       "13   50.80  0.000000       0.000000     NaN           5.0           0.464117   \n",
       "14   48.55  9.570000      24.209461     2.0          23.0           0.455145   \n",
       "15   46.90  0.000000       0.000000     1.0          31.0           0.465765   \n",
       "16   44.05  5.049999      13.484644     1.0          40.0           0.435553   \n",
       "17   42.70  0.000000       0.000000     2.0           7.0           0.453069   \n",
       "18   40.05  0.000000       0.000000     3.0           8.0           0.429205   \n",
       "19   38.15  0.000000       0.000000     6.0          28.0           0.427313   \n",
       "20   36.00  5.349998      17.219180     5.0         146.0           0.417303   \n",
       "21   33.60  7.040001      26.962854     1.0          33.0           0.399847   \n",
       "22   31.50  0.000000       0.000000    15.0          96.0           0.390051   \n",
       "23   29.25  8.600000      41.346157     2.0          83.0           0.375617   \n",
       "24   26.60  4.840000      21.415930    18.0         236.0           0.350531   \n",
       "25   24.60  5.250000      26.250000     6.0          60.0           0.341437   \n",
       "26   23.00  3.359999      17.573214    15.0         447.0           0.340918   \n",
       "27   22.10  4.400000      24.929176    25.0         175.0           0.355292   \n",
       "28   19.80  2.700001      16.564423    72.0         530.0           0.335608   \n",
       "29   18.75  4.449999      29.966320    27.0         115.0           0.343268   \n",
       "30   17.35  2.349999      17.343168    64.0         390.0           0.341498   \n",
       "31   15.75  4.000000      32.921810    39.0         161.0           0.333930   \n",
       "32   14.50  2.450000      22.171944   344.0        1053.0           0.332709   \n",
       "33   13.25  3.900000      45.882347   113.0          21.0           0.330024   \n",
       "34   11.75  2.350000      26.111115    83.0         514.0           0.320380   \n",
       "35   10.90  1.000000      11.428572    12.0          33.0           0.323646   \n",
       "36    9.50  1.560000      21.399183   131.0         579.0           0.313056   \n",
       "37    8.70  2.100000      35.294125    15.0          12.0           0.314582   \n",
       "38    7.80  1.350000      22.314047    32.0         172.0           0.312293   \n",
       "39    6.95  1.290000      23.888890     6.0          11.0           0.309669   \n",
       "40    6.15  2.120000      48.735630    54.0         594.0           0.306709   \n",
       "41    5.30  2.090000      53.452680     3.0          17.0           0.300666   \n",
       "42    4.80  0.650000      17.105259    46.0         248.0           0.302436   \n",
       "43    3.65  1.190000      46.484380    19.0         257.0           0.297370   \n",
       "44    2.82  0.630000      30.582531    11.0         263.0           0.296028   \n",
       "45    2.25  0.760000      46.913586    18.0         191.0           0.298774   \n",
       "46    1.78  0.310000      25.409830   146.0         658.0           0.301032   \n",
       "47    1.30  0.290000      27.619057   267.0         921.0           0.297737   \n",
       "48    1.13  0.390000      47.560980    19.0         124.0           0.307380   \n",
       "49    0.93  0.070000       9.333332    20.0         112.0           0.312751   \n",
       "50    0.80  0.300000      60.000004     6.0          17.0           0.320563   \n",
       "51    0.75  0.170000      31.481474     5.0         105.0           0.333503   \n",
       "52    0.63  0.140000      29.166672     1.0          36.0           0.338996   \n",
       "53     NaN  0.000000       0.000000     NaN           NaN           0.000000   \n",
       "\n",
       "    inTheMoney contractSize currency  \n",
       "0         True      REGULAR      USD  \n",
       "1         True      REGULAR      USD  \n",
       "2         True      REGULAR      USD  \n",
       "3         True      REGULAR      USD  \n",
       "4         True      REGULAR      USD  \n",
       "5         True      REGULAR      USD  \n",
       "6         True      REGULAR      USD  \n",
       "7         True      REGULAR      USD  \n",
       "8         True      REGULAR      USD  \n",
       "9         True      REGULAR      USD  \n",
       "10        True      REGULAR      USD  \n",
       "11        True      REGULAR      USD  \n",
       "12        True      REGULAR      USD  \n",
       "13        True      REGULAR      USD  \n",
       "14        True      REGULAR      USD  \n",
       "15        True      REGULAR      USD  \n",
       "16        True      REGULAR      USD  \n",
       "17        True      REGULAR      USD  \n",
       "18        True      REGULAR      USD  \n",
       "19        True      REGULAR      USD  \n",
       "20        True      REGULAR      USD  \n",
       "21        True      REGULAR      USD  \n",
       "22        True      REGULAR      USD  \n",
       "23        True      REGULAR      USD  \n",
       "24        True      REGULAR      USD  \n",
       "25        True      REGULAR      USD  \n",
       "26        True      REGULAR      USD  \n",
       "27        True      REGULAR      USD  \n",
       "28        True      REGULAR      USD  \n",
       "29        True      REGULAR      USD  \n",
       "30        True      REGULAR      USD  \n",
       "31        True      REGULAR      USD  \n",
       "32       False      REGULAR      USD  \n",
       "33       False      REGULAR      USD  \n",
       "34       False      REGULAR      USD  \n",
       "35       False      REGULAR      USD  \n",
       "36       False      REGULAR      USD  \n",
       "37       False      REGULAR      USD  \n",
       "38       False      REGULAR      USD  \n",
       "39       False      REGULAR      USD  \n",
       "40       False      REGULAR      USD  \n",
       "41       False      REGULAR      USD  \n",
       "42       False      REGULAR      USD  \n",
       "43       False      REGULAR      USD  \n",
       "44       False      REGULAR      USD  \n",
       "45       False      REGULAR      USD  \n",
       "46       False      REGULAR      USD  \n",
       "47       False      REGULAR      USD  \n",
       "48       False      REGULAR      USD  \n",
       "49       False      REGULAR      USD  \n",
       "50       False      REGULAR      USD  \n",
       "51       False      REGULAR      USD  \n",
       "52       False      REGULAR      USD  \n",
       "53       False      REGULAR      USD  "
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get option chain calls data for specific expiration date\n",
    "opt = aapl.option_chain(date='2020-07-24')\n",
    "opt.calls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>contractSymbol</th>\n",
       "      <th>lastTradeDate</th>\n",
       "      <th>strike</th>\n",
       "      <th>lastPrice</th>\n",
       "      <th>bid</th>\n",
       "      <th>ask</th>\n",
       "      <th>change</th>\n",
       "      <th>percentChange</th>\n",
       "      <th>volume</th>\n",
       "      <th>openInterest</th>\n",
       "      <th>impliedVolatility</th>\n",
       "      <th>inTheMoney</th>\n",
       "      <th>contractSize</th>\n",
       "      <th>currency</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAPL200724P00180000</td>\n",
       "      <td>2020-06-15 14:17:59</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.0</td>\n",
       "      <td>22</td>\n",
       "      <td>0.775393</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAPL200724P00190000</td>\n",
       "      <td>2020-06-15 16:28:26</td>\n",
       "      <td>190.0</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.0</td>\n",
       "      <td>20</td>\n",
       "      <td>0.732425</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AAPL200724P00195000</td>\n",
       "      <td>2020-06-15 04:13:08</td>\n",
       "      <td>195.0</td>\n",
       "      <td>0.39</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0.710940</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AAPL200724P00200000</td>\n",
       "      <td>2020-06-15 14:51:12</td>\n",
       "      <td>200.0</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>13.0</td>\n",
       "      <td>14</td>\n",
       "      <td>0.700198</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AAPL200724P00205000</td>\n",
       "      <td>2020-06-12 17:35:31</td>\n",
       "      <td>205.0</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0.689456</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>AAPL200724P00210000</td>\n",
       "      <td>2020-06-15 18:07:35</td>\n",
       "      <td>210.0</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "      <td>0.673831</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AAPL200724P00215000</td>\n",
       "      <td>2020-06-12 14:35:13</td>\n",
       "      <td>215.0</td>\n",
       "      <td>0.32</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10</td>\n",
       "      <td>0.656253</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AAPL200724P00220000</td>\n",
       "      <td>2020-06-16 14:19:25</td>\n",
       "      <td>220.0</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.43</td>\n",
       "      <td>-0.070000</td>\n",
       "      <td>-19.999998</td>\n",
       "      <td>105.0</td>\n",
       "      <td>8</td>\n",
       "      <td>0.642582</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>AAPL200724P00225000</td>\n",
       "      <td>2020-06-15 17:48:53</td>\n",
       "      <td>225.0</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14</td>\n",
       "      <td>0.632816</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AAPL200724P00230000</td>\n",
       "      <td>2020-06-16 13:41:27</td>\n",
       "      <td>230.0</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.48</td>\n",
       "      <td>-0.140000</td>\n",
       "      <td>-31.111107</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7</td>\n",
       "      <td>0.609379</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AAPL200724P00235000</td>\n",
       "      <td>2020-06-15 19:02:49</td>\n",
       "      <td>235.0</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.54</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.0</td>\n",
       "      <td>14</td>\n",
       "      <td>0.594731</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>AAPL200724P00240000</td>\n",
       "      <td>2020-06-16 14:45:43</td>\n",
       "      <td>240.0</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.39</td>\n",
       "      <td>0.66</td>\n",
       "      <td>-0.440000</td>\n",
       "      <td>-46.808510</td>\n",
       "      <td>2.0</td>\n",
       "      <td>17</td>\n",
       "      <td>0.583989</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>AAPL200724P00245000</td>\n",
       "      <td>2020-06-15 16:19:52</td>\n",
       "      <td>245.0</td>\n",
       "      <td>0.95</td>\n",
       "      <td>0.51</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>192.0</td>\n",
       "      <td>192</td>\n",
       "      <td>0.561040</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>AAPL200724P00250000</td>\n",
       "      <td>2020-06-16 14:21:24</td>\n",
       "      <td>250.0</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.71</td>\n",
       "      <td>-0.260000</td>\n",
       "      <td>-30.232557</td>\n",
       "      <td>12.0</td>\n",
       "      <td>217</td>\n",
       "      <td>0.550053</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AAPL200724P00255000</td>\n",
       "      <td>2020-06-16 13:34:33</td>\n",
       "      <td>255.0</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.68</td>\n",
       "      <td>0.77</td>\n",
       "      <td>-0.430000</td>\n",
       "      <td>-36.440678</td>\n",
       "      <td>5.0</td>\n",
       "      <td>40</td>\n",
       "      <td>0.530034</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AAPL200724P00260000</td>\n",
       "      <td>2020-06-15 18:50:59</td>\n",
       "      <td>260.0</td>\n",
       "      <td>1.02</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>44.0</td>\n",
       "      <td>198</td>\n",
       "      <td>0.515386</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>AAPL200724P00265000</td>\n",
       "      <td>2020-06-15 16:46:00</td>\n",
       "      <td>265.0</td>\n",
       "      <td>1.56</td>\n",
       "      <td>0.94</td>\n",
       "      <td>1.04</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>103.0</td>\n",
       "      <td>163</td>\n",
       "      <td>0.503667</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>AAPL200724P00270000</td>\n",
       "      <td>2020-06-16 13:54:33</td>\n",
       "      <td>270.0</td>\n",
       "      <td>1.03</td>\n",
       "      <td>1.07</td>\n",
       "      <td>1.16</td>\n",
       "      <td>-1.020000</td>\n",
       "      <td>-49.756100</td>\n",
       "      <td>5.0</td>\n",
       "      <td>198</td>\n",
       "      <td>0.490972</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>AAPL200724P00275000</td>\n",
       "      <td>2020-06-16 14:28:54</td>\n",
       "      <td>275.0</td>\n",
       "      <td>1.16</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1.26</td>\n",
       "      <td>-1.360000</td>\n",
       "      <td>-53.968254</td>\n",
       "      <td>8.0</td>\n",
       "      <td>217</td>\n",
       "      <td>0.470464</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>AAPL200724P00280000</td>\n",
       "      <td>2020-06-16 14:24:07</td>\n",
       "      <td>280.0</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1.36</td>\n",
       "      <td>1.45</td>\n",
       "      <td>-0.560000</td>\n",
       "      <td>-30.107530</td>\n",
       "      <td>5.0</td>\n",
       "      <td>512</td>\n",
       "      <td>0.455816</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>AAPL200724P00285000</td>\n",
       "      <td>2020-06-16 14:40:41</td>\n",
       "      <td>285.0</td>\n",
       "      <td>1.54</td>\n",
       "      <td>1.63</td>\n",
       "      <td>1.71</td>\n",
       "      <td>-0.580000</td>\n",
       "      <td>-27.358488</td>\n",
       "      <td>2.0</td>\n",
       "      <td>249</td>\n",
       "      <td>0.443853</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>AAPL200724P00290000</td>\n",
       "      <td>2020-06-16 14:53:03</td>\n",
       "      <td>290.0</td>\n",
       "      <td>1.97</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.19</td>\n",
       "      <td>-0.430000</td>\n",
       "      <td>-17.916668</td>\n",
       "      <td>1.0</td>\n",
       "      <td>151</td>\n",
       "      <td>0.441534</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>AAPL200724P00295000</td>\n",
       "      <td>2020-06-16 14:38:46</td>\n",
       "      <td>295.0</td>\n",
       "      <td>2.11</td>\n",
       "      <td>2.14</td>\n",
       "      <td>2.24</td>\n",
       "      <td>-0.890000</td>\n",
       "      <td>-29.666670</td>\n",
       "      <td>3.0</td>\n",
       "      <td>88</td>\n",
       "      <td>0.412970</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>AAPL200724P00300000</td>\n",
       "      <td>2020-06-16 14:42:06</td>\n",
       "      <td>300.0</td>\n",
       "      <td>2.51</td>\n",
       "      <td>2.44</td>\n",
       "      <td>2.55</td>\n",
       "      <td>-0.840000</td>\n",
       "      <td>-25.074625</td>\n",
       "      <td>19.0</td>\n",
       "      <td>384</td>\n",
       "      <td>0.396674</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>AAPL200724P00302500</td>\n",
       "      <td>2020-06-15 18:08:06</td>\n",
       "      <td>302.5</td>\n",
       "      <td>3.75</td>\n",
       "      <td>2.84</td>\n",
       "      <td>2.95</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>29</td>\n",
       "      <td>0.398444</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>AAPL200724P00305000</td>\n",
       "      <td>2020-06-16 14:18:05</td>\n",
       "      <td>305.0</td>\n",
       "      <td>2.70</td>\n",
       "      <td>2.91</td>\n",
       "      <td>3.05</td>\n",
       "      <td>-2.900000</td>\n",
       "      <td>-51.785717</td>\n",
       "      <td>27.0</td>\n",
       "      <td>104</td>\n",
       "      <td>0.386237</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>AAPL200724P00307500</td>\n",
       "      <td>2020-06-16 14:47:04</td>\n",
       "      <td>307.5</td>\n",
       "      <td>3.30</td>\n",
       "      <td>3.15</td>\n",
       "      <td>3.30</td>\n",
       "      <td>-3.000000</td>\n",
       "      <td>-47.619053</td>\n",
       "      <td>6.0</td>\n",
       "      <td>20</td>\n",
       "      <td>0.379645</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>AAPL200724P00310000</td>\n",
       "      <td>2020-06-16 14:53:22</td>\n",
       "      <td>310.0</td>\n",
       "      <td>3.80</td>\n",
       "      <td>3.60</td>\n",
       "      <td>3.75</td>\n",
       "      <td>-1.200000</td>\n",
       "      <td>-24.000000</td>\n",
       "      <td>27.0</td>\n",
       "      <td>311</td>\n",
       "      <td>0.379706</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>AAPL200724P00312500</td>\n",
       "      <td>2020-06-16 14:23:20</td>\n",
       "      <td>312.5</td>\n",
       "      <td>3.55</td>\n",
       "      <td>3.75</td>\n",
       "      <td>3.90</td>\n",
       "      <td>-1.960000</td>\n",
       "      <td>-35.571693</td>\n",
       "      <td>4.0</td>\n",
       "      <td>73</td>\n",
       "      <td>0.367804</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>AAPL200724P00315000</td>\n",
       "      <td>2020-06-16 14:37:47</td>\n",
       "      <td>315.0</td>\n",
       "      <td>3.75</td>\n",
       "      <td>4.20</td>\n",
       "      <td>4.35</td>\n",
       "      <td>-2.230000</td>\n",
       "      <td>-37.290970</td>\n",
       "      <td>31.0</td>\n",
       "      <td>225</td>\n",
       "      <td>0.365607</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>AAPL200724P00317500</td>\n",
       "      <td>2020-06-16 14:02:47</td>\n",
       "      <td>317.5</td>\n",
       "      <td>4.30</td>\n",
       "      <td>4.60</td>\n",
       "      <td>4.75</td>\n",
       "      <td>-4.729999</td>\n",
       "      <td>-52.380947</td>\n",
       "      <td>6.0</td>\n",
       "      <td>71</td>\n",
       "      <td>0.360541</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>AAPL200724P00320000</td>\n",
       "      <td>2020-06-16 14:41:41</td>\n",
       "      <td>320.0</td>\n",
       "      <td>4.90</td>\n",
       "      <td>4.90</td>\n",
       "      <td>5.10</td>\n",
       "      <td>-2.050000</td>\n",
       "      <td>-29.496399</td>\n",
       "      <td>15.0</td>\n",
       "      <td>230</td>\n",
       "      <td>0.352912</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>AAPL200724P00322500</td>\n",
       "      <td>2020-06-16 14:44:40</td>\n",
       "      <td>322.5</td>\n",
       "      <td>5.50</td>\n",
       "      <td>5.70</td>\n",
       "      <td>5.90</td>\n",
       "      <td>-1.900000</td>\n",
       "      <td>-25.675678</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24</td>\n",
       "      <td>0.357428</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>AAPL200724P00325000</td>\n",
       "      <td>2020-06-16 14:25:42</td>\n",
       "      <td>325.0</td>\n",
       "      <td>5.50</td>\n",
       "      <td>6.15</td>\n",
       "      <td>6.35</td>\n",
       "      <td>-2.650000</td>\n",
       "      <td>-32.515335</td>\n",
       "      <td>18.0</td>\n",
       "      <td>170</td>\n",
       "      <td>0.350409</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>AAPL200724P00327500</td>\n",
       "      <td>2020-06-16 13:52:39</td>\n",
       "      <td>327.5</td>\n",
       "      <td>6.30</td>\n",
       "      <td>6.45</td>\n",
       "      <td>6.65</td>\n",
       "      <td>-5.349999</td>\n",
       "      <td>-45.922745</td>\n",
       "      <td>13.0</td>\n",
       "      <td>134</td>\n",
       "      <td>0.338447</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>AAPL200724P00330000</td>\n",
       "      <td>2020-06-16 14:53:49</td>\n",
       "      <td>330.0</td>\n",
       "      <td>7.85</td>\n",
       "      <td>7.05</td>\n",
       "      <td>7.25</td>\n",
       "      <td>-2.300000</td>\n",
       "      <td>-22.660097</td>\n",
       "      <td>59.0</td>\n",
       "      <td>221</td>\n",
       "      <td>0.333503</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>AAPL200724P00332500</td>\n",
       "      <td>2020-06-15 18:40:54</td>\n",
       "      <td>332.5</td>\n",
       "      <td>10.01</td>\n",
       "      <td>7.70</td>\n",
       "      <td>7.90</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>12.0</td>\n",
       "      <td>42</td>\n",
       "      <td>0.328620</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>AAPL200724P00335000</td>\n",
       "      <td>2020-06-16 14:42:10</td>\n",
       "      <td>335.0</td>\n",
       "      <td>8.50</td>\n",
       "      <td>8.40</td>\n",
       "      <td>8.60</td>\n",
       "      <td>-2.700000</td>\n",
       "      <td>-24.107141</td>\n",
       "      <td>11.0</td>\n",
       "      <td>130</td>\n",
       "      <td>0.323676</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>AAPL200724P00337500</td>\n",
       "      <td>2020-06-16 14:38:16</td>\n",
       "      <td>337.5</td>\n",
       "      <td>9.25</td>\n",
       "      <td>9.20</td>\n",
       "      <td>9.45</td>\n",
       "      <td>-3.300000</td>\n",
       "      <td>-26.294823</td>\n",
       "      <td>6.0</td>\n",
       "      <td>52</td>\n",
       "      <td>0.320991</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>AAPL200724P00340000</td>\n",
       "      <td>2020-06-16 14:47:25</td>\n",
       "      <td>340.0</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.10</td>\n",
       "      <td>10.30</td>\n",
       "      <td>-3.270001</td>\n",
       "      <td>-24.186394</td>\n",
       "      <td>18.0</td>\n",
       "      <td>242</td>\n",
       "      <td>0.316901</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>AAPL200724P00342500</td>\n",
       "      <td>2020-06-16 14:55:09</td>\n",
       "      <td>342.5</td>\n",
       "      <td>12.00</td>\n",
       "      <td>10.95</td>\n",
       "      <td>11.15</td>\n",
       "      <td>-2.750000</td>\n",
       "      <td>-18.644068</td>\n",
       "      <td>3.0</td>\n",
       "      <td>135</td>\n",
       "      <td>0.311347</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>AAPL200724P00345000</td>\n",
       "      <td>2020-06-16 14:38:05</td>\n",
       "      <td>345.0</td>\n",
       "      <td>11.70</td>\n",
       "      <td>11.95</td>\n",
       "      <td>12.15</td>\n",
       "      <td>-4.120000</td>\n",
       "      <td>-26.042984</td>\n",
       "      <td>9.0</td>\n",
       "      <td>103</td>\n",
       "      <td>0.307777</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>AAPL200724P00347500</td>\n",
       "      <td>2020-06-16 14:34:02</td>\n",
       "      <td>347.5</td>\n",
       "      <td>12.20</td>\n",
       "      <td>12.90</td>\n",
       "      <td>13.15</td>\n",
       "      <td>-4.200000</td>\n",
       "      <td>-25.609755</td>\n",
       "      <td>2.0</td>\n",
       "      <td>54</td>\n",
       "      <td>0.302680</td>\n",
       "      <td>False</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>AAPL200724P00350000</td>\n",
       "      <td>2020-06-16 14:52:08</td>\n",
       "      <td>350.0</td>\n",
       "      <td>14.95</td>\n",
       "      <td>14.05</td>\n",
       "      <td>14.25</td>\n",
       "      <td>-3.070001</td>\n",
       "      <td>-17.036629</td>\n",
       "      <td>32.0</td>\n",
       "      <td>210</td>\n",
       "      <td>0.298255</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>AAPL200724P00352500</td>\n",
       "      <td>2020-06-16 14:48:20</td>\n",
       "      <td>352.5</td>\n",
       "      <td>15.50</td>\n",
       "      <td>15.20</td>\n",
       "      <td>15.45</td>\n",
       "      <td>0.550000</td>\n",
       "      <td>3.678931</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.294441</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>AAPL200724P00355000</td>\n",
       "      <td>2020-06-16 14:37:49</td>\n",
       "      <td>355.0</td>\n",
       "      <td>15.50</td>\n",
       "      <td>15.45</td>\n",
       "      <td>15.60</td>\n",
       "      <td>-5.420000</td>\n",
       "      <td>-25.908222</td>\n",
       "      <td>11.0</td>\n",
       "      <td>59</td>\n",
       "      <td>0.265602</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>AAPL200724P00357500</td>\n",
       "      <td>2020-06-16 14:34:02</td>\n",
       "      <td>357.5</td>\n",
       "      <td>16.90</td>\n",
       "      <td>17.95</td>\n",
       "      <td>18.20</td>\n",
       "      <td>-5.770001</td>\n",
       "      <td>-25.452143</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.289619</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>AAPL200724P00360000</td>\n",
       "      <td>2020-06-12 15:22:06</td>\n",
       "      <td>360.0</td>\n",
       "      <td>28.90</td>\n",
       "      <td>20.15</td>\n",
       "      <td>20.35</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>18.0</td>\n",
       "      <td>55</td>\n",
       "      <td>0.302436</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>AAPL200724P00365000</td>\n",
       "      <td>2020-06-10 17:44:00</td>\n",
       "      <td>365.0</td>\n",
       "      <td>21.07</td>\n",
       "      <td>22.15</td>\n",
       "      <td>22.75</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0.279426</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>AAPL200724P00370000</td>\n",
       "      <td>2020-06-11 19:36:28</td>\n",
       "      <td>370.0</td>\n",
       "      <td>36.90</td>\n",
       "      <td>25.55</td>\n",
       "      <td>26.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>0.268440</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>AAPL200724P00385000</td>\n",
       "      <td>2020-06-10 19:09:30</td>\n",
       "      <td>385.0</td>\n",
       "      <td>35.00</td>\n",
       "      <td>36.15</td>\n",
       "      <td>38.75</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>0.281990</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>AAPL200724P00390000</td>\n",
       "      <td>2020-06-15 15:23:22</td>\n",
       "      <td>390.0</td>\n",
       "      <td>54.20</td>\n",
       "      <td>40.15</td>\n",
       "      <td>42.90</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.270149</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>AAPL200724P00395000</td>\n",
       "      <td>2020-06-10 15:30:40</td>\n",
       "      <td>395.0</td>\n",
       "      <td>44.82</td>\n",
       "      <td>45.90</td>\n",
       "      <td>47.75</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>0.284309</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>AAPL200724P00400000</td>\n",
       "      <td>2020-06-15 14:23:33</td>\n",
       "      <td>400.0</td>\n",
       "      <td>64.70</td>\n",
       "      <td>50.50</td>\n",
       "      <td>53.95</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.359992</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>AAPL200724P00405000</td>\n",
       "      <td>2020-06-12 16:34:25</td>\n",
       "      <td>405.0</td>\n",
       "      <td>66.19</td>\n",
       "      <td>55.30</td>\n",
       "      <td>58.65</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.369086</td>\n",
       "      <td>True</td>\n",
       "      <td>REGULAR</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         contractSymbol       lastTradeDate  strike  lastPrice    bid    ask  \\\n",
       "0   AAPL200724P00180000 2020-06-15 14:17:59   180.0       0.20   0.00   0.18   \n",
       "1   AAPL200724P00190000 2020-06-15 16:28:26   190.0       0.18   0.00   0.22   \n",
       "2   AAPL200724P00195000 2020-06-15 04:13:08   195.0       0.39   0.00   0.24   \n",
       "3   AAPL200724P00200000 2020-06-15 14:51:12   200.0       0.40   0.03   0.27   \n",
       "4   AAPL200724P00205000 2020-06-12 17:35:31   205.0       0.55   0.06   0.31   \n",
       "5   AAPL200724P00210000 2020-06-15 18:07:35   210.0       0.33   0.09   0.34   \n",
       "6   AAPL200724P00215000 2020-06-12 14:35:13   215.0       0.32   0.13   0.36   \n",
       "7   AAPL200724P00220000 2020-06-16 14:19:25   220.0       0.28   0.15   0.43   \n",
       "8   AAPL200724P00225000 2020-06-15 17:48:53   225.0       0.50   0.29   0.42   \n",
       "9   AAPL200724P00230000 2020-06-16 13:41:27   230.0       0.31   0.27   0.48   \n",
       "10  AAPL200724P00235000 2020-06-15 19:02:49   235.0       0.55   0.33   0.54   \n",
       "11  AAPL200724P00240000 2020-06-16 14:45:43   240.0       0.50   0.39   0.66   \n",
       "12  AAPL200724P00245000 2020-06-15 16:19:52   245.0       0.95   0.51   0.60   \n",
       "13  AAPL200724P00250000 2020-06-16 14:21:24   250.0       0.60   0.62   0.71   \n",
       "14  AAPL200724P00255000 2020-06-16 13:34:33   255.0       0.75   0.68   0.77   \n",
       "15  AAPL200724P00260000 2020-06-15 18:50:59   260.0       1.02   0.80   0.87   \n",
       "16  AAPL200724P00265000 2020-06-15 16:46:00   265.0       1.56   0.94   1.04   \n",
       "17  AAPL200724P00270000 2020-06-16 13:54:33   270.0       1.03   1.07   1.16   \n",
       "18  AAPL200724P00275000 2020-06-16 14:28:54   275.0       1.16   1.20   1.26   \n",
       "19  AAPL200724P00280000 2020-06-16 14:24:07   280.0       1.30   1.36   1.45   \n",
       "20  AAPL200724P00285000 2020-06-16 14:40:41   285.0       1.54   1.63   1.71   \n",
       "21  AAPL200724P00290000 2020-06-16 14:53:03   290.0       1.97   1.75   2.19   \n",
       "22  AAPL200724P00295000 2020-06-16 14:38:46   295.0       2.11   2.14   2.24   \n",
       "23  AAPL200724P00300000 2020-06-16 14:42:06   300.0       2.51   2.44   2.55   \n",
       "24  AAPL200724P00302500 2020-06-15 18:08:06   302.5       3.75   2.84   2.95   \n",
       "25  AAPL200724P00305000 2020-06-16 14:18:05   305.0       2.70   2.91   3.05   \n",
       "26  AAPL200724P00307500 2020-06-16 14:47:04   307.5       3.30   3.15   3.30   \n",
       "27  AAPL200724P00310000 2020-06-16 14:53:22   310.0       3.80   3.60   3.75   \n",
       "28  AAPL200724P00312500 2020-06-16 14:23:20   312.5       3.55   3.75   3.90   \n",
       "29  AAPL200724P00315000 2020-06-16 14:37:47   315.0       3.75   4.20   4.35   \n",
       "30  AAPL200724P00317500 2020-06-16 14:02:47   317.5       4.30   4.60   4.75   \n",
       "31  AAPL200724P00320000 2020-06-16 14:41:41   320.0       4.90   4.90   5.10   \n",
       "32  AAPL200724P00322500 2020-06-16 14:44:40   322.5       5.50   5.70   5.90   \n",
       "33  AAPL200724P00325000 2020-06-16 14:25:42   325.0       5.50   6.15   6.35   \n",
       "34  AAPL200724P00327500 2020-06-16 13:52:39   327.5       6.30   6.45   6.65   \n",
       "35  AAPL200724P00330000 2020-06-16 14:53:49   330.0       7.85   7.05   7.25   \n",
       "36  AAPL200724P00332500 2020-06-15 18:40:54   332.5      10.01   7.70   7.90   \n",
       "37  AAPL200724P00335000 2020-06-16 14:42:10   335.0       8.50   8.40   8.60   \n",
       "38  AAPL200724P00337500 2020-06-16 14:38:16   337.5       9.25   9.20   9.45   \n",
       "39  AAPL200724P00340000 2020-06-16 14:47:25   340.0      10.25  10.10  10.30   \n",
       "40  AAPL200724P00342500 2020-06-16 14:55:09   342.5      12.00  10.95  11.15   \n",
       "41  AAPL200724P00345000 2020-06-16 14:38:05   345.0      11.70  11.95  12.15   \n",
       "42  AAPL200724P00347500 2020-06-16 14:34:02   347.5      12.20  12.90  13.15   \n",
       "43  AAPL200724P00350000 2020-06-16 14:52:08   350.0      14.95  14.05  14.25   \n",
       "44  AAPL200724P00352500 2020-06-16 14:48:20   352.5      15.50  15.20  15.45   \n",
       "45  AAPL200724P00355000 2020-06-16 14:37:49   355.0      15.50  15.45  15.60   \n",
       "46  AAPL200724P00357500 2020-06-16 14:34:02   357.5      16.90  17.95  18.20   \n",
       "47  AAPL200724P00360000 2020-06-12 15:22:06   360.0      28.90  20.15  20.35   \n",
       "48  AAPL200724P00365000 2020-06-10 17:44:00   365.0      21.07  22.15  22.75   \n",
       "49  AAPL200724P00370000 2020-06-11 19:36:28   370.0      36.90  25.55  26.00   \n",
       "50  AAPL200724P00385000 2020-06-10 19:09:30   385.0      35.00  36.15  38.75   \n",
       "51  AAPL200724P00390000 2020-06-15 15:23:22   390.0      54.20  40.15  42.90   \n",
       "52  AAPL200724P00395000 2020-06-10 15:30:40   395.0      44.82  45.90  47.75   \n",
       "53  AAPL200724P00400000 2020-06-15 14:23:33   400.0      64.70  50.50  53.95   \n",
       "54  AAPL200724P00405000 2020-06-12 16:34:25   405.0      66.19  55.30  58.65   \n",
       "\n",
       "      change  percentChange  volume  openInterest  impliedVolatility  \\\n",
       "0   0.000000       0.000000    42.0            22           0.775393   \n",
       "1   0.000000       0.000000    10.0            20           0.732425   \n",
       "2   0.000000       0.000000     NaN             1           0.710940   \n",
       "3   0.000000       0.000000    13.0            14           0.700198   \n",
       "4   0.000000       0.000000     NaN             1           0.689456   \n",
       "5   0.000000       0.000000     1.0             3           0.673831   \n",
       "6   0.000000       0.000000     9.0            10           0.656253   \n",
       "7  -0.070000     -19.999998   105.0             8           0.642582   \n",
       "8   0.000000       0.000000     4.0            14           0.632816   \n",
       "9  -0.140000     -31.111107     1.0             7           0.609379   \n",
       "10  0.000000       0.000000    10.0            14           0.594731   \n",
       "11 -0.440000     -46.808510     2.0            17           0.583989   \n",
       "12  0.000000       0.000000   192.0           192           0.561040   \n",
       "13 -0.260000     -30.232557    12.0           217           0.550053   \n",
       "14 -0.430000     -36.440678     5.0            40           0.530034   \n",
       "15  0.000000       0.000000    44.0           198           0.515386   \n",
       "16  0.000000       0.000000   103.0           163           0.503667   \n",
       "17 -1.020000     -49.756100     5.0           198           0.490972   \n",
       "18 -1.360000     -53.968254     8.0           217           0.470464   \n",
       "19 -0.560000     -30.107530     5.0           512           0.455816   \n",
       "20 -0.580000     -27.358488     2.0           249           0.443853   \n",
       "21 -0.430000     -17.916668     1.0           151           0.441534   \n",
       "22 -0.890000     -29.666670     3.0            88           0.412970   \n",
       "23 -0.840000     -25.074625    19.0           384           0.396674   \n",
       "24  0.000000       0.000000     1.0            29           0.398444   \n",
       "25 -2.900000     -51.785717    27.0           104           0.386237   \n",
       "26 -3.000000     -47.619053     6.0            20           0.379645   \n",
       "27 -1.200000     -24.000000    27.0           311           0.379706   \n",
       "28 -1.960000     -35.571693     4.0            73           0.367804   \n",
       "29 -2.230000     -37.290970    31.0           225           0.365607   \n",
       "30 -4.729999     -52.380947     6.0            71           0.360541   \n",
       "31 -2.050000     -29.496399    15.0           230           0.352912   \n",
       "32 -1.900000     -25.675678     1.0            24           0.357428   \n",
       "33 -2.650000     -32.515335    18.0           170           0.350409   \n",
       "34 -5.349999     -45.922745    13.0           134           0.338447   \n",
       "35 -2.300000     -22.660097    59.0           221           0.333503   \n",
       "36  0.000000       0.000000    12.0            42           0.328620   \n",
       "37 -2.700000     -24.107141    11.0           130           0.323676   \n",
       "38 -3.300000     -26.294823     6.0            52           0.320991   \n",
       "39 -3.270001     -24.186394    18.0           242           0.316901   \n",
       "40 -2.750000     -18.644068     3.0           135           0.311347   \n",
       "41 -4.120000     -26.042984     9.0           103           0.307777   \n",
       "42 -4.200000     -25.609755     2.0            54           0.302680   \n",
       "43 -3.070001     -17.036629    32.0           210           0.298255   \n",
       "44  0.550000       3.678931     7.0             1           0.294441   \n",
       "45 -5.420000     -25.908222    11.0            59           0.265602   \n",
       "46 -5.770001     -25.452143     9.0             1           0.289619   \n",
       "47  0.000000       0.000000    18.0            55           0.302436   \n",
       "48  0.000000       0.000000     NaN             1           0.279426   \n",
       "49  0.000000       0.000000     NaN             3           0.268440   \n",
       "50  0.000000       0.000000     NaN             2           0.281990   \n",
       "51  0.000000       0.000000     2.0             2           0.270149   \n",
       "52  0.000000       0.000000     NaN             2           0.284309   \n",
       "53  0.000000       0.000000     1.0             1           0.359992   \n",
       "54  0.000000       0.000000     1.0             1           0.369086   \n",
       "\n",
       "    inTheMoney contractSize currency  \n",
       "0        False      REGULAR      USD  \n",
       "1        False      REGULAR      USD  \n",
       "2        False      REGULAR      USD  \n",
       "3        False      REGULAR      USD  \n",
       "4        False      REGULAR      USD  \n",
       "5        False      REGULAR      USD  \n",
       "6        False      REGULAR      USD  \n",
       "7        False      REGULAR      USD  \n",
       "8        False      REGULAR      USD  \n",
       "9        False      REGULAR      USD  \n",
       "10       False      REGULAR      USD  \n",
       "11       False      REGULAR      USD  \n",
       "12       False      REGULAR      USD  \n",
       "13       False      REGULAR      USD  \n",
       "14       False      REGULAR      USD  \n",
       "15       False      REGULAR      USD  \n",
       "16       False      REGULAR      USD  \n",
       "17       False      REGULAR      USD  \n",
       "18       False      REGULAR      USD  \n",
       "19       False      REGULAR      USD  \n",
       "20       False      REGULAR      USD  \n",
       "21       False      REGULAR      USD  \n",
       "22       False      REGULAR      USD  \n",
       "23       False      REGULAR      USD  \n",
       "24       False      REGULAR      USD  \n",
       "25       False      REGULAR      USD  \n",
       "26       False      REGULAR      USD  \n",
       "27       False      REGULAR      USD  \n",
       "28       False      REGULAR      USD  \n",
       "29       False      REGULAR      USD  \n",
       "30       False      REGULAR      USD  \n",
       "31       False      REGULAR      USD  \n",
       "32       False      REGULAR      USD  \n",
       "33       False      REGULAR      USD  \n",
       "34       False      REGULAR      USD  \n",
       "35       False      REGULAR      USD  \n",
       "36       False      REGULAR      USD  \n",
       "37       False      REGULAR      USD  \n",
       "38       False      REGULAR      USD  \n",
       "39       False      REGULAR      USD  \n",
       "40       False      REGULAR      USD  \n",
       "41       False      REGULAR      USD  \n",
       "42       False      REGULAR      USD  \n",
       "43        True      REGULAR      USD  \n",
       "44        True      REGULAR      USD  \n",
       "45        True      REGULAR      USD  \n",
       "46        True      REGULAR      USD  \n",
       "47        True      REGULAR      USD  \n",
       "48        True      REGULAR      USD  \n",
       "49        True      REGULAR      USD  \n",
       "50        True      REGULAR      USD  \n",
       "51        True      REGULAR      USD  \n",
       "52        True      REGULAR      USD  \n",
       "53        True      REGULAR      USD  \n",
       "54        True      REGULAR      USD  "
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "opt.puts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Options(calls=         contractSymbol       lastTradeDate  strike  lastPrice     bid  \\\n",
       "0   AAPL200724C00170000 2020-06-12 13:38:07   170.0     175.11  178.50   \n",
       "1   AAPL200724C00230000 2020-06-09 19:19:41   230.0     115.11  118.35   \n",
       "2   AAPL200724C00250000 2020-06-15 15:35:19   250.0      88.60   99.40   \n",
       "3   AAPL200724C00255000 2020-06-12 13:50:07   255.0      92.60   93.60   \n",
       "4   AAPL200724C00260000 2020-06-16 13:46:57   260.0      93.00   88.80   \n",
       "5   AAPL200724C00265000 2020-06-16 14:49:37   265.0      85.98   83.20   \n",
       "6   AAPL200724C00270000 2020-06-10 14:26:57   270.0      80.50   79.70   \n",
       "7   AAPL200724C00275000 2020-06-12 14:44:44   275.0      67.92   74.30   \n",
       "8   AAPL200724C00280000 2020-06-12 17:59:03   280.0      59.02   69.60   \n",
       "9   AAPL200724C00285000 2020-06-10 18:32:31   285.0      70.35   64.60   \n",
       "10  AAPL200724C00290000 2020-06-15 16:22:57   290.0      52.80   59.85   \n",
       "11  AAPL200724C00295000 2020-06-10 19:12:42   295.0      59.85   55.30   \n",
       "12  AAPL200724C00300000 2020-06-12 17:46:57   300.0      41.50   51.25   \n",
       "13  AAPL200724C00302500 2020-06-11 15:14:49   302.5      48.30   49.10   \n",
       "14  AAPL200724C00305000 2020-06-16 13:56:31   305.0      49.10   46.75   \n",
       "15  AAPL200724C00307500 2020-06-15 13:54:30   307.5      34.47   45.60   \n",
       "16  AAPL200724C00310000 2020-06-16 14:51:57   310.0      42.50   42.40   \n",
       "17  AAPL200724C00312500 2020-06-15 16:24:56   312.5      33.75   40.10   \n",
       "18  AAPL200724C00315000 2020-06-15 14:30:16   315.0      29.05   37.20   \n",
       "19  AAPL200724C00317500 2020-06-10 19:56:01   317.5      39.27   36.00   \n",
       "20  AAPL200724C00320000 2020-06-16 14:13:55   320.0      36.42   33.95   \n",
       "21  AAPL200724C00322500 2020-06-16 13:35:26   322.5      33.15   32.20   \n",
       "22  AAPL200724C00325000 2020-06-15 18:48:28   325.0      27.38   30.25   \n",
       "23  AAPL200724C00327500 2020-06-16 14:44:27   327.5      29.40   28.35   \n",
       "24  AAPL200724C00330000 2020-06-16 14:44:27   330.0      27.44   25.70   \n",
       "25  AAPL200724C00332500 2020-06-16 14:44:27   332.5      25.25   24.25   \n",
       "26  AAPL200724C00335000 2020-06-16 14:53:06   335.0      22.48   22.65   \n",
       "27  AAPL200724C00337500 2020-06-16 14:43:40   337.5      22.05   21.80   \n",
       "28  AAPL200724C00340000 2020-06-16 14:55:08   340.0      19.00   19.55   \n",
       "29  AAPL200724C00342500 2020-06-16 14:21:25   342.5      19.30   18.50   \n",
       "30  AAPL200724C00345000 2020-06-16 14:54:50   345.0      15.90   17.10   \n",
       "31  AAPL200724C00347500 2020-06-16 14:40:46   347.5      16.15   15.55   \n",
       "32  AAPL200724C00350000 2020-06-16 14:52:50   350.0      13.50   14.30   \n",
       "33  AAPL200724C00352500 2020-06-16 14:52:37   352.5      12.40   13.00   \n",
       "34  AAPL200724C00355000 2020-06-16 14:46:06   355.0      11.35   11.55   \n",
       "35  AAPL200724C00357500 2020-06-16 14:52:57   357.5       9.75   10.60   \n",
       "36  AAPL200724C00360000 2020-06-16 14:53:24   360.0       8.85    9.35   \n",
       "37  AAPL200724C00362500 2020-06-16 14:53:13   362.5       8.05    8.50   \n",
       "38  AAPL200724C00365000 2020-06-16 14:52:06   365.0       7.40    7.55   \n",
       "39  AAPL200724C00367500 2020-06-16 14:45:06   367.5       6.69    6.75   \n",
       "40  AAPL200724C00370000 2020-06-16 14:39:05   370.0       6.47    5.95   \n",
       "41  AAPL200724C00372500 2020-06-16 13:57:32   372.5       6.00    5.15   \n",
       "42  AAPL200724C00375000 2020-06-16 14:45:48   375.0       4.45    4.60   \n",
       "43  AAPL200724C00380000 2020-06-16 14:41:32   380.0       3.75    3.45   \n",
       "44  AAPL200724C00385000 2020-06-16 14:51:10   385.0       2.69    2.71   \n",
       "45  AAPL200724C00390000 2020-06-16 14:39:43   390.0       2.38    1.96   \n",
       "46  AAPL200724C00395000 2020-06-16 14:54:59   395.0       1.53    1.54   \n",
       "47  AAPL200724C00400000 2020-06-16 14:49:52   400.0       1.34    1.22   \n",
       "48  AAPL200724C00405000 2020-06-16 14:21:16   405.0       1.21    1.02   \n",
       "49  AAPL200724C00410000 2020-06-16 14:54:00   410.0       0.82    0.83   \n",
       "50  AAPL200724C00415000 2020-06-16 14:39:07   415.0       0.80    0.71   \n",
       "51  AAPL200724C00420000 2020-06-16 14:18:26   420.0       0.71    0.56   \n",
       "52  AAPL200724C00425000 2020-06-16 14:19:08   425.0       0.62    0.54   \n",
       "53  AAPL200724C00435000 2020-06-15 16:28:26   435.0       0.37     NaN   \n",
       "\n",
       "       ask    change  percentChange  volume  openInterest  impliedVolatility  \\\n",
       "0   181.85  0.000000       0.000000     1.0           0.0           1.240971   \n",
       "1   121.55  0.000000       0.000000     NaN           1.0           0.749514   \n",
       "2   102.15  0.000000       0.000000     1.0           3.0           0.692874   \n",
       "3    96.90  0.000000       0.000000     1.0           0.0           0.617680   \n",
       "4    92.00  4.160004       4.682580     1.0           5.0           0.598271   \n",
       "5    86.70  8.750000      11.329794     2.0          54.0           0.530034   \n",
       "6    82.85  0.000000       0.000000     NaN          11.0           0.593144   \n",
       "7    77.30  0.000000       0.000000     2.0           6.0           0.531499   \n",
       "8    72.30  0.000000       0.000000     2.0          18.0           0.508794   \n",
       "9    67.35  0.000000       0.000000     1.0          10.0           0.547856   \n",
       "10   63.00  0.000000       0.000000     2.0         113.0           0.541264   \n",
       "11   57.90  0.000000       0.000000    28.0          35.0           0.501836   \n",
       "12   52.80  0.000000       0.000000     8.0         117.0           0.462896   \n",
       "13   50.80  0.000000       0.000000     NaN           5.0           0.464117   \n",
       "14   48.55  9.570000      24.209461     2.0          23.0           0.455145   \n",
       "15   46.90  0.000000       0.000000     1.0          31.0           0.465765   \n",
       "16   44.05  5.049999      13.484644     1.0          40.0           0.435553   \n",
       "17   42.70  0.000000       0.000000     2.0           7.0           0.453069   \n",
       "18   40.05  0.000000       0.000000     3.0           8.0           0.429205   \n",
       "19   38.15  0.000000       0.000000     6.0          28.0           0.427313   \n",
       "20   36.00  5.349998      17.219180     5.0         146.0           0.417303   \n",
       "21   33.60  7.040001      26.962854     1.0          33.0           0.399847   \n",
       "22   31.50  0.000000       0.000000    15.0          96.0           0.390051   \n",
       "23   29.25  8.600000      41.346157     2.0          83.0           0.375617   \n",
       "24   26.60  4.840000      21.415930    18.0         236.0           0.350531   \n",
       "25   24.60  5.250000      26.250000     6.0          60.0           0.341437   \n",
       "26   23.00  3.359999      17.573214    15.0         447.0           0.340918   \n",
       "27   22.10  4.400000      24.929176    25.0         175.0           0.355292   \n",
       "28   19.80  2.700001      16.564423    72.0         530.0           0.335608   \n",
       "29   18.75  4.449999      29.966320    27.0         115.0           0.343268   \n",
       "30   17.35  2.349999      17.343168    64.0         390.0           0.341498   \n",
       "31   15.75  4.000000      32.921810    39.0         161.0           0.333930   \n",
       "32   14.50  2.450000      22.171944   344.0        1053.0           0.332709   \n",
       "33   13.25  3.900000      45.882347   113.0          21.0           0.330024   \n",
       "34   11.75  2.350000      26.111115    83.0         514.0           0.320380   \n",
       "35   10.90  1.000000      11.428572    12.0          33.0           0.323646   \n",
       "36    9.50  1.560000      21.399183   131.0         579.0           0.313056   \n",
       "37    8.70  2.100000      35.294125    15.0          12.0           0.314582   \n",
       "38    7.80  1.350000      22.314047    32.0         172.0           0.312293   \n",
       "39    6.95  1.290000      23.888890     6.0          11.0           0.309669   \n",
       "40    6.15  2.120000      48.735630    54.0         594.0           0.306709   \n",
       "41    5.30  2.090000      53.452680     3.0          17.0           0.300666   \n",
       "42    4.80  0.650000      17.105259    46.0         248.0           0.302436   \n",
       "43    3.65  1.190000      46.484380    19.0         257.0           0.297370   \n",
       "44    2.82  0.630000      30.582531    11.0         263.0           0.296028   \n",
       "45    2.25  0.760000      46.913586    18.0         191.0           0.298774   \n",
       "46    1.78  0.310000      25.409830   146.0         658.0           0.301032   \n",
       "47    1.30  0.290000      27.619057   267.0         921.0           0.297737   \n",
       "48    1.13  0.390000      47.560980    19.0         124.0           0.307380   \n",
       "49    0.93  0.070000       9.333332    20.0         112.0           0.312751   \n",
       "50    0.80  0.300000      60.000004     6.0          17.0           0.320563   \n",
       "51    0.75  0.170000      31.481474     5.0         105.0           0.333503   \n",
       "52    0.63  0.140000      29.166672     1.0          36.0           0.338996   \n",
       "53     NaN  0.000000       0.000000     NaN           NaN           0.000000   \n",
       "\n",
       "    inTheMoney contractSize currency  \n",
       "0         True      REGULAR      USD  \n",
       "1         True      REGULAR      USD  \n",
       "2         True      REGULAR      USD  \n",
       "3         True      REGULAR      USD  \n",
       "4         True      REGULAR      USD  \n",
       "5         True      REGULAR      USD  \n",
       "6         True      REGULAR      USD  \n",
       "7         True      REGULAR      USD  \n",
       "8         True      REGULAR      USD  \n",
       "9         True      REGULAR      USD  \n",
       "10        True      REGULAR      USD  \n",
       "11        True      REGULAR      USD  \n",
       "12        True      REGULAR      USD  \n",
       "13        True      REGULAR      USD  \n",
       "14        True      REGULAR      USD  \n",
       "15        True      REGULAR      USD  \n",
       "16        True      REGULAR      USD  \n",
       "17        True      REGULAR      USD  \n",
       "18        True      REGULAR      USD  \n",
       "19        True      REGULAR      USD  \n",
       "20        True      REGULAR      USD  \n",
       "21        True      REGULAR      USD  \n",
       "22        True      REGULAR      USD  \n",
       "23        True      REGULAR      USD  \n",
       "24        True      REGULAR      USD  \n",
       "25        True      REGULAR      USD  \n",
       "26        True      REGULAR      USD  \n",
       "27        True      REGULAR      USD  \n",
       "28        True      REGULAR      USD  \n",
       "29        True      REGULAR      USD  \n",
       "30        True      REGULAR      USD  \n",
       "31        True      REGULAR      USD  \n",
       "32       False      REGULAR      USD  \n",
       "33       False      REGULAR      USD  \n",
       "34       False      REGULAR      USD  \n",
       "35       False      REGULAR      USD  \n",
       "36       False      REGULAR      USD  \n",
       "37       False      REGULAR      USD  \n",
       "38       False      REGULAR      USD  \n",
       "39       False      REGULAR      USD  \n",
       "40       False      REGULAR      USD  \n",
       "41       False      REGULAR      USD  \n",
       "42       False      REGULAR      USD  \n",
       "43       False      REGULAR      USD  \n",
       "44       False      REGULAR      USD  \n",
       "45       False      REGULAR      USD  \n",
       "46       False      REGULAR      USD  \n",
       "47       False      REGULAR      USD  \n",
       "48       False      REGULAR      USD  \n",
       "49       False      REGULAR      USD  \n",
       "50       False      REGULAR      USD  \n",
       "51       False      REGULAR      USD  \n",
       "52       False      REGULAR      USD  \n",
       "53       False      REGULAR      USD  , puts=         contractSymbol       lastTradeDate  strike  lastPrice    bid    ask  \\\n",
       "0   AAPL200724P00180000 2020-06-15 14:17:59   180.0       0.20   0.00   0.18   \n",
       "1   AAPL200724P00190000 2020-06-15 16:28:26   190.0       0.18   0.00   0.22   \n",
       "2   AAPL200724P00195000 2020-06-15 04:13:08   195.0       0.39   0.00   0.24   \n",
       "3   AAPL200724P00200000 2020-06-15 14:51:12   200.0       0.40   0.03   0.27   \n",
       "4   AAPL200724P00205000 2020-06-12 17:35:31   205.0       0.55   0.06   0.31   \n",
       "5   AAPL200724P00210000 2020-06-15 18:07:35   210.0       0.33   0.09   0.34   \n",
       "6   AAPL200724P00215000 2020-06-12 14:35:13   215.0       0.32   0.13   0.36   \n",
       "7   AAPL200724P00220000 2020-06-16 14:19:25   220.0       0.28   0.15   0.43   \n",
       "8   AAPL200724P00225000 2020-06-15 17:48:53   225.0       0.50   0.29   0.42   \n",
       "9   AAPL200724P00230000 2020-06-16 13:41:27   230.0       0.31   0.27   0.48   \n",
       "10  AAPL200724P00235000 2020-06-15 19:02:49   235.0       0.55   0.33   0.54   \n",
       "11  AAPL200724P00240000 2020-06-16 14:45:43   240.0       0.50   0.39   0.66   \n",
       "12  AAPL200724P00245000 2020-06-15 16:19:52   245.0       0.95   0.51   0.60   \n",
       "13  AAPL200724P00250000 2020-06-16 14:21:24   250.0       0.60   0.62   0.71   \n",
       "14  AAPL200724P00255000 2020-06-16 13:34:33   255.0       0.75   0.68   0.77   \n",
       "15  AAPL200724P00260000 2020-06-15 18:50:59   260.0       1.02   0.80   0.87   \n",
       "16  AAPL200724P00265000 2020-06-15 16:46:00   265.0       1.56   0.94   1.04   \n",
       "17  AAPL200724P00270000 2020-06-16 13:54:33   270.0       1.03   1.07   1.16   \n",
       "18  AAPL200724P00275000 2020-06-16 14:28:54   275.0       1.16   1.20   1.26   \n",
       "19  AAPL200724P00280000 2020-06-16 14:24:07   280.0       1.30   1.36   1.45   \n",
       "20  AAPL200724P00285000 2020-06-16 14:40:41   285.0       1.54   1.63   1.71   \n",
       "21  AAPL200724P00290000 2020-06-16 14:53:03   290.0       1.97   1.75   2.19   \n",
       "22  AAPL200724P00295000 2020-06-16 14:38:46   295.0       2.11   2.14   2.24   \n",
       "23  AAPL200724P00300000 2020-06-16 14:42:06   300.0       2.51   2.44   2.55   \n",
       "24  AAPL200724P00302500 2020-06-15 18:08:06   302.5       3.75   2.84   2.95   \n",
       "25  AAPL200724P00305000 2020-06-16 14:18:05   305.0       2.70   2.91   3.05   \n",
       "26  AAPL200724P00307500 2020-06-16 14:47:04   307.5       3.30   3.15   3.30   \n",
       "27  AAPL200724P00310000 2020-06-16 14:53:22   310.0       3.80   3.60   3.75   \n",
       "28  AAPL200724P00312500 2020-06-16 14:23:20   312.5       3.55   3.75   3.90   \n",
       "29  AAPL200724P00315000 2020-06-16 14:37:47   315.0       3.75   4.20   4.35   \n",
       "30  AAPL200724P00317500 2020-06-16 14:02:47   317.5       4.30   4.60   4.75   \n",
       "31  AAPL200724P00320000 2020-06-16 14:41:41   320.0       4.90   4.90   5.10   \n",
       "32  AAPL200724P00322500 2020-06-16 14:44:40   322.5       5.50   5.70   5.90   \n",
       "33  AAPL200724P00325000 2020-06-16 14:25:42   325.0       5.50   6.15   6.35   \n",
       "34  AAPL200724P00327500 2020-06-16 13:52:39   327.5       6.30   6.45   6.65   \n",
       "35  AAPL200724P00330000 2020-06-16 14:53:49   330.0       7.85   7.05   7.25   \n",
       "36  AAPL200724P00332500 2020-06-15 18:40:54   332.5      10.01   7.70   7.90   \n",
       "37  AAPL200724P00335000 2020-06-16 14:42:10   335.0       8.50   8.40   8.60   \n",
       "38  AAPL200724P00337500 2020-06-16 14:38:16   337.5       9.25   9.20   9.45   \n",
       "39  AAPL200724P00340000 2020-06-16 14:47:25   340.0      10.25  10.10  10.30   \n",
       "40  AAPL200724P00342500 2020-06-16 14:55:09   342.5      12.00  10.95  11.15   \n",
       "41  AAPL200724P00345000 2020-06-16 14:38:05   345.0      11.70  11.95  12.15   \n",
       "42  AAPL200724P00347500 2020-06-16 14:34:02   347.5      12.20  12.90  13.15   \n",
       "43  AAPL200724P00350000 2020-06-16 14:52:08   350.0      14.95  14.05  14.25   \n",
       "44  AAPL200724P00352500 2020-06-16 14:48:20   352.5      15.50  15.20  15.45   \n",
       "45  AAPL200724P00355000 2020-06-16 14:37:49   355.0      15.50  15.45  15.60   \n",
       "46  AAPL200724P00357500 2020-06-16 14:34:02   357.5      16.90  17.95  18.20   \n",
       "47  AAPL200724P00360000 2020-06-12 15:22:06   360.0      28.90  20.15  20.35   \n",
       "48  AAPL200724P00365000 2020-06-10 17:44:00   365.0      21.07  22.15  22.75   \n",
       "49  AAPL200724P00370000 2020-06-11 19:36:28   370.0      36.90  25.55  26.00   \n",
       "50  AAPL200724P00385000 2020-06-10 19:09:30   385.0      35.00  36.15  38.75   \n",
       "51  AAPL200724P00390000 2020-06-15 15:23:22   390.0      54.20  40.15  42.90   \n",
       "52  AAPL200724P00395000 2020-06-10 15:30:40   395.0      44.82  45.90  47.75   \n",
       "53  AAPL200724P00400000 2020-06-15 14:23:33   400.0      64.70  50.50  53.95   \n",
       "54  AAPL200724P00405000 2020-06-12 16:34:25   405.0      66.19  55.30  58.65   \n",
       "\n",
       "      change  percentChange  volume  openInterest  impliedVolatility  \\\n",
       "0   0.000000       0.000000    42.0            22           0.775393   \n",
       "1   0.000000       0.000000    10.0            20           0.732425   \n",
       "2   0.000000       0.000000     NaN             1           0.710940   \n",
       "3   0.000000       0.000000    13.0            14           0.700198   \n",
       "4   0.000000       0.000000     NaN             1           0.689456   \n",
       "5   0.000000       0.000000     1.0             3           0.673831   \n",
       "6   0.000000       0.000000     9.0            10           0.656253   \n",
       "7  -0.070000     -19.999998   105.0             8           0.642582   \n",
       "8   0.000000       0.000000     4.0            14           0.632816   \n",
       "9  -0.140000     -31.111107     1.0             7           0.609379   \n",
       "10  0.000000       0.000000    10.0            14           0.594731   \n",
       "11 -0.440000     -46.808510     2.0            17           0.583989   \n",
       "12  0.000000       0.000000   192.0           192           0.561040   \n",
       "13 -0.260000     -30.232557    12.0           217           0.550053   \n",
       "14 -0.430000     -36.440678     5.0            40           0.530034   \n",
       "15  0.000000       0.000000    44.0           198           0.515386   \n",
       "16  0.000000       0.000000   103.0           163           0.503667   \n",
       "17 -1.020000     -49.756100     5.0           198           0.490972   \n",
       "18 -1.360000     -53.968254     8.0           217           0.470464   \n",
       "19 -0.560000     -30.107530     5.0           512           0.455816   \n",
       "20 -0.580000     -27.358488     2.0           249           0.443853   \n",
       "21 -0.430000     -17.916668     1.0           151           0.441534   \n",
       "22 -0.890000     -29.666670     3.0            88           0.412970   \n",
       "23 -0.840000     -25.074625    19.0           384           0.396674   \n",
       "24  0.000000       0.000000     1.0            29           0.398444   \n",
       "25 -2.900000     -51.785717    27.0           104           0.386237   \n",
       "26 -3.000000     -47.619053     6.0            20           0.379645   \n",
       "27 -1.200000     -24.000000    27.0           311           0.379706   \n",
       "28 -1.960000     -35.571693     4.0            73           0.367804   \n",
       "29 -2.230000     -37.290970    31.0           225           0.365607   \n",
       "30 -4.729999     -52.380947     6.0            71           0.360541   \n",
       "31 -2.050000     -29.496399    15.0           230           0.352912   \n",
       "32 -1.900000     -25.675678     1.0            24           0.357428   \n",
       "33 -2.650000     -32.515335    18.0           170           0.350409   \n",
       "34 -5.349999     -45.922745    13.0           134           0.338447   \n",
       "35 -2.300000     -22.660097    59.0           221           0.333503   \n",
       "36  0.000000       0.000000    12.0            42           0.328620   \n",
       "37 -2.700000     -24.107141    11.0           130           0.323676   \n",
       "38 -3.300000     -26.294823     6.0            52           0.320991   \n",
       "39 -3.270001     -24.186394    18.0           242           0.316901   \n",
       "40 -2.750000     -18.644068     3.0           135           0.311347   \n",
       "41 -4.120000     -26.042984     9.0           103           0.307777   \n",
       "42 -4.200000     -25.609755     2.0            54           0.302680   \n",
       "43 -3.070001     -17.036629    32.0           210           0.298255   \n",
       "44  0.550000       3.678931     7.0             1           0.294441   \n",
       "45 -5.420000     -25.908222    11.0            59           0.265602   \n",
       "46 -5.770001     -25.452143     9.0             1           0.289619   \n",
       "47  0.000000       0.000000    18.0            55           0.302436   \n",
       "48  0.000000       0.000000     NaN             1           0.279426   \n",
       "49  0.000000       0.000000     NaN             3           0.268440   \n",
       "50  0.000000       0.000000     NaN             2           0.281990   \n",
       "51  0.000000       0.000000     2.0             2           0.270149   \n",
       "52  0.000000       0.000000     NaN             2           0.284309   \n",
       "53  0.000000       0.000000     1.0             1           0.359992   \n",
       "54  0.000000       0.000000     1.0             1           0.369086   \n",
       "\n",
       "    inTheMoney contractSize currency  \n",
       "0        False      REGULAR      USD  \n",
       "1        False      REGULAR      USD  \n",
       "2        False      REGULAR      USD  \n",
       "3        False      REGULAR      USD  \n",
       "4        False      REGULAR      USD  \n",
       "5        False      REGULAR      USD  \n",
       "6        False      REGULAR      USD  \n",
       "7        False      REGULAR      USD  \n",
       "8        False      REGULAR      USD  \n",
       "9        False      REGULAR      USD  \n",
       "10       False      REGULAR      USD  \n",
       "11       False      REGULAR      USD  \n",
       "12       False      REGULAR      USD  \n",
       "13       False      REGULAR      USD  \n",
       "14       False      REGULAR      USD  \n",
       "15       False      REGULAR      USD  \n",
       "16       False      REGULAR      USD  \n",
       "17       False      REGULAR      USD  \n",
       "18       False      REGULAR      USD  \n",
       "19       False      REGULAR      USD  \n",
       "20       False      REGULAR      USD  \n",
       "21       False      REGULAR      USD  \n",
       "22       False      REGULAR      USD  \n",
       "23       False      REGULAR      USD  \n",
       "24       False      REGULAR      USD  \n",
       "25       False      REGULAR      USD  \n",
       "26       False      REGULAR      USD  \n",
       "27       False      REGULAR      USD  \n",
       "28       False      REGULAR      USD  \n",
       "29       False      REGULAR      USD  \n",
       "30       False      REGULAR      USD  \n",
       "31       False      REGULAR      USD  \n",
       "32       False      REGULAR      USD  \n",
       "33       False      REGULAR      USD  \n",
       "34       False      REGULAR      USD  \n",
       "35       False      REGULAR      USD  \n",
       "36       False      REGULAR      USD  \n",
       "37       False      REGULAR      USD  \n",
       "38       False      REGULAR      USD  \n",
       "39       False      REGULAR      USD  \n",
       "40       False      REGULAR      USD  \n",
       "41       False      REGULAR      USD  \n",
       "42       False      REGULAR      USD  \n",
       "43        True      REGULAR      USD  \n",
       "44        True      REGULAR      USD  \n",
       "45        True      REGULAR      USD  \n",
       "46        True      REGULAR      USD  \n",
       "47        True      REGULAR      USD  \n",
       "48        True      REGULAR      USD  \n",
       "49        True      REGULAR      USD  \n",
       "50        True      REGULAR      USD  \n",
       "51        True      REGULAR      USD  \n",
       "52        True      REGULAR      USD  \n",
       "53        True      REGULAR      USD  \n",
       "54        True      REGULAR      USD  )"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "opt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#### OTHER METHODS NOT USED IN ARTICLE ####"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Dividends</th>\n",
       "      <th>Stock Splits</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1987-05-11</th>\n",
       "      <td>0.00214</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987-06-16</th>\n",
       "      <td>0.00000</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987-08-10</th>\n",
       "      <td>0.00214</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987-11-17</th>\n",
       "      <td>0.00286</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1988-02-12</th>\n",
       "      <td>0.00286</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-10</th>\n",
       "      <td>0.77000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-08-09</th>\n",
       "      <td>0.77000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-07</th>\n",
       "      <td>0.77000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-02-07</th>\n",
       "      <td>0.77000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-08</th>\n",
       "      <td>0.82000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>71 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Dividends  Stock Splits\n",
       "Date                               \n",
       "1987-05-11    0.00214           0.0\n",
       "1987-06-16    0.00000           2.0\n",
       "1987-08-10    0.00214           0.0\n",
       "1987-11-17    0.00286           0.0\n",
       "1988-02-12    0.00286           0.0\n",
       "...               ...           ...\n",
       "2019-05-10    0.77000           0.0\n",
       "2019-08-09    0.77000           0.0\n",
       "2019-11-07    0.77000           0.0\n",
       "2020-02-07    0.77000           0.0\n",
       "2020-05-08    0.82000           0.0\n",
       "\n",
       "[71 rows x 2 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show actions (dividends, splits)\n",
    "aapl.actions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "1987-06-16    2.0\n",
       "2000-06-21    2.0\n",
       "2005-02-28    2.0\n",
       "2014-06-09    7.0\n",
       "Name: Stock Splits, dtype: float64"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show splits\n",
    "aapl.splits"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Open, High, Low, Close, Adj Close, Volume]\n",
       "Index: []"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show financials BROKEN\n",
    "aapl.financials"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Open, High, Low, Close, Adj Close, Volume]\n",
       "Index: []"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show quarterly_financials BROKEN\n",
    "aapl.quarterly_financials\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.07%</td>\n",
       "      <td>% of Shares Held by All Insider</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>62.12%</td>\n",
       "      <td>% of Shares Held by Institutions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>62.16%</td>\n",
       "      <td>% of Float Held by Institutions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4296</td>\n",
       "      <td>Number of Institutions Holding Shares</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        0                                      1\n",
       "0   0.07%        % of Shares Held by All Insider\n",
       "1  62.12%       % of Shares Held by Institutions\n",
       "2  62.16%        % of Float Held by Institutions\n",
       "3    4296  Number of Institutions Holding Shares"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show major holders \n",
    "aapl.major_holders"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Holder</th>\n",
       "      <th>Shares</th>\n",
       "      <th>Date Reported</th>\n",
       "      <th>% Out</th>\n",
       "      <th>Value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Vanguard Group, Inc. (The)</td>\n",
       "      <td>336728608</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>0.0777</td>\n",
       "      <td>85626717728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Blackrock Inc.</td>\n",
       "      <td>274684501</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>0.0634</td>\n",
       "      <td>69849521759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Berkshire Hathaway, Inc</td>\n",
       "      <td>245155566</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>0.0566</td>\n",
       "      <td>62340608878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>State Street Corporation</td>\n",
       "      <td>180558954</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>0.0417</td>\n",
       "      <td>45914336412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Advisor Group, Inc.</td>\n",
       "      <td>116768396</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>0.0269</td>\n",
       "      <td>29693035418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>FMR, LLC</td>\n",
       "      <td>93376233</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>0.0215</td>\n",
       "      <td>23744642289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Geode Capital Management, LLC</td>\n",
       "      <td>64178586</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>0.0148</td>\n",
       "      <td>16319972633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Price (T.Rowe) Associates Inc</td>\n",
       "      <td>56203762</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>0.0130</td>\n",
       "      <td>14292054638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Northern Trust Corporation</td>\n",
       "      <td>53859611</td>\n",
       "      <td>2020-03-30</td>\n",
       "      <td>0.0124</td>\n",
       "      <td>13695960481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Norges Bank Investment Management</td>\n",
       "      <td>46856273</td>\n",
       "      <td>2019-12-30</td>\n",
       "      <td>0.0108</td>\n",
       "      <td>13759344566</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Holder     Shares Date Reported   % Out  \\\n",
       "0         Vanguard Group, Inc. (The)  336728608    2020-03-30  0.0777   \n",
       "1                     Blackrock Inc.  274684501    2020-03-30  0.0634   \n",
       "2            Berkshire Hathaway, Inc  245155566    2020-03-30  0.0566   \n",
       "3           State Street Corporation  180558954    2020-03-30  0.0417   \n",
       "4                Advisor Group, Inc.  116768396    2020-03-30  0.0269   \n",
       "5                           FMR, LLC   93376233    2020-03-30  0.0215   \n",
       "6      Geode Capital Management, LLC   64178586    2020-03-30  0.0148   \n",
       "7      Price (T.Rowe) Associates Inc   56203762    2020-03-30  0.0130   \n",
       "8         Northern Trust Corporation   53859611    2020-03-30  0.0124   \n",
       "9  Norges Bank Investment Management   46856273    2019-12-30  0.0108   \n",
       "\n",
       "         Value  \n",
       "0  85626717728  \n",
       "1  69849521759  \n",
       "2  62340608878  \n",
       "3  45914336412  \n",
       "4  29693035418  \n",
       "5  23744642289  \n",
       "6  16319972633  \n",
       "7  14292054638  \n",
       "8  13695960481  \n",
       "9  13759344566  "
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show institutional holders\n",
    "aapl.institutional_holders"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Open, High, Low, Close, Adj Close, Volume]\n",
       "Index: []"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show balance sheet BROKEN\n",
    "aapl.balance_sheet"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Open, High, Low, Close, Adj Close, Volume]\n",
       "Index: []"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# BROKEN\n",
    "aapl.quarterly_balance_sheet"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Open, High, Low, Close, Adj Close, Volume]\n",
       "Index: []"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show cashflow BROKEN\n",
    "aapl.cashflow"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Open, High, Low, Close, Adj Close, Volume]\n",
       "Index: []"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# BROKEN\n",
    "aapl.quarterly_cashflow\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Open, High, Low, Close, Adj Close, Volume]\n",
       "Index: []"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show earnings BROKEN\n",
    "aapl.earnings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Open, High, Low, Close, Adj Close, Volume]\n",
       "Index: []"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# BROKEN\n",
    "aapl.quarterly_earnings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Value</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-3</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>palmOil</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>controversialWeapons</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gambling</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>socialScore</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nuclear</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>furLeather</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>alcoholic</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gmo</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>catholic</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>socialPercentile</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>peerCount</th>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>governanceScore</th>\n",
       "      <td>10.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>environmentPercentile</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>animalTesting</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tobacco</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>totalEsg</th>\n",
       "      <td>23.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>highestControversy</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>esgPerformance</th>\n",
       "      <td>AVG_PERF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>coal</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pesticides</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>adult</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>percentile</th>\n",
       "      <td>32.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>peerGroup</th>\n",
       "      <td>Technology Hardware</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>smallArms</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>environmentScore</th>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>governancePercentile</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>militaryContract</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Value\n",
       "2020-3                                    \n",
       "palmOil                              False\n",
       "controversialWeapons                 False\n",
       "gambling                             False\n",
       "socialScore                             13\n",
       "nuclear                              False\n",
       "furLeather                           False\n",
       "alcoholic                            False\n",
       "gmo                                  False\n",
       "catholic                             False\n",
       "socialPercentile                         0\n",
       "peerCount                               57\n",
       "governanceScore                      10.26\n",
       "environmentPercentile                    0\n",
       "animalTesting                        False\n",
       "tobacco                              False\n",
       "totalEsg                             23.82\n",
       "highestControversy                       3\n",
       "esgPerformance                    AVG_PERF\n",
       "coal                                 False\n",
       "pesticides                           False\n",
       "adult                                False\n",
       "percentile                           32.44\n",
       "peerGroup              Technology Hardware\n",
       "smallArms                            False\n",
       "environmentScore                      0.55\n",
       "governancePercentile                     0\n",
       "militaryContract                     False"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show sustainability BROKEN\n",
    "aapl.sustainability"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Firm</th>\n",
       "      <th>To Grade</th>\n",
       "      <th>From Grade</th>\n",
       "      <th>Action</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2012-02-09 08:17:00</th>\n",
       "      <td>Canaccord Genuity</td>\n",
       "      <td>Buy</td>\n",
       "      <td></td>\n",
       "      <td>main</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-03-08 07:33:00</th>\n",
       "      <td>FBN Securities</td>\n",
       "      <td>Outperform</td>\n",
       "      <td></td>\n",
       "      <td>main</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-03-13 06:08:00</th>\n",
       "      <td>Jefferies</td>\n",
       "      <td>Buy</td>\n",
       "      <td></td>\n",
       "      <td>main</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-03-14 06:13:00</th>\n",
       "      <td>Morgan Stanley</td>\n",
       "      <td>Overweight</td>\n",
       "      <td></td>\n",
       "      <td>main</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-03-14 08:21:00</th>\n",
       "      <td>Canaccord Genuity</td>\n",
       "      <td>Buy</td>\n",
       "      <td></td>\n",
       "      <td>main</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-05 12:43:04</th>\n",
       "      <td>Wedbush</td>\n",
       "      <td>Outperform</td>\n",
       "      <td></td>\n",
       "      <td>main</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-10 11:19:05</th>\n",
       "      <td>Deutsche Bank</td>\n",
       "      <td>Buy</td>\n",
       "      <td></td>\n",
       "      <td>main</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-11 11:04:46</th>\n",
       "      <td>HSBC</td>\n",
       "      <td>Hold</td>\n",
       "      <td>Reduce</td>\n",
       "      <td>up</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-11 12:07:07</th>\n",
       "      <td>Wells Fargo</td>\n",
       "      <td>Overweight</td>\n",
       "      <td></td>\n",
       "      <td>main</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-11 12:16:06</th>\n",
       "      <td>B of A Securities</td>\n",
       "      <td>Buy</td>\n",
       "      <td></td>\n",
       "      <td>main</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>705 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Firm    To Grade From Grade Action\n",
       "Date                                                                \n",
       "2012-02-09 08:17:00  Canaccord Genuity         Buy              main\n",
       "2012-03-08 07:33:00     FBN Securities  Outperform              main\n",
       "2012-03-13 06:08:00          Jefferies         Buy              main\n",
       "2012-03-14 06:13:00     Morgan Stanley  Overweight              main\n",
       "2012-03-14 08:21:00  Canaccord Genuity         Buy              main\n",
       "...                                ...         ...        ...    ...\n",
       "2020-06-05 12:43:04            Wedbush  Outperform              main\n",
       "2020-06-10 11:19:05      Deutsche Bank         Buy              main\n",
       "2020-06-11 11:04:46               HSBC        Hold     Reduce     up\n",
       "2020-06-11 12:07:07        Wells Fargo  Overweight              main\n",
       "2020-06-11 12:16:06  B of A Securities         Buy              main\n",
       "\n",
       "[705 rows x 4 columns]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show analysts recommendations\n",
    "aapl.recommendations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Earnings Date</th>\n",
       "      <td>2020-07-28 00:00:00</td>\n",
       "      <td>2020-08-03 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Earnings Average</th>\n",
       "      <td>1.99</td>\n",
       "      <td>1.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Earnings Low</th>\n",
       "      <td>1.55</td>\n",
       "      <td>1.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Earnings High</th>\n",
       "      <td>2.3</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Revenue Average</th>\n",
       "      <td>51368400000</td>\n",
       "      <td>51368400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Revenue Low</th>\n",
       "      <td>42799000000</td>\n",
       "      <td>42799000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Revenue High</th>\n",
       "      <td>54517500000</td>\n",
       "      <td>54517500000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    0                    1\n",
       "Earnings Date     2020-07-28 00:00:00  2020-08-03 00:00:00\n",
       "Earnings Average                 1.99                 1.99\n",
       "Earnings Low                     1.55                 1.55\n",
       "Earnings High                     2.3                  2.3\n",
       "Revenue Average           51368400000          51368400000\n",
       "Revenue Low               42799000000          42799000000\n",
       "Revenue High              54517500000          54517500000"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show next event (earnings, etc)\n",
    "aapl.calendar\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'US0378331005'"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show ISIN code - *experimental*\n",
    "# ISIN = International Securities Identification Number\n",
    "aapl.isin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('2020-06-19',\n",
       " '2020-06-26',\n",
       " '2020-07-02',\n",
       " '2020-07-10',\n",
       " '2020-07-17',\n",
       " '2020-07-24',\n",
       " '2020-07-31',\n",
       " '2020-08-21',\n",
       " '2020-09-18',\n",
       " '2020-10-16',\n",
       " '2020-11-20',\n",
       " '2020-12-18',\n",
       " '2021-01-15',\n",
       " '2021-06-18',\n",
       " '2021-09-17',\n",
       " '2022-01-21',\n",
       " '2022-06-17',\n",
       " '2022-09-16')"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show options expirations\n",
    "aapl.options"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Options(calls=         contractSymbol       lastTradeDate  strike  lastPrice     bid  \\\n",
       "0   AAPL200619C00075000 2020-06-15 19:36:28    75.0     266.60  277.60   \n",
       "1   AAPL200619C00080000 2020-06-15 18:00:55    80.0     261.95  272.60   \n",
       "2   AAPL200619C00085000 2020-06-16 13:35:34    85.0     265.35  267.60   \n",
       "3   AAPL200619C00090000 2020-06-04 19:53:39    90.0     231.40  258.65   \n",
       "4   AAPL200619C00095000 2020-05-28 18:32:40    95.0     227.40  255.70   \n",
       "..                  ...                 ...     ...        ...     ...   \n",
       "92  AAPL200619C00460000 2020-06-16 13:30:10   460.0       0.02    0.00   \n",
       "93  AAPL200619C00470000 2020-06-15 19:08:28   470.0       0.01    0.00   \n",
       "94  AAPL200619C00480000 2020-06-15 19:40:30   480.0       0.01    0.00   \n",
       "95  AAPL200619C00490000 2020-06-15 13:58:25   490.0       0.01    0.00   \n",
       "96  AAPL200619C00500000 2020-06-15 19:40:12   500.0       0.01    0.00   \n",
       "\n",
       "       ask    change  percentChange  volume  openInterest  impliedVolatility  \\\n",
       "0   277.90  0.000000       0.000000      25            25           7.574219   \n",
       "1   272.90  0.000000       0.000000      11            62           7.265626   \n",
       "2   267.90  8.399994       3.269116       2            90           6.974611   \n",
       "3   260.45  0.000000       0.000000      45            81           0.000010   \n",
       "4   257.50  0.000000       0.000000      20             2           4.156255   \n",
       "..     ...       ...            ...     ...           ...                ...   \n",
       "92    0.01  0.010000     100.000000       1          1115           0.781252   \n",
       "93    0.01  0.000000       0.000000      73           784           0.843752   \n",
       "94    0.00  0.000000       0.000000    1458          2121           0.500005   \n",
       "95    0.00  0.000000       0.000000     266           690           0.500005   \n",
       "96    0.00  0.000000       0.000000      81          5053           0.500005   \n",
       "\n",
       "    inTheMoney contractSize currency  \n",
       "0         True      REGULAR      USD  \n",
       "1         True      REGULAR      USD  \n",
       "2         True      REGULAR      USD  \n",
       "3         True      REGULAR      USD  \n",
       "4         True      REGULAR      USD  \n",
       "..         ...          ...      ...  \n",
       "92       False      REGULAR      USD  \n",
       "93       False      REGULAR      USD  \n",
       "94       False      REGULAR      USD  \n",
       "95       False      REGULAR      USD  \n",
       "96       False      REGULAR      USD  \n",
       "\n",
       "[97 rows x 14 columns], puts=         contractSymbol       lastTradeDate  strike  lastPrice     bid  \\\n",
       "0   AAPL200619P00075000 2020-06-15 17:54:33    75.0       0.01    0.00   \n",
       "1   AAPL200619P00080000 2020-06-12 17:45:21    80.0       0.01    0.00   \n",
       "2   AAPL200619P00085000 2020-06-08 17:38:58    85.0       0.01    0.00   \n",
       "3   AAPL200619P00090000 2020-06-10 13:44:56    90.0       0.01    0.00   \n",
       "4   AAPL200619P00095000 2020-06-09 22:56:48    95.0       0.01    0.00   \n",
       "..                  ...                 ...     ...        ...     ...   \n",
       "90  AAPL200619P00460000 2020-06-12 17:04:39   460.0     120.60  107.05   \n",
       "91  AAPL200619P00470000 2020-06-12 17:04:38   470.0     130.60  119.90   \n",
       "92  AAPL200619P00480000 2020-06-15 14:27:51   480.0     144.35  129.50   \n",
       "93  AAPL200619P00490000 2020-06-15 18:00:10   490.0     148.65  137.55   \n",
       "94  AAPL200619P00500000 2020-06-16 13:36:31   500.0     149.20  148.60   \n",
       "\n",
       "       ask     change  percentChange  volume  openInterest  impliedVolatility  \\\n",
       "0     0.01   0.000000       0.000000       4          7941           4.250005   \n",
       "1     0.01   0.000000       0.000000       3          2224           4.125005   \n",
       "2     0.01   0.000000       0.000000      19          2554           3.875000   \n",
       "3     0.01   0.000000       0.000000       1          1436           3.750001   \n",
       "4     1.89   0.000000       0.000000       1           665           6.220705   \n",
       "..     ...        ...            ...     ...           ...                ...   \n",
       "90  108.00   0.000000       0.000000       5             4           0.000010   \n",
       "91  121.05   0.000000       0.000000       5             5           1.801515   \n",
       "92  129.85   0.000000       0.000000      10            16           1.717287   \n",
       "93  137.90   0.000000       0.000000       4            24           0.000010   \n",
       "94  148.95 -10.949997      -6.837339       5            17           1.541018   \n",
       "\n",
       "    inTheMoney contractSize currency  \n",
       "0        False      REGULAR      USD  \n",
       "1        False      REGULAR      USD  \n",
       "2        False      REGULAR      USD  \n",
       "3        False      REGULAR      USD  \n",
       "4        False      REGULAR      USD  \n",
       "..         ...          ...      ...  \n",
       "90        True      REGULAR      USD  \n",
       "91        True      REGULAR      USD  \n",
       "92        True      REGULAR      USD  \n",
       "93        True      REGULAR      USD  \n",
       "94        True      REGULAR      USD  \n",
       "\n",
       "[95 rows x 14 columns])"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get option chain for specific expiration\n",
    "opt = aapl.option_chain()\n",
    "opt"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "deeplearning",
   "language": "python",
   "name": "deeplearning"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}