13f x1 feature final.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": false
   },
   "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>date</th>\n",
       "      <th>record_id</th>\n",
       "      <th>iCIK</th>\n",
       "      <th>stock_id</th>\n",
       "      <th>period_end</th>\n",
       "      <th>iAMEND</th>\n",
       "      <th>iRESTATEMENT</th>\n",
       "      <th>iTYPE</th>\n",
       "      <th>iQTY</th>\n",
       "      <th>iMARKET_VALUE</th>\n",
       "      <th>iLONG_FRACTION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2013-01-02 00:00:00+00:00</td>\n",
       "      <td>37942554</td>\n",
       "      <td>732857</td>\n",
       "      <td>G0692U109</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>63005.0</td>\n",
       "      <td>2162.0</td>\n",
       "      <td>0.012254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2013-01-02 00:00:00+00:00</td>\n",
       "      <td>37942555</td>\n",
       "      <td>732857</td>\n",
       "      <td>384313102</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17450.0</td>\n",
       "      <td>158.0</td>\n",
       "      <td>0.000895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2013-01-02 00:00:00+00:00</td>\n",
       "      <td>37942556</td>\n",
       "      <td>732857</td>\n",
       "      <td>032511107</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16709.0</td>\n",
       "      <td>1208.0</td>\n",
       "      <td>0.006847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2013-01-02 00:00:00+00:00</td>\n",
       "      <td>37942557</td>\n",
       "      <td>732857</td>\n",
       "      <td>37946S107</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>47502.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>0.000998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2013-01-02 00:00:00+00:00</td>\n",
       "      <td>37942558</td>\n",
       "      <td>732857</td>\n",
       "      <td>31428X106</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14511.0</td>\n",
       "      <td>1312.0</td>\n",
       "      <td>0.007436</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        date  record_id    iCIK   stock_id  period_end  \\\n",
       "0  2013-01-02 00:00:00+00:00   37942554  732857  G0692U109  2012-12-31   \n",
       "1  2013-01-02 00:00:00+00:00   37942555  732857  384313102  2012-12-31   \n",
       "2  2013-01-02 00:00:00+00:00   37942556  732857  032511107  2012-12-31   \n",
       "3  2013-01-02 00:00:00+00:00   37942557  732857  37946S107  2012-12-31   \n",
       "4  2013-01-02 00:00:00+00:00   37942558  732857  31428X106  2012-12-31   \n",
       "\n",
       "   iAMEND  iRESTATEMENT  iTYPE     iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
       "0       0             0      0  63005.0         2162.0        0.012254  \n",
       "1       0             0      0  17450.0          158.0        0.000895  \n",
       "2       0             0      0  16709.0         1208.0        0.006847  \n",
       "3       0             0      0  47502.0          176.0        0.000998  \n",
       "4       0             0      0  14511.0         1312.0        0.007436  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "#import data\n",
    "df = pd.read_csv(\"13F_filtered.csv\")\n",
    "\n",
    "#preview first 5 lines of data\n",
    "display(df.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['G0692U109' '384313102' '032511107' ... '92347D100' '98741T104'\n",
      " '37954Y392']\n",
      "['2012-12-31' '2012-09-30' '2013-06-30' '2014-12-31' '2014-06-30'\n",
      " '2013-12-31' '2014-03-31' '2013-09-30' '2013-03-31' '2012-06-30'\n",
      " '2012-03-31' '2011-12-31' '2011-09-30' '2011-06-30' '2011-03-31'\n",
      " '2010-12-31' '2010-09-30' '2010-06-30' '2010-03-31' '2009-12-31'\n",
      " '2009-09-30' '2009-06-30' '2009-03-31' '2008-12-31' '2008-09-30'\n",
      " '2008-06-30' '2008-03-31' '2007-12-31' '2007-09-30' '2007-06-30'\n",
      " '2007-03-31' '2006-12-31' '2014-09-30' '2015-03-31' '2015-06-30'\n",
      " '2015-09-30' '2015-12-31' '2016-03-31' '2016-06-30' '2016-09-30'\n",
      " '2016-12-31' '2017-03-31' '2017-06-30' '2017-09-30' '2017-12-31'\n",
      " '2018-03-31' '2018-06-30' '2018-09-30' '2018-12-31' '2019-03-31'\n",
      " '2019-06-30' '2019-09-30' '2019-12-31' '2020-03-31']\n"
     ]
    }
   ],
   "source": [
    "#finds all unique stocks\n",
    "print (df.stock_id.unique())\n",
    "#find all unique dates\n",
    "print (df.period_end.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "0        2013-01-02 00:00:00+00:00   37942554   732857  G0692U109  2012-12-31   \n",
      "1        2013-01-02 00:00:00+00:00   37942555   732857  384313102  2012-12-31   \n",
      "2        2013-01-02 00:00:00+00:00   37942556   732857  032511107  2012-12-31   \n",
      "3        2013-01-02 00:00:00+00:00   37942557   732857  37946S107  2012-12-31   \n",
      "4        2013-01-02 00:00:00+00:00   37942558   732857  31428X106  2012-12-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1750353  2019-05-30 00:00:00+00:00   70776478  1776290  478160104  2012-12-31   \n",
      "1750354  2019-05-30 00:00:00+00:00   70776479  1776290  922908769  2012-12-31   \n",
      "1750355  2019-05-30 00:00:00+00:00   70776480  1776290  922908553  2012-12-31   \n",
      "1750356  2019-05-30 00:00:00+00:00   70776481  1776290  464287499  2012-12-31   \n",
      "1750357  2019-05-30 00:00:00+00:00   70776482  1776290  863667101  2012-12-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "0             0             0      0   63005.0         2162.0        0.012254  \n",
      "1             0             0      0   17450.0          158.0        0.000895  \n",
      "2             0             0      0   16709.0         1208.0        0.006847  \n",
      "3             0             0      0   47502.0          176.0        0.000998  \n",
      "4             0             0      0   14511.0         1312.0        0.007436  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1750353       0             0      0    3572.0       250000.0        0.002388  \n",
      "1750354       0             0      0  244110.0     17889000.0        0.170868  \n",
      "1750355       0             0      0   10899.0       717000.0        0.006848  \n",
      "1750356       0             0      0    3545.0       401000.0        0.003830  \n",
      "1750357       0             0      0   41287.0      2263000.0        0.021615  \n",
      "\n",
      "[43808 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "35388    2013-02-14 00:00:00+00:00   38488642  1393369  87611X105  2012-09-30   \n",
      "35389    2013-02-14 00:00:00+00:00   38488643  1393369  86764L108  2012-09-30   \n",
      "35390    2013-02-14 00:00:00+00:00   38488644  1393369  559080106  2012-09-30   \n",
      "35391    2013-02-14 00:00:00+00:00   38488645  1393369  92343V104  2012-09-30   \n",
      "35392    2013-02-14 00:00:00+00:00   38488646  1393369  96950F104  2012-09-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1750305  2019-05-30 00:00:00+00:00   70776430  1776290  478160104  2012-09-30   \n",
      "1750306  2019-05-30 00:00:00+00:00   70776431  1776290  922908769  2012-09-30   \n",
      "1750307  2019-05-30 00:00:00+00:00   70776432  1776290  922908553  2012-09-30   \n",
      "1750308  2019-05-30 00:00:00+00:00   70776433  1776290  464287499  2012-09-30   \n",
      "1750309  2019-05-30 00:00:00+00:00   70776434  1776290  863667101  2012-09-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "35388         0             0      0  220000.0         9434.0        0.048748  \n",
      "35389         0             0      0  210000.0         9797.0        0.050624  \n",
      "35390         0             0      0   89000.0         7784.0        0.040222  \n",
      "35391         0             0      0   80000.0         3646.0        0.018840  \n",
      "35392         0             0      0   40000.0         2187.0        0.011301  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1750305       0             0      0    3572.0       246000.0        0.002574  \n",
      "1750306       0             0      0  222674.0     16400000.0        0.171570  \n",
      "1750307       0             0      0   10885.0       707000.0        0.007396  \n",
      "1750308       0             0      0    3539.0       392000.0        0.004101  \n",
      "1750309       0             0      0   38208.0      2127000.0        0.022252  \n",
      "\n",
      "[498 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "41199    2013-08-01 00:00:00+00:00   38587073  1349353  002824100  2013-06-30   \n",
      "41200    2013-08-01 00:00:00+00:00   38587074  1349353  025816109  2013-06-30   \n",
      "41201    2013-08-01 00:00:00+00:00   38587075  1349353  026874784  2013-06-30   \n",
      "41202    2013-08-01 00:00:00+00:00   38587076  1349353  060505104  2013-06-30   \n",
      "41203    2013-08-01 00:00:00+00:00   38587077  1349353  064058100  2013-06-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1750451  2019-05-31 00:00:00+00:00   70776770  1776290  478160104  2013-06-30   \n",
      "1750452  2019-05-31 00:00:00+00:00   70776771  1776290  922908769  2013-06-30   \n",
      "1750453  2019-05-31 00:00:00+00:00   70776772  1776290  922908553  2013-06-30   \n",
      "1750454  2019-05-31 00:00:00+00:00   70776773  1776290  464287499  2013-06-30   \n",
      "1750455  2019-05-31 00:00:00+00:00   70776774  1776290  863667101  2013-06-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "41199         0             0      0   96510.0      3366000.0        0.023443  \n",
      "41200         0             0      0   70214.0      5249000.0        0.036557  \n",
      "41201         0             0      0  346115.0     15471000.0        0.107748  \n",
      "41202         0             0      0  882340.0     11347000.0        0.079026  \n",
      "41203         0             0      0  129065.0      3620000.0        0.025212  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1750451       0             0      0    3761.0       323000.0        0.002774  \n",
      "1750452       0             0      0  244542.0     20216000.0        0.173628  \n",
      "1750453       0             0      0   10918.0       750000.0        0.006441  \n",
      "1750454       0             0      0    3548.0       461000.0        0.003959  \n",
      "1750455       0             0      0   35523.0      2298000.0        0.019737  \n",
      "\n",
      "[55987 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "41230    2015-01-30 00:00:00+00:00   50944026  1315269  413086109  2014-12-31   \n",
      "41231    2015-01-30 00:00:00+00:00   50944027  1315269  438516106  2014-12-31   \n",
      "41232    2015-01-30 00:00:00+00:00   50944028  1315269  03076C106  2014-12-31   \n",
      "41233    2015-01-30 00:00:00+00:00   50944029  1315269  732872106  2014-12-31   \n",
      "41234    2015-01-30 00:00:00+00:00   50944030  1315269  922908512  2014-12-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1820377  2019-08-21 00:00:00+00:00   71733690  1546865  713448108  2014-12-31   \n",
      "1820378  2019-08-21 00:00:00+00:00   71733691  1546865  263534109  2014-12-31   \n",
      "1820379  2019-08-21 00:00:00+00:00   71733692  1546865  594918104  2014-12-31   \n",
      "1820380  2019-08-21 00:00:00+00:00   71733693  1546865  464287614  2014-12-31   \n",
      "1820381  2019-08-21 00:00:00+00:00   71733694  1546865  863667101  2014-12-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE     iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "41230         0             0      0  27379.0      2922000.0        0.019555  \n",
      "41231         0             0      0  28103.0      2808000.0        0.018793  \n",
      "41232         0             0      0  24035.0      3179000.0        0.021275  \n",
      "41233         0             0      0  59459.0      3346000.0        0.022393  \n",
      "41234         0             0      0   3200.0       286000.0        0.001914  \n",
      "...         ...           ...    ...      ...            ...             ...  \n",
      "1820377       0             0      0   5835.0       552000.0        0.003241  \n",
      "1820378       0             0      0   3965.0       293000.0        0.001721  \n",
      "1820379       0             0      0  11498.0       534000.0        0.003136  \n",
      "1820380       0             0      0  84823.0      8110000.0        0.047623  \n",
      "1820381       0             0      0  21710.0      2048000.0        0.012026  \n",
      "\n",
      "[66608 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "45486    2014-08-12 00:00:00+00:00   50429203  1568891  45685E106  2014-06-30   \n",
      "45487    2014-08-12 00:00:00+00:00   50429202  1568891  41146A106  2014-06-30   \n",
      "45488    2014-08-12 00:00:00+00:00   50429201  1568891  38259P706  2014-06-30   \n",
      "45489    2014-08-12 00:00:00+00:00   50429200  1568891  497266106  2014-06-30   \n",
      "45490    2014-08-12 00:00:00+00:00   50429199  1568891  90130A101  2014-06-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1820583  2019-08-21 00:00:00+00:00   71733896  1546865  921908844  2014-06-30   \n",
      "1820584  2019-08-21 00:00:00+00:00   71733897  1546865  713448108  2014-06-30   \n",
      "1820585  2019-08-21 00:00:00+00:00   71733898  1546865  594918104  2014-06-30   \n",
      "1820586  2019-08-21 00:00:00+00:00   71733899  1546865  464287614  2014-06-30   \n",
      "1820587  2019-08-21 00:00:00+00:00   71733900  1546865  863667101  2014-06-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "45486         0             0      1  313290.0     11385000.0        0.076929  \n",
      "45487         0             0      1  340750.0      4328000.0        0.029245  \n",
      "45488         0             0      1   13360.0      7686000.0        0.051935  \n",
      "45489         0             0      1    3500.0       410000.0        0.002770  \n",
      "45490         0             0      1  123640.0      4346000.0        0.029366  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1820583       0             0      0    8185.0       638000.0        0.004031  \n",
      "1820584       0             0      0    5540.0       495000.0        0.003128  \n",
      "1820585       0             0      0    9354.0       391000.0        0.002470  \n",
      "1820586       0             0      0   78009.0      7093000.0        0.044815  \n",
      "1820587       0             0      0   21170.0      1785000.0        0.011278  \n",
      "\n",
      "[60640 rows x 11 columns]\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "46479    2014-02-04 00:00:00+00:00   50403100  1141781  863667101  2013-12-31   \n",
      "46480    2014-02-04 00:00:00+00:00   50403099  1141781  780259206  2013-12-31   \n",
      "46481    2014-02-04 00:00:00+00:00   50403098  1141781  149123101  2013-12-31   \n",
      "46482    2014-02-04 00:00:00+00:00   50403097  1141781  594918104  2013-12-31   \n",
      "46483    2014-02-04 00:00:00+00:00   50403096  1141781  263534109  2013-12-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1820946  2019-08-22 00:00:00+00:00   71735398  1546865  931422109  2013-12-31   \n",
      "1820947  2019-08-22 00:00:00+00:00   71735399  1546865  594918104  2013-12-31   \n",
      "1820948  2019-08-22 00:00:00+00:00   71735400  1546865  464287614  2013-12-31   \n",
      "1820949  2019-08-22 00:00:00+00:00   71735401  1546865  896818101  2013-12-31   \n",
      "1820950  2019-08-22 00:00:00+00:00   71735402  1546865  863667101  2013-12-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "46479         0             0      0   69940.0      5255000.0        0.004972  \n",
      "46480         0             0      0   14218.0      1014000.0        0.000959  \n",
      "46481         0             0      0  170730.0     15504000.0        0.014668  \n",
      "46482         0             0      0  229219.0      8575000.0        0.008113  \n",
      "46483         0             0      0    9642.0       626000.0        0.000592  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1820946       0             0      0   35918.0      2063000.0        0.014624  \n",
      "1820947       0             0      0    9259.0       347000.0        0.002460  \n",
      "1820948       0             0      0   68352.0      5875000.0        0.041647  \n",
      "1820949       0             0      0    4780.0       363000.0        0.002573  \n",
      "1820950       0             0      0   20700.0      1556000.0        0.011030  \n",
      "\n",
      "[59763 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "51824    2014-08-08 00:00:00+00:00   50327687  1612389  49427F108  2014-03-31   \n",
      "51825    2014-08-08 00:00:00+00:00   50327686  1612389  92276F100  2014-03-31   \n",
      "51826    2014-08-08 00:00:00+00:00   50327685  1612389  44107P104  2014-03-31   \n",
      "51827    2014-08-08 00:00:00+00:00   50327684  1612389  437306103  2014-03-31   \n",
      "51828    2014-08-08 00:00:00+00:00   50327683  1612389  370023103  2014-03-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1820848  2019-08-22 00:00:00+00:00   71735300  1546865  713448108  2014-03-31   \n",
      "1820849  2019-08-22 00:00:00+00:00   71735301  1546865  931422109  2014-03-31   \n",
      "1820850  2019-08-22 00:00:00+00:00   71735302  1546865  594918104  2014-03-31   \n",
      "1820851  2019-08-22 00:00:00+00:00   71735303  1546865  464287614  2014-03-31   \n",
      "1820852  2019-08-22 00:00:00+00:00   71735304  1546865  863667101  2014-03-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE       iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "51824         0             0      0  1298090.0     82043000.0        0.083198  \n",
      "51825         0             0      0   788271.0     51514000.0        0.052239  \n",
      "51826         0             0      0  3328310.0     72682000.0        0.073705  \n",
      "51827         0             0      0   375105.0     24331000.0        0.024673  \n",
      "51828         0             0      0   981816.0     23305000.0        0.023633  \n",
      "...         ...           ...    ...        ...            ...             ...  \n",
      "1820848       0             0      0     5540.0       462000.0        0.003169  \n",
      "1820849       0             0      0    36058.0      2381000.0        0.016333  \n",
      "1820850       0             0      0     9354.0       384000.0        0.002634  \n",
      "1820851       0             0      0    76467.0      6617000.0        0.045390  \n",
      "1820852       0             0      0    20905.0      1703000.0        0.011682  \n",
      "\n",
      "[59533 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "51869    2014-08-08 00:00:00+00:00   50327642  1612389  437306103  2013-09-30   \n",
      "51870    2014-08-08 00:00:00+00:00   50327641  1612389  313747206  2013-09-30   \n",
      "51871    2014-08-08 00:00:00+00:00   50327640  1612389  44107P104  2013-09-30   \n",
      "51872    2014-08-08 00:00:00+00:00   50327639  1612389  09063H107  2013-09-30   \n",
      "51873    2014-08-08 00:00:00+00:00   50327638  1612389  297178105  2013-09-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1750501  2019-05-31 00:00:00+00:00   70776820  1776290  478160104  2013-09-30   \n",
      "1750502  2019-05-31 00:00:00+00:00   70776821  1776290  922908769  2013-09-30   \n",
      "1750503  2019-05-31 00:00:00+00:00   70776822  1776290  922908553  2013-09-30   \n",
      "1750504  2019-05-31 00:00:00+00:00   70776823  1776290  464287499  2013-09-30   \n",
      "1750505  2019-05-31 00:00:00+00:00   70776824  1776290  863667101  2013-09-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE       iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "51869         0             0      0   633620.0     38505000.0        0.054249  \n",
      "51870         0             0      0   122440.0     13193000.0        0.018587  \n",
      "51871         0             0      0  3558200.0     63300000.0        0.089182  \n",
      "51872         0             0      0   160670.0      3363000.0        0.004738  \n",
      "51873         0             0      0    74677.0     11735000.0        0.016533  \n",
      "...         ...           ...    ...        ...            ...             ...  \n",
      "1750501       0             0      0     3836.0       333000.0        0.002685  \n",
      "1750502       0             0      0   245446.0     21513000.0        0.173464  \n",
      "1750503       0             0      0    11429.0       756000.0        0.006096  \n",
      "1750504       0             0      0     3554.0       494000.0        0.003983  \n",
      "1750505       0             0      0    27532.0      1861000.0        0.015006  \n",
      "\n",
      "[57569 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "51904    2014-08-08 00:00:00+00:00   50327607  1612389  437306103  2013-03-31   \n",
      "51905    2014-08-08 00:00:00+00:00   50327606  1612389  313747206  2013-03-31   \n",
      "51906    2014-08-08 00:00:00+00:00   50327605  1612389  44107P104  2013-03-31   \n",
      "51907    2014-08-08 00:00:00+00:00   50327604  1612389  09063H107  2013-03-31   \n",
      "51908    2014-08-08 00:00:00+00:00   50327603  1612389  297178105  2013-03-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1750402  2019-05-31 00:00:00+00:00   70776721  1776290  478160104  2013-03-31   \n",
      "1750403  2019-05-31 00:00:00+00:00   70776722  1776290  922908769  2013-03-31   \n",
      "1750404  2019-05-31 00:00:00+00:00   70776723  1776290  922908553  2013-03-31   \n",
      "1750405  2019-05-31 00:00:00+00:00   70776724  1776290  464287499  2013-03-31   \n",
      "1750406  2019-05-31 00:00:00+00:00   70776725  1776290  863667101  2013-03-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE       iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "51904         0             0      0   637995.0     40462000.0        0.069595  \n",
      "51905         0             0      0   148806.0     16077000.0        0.027652  \n",
      "51906         0             0      0  2948160.0     51563000.0        0.088689  \n",
      "51907         0             0      0  1397000.0     30175000.0        0.051901  \n",
      "51908         0             0      0    55985.0      8430000.0        0.014500  \n",
      "...         ...           ...    ...        ...            ...             ...  \n",
      "1750402       0             0      0     3572.0       291000.0        0.002577  \n",
      "1750403       0             0      0   244380.0     19785000.0        0.175219  \n",
      "1750404       0             0      0    10908.0       769000.0        0.006810  \n",
      "1750405       0             0      0     3545.0       451000.0        0.003994  \n",
      "1750406       0             0      0    38384.0      2504000.0        0.022176  \n",
      "\n",
      "[41734 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "57953    2014-08-06 00:00:00+00:00   50230403  1612389  437306103  2012-06-30   \n",
      "57954    2014-08-06 00:00:00+00:00   50230402  1612389  313747206  2012-06-30   \n",
      "57955    2014-08-06 00:00:00+00:00   50230401  1612389  44107P104  2012-06-30   \n",
      "57956    2014-08-06 00:00:00+00:00   50230400  1612389  828806109  2012-06-30   \n",
      "57957    2014-08-06 00:00:00+00:00   50230399  1612389  49427F108  2012-06-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1750261  2019-05-30 00:00:00+00:00   70776386  1776290  478160104  2012-06-30   \n",
      "1750262  2019-05-30 00:00:00+00:00   70776387  1776290  922908769  2012-06-30   \n",
      "1750263  2019-05-30 00:00:00+00:00   70776388  1776290  922908553  2012-06-30   \n",
      "1750264  2019-05-30 00:00:00+00:00   70776389  1776290  464287499  2012-06-30   \n",
      "1750265  2019-05-30 00:00:00+00:00   70776390  1776290  863667101  2012-06-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE       iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "57953         0             0      0   365595.0     22433000.0        0.090882  \n",
      "57954         0             0      0    51776.0      5389000.0        0.021832  \n",
      "57955         0             0      0  1273220.0     20142000.0        0.081600  \n",
      "57956         0             0      0   266749.0     39041000.0        0.158164  \n",
      "57957         0             0      0   500516.0     24230000.0        0.098161  \n",
      "...         ...           ...    ...        ...            ...             ...  \n",
      "1750261       0             0      0     3297.0       223000.0        0.002554  \n",
      "1750262       0             0      0   223831.0     15601000.0        0.178704  \n",
      "1750263       0             0      0    10561.0       691000.0        0.007915  \n",
      "1750264       0             0      0     3387.0       357000.0        0.004089  \n",
      "1750265       0             0      0    37512.0      2067000.0        0.023677  \n",
      "\n",
      "[438 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "57970    2014-08-06 00:00:00+00:00   50230386  1612389  23317H102  2012-03-31   \n",
      "57971    2014-08-06 00:00:00+00:00   50230385  1612389  313747206  2012-03-31   \n",
      "57972    2014-08-06 00:00:00+00:00   50230384  1612389  44107P104  2012-03-31   \n",
      "57973    2014-08-06 00:00:00+00:00   50230383  1612389  828806109  2012-03-31   \n",
      "57974    2014-08-06 00:00:00+00:00   50230382  1612389  437306103  2012-03-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1750220  2019-05-30 00:00:00+00:00   70776345  1776290  922042858  2012-03-31   \n",
      "1750221  2019-05-30 00:00:00+00:00   70776346  1776290  464287176  2012-03-31   \n",
      "1750222  2019-05-30 00:00:00+00:00   70776347  1776290  922908769  2012-03-31   \n",
      "1750223  2019-05-30 00:00:00+00:00   70776348  1776290  922908553  2012-03-31   \n",
      "1750224  2019-05-30 00:00:00+00:00   70776349  1776290  464287499  2012-03-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE       iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "57970         0             0      0   182060.0      2658000.0        0.009728  \n",
      "57971         0             0      0    50326.0      4871000.0        0.017828  \n",
      "57972         0             0      0  1914090.0     31429000.0        0.115032  \n",
      "57973         0             0      0   278211.0     38108000.0        0.139477  \n",
      "57974         0             0      0   310045.0     18916000.0        0.069234  \n",
      "...         ...           ...    ...        ...            ...             ...  \n",
      "1750220       0             0      0    23828.0      1036000.0        0.009732  \n",
      "1750221       0             0      0    86173.0     10138000.0        0.095234  \n",
      "1750222       0             0      0   214351.0     15489000.0        0.145499  \n",
      "1750223       0             0      0    10552.0       672000.0        0.006313  \n",
      "1750224       0             0      0     3387.0       375000.0        0.003523  \n",
      "\n",
      "[493 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "57989    2014-08-06 00:00:00+00:00   50230367  1612389  23317H102  2011-12-31   \n",
      "57990    2014-08-06 00:00:00+00:00   50230366  1612389  313747206  2011-12-31   \n",
      "57991    2014-08-06 00:00:00+00:00   50230365  1612389  44107P104  2011-12-31   \n",
      "57992    2014-08-06 00:00:00+00:00   50230364  1612389  828806109  2011-12-31   \n",
      "57993    2014-08-06 00:00:00+00:00   50230363  1612389  437306103  2011-12-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1487499  2018-09-13 00:00:00+00:00   67158092  1731876  478160104  2011-12-31   \n",
      "1487500  2018-09-13 00:00:00+00:00   67158093  1731876  057224107  2011-12-31   \n",
      "1487501  2018-09-13 00:00:00+00:00   67158094  1731876  191216100  2011-12-31   \n",
      "1487502  2018-09-13 00:00:00+00:00   67158095  1731876  057665200  2011-12-31   \n",
      "1487503  2018-09-13 00:00:00+00:00   67158096  1731876  863667101  2011-12-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE       iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "57989         0             0      0   131950.0      1606000.0        0.007869  \n",
      "57990         0             0      0    95267.0      8645000.0        0.042357  \n",
      "57991         0             0      0  1312320.0     19383000.0        0.094969  \n",
      "57992         0             0      0   314674.0     38149000.0        0.186915  \n",
      "57993         0             0      0   327545.0     18857000.0        0.092392  \n",
      "...         ...           ...    ...        ...            ...             ...  \n",
      "1487499       0             0      0    49879.0      3248000.0        0.031420  \n",
      "1487500       0             0      0    28954.0      1408000.0        0.013621  \n",
      "1487501       0             0      0    31022.0      2146000.0        0.020760  \n",
      "1487502       0             0      0     9207.0       373000.0        0.003608  \n",
      "1487503       0             0      0    54306.0      2666000.0        0.025790  \n",
      "\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[388 rows x 11 columns]\n",
      "                             date  record_id     iCIK   stock_id  period_end  \\\n",
      "58006   2014-08-06 00:00:00+00:00   50230350  1612389  23317H102  2011-09-30   \n",
      "58007   2014-08-06 00:00:00+00:00   50230349  1612389  313747206  2011-09-30   \n",
      "58008   2014-08-06 00:00:00+00:00   50230348  1612389  44107P104  2011-09-30   \n",
      "58009   2014-08-06 00:00:00+00:00   50230347  1612389  828806109  2011-09-30   \n",
      "58010   2014-08-06 00:00:00+00:00   50230346  1612389  437306103  2011-09-30   \n",
      "...                           ...        ...      ...        ...         ...   \n",
      "416966  2014-01-10 00:00:00+00:00   46958458  1590073  92206C714  2011-09-30   \n",
      "416967  2014-01-10 00:00:00+00:00   46958457  1590073  464286657  2011-09-30   \n",
      "416968  2014-01-10 00:00:00+00:00   46958456  1590073  464285105  2011-09-30   \n",
      "416969  2014-01-10 00:00:00+00:00   46958455  1590073  81369Y886  2011-09-30   \n",
      "416970  2014-01-10 00:00:00+00:00   46958454  1590073  464287234  2011-09-30   \n",
      "\n",
      "        iAMEND  iRESTATEMENT  iTYPE       iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "58006        0             0      0   131950.0      1438000.0        0.008630  \n",
      "58007        0             0      0    88564.0      7299000.0        0.043803  \n",
      "58008        0             0      0  1202630.0     13157000.0        0.078959  \n",
      "58009        0             0      0   284322.0     29401000.0        0.176444  \n",
      "58010        0             0      0   429656.0     24387000.0        0.146353  \n",
      "...        ...           ...    ...        ...            ...             ...  \n",
      "416966       0             0      0    10253.0       506000.0        0.005254  \n",
      "416967       0             0      0    18770.0       636000.0        0.006604  \n",
      "416968       0             0      0    21527.0       341000.0        0.003541  \n",
      "416969       0             0      0    28208.0       948000.0        0.009843  \n",
      "416970       0             0      0   189250.0      6642000.0        0.068966  \n",
      "\n",
      "[150 rows x 11 columns]\n",
      "                             date  record_id     iCIK   stock_id  period_end  \\\n",
      "58022   2014-08-06 00:00:00+00:00   50230334  1612389  437306103  2011-06-30   \n",
      "58023   2014-08-06 00:00:00+00:00   50230333  1612389  313747206  2011-06-30   \n",
      "58024   2014-08-06 00:00:00+00:00   50230332  1612389  44107P104  2011-06-30   \n",
      "58025   2014-08-06 00:00:00+00:00   50230331  1612389  297178105  2011-06-30   \n",
      "58026   2014-08-06 00:00:00+00:00   50230330  1612389  49427F108  2011-06-30   \n",
      "...                           ...        ...      ...        ...         ...   \n",
      "416062  2014-01-10 00:00:00+00:00   47002613  1590073  92206C714  2011-06-30   \n",
      "416063  2014-01-10 00:00:00+00:00   47002612  1590073  464286657  2011-06-30   \n",
      "416064  2014-01-10 00:00:00+00:00   47002611  1590073  464285105  2011-06-30   \n",
      "416065  2014-01-10 00:00:00+00:00   47002610  1590073  81369Y886  2011-06-30   \n",
      "416066  2014-01-10 00:00:00+00:00   47002609  1590073  464287234  2011-06-30   \n",
      "\n",
      "        iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "58022        0             0      0  396418.0     24134000.0        0.106685  \n",
      "58023        0             0      0  109640.0      9339000.0        0.041283  \n",
      "58024        0             0      0  814828.0     13811000.0        0.061052  \n",
      "58025        0             0      0   48504.0      6562000.0        0.029007  \n",
      "58026        0             0      0  155500.0      6141000.0        0.027146  \n",
      "...        ...           ...    ...       ...            ...             ...  \n",
      "416062       0             0      0   10253.0       607000.0        0.005200  \n",
      "416063       0             0      0   18770.0       897000.0        0.007684  \n",
      "416064       0             0      0   21527.0       315000.0        0.002699  \n",
      "416065       0             0      0   27233.0       912000.0        0.007813  \n",
      "416066       0             0      0  188014.0      8949000.0        0.076665  \n",
      "\n",
      "[144 rows x 11 columns]\n",
      "                             date  record_id     iCIK   stock_id  period_end  \\\n",
      "58038   2014-08-06 00:00:00+00:00   50230318  1612389  44107P104  2011-03-31   \n",
      "58039   2014-08-06 00:00:00+00:00   50230317  1612389  313747206  2011-03-31   \n",
      "58040   2014-08-06 00:00:00+00:00   50230316  1612389  758849103  2011-03-31   \n",
      "58041   2014-08-06 00:00:00+00:00   50230315  1612389  29476L107  2011-03-31   \n",
      "58042   2014-08-06 00:00:00+00:00   50230314  1612389  297178105  2011-03-31   \n",
      "...                           ...        ...      ...        ...         ...   \n",
      "414081  2014-01-10 00:00:00+00:00   47018625  1590073  30231G102  2011-03-31   \n",
      "414082  2014-01-10 00:00:00+00:00   47018624  1590073  92206C714  2011-03-31   \n",
      "414083  2014-01-10 00:00:00+00:00   47018623  1590073  464286657  2011-03-31   \n",
      "414084  2014-01-10 00:00:00+00:00   47018622  1590073  464285105  2011-03-31   \n",
      "414085  2014-01-10 00:00:00+00:00   47018621  1590073  464287234  2011-03-31   \n",
      "\n",
      "        iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "58038        0             0      0  786777.0     13855000.0        0.062996  \n",
      "58039        0             0      0  159041.0     12971000.0        0.058977  \n",
      "58040        0             0      0   91644.0      3985000.0        0.018119  \n",
      "58041        0             0      0   92590.0      5223000.0        0.023748  \n",
      "58042        0             0      0   92013.0     11410000.0        0.051879  \n",
      "...        ...           ...    ...       ...            ...             ...  \n",
      "414081       0             0      0    7840.0       660000.0        0.005783  \n",
      "414082       0             0      0   10253.0       614000.0        0.005380  \n",
      "414083       0             0      0   19699.0       991000.0        0.008683  \n",
      "414084       0             0      0   21527.0       302000.0        0.002646  \n",
      "414085       0             0      0  187632.0      8750000.0        0.076670  \n",
      "\n",
      "[138 rows x 11 columns]\n",
      "                             date  record_id     iCIK   stock_id  period_end  \\\n",
      "58054   2014-08-06 00:00:00+00:00   50230302  1612389  437306103  2010-12-31   \n",
      "58055   2014-08-06 00:00:00+00:00   50230301  1612389  313747206  2010-12-31   \n",
      "58056   2014-08-06 00:00:00+00:00   50230300  1612389  25960P109  2010-12-31   \n",
      "58057   2014-08-06 00:00:00+00:00   50230299  1612389  44107P104  2010-12-31   \n",
      "58058   2014-08-06 00:00:00+00:00   50230298  1612389  29476L107  2010-12-31   \n",
      "...                           ...        ...      ...        ...         ...   \n",
      "202175  2014-01-30 00:00:00+00:00   49866487  1590073  30231G102  2010-12-31   \n",
      "202176  2014-01-30 00:00:00+00:00   49866486  1590073  92206C714  2010-12-31   \n",
      "202177  2014-01-30 00:00:00+00:00   49866485  1590073  464286657  2010-12-31   \n",
      "202178  2014-01-30 00:00:00+00:00   49866484  1590073  464285105  2010-12-31   \n",
      "202179  2014-01-30 00:00:00+00:00   49866483  1590073  464287234  2010-12-31   \n",
      "\n",
      "        iAMEND  iRESTATEMENT  iTYPE       iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "58054        0             0      0   394141.0     21871000.0        0.103384  \n",
      "58055        0             0      0   169038.0     13173000.0        0.062268  \n",
      "58056        0             0      0   261677.0      4344000.0        0.020534  \n",
      "58057        0             0      0  1362720.0     24352000.0        0.115111  \n",
      "58058        0             0      0   164977.0      8571000.0        0.040515  \n",
      "...        ...           ...    ...        ...            ...             ...  \n",
      "202175       0             0      0     4553.0       333000.0        0.003154  \n",
      "202176       0             0      0    10253.0       579000.0        0.005484  \n",
      "202177       0             0      0    16733.0       822000.0        0.007786  \n",
      "202178       0             0      0    21527.0       299000.0        0.002832  \n",
      "202179       0             0      0   182337.0      8313000.0        0.078738  \n",
      "\n",
      "[142 rows x 11 columns]\n",
      "                             date  record_id     iCIK   stock_id  period_end  \\\n",
      "58072   2014-08-06 00:00:00+00:00   50230284  1612389  437306103  2010-09-30   \n",
      "58073   2014-08-06 00:00:00+00:00   50230283  1612389  313747206  2010-09-30   \n",
      "58074   2014-08-06 00:00:00+00:00   50230282  1612389  25960P109  2010-09-30   \n",
      "58075   2014-08-06 00:00:00+00:00   50230281  1612389  44107P104  2010-09-30   \n",
      "58076   2014-08-06 00:00:00+00:00   50230280  1612389  29476L107  2010-09-30   \n",
      "58077   2014-08-06 00:00:00+00:00   50230279  1612389  297178105  2010-09-30   \n",
      "58078   2014-08-06 00:00:00+00:00   50230278  1612389  49427F108  2010-09-30   \n",
      "58079   2014-08-06 00:00:00+00:00   50230277  1612389  78440X101  2010-09-30   \n",
      "58080   2014-08-06 00:00:00+00:00   50230276  1612389  004239109  2010-09-30   \n",
      "58081   2014-08-06 00:00:00+00:00   50230275  1612389  828806109  2010-09-30   \n",
      "58082   2014-08-06 00:00:00+00:00   50230274  1612389  49446R109  2010-09-30   \n",
      "58083   2014-08-06 00:00:00+00:00   50230273  1612389  929042109  2010-09-30   \n",
      "58084   2014-08-06 00:00:00+00:00   50230272  1612389  74460D109  2010-09-30   \n",
      "58085   2014-08-06 00:00:00+00:00   50230271  1612389  053484101  2010-09-30   \n",
      "58086   2014-08-06 00:00:00+00:00   50230270  1612389  015271109  2010-09-30   \n",
      "58087   2014-08-06 00:00:00+00:00   50230269  1612389  101121101  2010-09-30   \n",
      "201027  2014-06-23 00:00:00+00:00   49887946  1570251  464287622  2010-09-30   \n",
      "201028  2014-06-23 00:00:00+00:00   49887945  1570251  527288104  2010-09-30   \n",
      "201029  2014-06-23 00:00:00+00:00   49887944  1570251  464287614  2010-09-30   \n",
      "201030  2014-06-23 00:00:00+00:00   49887943  1570251  464287598  2010-09-30   \n",
      "201031  2014-06-23 00:00:00+00:00   49887942  1570251  464287465  2010-09-30   \n",
      "201032  2014-06-23 00:00:00+00:00   49887941  1570251  464288158  2010-09-30   \n",
      "201033  2014-06-23 00:00:00+00:00   49887940  1570251  464287200  2010-09-30   \n",
      "201034  2014-06-23 00:00:00+00:00   49887939  1570251  458140100  2010-09-30   \n",
      "201035  2014-06-23 00:00:00+00:00   49887938  1570251  084670702  2010-09-30   \n",
      "201036  2014-06-23 00:00:00+00:00   49887937  1570251  227046109  2010-09-30   \n",
      "201037  2014-06-23 00:00:00+00:00   49887936  1570251  464287689  2010-09-30   \n",
      "201038  2014-06-23 00:00:00+00:00   49887935  1570251  037833100  2010-09-30   \n",
      "201039  2014-06-23 00:00:00+00:00   49887934  1570251  464287564  2010-09-30   \n",
      "201040  2014-06-23 00:00:00+00:00   49887933  1570251  464287226  2010-09-30   \n",
      "201041  2014-06-23 00:00:00+00:00   49887932  1570251  464288414  2010-09-30   \n",
      "201042  2014-06-23 00:00:00+00:00   49887931  1570251  38259P508  2010-09-30   \n",
      "201043  2014-06-23 00:00:00+00:00   49887930  1570251  78463V107  2010-09-30   \n",
      "201044  2014-06-23 00:00:00+00:00   49887929  1570251  464288885  2010-09-30   \n",
      "201045  2014-06-23 00:00:00+00:00   49887928  1570251  464287655  2010-09-30   \n",
      "201046  2014-06-23 00:00:00+00:00   49887927  1570251  73935S105  2010-09-30   \n",
      "201047  2014-06-23 00:00:00+00:00   49887926  1570251  73936D206  2010-09-30   \n",
      "201048  2014-06-23 00:00:00+00:00   49887925  1570251  464287648  2010-09-30   \n",
      "201049  2014-06-23 00:00:00+00:00   49887924  1570251  464288281  2010-09-30   \n",
      "201050  2014-06-23 00:00:00+00:00   49887923  1570251  369604103  2010-09-30   \n",
      "201051  2014-06-23 00:00:00+00:00   49887922  1570251  084670108  2010-09-30   \n",
      "201052  2014-06-23 00:00:00+00:00   49887921  1570251  464288877  2010-09-30   \n",
      "201053  2014-06-23 00:00:00+00:00   49887920  1570251  464287630  2010-09-30   \n",
      "201054  2014-06-23 00:00:00+00:00   49887919  1570251  464285105  2010-09-30   \n",
      "201055  2014-06-23 00:00:00+00:00   49887918  1570251  464287234  2010-09-30   \n",
      "201056  2014-06-23 00:00:00+00:00   49887917  1570251  464287457  2010-09-30   \n",
      "\n",
      "        iAMEND  iRESTATEMENT  iTYPE       iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "58072        0             0      0   406690.0     21514000.0        0.114006  \n",
      "58073        0             0      0   193169.0     15774000.0        0.083589  \n",
      "58074        0             0      0   261677.0      4582000.0        0.024281  \n",
      "58075        0             0      0  1016660.0     14721000.0        0.078009  \n",
      "58076        0             0      0   196549.0      9350000.0        0.049547  \n",
      "58077        0             0      0   150599.0     16482000.0        0.087341  \n",
      "58078        0             0      0   165920.0      5499000.0        0.029140  \n",
      "58079        0             0      0   258653.0     16380000.0        0.086800  \n",
      "58080        0             0      0    29307.0       557000.0        0.002952  \n",
      "58081        0             0      0   459931.0     40105000.0        0.212523  \n",
      "58082        0             0      0   233549.0      3676000.0        0.019480  \n",
      "58083        0             0      0   167308.0     14310000.0        0.075831  \n",
      "58084        0             0      0    10109.0       981000.0        0.005198  \n",
      "58085        0             0      0    59286.0      6162000.0        0.032654  \n",
      "58086        0             0      0   142127.0      9949000.0        0.052721  \n",
      "58087        0             0      0   104272.0      8667000.0        0.045928  \n",
      "201027       0             0      0   698129.0     44087000.0        0.257328  \n",
      "201028       0             0      0    10000.0       236000.0        0.001377  \n",
      "201029       0             0      0   159885.0      8213000.0        0.047938  \n",
      "201030       0             0      0   136293.0      8040000.0        0.046928  \n",
      "201031       0             0      0   299085.0     16426000.0        0.095876  \n",
      "201032       0             0      0    53111.0      5632000.0        0.032873  \n",
      "201033       0             0      0     2510.0       287000.0        0.001675  \n",
      "201034       0             0      0   460676.0      8845000.0        0.051627  \n",
      "201035       0             0      0    71196.0      5886000.0        0.034356  \n",
      "201036       0             0      0    40497.0       526000.0        0.003070  \n",
      "201037       0             0      0    10220.0       689000.0        0.004022  \n",
      "201038       0             0      0     1000.0       284000.0        0.001658  \n",
      "201039       0             0      0    26680.0      1652000.0        0.009642  \n",
      "201040       0             0      0    10844.0      1178000.0        0.006876  \n",
      "201041       0             0      0   156837.0     16746000.0        0.097743  \n",
      "201042       0             0      0     9863.0      5186000.0        0.030270  \n",
      "201043       0             0      0     5624.0       719000.0        0.004197  \n",
      "201044       0             0      0    61892.0      3509000.0        0.020481  \n",
      "201045       0             0      0   118912.0      8027000.0        0.046852  \n",
      "201046       0             0      0    17166.0       414000.0        0.002416  \n",
      "201047       0             0      0     9400.0       254000.0        0.001483  \n",
      "201048       0             0      0    25160.0      1880000.0        0.010973  \n",
      "201049       0             0      0     5774.0       643000.0        0.003753  \n",
      "201050       0             0      0    12029.0       195000.0        0.001138  \n",
      "201051       0             0      0       64.0      7968000.0        0.046508  \n",
      "201052       0             0      0    69670.0      3390000.0        0.019787  \n",
      "201053       0             0      0    29403.0      1823000.0        0.010641  \n",
      "201054       0             0      0   463591.0      5934000.0        0.034636  \n",
      "201055       0             0      0   256932.0     11503000.0        0.067141  \n",
      "201056       0             0      0    13678.0      1154000.0        0.006736  \n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                             date  record_id     iCIK   stock_id  period_end  \\\n",
      "58088   2014-08-06 00:00:00+00:00   50230268  1612389  437306103  2010-06-30   \n",
      "58089   2014-08-06 00:00:00+00:00   50230267  1612389  313747206  2010-06-30   \n",
      "58090   2014-08-06 00:00:00+00:00   50230266  1612389  25960P109  2010-06-30   \n",
      "58091   2014-08-06 00:00:00+00:00   50230265  1612389  44107P104  2010-06-30   \n",
      "58092   2014-08-06 00:00:00+00:00   50230264  1612389  29476L107  2010-06-30   \n",
      "58093   2014-08-06 00:00:00+00:00   50230263  1612389  297178105  2010-06-30   \n",
      "58094   2014-08-06 00:00:00+00:00   50230262  1612389  49427F108  2010-06-30   \n",
      "58095   2014-08-06 00:00:00+00:00   50230261  1612389  78440X101  2010-06-30   \n",
      "58096   2014-08-06 00:00:00+00:00   50230260  1612389  004239109  2010-06-30   \n",
      "58097   2014-08-06 00:00:00+00:00   50230259  1612389  828806109  2010-06-30   \n",
      "58098   2014-08-06 00:00:00+00:00   50230258  1612389  49446R109  2010-06-30   \n",
      "58099   2014-08-06 00:00:00+00:00   50230257  1612389  929042109  2010-06-30   \n",
      "58100   2014-08-06 00:00:00+00:00   50230256  1612389  74460D109  2010-06-30   \n",
      "58101   2014-08-06 00:00:00+00:00   50230255  1612389  053484101  2010-06-30   \n",
      "58102   2014-08-06 00:00:00+00:00   50230254  1612389  015271109  2010-06-30   \n",
      "58103   2014-08-06 00:00:00+00:00   50230253  1612389  101121101  2010-06-30   \n",
      "201057  2014-06-23 00:00:00+00:00   49887916  1570251  464287622  2010-06-30   \n",
      "201058  2014-06-23 00:00:00+00:00   49887915  1570251  464287614  2010-06-30   \n",
      "201059  2014-06-23 00:00:00+00:00   49887914  1570251  464287598  2010-06-30   \n",
      "201060  2014-06-23 00:00:00+00:00   49887913  1570251  464288414  2010-06-30   \n",
      "201061  2014-06-23 00:00:00+00:00   49887912  1570251  464288158  2010-06-30   \n",
      "201062  2014-06-23 00:00:00+00:00   49887911  1570251  464287465  2010-06-30   \n",
      "201063  2014-06-23 00:00:00+00:00   49887910  1570251  458140100  2010-06-30   \n",
      "201064  2014-06-23 00:00:00+00:00   49887909  1570251  084670702  2010-06-30   \n",
      "201065  2014-06-23 00:00:00+00:00   49887908  1570251  227046109  2010-06-30   \n",
      "201066  2014-06-23 00:00:00+00:00   49887907  1570251  464287689  2010-06-30   \n",
      "201067  2014-06-23 00:00:00+00:00   49887906  1570251  037833100  2010-06-30   \n",
      "201068  2014-06-23 00:00:00+00:00   49887905  1570251  464287226  2010-06-30   \n",
      "201069  2014-06-23 00:00:00+00:00   49887904  1570251  38259P508  2010-06-30   \n",
      "201070  2014-06-23 00:00:00+00:00   49887903  1570251  78463V107  2010-06-30   \n",
      "201071  2014-06-23 00:00:00+00:00   49887902  1570251  464288885  2010-06-30   \n",
      "201072  2014-06-23 00:00:00+00:00   49887901  1570251  464287655  2010-06-30   \n",
      "201073  2014-06-23 00:00:00+00:00   49887900  1570251  73935S105  2010-06-30   \n",
      "201074  2014-06-23 00:00:00+00:00   49887899  1570251  73936D206  2010-06-30   \n",
      "201075  2014-06-23 00:00:00+00:00   49887898  1570251  464287648  2010-06-30   \n",
      "201076  2014-06-23 00:00:00+00:00   49887897  1570251  464288281  2010-06-30   \n",
      "201077  2014-06-23 00:00:00+00:00   49887896  1570251  912318102  2010-06-30   \n",
      "201078  2014-06-23 00:00:00+00:00   49887895  1570251  369604103  2010-06-30   \n",
      "201079  2014-06-23 00:00:00+00:00   49887894  1570251  464288877  2010-06-30   \n",
      "201080  2014-06-23 00:00:00+00:00   49887893  1570251  464287630  2010-06-30   \n",
      "201081  2014-06-23 00:00:00+00:00   49887892  1570251  464285105  2010-06-30   \n",
      "201082  2014-06-23 00:00:00+00:00   49887891  1570251  464287234  2010-06-30   \n",
      "201083  2014-06-23 00:00:00+00:00   49887890  1570251  464287457  2010-06-30   \n",
      "\n",
      "        iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "58088        0             0      0  402417.0     18137000.0        0.112402  \n",
      "58089        0             0      0  205095.0     14412000.0        0.089316  \n",
      "58090        0             0      0  261769.0      3722000.0        0.023067  \n",
      "58091        0             0      0  254989.0      3437000.0        0.021300  \n",
      "58092        0             0      0  203299.0      8465000.0        0.052461  \n",
      "58093        0             0      0  155715.0     15188000.0        0.094126  \n",
      "58094        0             0      0  141920.0      4219000.0        0.026147  \n",
      "58095        0             0      0  259910.0     14305000.0        0.088653  \n",
      "58096        0             0      0   29307.0       493000.0        0.003055  \n",
      "58097        0             0      0  460435.0     34958000.0        0.216647  \n",
      "58098        0             0      0  176720.0      2375000.0        0.014719  \n",
      "58099        0             0      0  195043.0     14228000.0        0.088176  \n",
      "58100        0             0      0   48260.0      4243000.0        0.026295  \n",
      "58101        0             0      0   71935.0      6717000.0        0.041628  \n",
      "58102        0             0      0  142359.0      9021000.0        0.055906  \n",
      "58103        0             0      0  104272.0      7439000.0        0.046102  \n",
      "201057       0             0      0  629056.0     35944000.0        0.257968  \n",
      "201058       0             0      0  162570.0      7451000.0        0.053475  \n",
      "201059       0             0      0  139190.0      7545000.0        0.054150  \n",
      "201060       0             0      0  132016.0     13734000.0        0.098568  \n",
      "201061       0             0      0   50580.0      5339000.0        0.038318  \n",
      "201062       0             0      0  271078.0     12608000.0        0.090487  \n",
      "201063       0             0      0  461033.0      8967000.0        0.064356  \n",
      "201064       0             0      0   68567.0      5464000.0        0.039215  \n",
      "201065       0             0      0   65687.0       695000.0        0.004988  \n",
      "201066       0             0      0    9930.0       607000.0        0.004356  \n",
      "201067       0             0      0    1037.0       261000.0        0.001873  \n",
      "201068       0             0      0    9237.0       991000.0        0.007112  \n",
      "201069       0             0      0   10525.0      4683000.0        0.033610  \n",
      "201070       0             0      0    5624.0       684000.0        0.004909  \n",
      "201071       0             0      0   61508.0      2957000.0        0.021222  \n",
      "201072       0             0      0  112923.0      6901000.0        0.049528  \n",
      "201073       0             0      0   17166.0       370000.0        0.002655  \n",
      "201074       0             0      0    9400.0       233000.0        0.001672  \n",
      "201075       0             0      0   23286.0      1550000.0        0.011124  \n",
      "201076       0             0      0    5968.0       620000.0        0.004450  \n",
      "201077       0             0      0  431406.0      3343000.0        0.023992  \n",
      "201078       0             0      0   12023.0       173000.0        0.001242  \n",
      "201079       0             0      0   68033.0      2805000.0        0.020131  \n",
      "201080       0             0      0   26888.0      1534000.0        0.011009  \n",
      "201081       0             0      0  462970.0      5634000.0        0.040435  \n",
      "201082       0             0      0  190009.0      7091000.0        0.050892  \n",
      "201083       0             0      0   13678.0      1151000.0        0.008261  \n",
      "                             date  record_id     iCIK   stock_id  period_end  \\\n",
      "58210   2014-08-06 00:00:00+00:00   50229597  1612389  437306103  2010-03-31   \n",
      "58211   2014-08-06 00:00:00+00:00   50229596  1612389  313747206  2010-03-31   \n",
      "58212   2014-08-06 00:00:00+00:00   50229595  1612389  25960P109  2010-03-31   \n",
      "58213   2014-08-06 00:00:00+00:00   50229594  1612389  44107P104  2010-03-31   \n",
      "58214   2014-08-06 00:00:00+00:00   50229593  1612389  29476L107  2010-03-31   \n",
      "58215   2014-08-06 00:00:00+00:00   50229592  1612389  297178105  2010-03-31   \n",
      "58216   2014-08-06 00:00:00+00:00   50229591  1612389  929042109  2010-03-31   \n",
      "58217   2014-08-06 00:00:00+00:00   50229590  1612389  26613Q106  2010-03-31   \n",
      "58218   2014-08-06 00:00:00+00:00   50229589  1612389  78440X101  2010-03-31   \n",
      "58219   2014-08-06 00:00:00+00:00   50229588  1612389  004239109  2010-03-31   \n",
      "58220   2014-08-06 00:00:00+00:00   50229587  1612389  554382101  2010-03-31   \n",
      "58221   2014-08-06 00:00:00+00:00   50229586  1612389  828806109  2010-03-31   \n",
      "58222   2014-08-06 00:00:00+00:00   50229585  1612389  517942108  2010-03-31   \n",
      "58223   2014-08-06 00:00:00+00:00   50229584  1612389  00163T109  2010-03-31   \n",
      "58224   2014-08-06 00:00:00+00:00   50229583  1612389  74460D109  2010-03-31   \n",
      "58225   2014-08-06 00:00:00+00:00   50229582  1612389  053484101  2010-03-31   \n",
      "58226   2014-08-06 00:00:00+00:00   50229581  1612389  015271109  2010-03-31   \n",
      "58227   2014-08-06 00:00:00+00:00   50229580  1612389  101121101  2010-03-31   \n",
      "201084  2014-06-12 00:00:00+00:00   49884996  1570251  464287614  2010-03-31   \n",
      "201085  2014-06-12 00:00:00+00:00   49884995  1570251  464287598  2010-03-31   \n",
      "201086  2014-06-12 00:00:00+00:00   49884994  1570251  464288414  2010-03-31   \n",
      "201087  2014-06-12 00:00:00+00:00   49884993  1570251  464288158  2010-03-31   \n",
      "201088  2014-06-12 00:00:00+00:00   49884992  1570251  464287465  2010-03-31   \n",
      "201089  2014-06-12 00:00:00+00:00   49884991  1570251  458140100  2010-03-31   \n",
      "201090  2014-06-12 00:00:00+00:00   49884990  1570251  084670702  2010-03-31   \n",
      "201091  2014-06-12 00:00:00+00:00   49884989  1570251  227046109  2010-03-31   \n",
      "201092  2014-06-12 00:00:00+00:00   49884988  1570251  464287689  2010-03-31   \n",
      "201093  2014-06-12 00:00:00+00:00   49884987  1570251  037833100  2010-03-31   \n",
      "201094  2014-06-12 00:00:00+00:00   49884986  1570251  464287226  2010-03-31   \n",
      "201095  2014-06-12 00:00:00+00:00   49884985  1570251  38259P508  2010-03-31   \n",
      "201096  2014-06-12 00:00:00+00:00   49884984  1570251  78463V107  2010-03-31   \n",
      "201097  2014-06-12 00:00:00+00:00   49884983  1570251  464288885  2010-03-31   \n",
      "201098  2014-06-12 00:00:00+00:00   49884982  1570251  464287655  2010-03-31   \n",
      "201099  2014-06-12 00:00:00+00:00   49884981  1570251  73935S105  2010-03-31   \n",
      "201100  2014-06-12 00:00:00+00:00   49884980  1570251  73936D206  2010-03-31   \n",
      "201101  2014-06-12 00:00:00+00:00   49884979  1570251  464287648  2010-03-31   \n",
      "201102  2014-06-12 00:00:00+00:00   49884978  1570251  464287622  2010-03-31   \n",
      "201103  2014-06-12 00:00:00+00:00   49884977  1570251  912318102  2010-03-31   \n",
      "201104  2014-06-12 00:00:00+00:00   49884976  1570251  369604103  2010-03-31   \n",
      "201105  2014-06-12 00:00:00+00:00   49884975  1570251  464288877  2010-03-31   \n",
      "201106  2014-06-12 00:00:00+00:00   49884974  1570251  464287630  2010-03-31   \n",
      "201107  2014-06-12 00:00:00+00:00   49884973  1570251  464285105  2010-03-31   \n",
      "201108  2014-06-12 00:00:00+00:00   49884972  1570251  464287234  2010-03-31   \n",
      "201109  2014-06-12 00:00:00+00:00   49884971  1570251  464287457  2010-03-31   \n",
      "\n",
      "        iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "58210        0             0      0  183024.0      8566000.0        0.044326  \n",
      "58211        0             0      0  192757.0     14035000.0        0.072626  \n",
      "58212        0             0      0  414937.0      6378000.0        0.033004  \n",
      "58213        0             0      0  347295.0      5088000.0        0.026329  \n",
      "58214        0             0      0  268504.0     10512000.0        0.054396  \n",
      "58215        0             0      0  214363.0     19282000.0        0.099777  \n",
      "58216        0             0      0  250059.0     18929000.0        0.097951  \n",
      "58217        0             0      0   31571.0       682000.0        0.003529  \n",
      "58218        0             0      0  435577.0     24945000.0        0.129082  \n",
      "58219        0             0      0  232206.0      4147000.0        0.021459  \n",
      "58220        0             0      0   17449.0       668000.0        0.003457  \n",
      "58221        0             0      0  479708.0     37842000.0        0.195819  \n",
      "58222        0             0      0  195771.0      4561000.0        0.023602  \n",
      "58223        0             0      0  169287.0      2235000.0        0.011565  \n",
      "58224        0             0      0   53260.0      4899000.0        0.025351  \n",
      "58225        0             0      0   86350.0      7456000.0        0.038582  \n",
      "58226        0             0      0  161870.0     10942000.0        0.056621  \n",
      "58227        0             0      0  160164.0     12083000.0        0.062525  \n",
      "201084       0             0      0  172480.0      8960000.0        0.058894  \n",
      "201085       0             0      0  146612.0      8954000.0        0.058855  \n",
      "201086       0             0      0   69315.0      7160000.0        0.047063  \n",
      "201087       0             0      0   72739.0      7635000.0        0.050185  \n",
      "201088       0             0      0  262457.0     14692000.0        0.096571  \n",
      "201089       0             0      0  460676.0     10268000.0        0.067492  \n",
      "201090       0             0      0   84963.0      6905000.0        0.045387  \n",
      "201091       0             0      0   59705.0       524000.0        0.003444  \n",
      "201092       0             0      0   10456.0       719000.0        0.004726  \n",
      "201093       0             0      0    1000.0       235000.0        0.001545  \n",
      "201094       0             0      0    9222.0       961000.0        0.006317  \n",
      "201095       0             0      0   10513.0      5962000.0        0.039188  \n",
      "201096       0             0      0    5624.0       613000.0        0.004029  \n",
      "201097       0             0      0   63353.0      3588000.0        0.023584  \n",
      "201098       0             0      0  115754.0      7848000.0        0.051585  \n",
      "201099       0             0      0   17166.0       404000.0        0.002655  \n",
      "201100       0             0      0    9400.0       249000.0        0.001637  \n",
      "201101       0             0      0   25897.0      1897000.0        0.012469  \n",
      "201102       0             0      0  681163.0     44017000.0        0.289325  \n",
      "201103       0             0      0  433232.0      2994000.0        0.019680  \n",
      "201104       0             0      0   11973.0       218000.0        0.001433  \n",
      "201105       0             0      0   68824.0      3486000.0        0.022914  \n",
      "201106       0             0      0   30048.0      1918000.0        0.012607  \n",
      "201107       0             0      0   48641.0      5303000.0        0.034857  \n",
      "201108       0             0      0  130259.0      5487000.0        0.036066  \n",
      "201109       0             0      0   13678.0      1140000.0        0.007493  \n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                             date  record_id     iCIK   stock_id  period_end  \\\n",
      "58228   2014-08-06 00:00:00+00:00   50229579  1612389  437306103  2009-12-31   \n",
      "58229   2014-08-06 00:00:00+00:00   50229578  1612389  313747206  2009-12-31   \n",
      "58230   2014-08-06 00:00:00+00:00   50229577  1612389  25960P109  2009-12-31   \n",
      "58231   2014-08-06 00:00:00+00:00   50229576  1612389  44107P104  2009-12-31   \n",
      "58232   2014-08-06 00:00:00+00:00   50229575  1612389  29476L107  2009-12-31   \n",
      "58233   2014-08-06 00:00:00+00:00   50229574  1612389  758849103  2009-12-31   \n",
      "58234   2014-08-06 00:00:00+00:00   50229573  1612389  297178105  2009-12-31   \n",
      "58235   2014-08-06 00:00:00+00:00   50229572  1612389  929042109  2009-12-31   \n",
      "58236   2014-08-06 00:00:00+00:00   50229571  1612389  26613Q106  2009-12-31   \n",
      "58237   2014-08-06 00:00:00+00:00   50229570  1612389  78440X101  2009-12-31   \n",
      "58238   2014-08-06 00:00:00+00:00   50229569  1612389  004239109  2009-12-31   \n",
      "58239   2014-08-06 00:00:00+00:00   50229568  1612389  554382101  2009-12-31   \n",
      "58240   2014-08-06 00:00:00+00:00   50229567  1612389  828806109  2009-12-31   \n",
      "58241   2014-08-06 00:00:00+00:00   50229566  1612389  517942108  2009-12-31   \n",
      "58242   2014-08-06 00:00:00+00:00   50229565  1612389  00163T109  2009-12-31   \n",
      "58243   2014-08-06 00:00:00+00:00   50229564  1612389  74460D109  2009-12-31   \n",
      "58244   2014-08-06 00:00:00+00:00   50229563  1612389  053484101  2009-12-31   \n",
      "58245   2014-08-06 00:00:00+00:00   50229562  1612389  015271109  2009-12-31   \n",
      "58246   2014-08-06 00:00:00+00:00   50229561  1612389  101121101  2009-12-31   \n",
      "201110  2014-06-09 00:00:00+00:00   49884884  1570251  084670207  2009-12-31   \n",
      "201111  2014-06-09 00:00:00+00:00   49884883  1570251  464287614  2009-12-31   \n",
      "201112  2014-06-09 00:00:00+00:00   49884882  1570251  464287598  2009-12-31   \n",
      "201113  2014-06-09 00:00:00+00:00   49884881  1570251  464288414  2009-12-31   \n",
      "201114  2014-06-09 00:00:00+00:00   49884880  1570251  464288158  2009-12-31   \n",
      "201115  2014-06-09 00:00:00+00:00   49884879  1570251  464287465  2009-12-31   \n",
      "201116  2014-06-09 00:00:00+00:00   49884878  1570251  458140100  2009-12-31   \n",
      "201117  2014-06-09 00:00:00+00:00   49884877  1570251  227046109  2009-12-31   \n",
      "201118  2014-06-09 00:00:00+00:00   49884876  1570251  464287689  2009-12-31   \n",
      "201119  2014-06-09 00:00:00+00:00   49884875  1570251  464287226  2009-12-31   \n",
      "201120  2014-06-09 00:00:00+00:00   49884874  1570251  38259P508  2009-12-31   \n",
      "201121  2014-06-09 00:00:00+00:00   49884873  1570251  78463V107  2009-12-31   \n",
      "201122  2014-06-09 00:00:00+00:00   49884872  1570251  464288885  2009-12-31   \n",
      "201123  2014-06-09 00:00:00+00:00   49884871  1570251  464287655  2009-12-31   \n",
      "201124  2014-06-09 00:00:00+00:00   49884870  1570251  73935S105  2009-12-31   \n",
      "201125  2014-06-09 00:00:00+00:00   49884869  1570251  73936D206  2009-12-31   \n",
      "201126  2014-06-09 00:00:00+00:00   49884868  1570251  464287648  2009-12-31   \n",
      "201127  2014-06-09 00:00:00+00:00   49884867  1570251  464287622  2009-12-31   \n",
      "201128  2014-06-09 00:00:00+00:00   49884866  1570251  912318102  2009-12-31   \n",
      "201129  2014-06-09 00:00:00+00:00   49884865  1570251  369604103  2009-12-31   \n",
      "201130  2014-06-09 00:00:00+00:00   49884864  1570251  464288877  2009-12-31   \n",
      "201131  2014-06-09 00:00:00+00:00   49884863  1570251  464287630  2009-12-31   \n",
      "201132  2014-06-09 00:00:00+00:00   49884862  1570251  464285105  2009-12-31   \n",
      "201133  2014-06-09 00:00:00+00:00   49884861  1570251  464287234  2009-12-31   \n",
      "201134  2014-06-09 00:00:00+00:00   49884860  1570251  464287457  2009-12-31   \n",
      "\n",
      "        iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "58228        0             0      0  127125.0      6065000.0        0.029962  \n",
      "58229        0             0      0  215822.0     14615000.0        0.072201  \n",
      "58230        0             0      0  383637.0      5467000.0        0.027008  \n",
      "58231        0             0      0  427595.0      4990000.0        0.024652  \n",
      "58232        0             0      0  257456.0      8697000.0        0.042965  \n",
      "58233        0             0      0   34100.0      1196000.0        0.005909  \n",
      "58234        0             0      0  165542.0     13848000.0        0.068412  \n",
      "58235        0             0      0  362296.0     25339000.0        0.125180  \n",
      "58236        0             0      0  175114.0      3150000.0        0.015562  \n",
      "58237        0             0      0  507532.0     25498000.0        0.125966  \n",
      "58238        0             0      0  386514.0      6520000.0        0.032210  \n",
      "58239        0             0      0   67344.0      2421000.0        0.011960  \n",
      "58240        0             0      0  526243.0     39484000.0        0.195060  \n",
      "58241        0             0      0  102635.0      2179000.0        0.010765  \n",
      "58242        0             0      0  300621.0      4116000.0        0.020334  \n",
      "58243        0             0      0   53260.0      4338000.0        0.021431  \n",
      "58244        0             0      0  118035.0      9692000.0        0.047881  \n",
      "58245        0             0      0  161870.0     10407000.0        0.051413  \n",
      "58246        0             0      0  214668.0     14398000.0        0.071129  \n",
      "201110       0             0      0    1778.0      5843000.0        0.037693  \n",
      "201111       0             0      0  181747.0      9060000.0        0.058446  \n",
      "201112       0             0      0  155517.0      8927000.0        0.057588  \n",
      "201113       0             0      0   76302.0      7840000.0        0.050576  \n",
      "201114       0             0      0   69340.0      7284000.0        0.046989  \n",
      "201115       0             0      0  303352.0     16769000.0        0.108177  \n",
      "201116       0             0      0  460676.0      9398000.0        0.060627  \n",
      "201117       0             0      0   54103.0       311000.0        0.002006  \n",
      "201118       0             0      0   10128.0       661000.0        0.004264  \n",
      "201119       0             0      0   10437.0      1077000.0        0.006948  \n",
      "201120       0             0      0   10513.0      6518000.0        0.042048  \n",
      "201121       0             0      0    5624.0       604000.0        0.003896  \n",
      "201122       0             0      0   65165.0      3592000.0        0.023172  \n",
      "201123       0             0      0  126755.0      7915000.0        0.051060  \n",
      "201124       0             0      0   17166.0       423000.0        0.002729  \n",
      "201125       0             0      0    9400.0       259000.0        0.001671  \n",
      "201126       0             0      0   26476.0      1803000.0        0.011631  \n",
      "201127       0             0      0  774704.0     47497000.0        0.306405  \n",
      "201128       0             0      0  234294.0      2362000.0        0.015237  \n",
      "201129       0             0      0   10473.0       158000.0        0.001019  \n",
      "201130       0             0      0   70059.0      3527000.0        0.022753  \n",
      "201131       0             0      0   30699.0      1782000.0        0.011496  \n",
      "201132       0             0      0   52635.0      5651000.0        0.036455  \n",
      "201133       0             0      0  111286.0      4618000.0        0.029791  \n",
      "201134       0             0      0   13678.0      1135000.0        0.007322  \n",
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "58247  2014-08-06 00:00:00+00:00   50229560  1612389  437306103  2009-09-30   \n",
      "58248  2014-08-06 00:00:00+00:00   50229559  1612389  313747206  2009-09-30   \n",
      "58249  2014-08-06 00:00:00+00:00   50229558  1612389  25960P109  2009-09-30   \n",
      "58250  2014-08-06 00:00:00+00:00   50229557  1612389  44107P104  2009-09-30   \n",
      "58251  2014-08-06 00:00:00+00:00   50229556  1612389  29476L107  2009-09-30   \n",
      "58252  2014-08-06 00:00:00+00:00   50229555  1612389  297178105  2009-09-30   \n",
      "58253  2014-08-06 00:00:00+00:00   50229554  1612389  49427F108  2009-09-30   \n",
      "58254  2014-08-06 00:00:00+00:00   50229553  1612389  929042109  2009-09-30   \n",
      "58255  2014-08-06 00:00:00+00:00   50229552  1612389  26613Q106  2009-09-30   \n",
      "58256  2014-08-06 00:00:00+00:00   50229551  1612389  78440X101  2009-09-30   \n",
      "58257  2014-08-06 00:00:00+00:00   50229550  1612389  004239109  2009-09-30   \n",
      "58258  2014-08-06 00:00:00+00:00   50229549  1612389  828806109  2009-09-30   \n",
      "58259  2014-08-06 00:00:00+00:00   50229548  1612389  49446R109  2009-09-30   \n",
      "58260  2014-08-06 00:00:00+00:00   50229547  1612389  00163T109  2009-09-30   \n",
      "58261  2014-08-06 00:00:00+00:00   50229546  1612389  74460D109  2009-09-30   \n",
      "58262  2014-08-06 00:00:00+00:00   50229545  1612389  053484101  2009-09-30   \n",
      "58263  2014-08-06 00:00:00+00:00   50229544  1612389  015271109  2009-09-30   \n",
      "58264  2014-08-06 00:00:00+00:00   50229543  1612389  101121101  2009-09-30   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "58247       0             0      0  150123.0      6469000.0        0.038750  \n",
      "58248       0             0      0  194877.0     11960000.0        0.071642  \n",
      "58249       0             0      0  271714.0      3337000.0        0.019989  \n",
      "58250       0             0      0  493306.0      5806000.0        0.034779  \n",
      "58251       0             0      0  213017.0      6540000.0        0.039176  \n",
      "58252       0             0      0  116145.0      9243000.0        0.055367  \n",
      "58253       0             0      0   16524.0       458000.0        0.002743  \n",
      "58254       0             0      0  401722.0     25875000.0        0.154995  \n",
      "58255       0             0      0  139121.0      1854000.0        0.011106  \n",
      "58256       0             0      0  462786.0     20293000.0        0.121558  \n",
      "58257       0             0      0  363439.0      5477000.0        0.032808  \n",
      "58258       0             0      0  550024.0     35906000.0        0.215082  \n",
      "58259       0             0      0  120561.0      1572000.0        0.009417  \n",
      "58260       0             0      0  162028.0      1931000.0        0.011567  \n",
      "58261       0             0      0   39293.0      2956000.0        0.017707  \n",
      "58262       0             0      0   93045.0      6767000.0        0.040535  \n",
      "58263       0             0      0  134025.0      7284000.0        0.043632  \n",
      "58264       0             0      0  201570.0     13213000.0        0.079148  \n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "58265  2014-08-06 00:00:00+00:00   50229542  1612389  437306103  2009-06-30   \n",
      "58266  2014-08-06 00:00:00+00:00   50229541  1612389  313747206  2009-06-30   \n",
      "58267  2014-08-06 00:00:00+00:00   50229540  1612389  25960P109  2009-06-30   \n",
      "58268  2014-08-06 00:00:00+00:00   50229539  1612389  44107P104  2009-06-30   \n",
      "58269  2014-08-06 00:00:00+00:00   50229538  1612389  29476L107  2009-06-30   \n",
      "58270  2014-08-06 00:00:00+00:00   50229537  1612389  758849103  2009-06-30   \n",
      "58271  2014-08-06 00:00:00+00:00   50229536  1612389  297178105  2009-06-30   \n",
      "58272  2014-08-06 00:00:00+00:00   50229535  1612389  49427F108  2009-06-30   \n",
      "58273  2014-08-06 00:00:00+00:00   50229534  1612389  929042109  2009-06-30   \n",
      "58274  2014-08-06 00:00:00+00:00   50229533  1612389  26613Q106  2009-06-30   \n",
      "58275  2014-08-06 00:00:00+00:00   50229532  1612389  78440X101  2009-06-30   \n",
      "58276  2014-08-06 00:00:00+00:00   50229531  1612389  004239109  2009-06-30   \n",
      "58277  2014-08-06 00:00:00+00:00   50229530  1612389  554382101  2009-06-30   \n",
      "58278  2014-08-06 00:00:00+00:00   50229529  1612389  828806109  2009-06-30   \n",
      "58279  2014-08-06 00:00:00+00:00   50229528  1612389  49446R109  2009-06-30   \n",
      "58280  2014-08-06 00:00:00+00:00   50229527  1612389  00163T109  2009-06-30   \n",
      "58281  2014-08-06 00:00:00+00:00   50229526  1612389  74460D109  2009-06-30   \n",
      "58282  2014-08-06 00:00:00+00:00   50229525  1612389  053484101  2009-06-30   \n",
      "58283  2014-08-06 00:00:00+00:00   50229524  1612389  015271109  2009-06-30   \n",
      "58284  2014-08-06 00:00:00+00:00   50229523  1612389  101121101  2009-06-30   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "58265       0             0      0  147000.0      5013000.0        0.038217  \n",
      "58266       0             0      0  323606.0     16672000.0        0.127099  \n",
      "58267       0             0      0  264029.0      2374000.0        0.018098  \n",
      "58268       0             0      0  482550.0      4049000.0        0.030868  \n",
      "58269       0             0      0  125082.0      2781000.0        0.021201  \n",
      "58270       0             0      0  235353.0      8216000.0        0.062635  \n",
      "58271       0             0      0   58672.0      3651000.0        0.027833  \n",
      "58272       0             0      0   77592.0      1594000.0        0.012152  \n",
      "58273       0             0      0  274295.0     12352000.0        0.094166  \n",
      "58274       0             0      0  170326.0      1604000.0        0.012228  \n",
      "58275       0             0      0  343585.0      7882000.0        0.060089  \n",
      "58276       0             0      0  333922.0      4358000.0        0.033223  \n",
      "58277       0             0      0   50767.0       894000.0        0.006815  \n",
      "58278       0             0      0  675595.0     32669000.0        0.249053  \n",
      "58279       0             0      0  223515.0      2246000.0        0.017122  \n",
      "58280       0             0      0  165941.0      1337000.0        0.010193  \n",
      "58281       0             0      0  125322.0      8206000.0        0.062559  \n",
      "58282       0             0      0  109172.0      6107000.0        0.046557  \n",
      "58283       0             0      0   62799.0      2248000.0        0.017138  \n",
      "58284       0             0      0  145079.0      6920000.0        0.052755  \n",
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "58285  2014-08-06 00:00:00+00:00   50229522  1612389  44107P104  2009-03-31   \n",
      "58286  2014-08-06 00:00:00+00:00   50229521  1612389  313747206  2009-03-31   \n",
      "58287  2014-08-06 00:00:00+00:00   50229520  1612389  758849103  2009-03-31   \n",
      "58288  2014-08-06 00:00:00+00:00   50229519  1612389  297178105  2009-03-31   \n",
      "58289  2014-08-06 00:00:00+00:00   50229518  1612389  49427F108  2009-03-31   \n",
      "58290  2014-08-06 00:00:00+00:00   50229517  1612389  929042109  2009-03-31   \n",
      "58291  2014-08-06 00:00:00+00:00   50229516  1612389  26613Q106  2009-03-31   \n",
      "58292  2014-08-06 00:00:00+00:00   50229515  1612389  78440X101  2009-03-31   \n",
      "58293  2014-08-06 00:00:00+00:00   50229514  1612389  004239109  2009-03-31   \n",
      "58294  2014-08-06 00:00:00+00:00   50229513  1612389  828806109  2009-03-31   \n",
      "58295  2014-08-06 00:00:00+00:00   50229512  1612389  49446R109  2009-03-31   \n",
      "58296  2014-08-06 00:00:00+00:00   50229511  1612389  00163T109  2009-03-31   \n",
      "58297  2014-08-06 00:00:00+00:00   50229510  1612389  74460D109  2009-03-31   \n",
      "58298  2014-08-06 00:00:00+00:00   50229509  1612389  053484101  2009-03-31   \n",
      "58299  2014-08-06 00:00:00+00:00   50229508  1612389  437306103  2009-03-31   \n",
      "58300  2014-08-06 00:00:00+00:00   50229507  1612389  101121101  2009-03-31   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "58285       0             0      0  323765.0      1269000.0        0.013195  \n",
      "58286       0             0      0  334387.0     15382000.0        0.159941  \n",
      "58287       0             0      0  347811.0      9241000.0        0.096087  \n",
      "58288       0             0      0   38582.0      2212000.0        0.023000  \n",
      "58289       0             0      0   27382.0       471000.0        0.004897  \n",
      "58290       0             0      0  173058.0      5752000.0        0.059809  \n",
      "58291       0             0      0  170526.0      1173000.0        0.012197  \n",
      "58292       0             0      0  152838.0      1651000.0        0.017167  \n",
      "58293       0             0      0  419522.0      4451000.0        0.046281  \n",
      "58294       0             0      0  891677.0     29042000.0        0.301977  \n",
      "58295       0             0      0  150345.0      1146000.0        0.011916  \n",
      "58296       0             0      0   22530.0       146000.0        0.001518  \n",
      "58297       0             0      0  161814.0      8940000.0        0.092957  \n",
      "58298       0             0      0  107060.0      5038000.0        0.052385  \n",
      "58299       0             0      0  196065.0      6009000.0        0.062481  \n",
      "58300       0             0      0  121337.0      4250000.0        0.044191  \n",
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "61806  2014-08-04 00:00:00+00:00   50173071  1612389  44107P104  2008-12-31   \n",
      "61807  2014-08-04 00:00:00+00:00   50173070  1612389  313747206  2008-12-31   \n",
      "61808  2014-08-04 00:00:00+00:00   50173069  1612389  758849103  2008-12-31   \n",
      "61809  2014-08-04 00:00:00+00:00   50173068  1612389  297178105  2008-12-31   \n",
      "61810  2014-08-04 00:00:00+00:00   50173067  1612389  49427F108  2008-12-31   \n",
      "61811  2014-08-04 00:00:00+00:00   50173066  1612389  929042109  2008-12-31   \n",
      "61812  2014-08-04 00:00:00+00:00   50173065  1612389  78440X101  2008-12-31   \n",
      "61813  2014-08-04 00:00:00+00:00   50173064  1612389  004239109  2008-12-31   \n",
      "61814  2014-08-04 00:00:00+00:00   50173063  1612389  743410102  2008-12-31   \n",
      "61815  2014-08-04 00:00:00+00:00   50173062  1612389  828806109  2008-12-31   \n",
      "61816  2014-08-04 00:00:00+00:00   50173061  1612389  49446R109  2008-12-31   \n",
      "61817  2014-08-04 00:00:00+00:00   50173060  1612389  00163T109  2008-12-31   \n",
      "61818  2014-08-04 00:00:00+00:00   50173059  1612389  74460D109  2008-12-31   \n",
      "61819  2014-08-04 00:00:00+00:00   50173058  1612389  053484101  2008-12-31   \n",
      "61820  2014-08-04 00:00:00+00:00   50173057  1612389  437306103  2008-12-31   \n",
      "61821  2014-08-04 00:00:00+00:00   50173056  1612389  101121101  2008-12-31   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "61806       0             0      0  512731.0      3881000.0        0.031390  \n",
      "61807       0             0      0  430469.0     26724000.0        0.216149  \n",
      "61808       0             0      0  264068.0     12332000.0        0.099744  \n",
      "61809       0             0      0   37079.0      2846000.0        0.023019  \n",
      "61810       0             0      0   24247.0       811000.0        0.006560  \n",
      "61811       0             0      0  128945.0      7782000.0        0.062942  \n",
      "61812       0             0      0  128833.0      3337000.0        0.026990  \n",
      "61813       0             0      0  368035.0      5252000.0        0.042479  \n",
      "61814       0             0      0     161.0         4000.0        0.000032  \n",
      "61815       0             0      0  537047.0     26203000.0        0.211935  \n",
      "61816       0             0      0  104401.0      1908000.0        0.015432  \n",
      "61817       0             0      0   65043.0       903000.0        0.007304  \n",
      "61818       0             0      0  159701.0     12696000.0        0.102688  \n",
      "61819       0             0      0   71412.0      4326000.0        0.034989  \n",
      "61820       0             0      0  190572.0      7737000.0        0.062578  \n",
      "61821       0             0      0  125371.0      6895000.0        0.055768  \n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "61822  2014-08-04 00:00:00+00:00   50173055  1612389  437306103  2008-09-30   \n",
      "61823  2014-08-04 00:00:00+00:00   50173054  1612389  313747206  2008-09-30   \n",
      "61824  2014-08-04 00:00:00+00:00   50173053  1612389  44107P104  2008-09-30   \n",
      "61825  2014-08-04 00:00:00+00:00   50173052  1612389  758849103  2008-09-30   \n",
      "61826  2014-08-04 00:00:00+00:00   50173051  1612389  297178105  2008-09-30   \n",
      "61827  2014-08-04 00:00:00+00:00   50173050  1612389  49427F108  2008-09-30   \n",
      "61828  2014-08-04 00:00:00+00:00   50173049  1612389  929042109  2008-09-30   \n",
      "61829  2014-08-04 00:00:00+00:00   50173048  1612389  828806109  2008-09-30   \n",
      "61830  2014-08-04 00:00:00+00:00   50173047  1612389  78440X101  2008-09-30   \n",
      "61831  2014-08-04 00:00:00+00:00   50173046  1612389  004239109  2008-09-30   \n",
      "61832  2014-08-04 00:00:00+00:00   50173045  1612389  743410102  2008-09-30   \n",
      "61833  2014-08-04 00:00:00+00:00   50173044  1612389  05564E106  2008-09-30   \n",
      "61834  2014-08-04 00:00:00+00:00   50173043  1612389  49446R109  2008-09-30   \n",
      "61835  2014-08-04 00:00:00+00:00   50173042  1612389  00163T109  2008-09-30   \n",
      "61836  2014-08-04 00:00:00+00:00   50173041  1612389  74460D109  2008-09-30   \n",
      "61837  2014-08-04 00:00:00+00:00   50173040  1612389  053484101  2008-09-30   \n",
      "61838  2014-08-04 00:00:00+00:00   50173039  1612389  015271109  2008-09-30   \n",
      "61839  2014-08-04 00:00:00+00:00   50173038  1612389  101121101  2008-09-30   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "61822       0             0      0  197415.0     11440000.0        0.066450  \n",
      "61823       0             0      0  448142.0     38361000.0        0.222823  \n",
      "61824       0             0      0  640796.0      8516000.0        0.049466  \n",
      "61825       0             0      0   60823.0      4056000.0        0.023560  \n",
      "61826       0             0      0   46820.0      5540000.0        0.032180  \n",
      "61827       0             0      0   24818.0      1186000.0        0.006889  \n",
      "61828       0             0      0   97620.0      8879000.0        0.051574  \n",
      "61829       0             0      0  318433.0     28365000.0        0.164760  \n",
      "61830       0             0      0   76708.0      4971000.0        0.028875  \n",
      "61831       0             0      0  248200.0      6274000.0        0.036443  \n",
      "61832       0             0      0  117397.0      5318000.0        0.030890  \n",
      "61833       0             0      0  107937.0      5289000.0        0.030722  \n",
      "61834       0             0      0   61284.0      2264000.0        0.013151  \n",
      "61835       0             0      0   31085.0      1283000.0        0.007452  \n",
      "61836       0             0      0  175572.0     17383000.0        0.100971  \n",
      "61837       0             0      0   64505.0      6349000.0        0.036879  \n",
      "61838       0             0      0   41315.0      4648000.0        0.026998  \n",
      "61839       0             0      0  128520.0     12037000.0        0.069918  \n",
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "61840  2014-08-04 00:00:00+00:00   50173037  1612389  437306103  2008-06-30   \n",
      "61841  2014-08-04 00:00:00+00:00   50173036  1612389  313747206  2008-06-30   \n",
      "61842  2014-08-04 00:00:00+00:00   50173035  1612389  44107P104  2008-06-30   \n",
      "61843  2014-08-04 00:00:00+00:00   50173034  1612389  758849103  2008-06-30   \n",
      "61844  2014-08-04 00:00:00+00:00   50173033  1612389  297178105  2008-06-30   \n",
      "61845  2014-08-04 00:00:00+00:00   50173032  1612389  49427F108  2008-06-30   \n",
      "61846  2014-08-04 00:00:00+00:00   50173031  1612389  929042109  2008-06-30   \n",
      "61847  2014-08-04 00:00:00+00:00   50173030  1612389  554489104  2008-06-30   \n",
      "61848  2014-08-04 00:00:00+00:00   50173029  1612389  78440X101  2008-06-30   \n",
      "61849  2014-08-04 00:00:00+00:00   50173028  1612389  004239109  2008-06-30   \n",
      "61850  2014-08-04 00:00:00+00:00   50173027  1612389  743410102  2008-06-30   \n",
      "61851  2014-08-04 00:00:00+00:00   50173026  1612389  05564E106  2008-06-30   \n",
      "61852  2014-08-04 00:00:00+00:00   50173025  1612389  49446R109  2008-06-30   \n",
      "61853  2014-08-04 00:00:00+00:00   50173024  1612389  00163T109  2008-06-30   \n",
      "61854  2014-08-04 00:00:00+00:00   50173023  1612389  74460D109  2008-06-30   \n",
      "61855  2014-08-04 00:00:00+00:00   50173022  1612389  053484101  2008-06-30   \n",
      "61856  2014-08-04 00:00:00+00:00   50173021  1612389  015271109  2008-06-30   \n",
      "61857  2014-08-04 00:00:00+00:00   50173020  1612389  828806109  2008-06-30   \n",
      "61858  2014-08-04 00:00:00+00:00   50173019  1612389  101121101  2008-06-30   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "61840       0             0      0  147568.0      7092000.0        0.053493  \n",
      "61841       0             0      0  334684.0     23093000.0        0.174183  \n",
      "61842       0             0      0  340431.0      4647000.0        0.035051  \n",
      "61843       0             0      0   37897.0      2240000.0        0.016896  \n",
      "61844       0             0      0   17066.0      1818000.0        0.013713  \n",
      "61845       0             0      0   50818.0      2390000.0        0.018027  \n",
      "61846       0             0      0   70659.0      6218000.0        0.046900  \n",
      "61847       0             0      0   38434.0      1313000.0        0.009904  \n",
      "61848       0             0      0  108875.0      9006000.0        0.067929  \n",
      "61849       0             0      0  186803.0      4324000.0        0.032614  \n",
      "61850       0             0      0  137358.0      6920000.0        0.052195  \n",
      "61851       0             0      0  122937.0      5321000.0        0.040135  \n",
      "61852       0             0      0   45299.0      1564000.0        0.011797  \n",
      "61853       0             0      0   25308.0      1275000.0        0.009617  \n",
      "61854       0             0      0  162651.0     13141000.0        0.099118  \n",
      "61855       0             0      0   49950.0      4454000.0        0.033595  \n",
      "61856       0             0      0   52055.0      5067000.0        0.038219  \n",
      "61857       0             0      0  212193.0     19074000.0        0.143869  \n",
      "61858       0             0      0  150991.0     13622000.0        0.102746  \n",
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "61859  2014-08-04 00:00:00+00:00   50173018  1612389  437306103  2008-03-31   \n",
      "61860  2014-08-04 00:00:00+00:00   50173017  1612389  313747206  2008-03-31   \n",
      "61861  2014-08-04 00:00:00+00:00   50173016  1612389  44107P104  2008-03-31   \n",
      "61862  2014-08-04 00:00:00+00:00   50173015  1612389  758849103  2008-03-31   \n",
      "61863  2014-08-04 00:00:00+00:00   50173014  1612389  297178105  2008-03-31   \n",
      "61864  2014-08-04 00:00:00+00:00   50173013  1612389  49427F108  2008-03-31   \n",
      "61865  2014-08-04 00:00:00+00:00   50173012  1612389  929042109  2008-03-31   \n",
      "61866  2014-08-04 00:00:00+00:00   50173011  1612389  554489104  2008-03-31   \n",
      "61867  2014-08-04 00:00:00+00:00   50173010  1612389  30225T102  2008-03-31   \n",
      "61868  2014-08-04 00:00:00+00:00   50173009  1612389  78440X101  2008-03-31   \n",
      "61869  2014-08-04 00:00:00+00:00   50173008  1612389  004239109  2008-03-31   \n",
      "61870  2014-08-04 00:00:00+00:00   50173007  1612389  743410102  2008-03-31   \n",
      "61871  2014-08-04 00:00:00+00:00   50173006  1612389  05564E106  2008-03-31   \n",
      "61872  2014-08-04 00:00:00+00:00   50173005  1612389  49446R109  2008-03-31   \n",
      "61873  2014-08-04 00:00:00+00:00   50173004  1612389  00163T109  2008-03-31   \n",
      "61874  2014-08-04 00:00:00+00:00   50173003  1612389  74460D109  2008-03-31   \n",
      "61875  2014-08-04 00:00:00+00:00   50173002  1612389  053484101  2008-03-31   \n",
      "61876  2014-08-04 00:00:00+00:00   50173001  1612389  015271109  2008-03-31   \n",
      "61877  2014-08-04 00:00:00+00:00   50173000  1612389  828806109  2008-03-31   \n",
      "61878  2014-08-04 00:00:00+00:00   50172999  1612389  101121101  2008-03-31   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "61859       0             0      0   27674.0      1328000.0        0.008448  \n",
      "61860       0             0      0  333414.0     25990000.0        0.165330  \n",
      "61861       0             0      0  406109.0      6465000.0        0.041126  \n",
      "61862       0             0      0   48897.0      3167000.0        0.020146  \n",
      "61863       0             0      0   17692.0      2017000.0        0.012831  \n",
      "61864       0             0      0   55932.0      2747000.0        0.017474  \n",
      "61865       0             0      0   57209.0      4932000.0        0.031374  \n",
      "61866       0             0      0   76548.0      2734000.0        0.017392  \n",
      "61867       0             0      0   64856.0      1050000.0        0.006679  \n",
      "61868       0             0      0  108875.0      8870000.0        0.056425  \n",
      "61869       0             0      0  138803.0      3352000.0        0.021323  \n",
      "61870       0             0      0   70142.0      3817000.0        0.024281  \n",
      "61871       0             0      0  227225.0     10352000.0        0.065852  \n",
      "61872       0             0      0   53299.0      2088000.0        0.013282  \n",
      "61873       0             0      0   99538.0      5417000.0        0.034459  \n",
      "61874       0             0      0  207281.0     18369000.0        0.116850  \n",
      "61875       0             0      0   49950.0      4821000.0        0.030668  \n",
      "61876       0             0      0   66555.0      6171000.0        0.039255  \n",
      "61877       0             0      0  257779.0     23950000.0        0.152353  \n",
      "61878       0             0      0  212491.0     19564000.0        0.124452  \n",
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "61879  2014-08-04 00:00:00+00:00   50172998  1612389  437306103  2007-12-31   \n",
      "61880  2014-08-04 00:00:00+00:00   50172997  1612389  313747206  2007-12-31   \n",
      "61881  2014-08-04 00:00:00+00:00   50172996  1612389  44107P104  2007-12-31   \n",
      "61882  2014-08-04 00:00:00+00:00   50172995  1612389  758849103  2007-12-31   \n",
      "61883  2014-08-04 00:00:00+00:00   50172994  1612389  297178105  2007-12-31   \n",
      "61884  2014-08-04 00:00:00+00:00   50172993  1612389  49427F108  2007-12-31   \n",
      "61885  2014-08-04 00:00:00+00:00   50172992  1612389  929042109  2007-12-31   \n",
      "61886  2014-08-04 00:00:00+00:00   50172991  1612389  554489104  2007-12-31   \n",
      "61887  2014-08-04 00:00:00+00:00   50172990  1612389  78440X101  2007-12-31   \n",
      "61888  2014-08-04 00:00:00+00:00   50172989  1612389  004239109  2007-12-31   \n",
      "61889  2014-08-04 00:00:00+00:00   50172988  1612389  743410102  2007-12-31   \n",
      "61890  2014-08-04 00:00:00+00:00   50172987  1612389  05564E106  2007-12-31   \n",
      "61891  2014-08-04 00:00:00+00:00   50172986  1612389  49446R109  2007-12-31   \n",
      "61892  2014-08-04 00:00:00+00:00   50172985  1612389  517942108  2007-12-31   \n",
      "61893  2014-08-04 00:00:00+00:00   50172984  1612389  00163T109  2007-12-31   \n",
      "61894  2014-08-04 00:00:00+00:00   50172983  1612389  74460D109  2007-12-31   \n",
      "61895  2014-08-04 00:00:00+00:00   50172982  1612389  053484101  2007-12-31   \n",
      "61896  2014-08-04 00:00:00+00:00   50172981  1612389  015271109  2007-12-31   \n",
      "61897  2014-08-04 00:00:00+00:00   50172980  1612389  828806109  2007-12-31   \n",
      "61898  2014-08-04 00:00:00+00:00   50172979  1612389  101121101  2007-12-31   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "61879       0             0      0   34174.0      1533000.0        0.010747  \n",
      "61880       0             0      0  191965.0     15770000.0        0.110554  \n",
      "61881       0             0      0  530049.0      9032000.0        0.063318  \n",
      "61882       0             0      0   48897.0      3153000.0        0.022104  \n",
      "61883       0             0      0    4000.0       390000.0        0.002734  \n",
      "61884       0             0      0   44352.0      2438000.0        0.017091  \n",
      "61885       0             0      0  148522.0     13063000.0        0.091577  \n",
      "61886       0             0      0   42892.0      1458000.0        0.010221  \n",
      "61887       0             0      0  196030.0     18321000.0        0.128438  \n",
      "61888       0             0      0  126343.0      3236000.0        0.022686  \n",
      "61889       0             0      0   73692.0      4242000.0        0.029738  \n",
      "61890       0             0      0  234553.0      9506000.0        0.066641  \n",
      "61891       0             0      0   40073.0      1459000.0        0.010228  \n",
      "61892       0             0      0   43567.0      1390000.0        0.009744  \n",
      "61893       0             0      0   79494.0      4576000.0        0.032080  \n",
      "61894       0             0      0  165788.0     12170000.0        0.085317  \n",
      "61895       0             0      0   23175.0      2182000.0        0.015297  \n",
      "61896       0             0      0   26785.0      2723000.0        0.019089  \n",
      "61897       0             0      0  190819.0     16575000.0        0.116198  \n",
      "61898       0             0      0  211611.0     19428000.0        0.136198  \n",
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "61899  2014-08-04 00:00:00+00:00   50172978  1612389  44107P104  2007-09-30   \n",
      "61900  2014-08-04 00:00:00+00:00   50172977  1612389  313747206  2007-09-30   \n",
      "61901  2014-08-04 00:00:00+00:00   50172976  1612389  758849103  2007-09-30   \n",
      "61902  2014-08-04 00:00:00+00:00   50172975  1612389  297178105  2007-09-30   \n",
      "61903  2014-08-04 00:00:00+00:00   50172974  1612389  49427F108  2007-09-30   \n",
      "61904  2014-08-04 00:00:00+00:00   50172973  1612389  929042109  2007-09-30   \n",
      "61905  2014-08-04 00:00:00+00:00   50172972  1612389  554489104  2007-09-30   \n",
      "61906  2014-08-04 00:00:00+00:00   50172971  1612389  78440X101  2007-09-30   \n",
      "61907  2014-08-04 00:00:00+00:00   50172970  1612389  004239109  2007-09-30   \n",
      "61908  2014-08-04 00:00:00+00:00   50172969  1612389  743410102  2007-09-30   \n",
      "61909  2014-08-04 00:00:00+00:00   50172968  1612389  05564E106  2007-09-30   \n",
      "61910  2014-08-04 00:00:00+00:00   50172967  1612389  49446R109  2007-09-30   \n",
      "61911  2014-08-04 00:00:00+00:00   50172966  1612389  517942108  2007-09-30   \n",
      "61912  2014-08-04 00:00:00+00:00   50172965  1612389  00163T109  2007-09-30   \n",
      "61913  2014-08-04 00:00:00+00:00   50172964  1612389  74460D109  2007-09-30   \n",
      "61914  2014-08-04 00:00:00+00:00   50172963  1612389  053484101  2007-09-30   \n",
      "61915  2014-08-04 00:00:00+00:00   50172962  1612389  437306103  2007-09-30   \n",
      "61916  2014-08-04 00:00:00+00:00   50172961  1612389  828806109  2007-09-30   \n",
      "61917  2014-08-04 00:00:00+00:00   50172960  1612389  101121101  2007-09-30   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "61899       0             0      0  546076.0     12254000.0        0.070090  \n",
      "61900       0             0      0  269114.0     23844000.0        0.136382  \n",
      "61901       0             0      0   48897.0      3753000.0        0.021466  \n",
      "61902       0             0      0    4000.0       470000.0        0.002688  \n",
      "61903       0             0      0   37898.0      2298000.0        0.013144  \n",
      "61904       0             0      0  175631.0     19205000.0        0.109848  \n",
      "61905       0             0      0   25791.0      1060000.0        0.006063  \n",
      "61906       0             0      0  229930.0     26849000.0        0.153570  \n",
      "61907       0             0      0  126343.0      3428000.0        0.019607  \n",
      "61908       0             0      0  220942.0     13215000.0        0.075587  \n",
      "61909       0             0      0  344528.0     19269000.0        0.110214  \n",
      "61910       0             0      0   83990.0      3797000.0        0.021718  \n",
      "61911       0             0      0   49904.0      2100000.0        0.012011  \n",
      "61912       0             0      0  182475.0     10914000.0        0.062426  \n",
      "61913       0             0      0   14393.0      1132000.0        0.006475  \n",
      "61914       0             0      0   24766.0      2924000.0        0.016725  \n",
      "61915       0             0      0   19529.0      1019000.0        0.005828  \n",
      "61916       0             0      0   59790.0      5979000.0        0.034198  \n",
      "61917       0             0      0  205221.0     21322000.0        0.121957  \n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "61918  2014-08-04 00:00:00+00:00   50172959  1612389  44107P104  2007-06-30   \n",
      "61919  2014-08-04 00:00:00+00:00   50172958  1612389  313747206  2007-06-30   \n",
      "61920  2014-08-04 00:00:00+00:00   50172957  1612389  554382101  2007-06-30   \n",
      "61921  2014-08-04 00:00:00+00:00   50172956  1612389  758849103  2007-06-30   \n",
      "61922  2014-08-04 00:00:00+00:00   50172955  1612389  49427F108  2007-06-30   \n",
      "61923  2014-08-04 00:00:00+00:00   50172954  1612389  929042109  2007-06-30   \n",
      "61924  2014-08-04 00:00:00+00:00   50172953  1612389  828806109  2007-06-30   \n",
      "61925  2014-08-04 00:00:00+00:00   50172952  1612389  743410102  2007-06-30   \n",
      "61926  2014-08-04 00:00:00+00:00   50172951  1612389  78440X101  2007-06-30   \n",
      "61927  2014-08-04 00:00:00+00:00   50172950  1612389  004239109  2007-06-30   \n",
      "61928  2014-08-04 00:00:00+00:00   50172949  1612389  370021107  2007-06-30   \n",
      "61929  2014-08-04 00:00:00+00:00   50172948  1612389  05564E106  2007-06-30   \n",
      "61930  2014-08-04 00:00:00+00:00   50172947  1612389  49446R109  2007-06-30   \n",
      "61931  2014-08-04 00:00:00+00:00   50172946  1612389  517942108  2007-06-30   \n",
      "61932  2014-08-04 00:00:00+00:00   50172945  1612389  00163T109  2007-06-30   \n",
      "61933  2014-08-04 00:00:00+00:00   50172944  1612389  053484101  2007-06-30   \n",
      "61934  2014-08-04 00:00:00+00:00   50172943  1612389  437306103  2007-06-30   \n",
      "61935  2014-08-04 00:00:00+00:00   50172942  1612389  101121101  2007-06-30   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "61918       0             0      0  874291.0     20214000.0        0.110159  \n",
      "61919       0             0      0  232000.0     17924000.0        0.097679  \n",
      "61920       0             0      0   12175.0      1003000.0        0.005466  \n",
      "61921       0             0      0   77158.0      5440000.0        0.029646  \n",
      "61922       0             0      0   50598.0      3584000.0        0.019531  \n",
      "61923       0             0      0  150238.0     16502000.0        0.089930  \n",
      "61924       0             0      0   22100.0      2056000.0        0.011204  \n",
      "61925       0             0      0  307154.0     17477000.0        0.095243  \n",
      "61926       0             0      0  296862.0     36778000.0        0.200426  \n",
      "61927       0             0      0   63000.0      1635000.0        0.008910  \n",
      "61928       0             0      0   29638.0      1569000.0        0.008550  \n",
      "61929       0             0      0  466115.0     27636000.0        0.150606  \n",
      "61930       0             0      0   90843.0      3458000.0        0.018845  \n",
      "61931       0             0      0   23757.0      1032000.0        0.005624  \n",
      "61932       0             0      0   76994.0      4168000.0        0.022714  \n",
      "61933       0             0      0   16235.0      1930000.0        0.010518  \n",
      "61934       0             0      0   16129.0       838000.0        0.004567  \n",
      "61935       0             0      0  198324.0     20255000.0        0.110382  \n",
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "61936  2014-08-04 00:00:00+00:00   50172941  1612389  758849103  2007-03-31   \n",
      "61937  2014-08-04 00:00:00+00:00   50172940  1612389  313747206  2007-03-31   \n",
      "61938  2014-08-04 00:00:00+00:00   50172939  1612389  039583109  2007-03-31   \n",
      "61939  2014-08-04 00:00:00+00:00   50172938  1612389  554382101  2007-03-31   \n",
      "61940  2014-08-04 00:00:00+00:00   50172937  1612389  49427F108  2007-03-31   \n",
      "61941  2014-08-04 00:00:00+00:00   50172936  1612389  929042109  2007-03-31   \n",
      "61942  2014-08-04 00:00:00+00:00   50172935  1612389  828806109  2007-03-31   \n",
      "61943  2014-08-04 00:00:00+00:00   50172934  1612389  743410102  2007-03-31   \n",
      "61944  2014-08-04 00:00:00+00:00   50172933  1612389  78440X101  2007-03-31   \n",
      "61945  2014-08-04 00:00:00+00:00   50172932  1612389  004239109  2007-03-31   \n",
      "61946  2014-08-04 00:00:00+00:00   50172931  1612389  370021107  2007-03-31   \n",
      "61947  2014-08-04 00:00:00+00:00   50172930  1612389  05564E106  2007-03-31   \n",
      "61948  2014-08-04 00:00:00+00:00   50172929  1612389  49446R109  2007-03-31   \n",
      "61949  2014-08-04 00:00:00+00:00   50172928  1612389  00163T109  2007-03-31   \n",
      "61950  2014-08-04 00:00:00+00:00   50172927  1612389  053484101  2007-03-31   \n",
      "61951  2014-08-04 00:00:00+00:00   50172926  1612389  44107P104  2007-03-31   \n",
      "61952  2014-08-04 00:00:00+00:00   50172925  1612389  101121101  2007-03-31   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "61936       0             0      0   82565.0      6898000.0        0.040503  \n",
      "61937       0             0      0  239724.0     21724000.0        0.127557  \n",
      "61938       0             0      0   27867.0      1513000.0        0.008884  \n",
      "61939       0             0      0   19379.0      1790000.0        0.010510  \n",
      "61940       0             0      0   50598.0      3732000.0        0.021913  \n",
      "61941       0             0      0   52483.0      6263000.0        0.036775  \n",
      "61942       0             0      0   22100.0      2459000.0        0.014438  \n",
      "61943       0             0      0  293868.0     19081000.0        0.112038  \n",
      "61944       0             0      0  274626.0     37673000.0        0.221205  \n",
      "61945       0             0      0   55000.0      1434000.0        0.008420  \n",
      "61946       0             0      0   26180.0      1690000.0        0.009923  \n",
      "61947       0             0      0  302984.0     19133000.0        0.112344  \n",
      "61948       0             0      0  131313.0      6400000.0        0.037579  \n",
      "61949       0             0      0   73294.0      4309000.0        0.025301  \n",
      "61950       0             0      0    6000.0       780000.0        0.004580  \n",
      "61951       0             0      0  472357.0     12428000.0        0.072974  \n",
      "61952       0             0      0  195924.0     23001000.0        0.135055  \n",
      "                            date  record_id     iCIK   stock_id  period_end  \\\n",
      "61953  2014-08-04 00:00:00+00:00   50172924  1612389  758849103  2006-12-31   \n",
      "61954  2014-08-04 00:00:00+00:00   50172923  1612389  313747206  2006-12-31   \n",
      "61955  2014-08-04 00:00:00+00:00   50172922  1612389  039583109  2006-12-31   \n",
      "61956  2014-08-04 00:00:00+00:00   50172921  1612389  49427F108  2006-12-31   \n",
      "61957  2014-08-04 00:00:00+00:00   50172920  1612389  929042109  2006-12-31   \n",
      "61958  2014-08-04 00:00:00+00:00   50172919  1612389  78440X101  2006-12-31   \n",
      "61959  2014-08-04 00:00:00+00:00   50172918  1612389  101121101  2006-12-31   \n",
      "61960  2014-08-04 00:00:00+00:00   50172917  1612389  554382101  2006-12-31   \n",
      "61961  2014-08-04 00:00:00+00:00   50172916  1612389  828806109  2006-12-31   \n",
      "61962  2014-08-04 00:00:00+00:00   50172915  1612389  49446R109  2006-12-31   \n",
      "61963  2014-08-04 00:00:00+00:00   50172914  1612389  00163T109  2006-12-31   \n",
      "61964  2014-08-04 00:00:00+00:00   50172913  1612389  44107P104  2006-12-31   \n",
      "61965  2014-08-04 00:00:00+00:00   50172912  1612389  743410102  2006-12-31   \n",
      "\n",
      "       iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "61953       0             0      0   80921.0      6326000.0        0.040325  \n",
      "61954       0             0      0  260358.0     22130000.0        0.141067  \n",
      "61955       0             0      0  363781.0     21176000.0        0.134986  \n",
      "61956       0             0      0  225538.0     17592000.0        0.112140  \n",
      "61957       0             0      0  137642.0     16724000.0        0.106606  \n",
      "61958       0             0      0  154425.0     20505000.0        0.130708  \n",
      "61959       0             0      0   75434.0      8440000.0        0.053801  \n",
      "61960       0             0      0   25995.0      2250000.0        0.014343  \n",
      "61961       0             0      0   14400.0      1459000.0        0.009300  \n",
      "61962       0             0      0  353200.0     15876000.0        0.101201  \n",
      "61963       0             0      0   88294.0      5175000.0        0.032988  \n",
      "61964       0             0      0   76900.0      1888000.0        0.012035  \n",
      "61965       0             0      0  285248.0     17335000.0        0.110501  \n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "348317   2014-11-24 00:00:00+00:00   48096971  1592616  863667101  2014-09-30   \n",
      "348318   2014-11-24 00:00:00+00:00   48096970  1592616  G97822103  2014-09-30   \n",
      "348319   2014-11-24 00:00:00+00:00   48096969  1592616  00724F101  2014-09-30   \n",
      "348320   2014-11-24 00:00:00+00:00   48096968  1592616  594918104  2014-09-30   \n",
      "348321   2014-11-24 00:00:00+00:00   48096967  1592616  263534109  2014-09-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1820479  2019-08-21 00:00:00+00:00   71733792  1546865  002824100  2014-09-30   \n",
      "1820480  2019-08-21 00:00:00+00:00   71733793  1546865  713448108  2014-09-30   \n",
      "1820481  2019-08-21 00:00:00+00:00   71733794  1546865  594918104  2014-09-30   \n",
      "1820482  2019-08-21 00:00:00+00:00   71733795  1546865  464287614  2014-09-30   \n",
      "1820483  2019-08-21 00:00:00+00:00   71733796  1546865  863667101  2014-09-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE     iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "348317        0             0      0   6240.0       504000.0        0.003549  \n",
      "348318        0             0      0   3220.0       483000.0        0.003401  \n",
      "348319        0             0      0   2380.0       165000.0        0.001162  \n",
      "348320        0             0      0  63637.0      2951000.0        0.020782  \n",
      "348321        0             0      0  15100.0      1084000.0        0.007634  \n",
      "...         ...           ...    ...      ...            ...             ...  \n",
      "1820479       0             0      0  59552.0      2477000.0        0.015734  \n",
      "1820480       0             0      0   5315.0       495000.0        0.003144  \n",
      "1820481       0             0      0   9354.0       434000.0        0.002757  \n",
      "1820482       0             0      0  79576.0      7292000.0        0.046320  \n",
      "1820483       0             0      0  21360.0      1725000.0        0.010958  \n",
      "\n",
      "[60412 rows x 11 columns]\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "503653   2015-04-01 00:00:00+00:00   51925325   811360  235851102  2015-03-31   \n",
      "503654   2015-04-01 00:00:00+00:00   51925326   811360  717081103  2015-03-31   \n",
      "503655   2015-04-01 00:00:00+00:00   51925327   811360  053015103  2015-03-31   \n",
      "503656   2015-04-01 00:00:00+00:00   51925328   811360  871829107  2015-03-31   \n",
      "503657   2015-04-01 00:00:00+00:00   51925329   811360  931427108  2015-03-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1820267  2019-08-21 00:00:00+00:00   71733580  1546865  713448108  2015-03-31   \n",
      "1820268  2019-08-21 00:00:00+00:00   71733581  1546865  263534109  2015-03-31   \n",
      "1820269  2019-08-21 00:00:00+00:00   71733582  1546865  594918104  2015-03-31   \n",
      "1820270  2019-08-21 00:00:00+00:00   71733583  1546865  464287614  2015-03-31   \n",
      "1820271  2019-08-21 00:00:00+00:00   71733584  1546865  863667101  2015-03-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "503653        0             0      0  181818.0     15436000.0        0.035473  \n",
      "503654        0             0      0   13572.0       472000.0        0.001085  \n",
      "503655        0             0      0   23509.0      2013000.0        0.004626  \n",
      "503656        0             0      0    6335.0       239000.0        0.000549  \n",
      "503657        0             0      0   12776.0      1082000.0        0.002486  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1820267       0             0      0    6340.0       606000.0        0.003315  \n",
      "1820268       0             0      0    3360.0       240000.0        0.001313  \n",
      "1820269       0             0      0   12999.0       529000.0        0.002894  \n",
      "1820270       0             0      0   82377.0      8149000.0        0.044574  \n",
      "1820271       0             0      0   23440.0      2162000.0        0.011826  \n",
      "\n",
      "[66548 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "568803   2015-07-01 00:00:00+00:00   53023731   811360  235851102  2015-06-30   \n",
      "568804   2015-07-01 00:00:00+00:00   53023732   811360  717081103  2015-06-30   \n",
      "568805   2015-07-01 00:00:00+00:00   53023733   811360  053015103  2015-06-30   \n",
      "568806   2015-07-01 00:00:00+00:00   53023734   811360  871829107  2015-06-30   \n",
      "568807   2015-07-01 00:00:00+00:00   53023735   811360  731068102  2015-06-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1820154  2019-08-21 00:00:00+00:00   71733467  1546865  263534109  2015-06-30   \n",
      "1820155  2019-08-21 00:00:00+00:00   71733468  1546865  594918104  2015-06-30   \n",
      "1820156  2019-08-21 00:00:00+00:00   71733469  1546865  464287614  2015-06-30   \n",
      "1820157  2019-08-21 00:00:00+00:00   71733470  1546865  69404d108  2015-06-30   \n",
      "1820158  2019-08-21 00:00:00+00:00   71733471  1546865  863667101  2015-06-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "568803        0             0      0  181983.0     15576000.0        0.035591  \n",
      "568804        0             0      0   13572.0       455000.0        0.001040  \n",
      "568805        0             0      0   23509.0      1886000.0        0.004310  \n",
      "568806        0             0      0    6335.0       229000.0        0.000523  \n",
      "568807        0             0      0   58706.0      8695000.0        0.019868  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1820154       0             0      0    3360.0       215000.0        0.001183  \n",
      "1820155       0             0      0   12989.0       574000.0        0.003157  \n",
      "1820156       0             0      0   81572.0      8076000.0        0.044424  \n",
      "1820157       0             0      0   10000.0        58000.0        0.000319  \n",
      "1820158       0             0      0   23905.0      2285000.0        0.012569  \n",
      "\n",
      "[66556 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "634434   2015-10-01 00:00:00+00:00   54131582   919538  29265n108  2015-09-30   \n",
      "634435   2015-10-01 00:00:00+00:00   54131583   919538  87422j105  2015-09-30   \n",
      "634436   2015-10-01 00:00:00+00:00   54131584   919538  48123v102  2015-09-30   \n",
      "634437   2015-10-01 00:00:00+00:00   54131585   919538  26875p101  2015-09-30   \n",
      "634438   2015-10-01 00:00:00+00:00   54131586   919538  55405w104  2015-09-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1820039  2019-08-21 00:00:00+00:00   71733352  1546865  713448108  2015-09-30   \n",
      "1820040  2019-08-21 00:00:00+00:00   71733353  1546865  594918104  2015-09-30   \n",
      "1820041  2019-08-21 00:00:00+00:00   71733354  1546865  464287614  2015-09-30   \n",
      "1820042  2019-08-21 00:00:00+00:00   71733355  1546865  15135b101  2015-09-30   \n",
      "1820043  2019-08-21 00:00:00+00:00   71733356  1546865  863667101  2015-09-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "634434        0             0      0  175431.0      8747000.0        0.022690  \n",
      "634435        0             0      0   36526.0       369000.0        0.000957  \n",
      "634436        0             0      0  100255.0      7103000.0        0.018425  \n",
      "634437        0             0      0  138888.0     10111000.0        0.026228  \n",
      "634438        0             0      0  438572.0     11491000.0        0.029807  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1820039       0             0      0    6340.0       598000.0        0.003570  \n",
      "1820040       0             0      0   12249.0       542000.0        0.003236  \n",
      "1820041       0             0      0   80792.0      7514000.0        0.044856  \n",
      "1820042       0             0      0    4485.0       243000.0        0.001451  \n",
      "1820043       0             0      0   24195.0      2277000.0        0.013593  \n",
      "\n",
      "[63923 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "698476   2016-01-04 00:00:00+00:00   55213264  1509508  88579y101  2015-12-31   \n",
      "698477   2016-01-04 00:00:00+00:00   55213265  1509508  210771200  2015-12-31   \n",
      "698478   2016-01-04 00:00:00+00:00   55213266  1509508  69840w108  2015-12-31   \n",
      "698479   2016-01-04 00:00:00+00:00   55213267  1509508  717081103  2015-12-31   \n",
      "698480   2016-01-04 00:00:00+00:00   55213268  1509508  037411105  2015-12-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1819934  2019-08-21 00:00:00+00:00   71733247  1546865  594918104  2015-12-31   \n",
      "1819935  2019-08-21 00:00:00+00:00   71733248  1546865  464287614  2015-12-31   \n",
      "1819936  2019-08-21 00:00:00+00:00   71733249  1546865  83190l208  2015-12-31   \n",
      "1819937  2019-08-21 00:00:00+00:00   71733250  1546865  15135b101  2015-12-31   \n",
      "1819938  2019-08-21 00:00:00+00:00   71733251  1546865  863667101  2015-12-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "698476        0             0      0    2401.0       362000.0        0.001761  \n",
      "698477        0             0      0    5960.0       287000.0        0.001396  \n",
      "698478        0             0      0    1290.0       252000.0        0.001226  \n",
      "698479        0             0      0   38832.0      1254000.0        0.006100  \n",
      "698480        0             0      0   13468.0       599000.0        0.002914  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1819934       0             0      0   12149.0       674000.0        0.003760  \n",
      "1819935       0             0      0  116027.0     11543000.0        0.064402  \n",
      "1819936       0             0      0   35280.0       568000.0        0.003169  \n",
      "1819937       0             0      0    8335.0       549000.0        0.003063  \n",
      "1819938       0             0      0   24490.0      2276000.0        0.012698  \n",
      "\n",
      "[64752 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "762432   2016-04-01 00:00:00+00:00   56220906  1509508  88579y101  2016-03-31   \n",
      "762433   2016-04-01 00:00:00+00:00   56220907  1509508  210771200  2016-03-31   \n",
      "762434   2016-04-01 00:00:00+00:00   56220908  1509508  69840w108  2016-03-31   \n",
      "762435   2016-04-01 00:00:00+00:00   56220909  1509508  717081103  2016-03-31   \n",
      "762436   2016-04-01 00:00:00+00:00   56220910  1509508  037411105  2016-03-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1819829  2019-08-21 00:00:00+00:00   71731811  1546865  594918104  2016-03-31   \n",
      "1819830  2019-08-21 00:00:00+00:00   71731812  1546865  464287614  2016-03-31   \n",
      "1819831  2019-08-21 00:00:00+00:00   71731813  1546865  83190l208  2016-03-31   \n",
      "1819832  2019-08-21 00:00:00+00:00   71731814  1546865  15135b101  2016-03-31   \n",
      "1819833  2019-08-21 00:00:00+00:00   71731815  1546865  863667101  2016-03-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "762432        0             0      0    2501.0       417000.0        0.002098  \n",
      "762433        0             0      0    5960.0       270000.0        0.001359  \n",
      "762434        0             0      0    1290.0       264000.0        0.001328  \n",
      "762435        0             0      0   38200.0      1132000.0        0.005696  \n",
      "762436        0             0      0   22820.0      1114000.0        0.005605  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1819829       0             0      0   12279.0       678000.0        0.003640  \n",
      "1819830       0             0      0  122057.0     12179000.0        0.065391  \n",
      "1819831       0             0      0   35280.0       653000.0        0.003506  \n",
      "1819832       0             0      0    9835.0       605000.0        0.003248  \n",
      "1819833       0             0      0   24760.0      2657000.0        0.014266  \n",
      "\n",
      "[65572 rows x 11 columns]\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "828038   2016-07-05 00:00:00+00:00   57310177  1484429  731068102  2016-06-30   \n",
      "828039   2016-07-05 00:00:00+00:00   57310178  1484429  099724106  2016-06-30   \n",
      "828040   2016-07-05 00:00:00+00:00   57310179  1484429  918204108  2016-06-30   \n",
      "828041   2016-07-05 00:00:00+00:00   57310180  1484429  032095101  2016-06-30   \n",
      "828042   2016-07-05 00:00:00+00:00   57310181  1484429  778296103  2016-06-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1819721  2019-08-21 00:00:00+00:00   71731703  1546865  n59465109  2016-06-30   \n",
      "1819722  2019-08-21 00:00:00+00:00   71731704  1546865  464287614  2016-06-30   \n",
      "1819723  2019-08-21 00:00:00+00:00   71731705  1546865  83190l208  2016-06-30   \n",
      "1819724  2019-08-21 00:00:00+00:00   71731706  1546865  15135b101  2016-06-30   \n",
      "1819725  2019-08-21 00:00:00+00:00   71731707  1546865  863667101  2016-06-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE       iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "828038        0             0      0   550000.0     44962000.0        0.004401  \n",
      "828039        0             0      0  7100000.0    209592000.0        0.020513  \n",
      "828040        0             0      0  6141000.0    377549000.0        0.036951  \n",
      "828041        0             0      0  3245000.0    186003000.0        0.018204  \n",
      "828042        0             0      0  5000000.0    283400000.0        0.027737  \n",
      "...         ...           ...    ...        ...            ...             ...  \n",
      "1819721       0             0      0    11911.0       515000.0        0.002667  \n",
      "1819722       0             0      0   126453.0     12691000.0        0.065725  \n",
      "1819723       0             0      0    35280.0       564000.0        0.002921  \n",
      "1819724       0             0      0     9730.0       695000.0        0.003599  \n",
      "1819725       0             0      0    24792.0      2971000.0        0.015386  \n",
      "\n",
      "[66352 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "894714   2016-10-03 00:00:00+00:00   58397871  1161825  438516106  2016-09-30   \n",
      "894715   2016-10-03 00:00:00+00:00   58397872  1161825  235851102  2016-09-30   \n",
      "894716   2016-10-03 00:00:00+00:00   58397873  1161825  576314108  2016-09-30   \n",
      "894717   2016-10-03 00:00:00+00:00   58397874  1161825  91324P102  2016-09-30   \n",
      "894718   2016-10-03 00:00:00+00:00   58397875  1161825  09062X103  2016-09-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1819606  2019-08-21 00:00:00+00:00   71731588  1546865  594918104  2016-09-30   \n",
      "1819607  2019-08-21 00:00:00+00:00   71731589  1546865  464287614  2016-09-30   \n",
      "1819608  2019-08-21 00:00:00+00:00   71731590  1546865  83190l208  2016-09-30   \n",
      "1819609  2019-08-21 00:00:00+00:00   71731591  1546865  15135b101  2016-09-30   \n",
      "1819610  2019-08-21 00:00:00+00:00   71731592  1546865  863667101  2016-09-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "894714        0             0      0    2000.0       233000.0        0.002370  \n",
      "894715        0             0      0   11320.0       887000.0        0.009022  \n",
      "894716        0             0      0   20000.0         2000.0        0.000020  \n",
      "894717        0             0      0    9500.0      1330000.0        0.013528  \n",
      "894718        0             0      0    4770.0      1493000.0        0.015186  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1819606       0             0      0   21948.0      1265000.0        0.006396  \n",
      "1819607       0             0      0  126710.0     13199000.0        0.066735  \n",
      "1819608       0             0      0   35280.0       575000.0        0.002907  \n",
      "1819609       0             0      0    9710.0       650000.0        0.003286  \n",
      "1819610       0             0      0   24767.0      2883000.0        0.014577  \n",
      "\n",
      "[53514 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "947701   2017-01-03 00:00:00+00:00   59234846  1601622  75615P103  2016-12-31   \n",
      "947702   2017-01-03 00:00:00+00:00   59234847  1601622  78464A490  2016-12-31   \n",
      "947703   2017-01-03 00:00:00+00:00   59234848  1601622  464287598  2016-12-31   \n",
      "947704   2017-01-03 00:00:00+00:00   59234849  1601622  922042858  2016-12-31   \n",
      "947705   2017-01-03 00:00:00+00:00   59234850  1601622  464287234  2016-12-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1872619  2019-11-07 00:00:00+00:00   72272752  1793399  89417E109  2016-12-31   \n",
      "1872620  2019-11-07 00:00:00+00:00   72272753  1793399  478160104  2016-12-31   \n",
      "1872621  2019-11-07 00:00:00+00:00   72272754  1793399  00287Y109  2016-12-31   \n",
      "1872622  2019-11-07 00:00:00+00:00   72272755  1793399  464287655  2016-12-31   \n",
      "1872623  2019-11-07 00:00:00+00:00   72272756  1793399  92343V104  2016-12-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "947701        0             0      0   90200.0      1969000.0        0.019635  \n",
      "947702        0             0      0  106788.0      5555000.0        0.055395  \n",
      "947703        0             0      0  193762.0     21707000.0        0.216464  \n",
      "947704        0             0      0  112359.0      4020000.0        0.040088  \n",
      "947705        0             0      0   31079.0      1088000.0        0.010850  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1872619       0             0      0    1634.0       200000.0        0.002214  \n",
      "1872620       0             0      0   11151.0      1285000.0        0.014225  \n",
      "1872621       0             0      0    7471.0       468000.0        0.005181  \n",
      "1872622       0             0      0   28300.0      3816000.0        0.042243  \n",
      "1872623       0             0      0    4360.0       233000.0        0.002579  \n",
      "\n",
      "[71961 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1019444  2017-03-31 00:00:00+00:00   60361590  1598379  701081101  2017-03-31   \n",
      "1019445  2017-03-31 00:00:00+00:00   60361591  1598379  74022D308  2017-03-31   \n",
      "1019446  2017-03-31 00:00:00+00:00   60361592  1598379  G60754101  2017-03-31   \n",
      "1019447  2017-03-31 00:00:00+00:00   60361593  1598379  075896100  2017-03-31   \n",
      "1019448  2017-03-31 00:00:00+00:00   60361594  1598379  166764100  2017-03-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1878363  2019-11-08 00:00:00+00:00   72345307  1793399  949746101  2017-03-31   \n",
      "1878364  2019-11-08 00:00:00+00:00   72345308  1793399  478160104  2017-03-31   \n",
      "1878365  2019-11-08 00:00:00+00:00   72345309  1793399  00287Y109  2017-03-31   \n",
      "1878366  2019-11-08 00:00:00+00:00   72345310  1793399  464287655  2017-03-31   \n",
      "1878367  2019-11-08 00:00:00+00:00   72345311  1793399  92343V104  2017-03-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE       iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1019444       0             0      0  2311160.0      3998000.0        0.028006  \n",
      "1019445       0             0      0   711084.0      3320000.0        0.023257  \n",
      "1019446       0             0      0   162632.0      6206000.0        0.043473  \n",
      "1019447       0             0      0   113769.0      4532000.0        0.031747  \n",
      "1019448       0             0      0    23042.0      2476000.0        0.017344  \n",
      "...         ...           ...    ...        ...            ...             ...  \n",
      "1878363       0             0      0    19410.0      1089000.0        0.011190  \n",
      "1878364       0             0      0    11241.0      1400000.0        0.014386  \n",
      "1878365       0             0      0     7676.0       500000.0        0.005138  \n",
      "1878366       0             0      0    34500.0      4736000.0        0.048666  \n",
      "1878367       0             0      0     4430.0       216000.0        0.002220  \n",
      "\n",
      "[69070 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1088784  2017-07-10 00:00:00+00:00   61443368  1049648  88579y101  2017-06-30   \n",
      "1088785  2017-07-10 00:00:00+00:00   61443369  1049648  438516106  2017-06-30   \n",
      "1088786  2017-07-10 00:00:00+00:00   61443370  1049648  92343V104  2017-06-30   \n",
      "1088787  2017-07-10 00:00:00+00:00   61443371  1049648  636180101  2017-06-30   \n",
      "1088788  2017-07-10 00:00:00+00:00   61443372  1049648  717081103  2017-06-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1878430  2019-11-08 00:00:00+00:00   72345374  1793399  89417E109  2017-06-30   \n",
      "1878431  2019-11-08 00:00:00+00:00   72345375  1793399  478160104  2017-06-30   \n",
      "1878432  2019-11-08 00:00:00+00:00   72345376  1793399  00287Y109  2017-06-30   \n",
      "1878433  2019-11-08 00:00:00+00:00   72345377  1793399  464287655  2017-06-30   \n",
      "1878434  2019-11-08 00:00:00+00:00   72345378  1793399  92837G100  2017-06-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1088784       0             0      0    7950.0      1655000.0        0.009252  \n",
      "1088785       0             0      0   63383.0      8448000.0        0.047229  \n",
      "1088786       0             0      0   83050.0      3709000.0        0.020736  \n",
      "1088787       0             0      0   12250.0       684000.0        0.003824  \n",
      "1088788       0             0      0  189450.0      6364000.0        0.035579  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1878430       0             0      0    1634.0       208000.0        0.002032  \n",
      "1878431       0             0      0   11241.0      1494000.0        0.014598  \n",
      "1878432       0             0      0    7676.0       556000.0        0.005433  \n",
      "1878433       0             0      0   35000.0      4969000.0        0.048553  \n",
      "1878434       0             0      0   30330.0       375000.0        0.003664  \n",
      "\n",
      "[60692 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1148993  2017-10-02 00:00:00+00:00   62350031  1694284  74144t108  2017-09-30   \n",
      "1148994  2017-10-02 00:00:00+00:00   62350032  1694284  872540109  2017-09-30   \n",
      "1148995  2017-10-02 00:00:00+00:00   62350033  1694284  82669g104  2017-09-30   \n",
      "1148996  2017-10-02 00:00:00+00:00   62350034  1694284  931427108  2017-09-30   \n",
      "1148997  2017-10-02 00:00:00+00:00   62350035  1694284  718172109  2017-09-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1890408  2019-11-12 00:00:00+00:00   72504396  1793399  89417E109  2017-09-30   \n",
      "1890409  2019-11-12 00:00:00+00:00   72504397  1793399  58933Y105  2017-09-30   \n",
      "1890410  2019-11-12 00:00:00+00:00   72504398  1793399  693475105  2017-09-30   \n",
      "1890411  2019-11-12 00:00:00+00:00   72504399  1793399  464287655  2017-09-30   \n",
      "1890412  2019-11-12 00:00:00+00:00   72504400  1793399  92837G100  2017-09-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1148993       0             0      0   83626.0      7581000.0        0.028515  \n",
      "1148994       0             0      0   92157.0      6795000.0        0.025559  \n",
      "1148995       0             0      0    8825.0      1130000.0        0.004250  \n",
      "1148996       0             0      0  148555.0     11471000.0        0.043148  \n",
      "1148997       0             0      0    4588.0       509000.0        0.001915  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1890408       0             0      0    1634.0       200000.0        0.001747  \n",
      "1890409       0             0      0    8494.0       518000.0        0.004524  \n",
      "1890410       0             0      0    2800.0       377000.0        0.003292  \n",
      "1890411       0             0      0   35960.0      5329000.0        0.046537  \n",
      "1890412       0             0      0   44593.0       581000.0        0.005074  \n",
      "\n",
      "[75175 rows x 11 columns]\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1222897  2018-01-02 00:00:00+00:00   63494512  1352449  88579y101  2017-12-31   \n",
      "1222898  2018-01-02 00:00:00+00:00   63494513  1352449  718546104  2017-12-31   \n",
      "1222899  2018-01-02 00:00:00+00:00   63494514  1352449  526057104  2017-12-31   \n",
      "1222900  2018-01-02 00:00:00+00:00   63494515  1352449  053015103  2017-12-31   \n",
      "1222901  2018-01-02 00:00:00+00:00   63494516  1352449  28141c104  2017-12-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1890479  2019-11-12 00:00:00+00:00   72504467  1793399  89417E109  2017-12-31   \n",
      "1890480  2019-11-12 00:00:00+00:00   72504468  1793399  478160104  2017-12-31   \n",
      "1890481  2019-11-12 00:00:00+00:00   72504469  1793399  00287Y109  2017-12-31   \n",
      "1890482  2019-11-12 00:00:00+00:00   72504470  1793399  464287655  2017-12-31   \n",
      "1890483  2019-11-12 00:00:00+00:00   72504471  1793399  92837G100  2017-12-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE     iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1222897       0             0      0   2400.0       565000.0        0.003190  \n",
      "1222898       0             0      0  95753.0      9685000.0        0.054686  \n",
      "1222899       0             0      0  23275.0      1472000.0        0.008312  \n",
      "1222900       0             0      0   3400.0       398000.0        0.002247  \n",
      "1222901       0             0      0  16400.0            0.0        0.000000  \n",
      "...         ...           ...    ...      ...            ...             ...  \n",
      "1890479       0             0      0   1634.0       222000.0        0.001808  \n",
      "1890480       0             0      0  11241.0      1571000.0        0.012792  \n",
      "1890481       0             0      0   7676.0       742000.0        0.006042  \n",
      "1890482       0             0      0  37933.0      5770000.0        0.046984  \n",
      "1890483       0             0      0  45671.0       589000.0        0.004796  \n",
      "\n",
      "[88632 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1308891  2018-04-02 00:00:00+00:00   64709636   939791  438516106  2018-03-31   \n",
      "1308892  2018-04-02 00:00:00+00:00   64709637   939791  235851102  2018-03-31   \n",
      "1308893  2018-04-02 00:00:00+00:00   64709638   939791  501889208  2018-03-31   \n",
      "1308894  2018-04-02 00:00:00+00:00   64709639   939791  514766104  2018-03-31   \n",
      "1308895  2018-04-02 00:00:00+00:00   64709640   939791  811707801  2018-03-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1890549  2019-11-12 00:00:00+00:00   72504537  1793399  89417E109  2018-03-31   \n",
      "1890550  2019-11-12 00:00:00+00:00   72504538  1793399  478160104  2018-03-31   \n",
      "1890551  2019-11-12 00:00:00+00:00   72504539  1793399  00287Y109  2018-03-31   \n",
      "1890552  2019-11-12 00:00:00+00:00   72504540  1793399  464287655  2018-03-31   \n",
      "1890553  2019-11-12 00:00:00+00:00   72504541  1793399  92837G100  2018-03-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE     iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1308891       0             0      0  12189.0      1761000.0        0.016420  \n",
      "1308892       0             0      0  28984.0      2838000.0        0.026462  \n",
      "1308893       0             0      0  59175.0      2246000.0        0.020942  \n",
      "1308894       0             0      0  14489.0       189000.0        0.001762  \n",
      "1308895       0             0      0  18298.0       484000.0        0.004513  \n",
      "...         ...           ...    ...      ...            ...             ...  \n",
      "1890549       0             0      0   1634.0       223000.0        0.001825  \n",
      "1890550       0             0      0  11241.0      1430000.0        0.011702  \n",
      "1890551       0             0      0   7676.0       706000.0        0.005777  \n",
      "1890552       0             0      0  40900.0      6153000.0        0.050352  \n",
      "1890553       0             0      0  45328.0       497000.0        0.004067  \n",
      "\n",
      "[88555 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1386844  2018-07-02 00:00:00+00:00   65733018   939791  438516106  2018-06-30   \n",
      "1386845  2018-07-02 00:00:00+00:00   65733019   939791  235851102  2018-06-30   \n",
      "1386846  2018-07-02 00:00:00+00:00   65733020   939791  28238p109  2018-06-30   \n",
      "1386847  2018-07-02 00:00:00+00:00   65733021   939791  514766104  2018-06-30   \n",
      "1386848  2018-07-02 00:00:00+00:00   65733022   939791  811707801  2018-06-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1890617  2019-11-12 00:00:00+00:00   72505308  1793399  949746101  2018-06-30   \n",
      "1890618  2019-11-12 00:00:00+00:00   72505309  1793399  478160104  2018-06-30   \n",
      "1890619  2019-11-12 00:00:00+00:00   72505310  1793399  00287Y109  2018-06-30   \n",
      "1890620  2019-11-12 00:00:00+00:00   72505311  1793399  464287655  2018-06-30   \n",
      "1890621  2019-11-12 00:00:00+00:00   72505312  1793399  92837G100  2018-06-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE     iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1386844       0             0      0  11992.0      1727000.0        0.016101  \n",
      "1386845       0             0      0  28774.0      2839000.0        0.026469  \n",
      "1386846       0             0      0  30301.0       670000.0        0.006247  \n",
      "1386847       0             0      0  36070.0       537000.0        0.005007  \n",
      "1386848       0             0      0  18371.0       580000.0        0.005407  \n",
      "...         ...           ...    ...      ...            ...             ...  \n",
      "1890617       0             0      0  32250.0      1789000.0        0.014304  \n",
      "1890618       0             0      0  11241.0      1364000.0        0.010906  \n",
      "1890619       0             0      0   7676.0       711000.0        0.005685  \n",
      "1890620       0             0      0  44900.0      7349000.0        0.058760  \n",
      "1890621       0             0      0  42723.0       469000.0        0.003750  \n",
      "\n",
      "[90148 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1490498  2018-10-02 00:00:00+00:00   67192073  1616454  92203J407  2018-09-30   \n",
      "1490499  2018-10-02 00:00:00+00:00   67192074  1616454  464287630  2018-09-30   \n",
      "1490500  2018-10-02 00:00:00+00:00   67192075  1616454  464288281  2018-09-30   \n",
      "1490501  2018-10-02 00:00:00+00:00   67192076  1616454  464287648  2018-09-30   \n",
      "1490502  2018-10-02 00:00:00+00:00   67192077  1616454  72201R833  2018-09-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1890690  2019-11-12 00:00:00+00:00   72505381  1793399  478160104  2018-09-30   \n",
      "1890691  2019-11-12 00:00:00+00:00   72505382  1793399  039483102  2018-09-30   \n",
      "1890692  2019-11-12 00:00:00+00:00   72505383  1793399  00287Y109  2018-09-30   \n",
      "1890693  2019-11-12 00:00:00+00:00   72505384  1793399  464287655  2018-09-30   \n",
      "1890694  2019-11-12 00:00:00+00:00   72505385  1793399  92837G100  2018-09-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1490498       0             0      0  189102.0     10313000.0        0.020287  \n",
      "1490499       0             0      0   13850.0      1842000.0        0.003623  \n",
      "1490500       0             0      0   88806.0      9574000.0        0.018833  \n",
      "1490501       0             0      0    8439.0      1815000.0        0.003570  \n",
      "1490502       0             0      0   19499.0      1981000.0        0.003897  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1890690       0             0      0   11241.0      1553000.0        0.011229  \n",
      "1890691       0             0      0    5000.0       251000.0        0.001815  \n",
      "1890692       0             0      0    7676.0       726000.0        0.005249  \n",
      "1890693       0             0      0   48800.0      8237000.0        0.059558  \n",
      "1890694       0             0      0   40430.0       426000.0        0.003080  \n",
      "\n",
      "[91976 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1583200  2019-02-05 00:00:00+00:00   68481263  1037558  540424108  2018-12-31   \n",
      "1583201  2019-02-05 00:00:00+00:00   68481264  1037558  053015103  2018-12-31   \n",
      "1583202  2019-02-05 00:00:00+00:00   68481265  1037558  46432F396  2018-12-31   \n",
      "1583203  2019-02-05 00:00:00+00:00   68481266  1037558  293668109  2018-12-31   \n",
      "1583204  2019-02-05 00:00:00+00:00   68481267  1037558  717081103  2018-12-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1947300  2020-03-18 00:00:00+00:00   73299987  1760076  808524805  2018-12-31   \n",
      "1947301  2020-03-18 00:00:00+00:00   73299988  1760076  92826C839  2018-12-31   \n",
      "1947302  2020-03-18 00:00:00+00:00   73299989  1760076  902973304  2018-12-31   \n",
      "1947303  2020-03-18 00:00:00+00:00   73299990  1760076  922042858  2018-12-31   \n",
      "1947304  2020-03-18 00:00:00+00:00   73299991  1760076  863667101  2018-12-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1583200       0             0      0    9000.0       410000.0        0.000741  \n",
      "1583201       0             0      0    3048.0       400000.0        0.000723  \n",
      "1583202       0             0      0  222702.0     22321000.0        0.040356  \n",
      "1583203       0             0      0   31306.0      1007000.0        0.001821  \n",
      "1583204       0             0      0   19659.0       858000.0        0.001551  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1947300       0             0      0  438428.0     12429000.0        0.106073  \n",
      "1947301       0             0      0    3193.0       421000.0        0.003593  \n",
      "1947302       0             0      0   15004.0       686000.0        0.005855  \n",
      "1947303       0             0      0  177960.0      6780000.0        0.057863  \n",
      "1947304       0             0      0    1920.0       301000.0        0.002569  \n",
      "\n",
      "[62711 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1645540  2019-04-08 00:00:00+00:00   69404865  1598102  438516106  2019-03-31   \n",
      "1645541  2019-04-08 00:00:00+00:00   69404866  1598102  969457100  2019-03-31   \n",
      "1645542  2019-04-08 00:00:00+00:00   69404867  1598102  464287457  2019-03-31   \n",
      "1645543  2019-04-08 00:00:00+00:00   69404868  1598102  03073E105  2019-03-31   \n",
      "1645544  2019-04-08 00:00:00+00:00   69404869  1598102  23355L106  2019-03-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "2048023  2020-04-16 00:00:00+00:00   74378680  1802387  46090E103  2019-03-31   \n",
      "2048024  2020-04-16 00:00:00+00:00   74378681  1802387  81369Y209  2019-03-31   \n",
      "2048025  2020-04-16 00:00:00+00:00   74378682  1802387  713448108  2019-03-31   \n",
      "2048026  2020-04-16 00:00:00+00:00   74378683  1802387  45409B107  2019-03-31   \n",
      "2048027  2020-04-16 00:00:00+00:00   74378684  1802387  92826C839  2019-03-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1645540       0             0      0    3416.0       543000.0        0.002894  \n",
      "1645541       0             0      0   15603.0       448000.0        0.002387  \n",
      "1645542       0             0      0  157848.0     13278000.0        0.070759  \n",
      "1645543       0             0      0    4816.0       383000.0        0.002041  \n",
      "1645544       0             0      0    6520.0       419000.0        0.002233  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "2048023       0             0      0    4630.0       970000.0        0.008969  \n",
      "2048024       0             0      0   11034.0      1066000.0        0.009857  \n",
      "2048025       0             0      0    5682.0       767000.0        0.007092  \n",
      "2048026       0             0      0   20972.0       606000.0        0.005604  \n",
      "2048027       0             0      0    4827.0       801000.0        0.007407  \n",
      "\n",
      "[101256 rows x 11 columns]\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1751238  2019-07-23 00:00:00+00:00   70794666  1730386  46138J841  2019-06-30   \n",
      "1751239  2019-07-23 00:00:00+00:00   70794667  1730386  464287481  2019-06-30   \n",
      "1751240  2019-07-23 00:00:00+00:00   70794668  1730386  742718109  2019-06-30   \n",
      "1751241  2019-07-23 00:00:00+00:00   70794669  1730386  464287234  2019-06-30   \n",
      "1751242  2019-07-23 00:00:00+00:00   70794670  1730386  18383M266  2019-06-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1947077  2020-02-27 00:00:00+00:00   73296963  1802224  92826C839  2019-06-30   \n",
      "1947078  2020-02-27 00:00:00+00:00   73296964  1802224  92189H201  2019-06-30   \n",
      "1947079  2020-02-27 00:00:00+00:00   73296965  1802224  464287499  2019-06-30   \n",
      "1947080  2020-02-27 00:00:00+00:00   73296966  1802224  02079K305  2019-06-30   \n",
      "1947081  2020-02-27 00:00:00+00:00   73296967  1802224  464287408  2019-06-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1751238       0             0      0   46222.0    982000000.0        0.267129  \n",
      "1751239       0             0      0    2916.0       416000.0        0.000113  \n",
      "1751240       0             0      0    4080.0       447000.0        0.000122  \n",
      "1751241       0             0      0   56306.0      2416000.0        0.000657  \n",
      "1751242       0             0      0   52746.0      1118000.0        0.000304  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1947077       0             0      0    3464.0       601000.0        0.006529  \n",
      "1947078       0             0      0    4050.0       201000.0        0.002183  \n",
      "1947079       0             0      0  105013.0      5867000.0        0.063734  \n",
      "1947080       0             0      0     619.0       670000.0        0.007278  \n",
      "1947081       0             0      0    8260.0       963000.0        0.010461  \n",
      "\n",
      "[82579 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1835487  2019-10-01 00:00:00+00:00   71945888   826794  19247x100  2019-09-30   \n",
      "1835488  2019-10-01 00:00:00+00:00   71945889   826794  055622104  2019-09-30   \n",
      "1835489  2019-10-01 00:00:00+00:00   71945890   826794  67066g104  2019-09-30   \n",
      "1835490  2019-10-01 00:00:00+00:00   71945891   826794  654902204  2019-09-30   \n",
      "1835491  2019-10-01 00:00:00+00:00   71945892   826794  458140100  2019-09-30   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "1946719  2020-03-06 00:00:00+00:00   73292183  1760076  92826C839  2019-09-30   \n",
      "1946720  2020-03-06 00:00:00+00:00   73292184  1760076  596278101  2019-09-30   \n",
      "1946721  2020-03-06 00:00:00+00:00   73292185  1760076  922908512  2019-09-30   \n",
      "1946722  2020-03-06 00:00:00+00:00   73292186  1760076  464287614  2019-09-30   \n",
      "1946723  2020-03-06 00:00:00+00:00   73292187  1760076  863667101  2019-09-30   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1835487       0             0      0   96617.0      2378000.0        0.017702  \n",
      "1835488       0             0      0  146900.0      5581000.0        0.041546  \n",
      "1835489       0             0      0   14230.0      2477000.0        0.018439  \n",
      "1835490       0             0      0  598950.0      3031000.0        0.022563  \n",
      "1835491       0             0      0  136027.0      7009000.0        0.052176  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "1946719       0             0      0    3193.0       549000.0        0.002150  \n",
      "1946720       0             0      0     100.0        12000.0        0.000047  \n",
      "1946721       0             0      0    2008.0       227000.0        0.000889  \n",
      "1946722       0             0      0    2475.0       395000.0        0.001547  \n",
      "1946723       0             0      0    1920.0       415000.0        0.001625  \n",
      "\n",
      "[106678 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1929003  2020-02-25 00:00:00+00:00   73274491  1697539  511656100  2019-12-31   \n",
      "1929004  2020-02-25 00:00:00+00:00   73274490  1697539  20084T103  2019-12-31   \n",
      "1929005  2020-02-25 00:00:00+00:00   73274489  1697539  675234108  2019-12-31   \n",
      "1929006  2020-02-25 00:00:00+00:00   73274488  1697539  027745108  2019-12-31   \n",
      "1929007  2020-02-25 00:00:00+00:00   73274487  1697539  82620P102  2019-12-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "2068844  2020-04-23 00:00:00+00:00   74545608  1810023  98978V103  2019-12-31   \n",
      "2068845  2020-04-23 00:00:00+00:00   74545609  1810023  808524805  2019-12-31   \n",
      "2068846  2020-04-23 00:00:00+00:00   74545610  1810023  025537101  2019-12-31   \n",
      "2068847  2020-04-23 00:00:00+00:00   74545611  1810023  863667101  2019-12-31   \n",
      "2068848  2020-04-23 00:00:00+00:00   74545612  1810023  88160R101  2019-12-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE      iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1929003       0             0      0  113130.0   5.535450e+09        0.051883  \n",
      "1929004       0             0      0  146000.0   3.504000e+09        0.032842  \n",
      "1929005       0             0      0   15000.0   3.831000e+08        0.003591  \n",
      "1929006       0             0      0    7500.0   2.967750e+08        0.002782  \n",
      "1929007       0             0      0   26741.0   7.786970e+08        0.007299  \n",
      "...         ...           ...    ...       ...            ...             ...  \n",
      "2068844       0             0      0    1831.0   2.420000e+05        0.001593  \n",
      "2068845       0             0      0   11737.0   3.950000e+05        0.002600  \n",
      "2068846       0             0      0    2918.0   2.760000e+05        0.001817  \n",
      "2068847       0             0      0    1216.0   2.550000e+05        0.001678  \n",
      "2068848       0             0      0     664.0   2.780000e+05        0.001830  \n",
      "\n",
      "[3463 rows x 11 columns]\n",
      "                              date  record_id     iCIK   stock_id  period_end  \\\n",
      "1947693  2020-04-01 00:00:00+00:00   73305478  1384943  717081103  2020-03-31   \n",
      "1947694  2020-04-01 00:00:00+00:00   73305479  1384943  053015103  2020-03-31   \n",
      "1947695  2020-04-01 00:00:00+00:00   73305480  1384943  458140100  2020-03-31   \n",
      "1947696  2020-04-01 00:00:00+00:00   73305481  1384943  02079K107  2020-03-31   \n",
      "1947697  2020-04-01 00:00:00+00:00   73305482  1384943  194162103  2020-03-31   \n",
      "...                            ...        ...      ...        ...         ...   \n",
      "2070886  2020-04-23 00:00:00+00:00   74561256  1638520  550021109  2020-03-31   \n",
      "2070887  2020-04-23 00:00:00+00:00   74561257  1638520  g1151c101  2020-03-31   \n",
      "2070888  2020-04-23 00:00:00+00:00   74561258  1638520  988498101  2020-03-31   \n",
      "2070889  2020-04-23 00:00:00+00:00   74561259  1638520  78462f103  2020-03-31   \n",
      "2070890  2020-04-23 00:00:00+00:00   74561260  1638520  88160R101  2020-03-31   \n",
      "\n",
      "         iAMEND  iRESTATEMENT  iTYPE     iQTY  iMARKET_VALUE  iLONG_FRACTION  \n",
      "1947693       0             0      0  18949.0       618000.0        0.001339  \n",
      "1947694       0             0      0  72503.0      9910000.0        0.021473  \n",
      "1947695       0             0      0  29732.0      1609000.0        0.003486  \n",
      "1947696       0             0      0    668.0       777000.0        0.001684  \n",
      "1947697       0             0      0  52230.0      3466000.0        0.007510  \n",
      "...         ...           ...    ...      ...            ...             ...  \n",
      "2070886       0             0      0   1320.0       250000.0        0.001275  \n",
      "2070887       0             0      0   4053.0       662000.0        0.003377  \n",
      "2070888       0             0      0   3611.0       247000.0        0.001260  \n",
      "2070889       0             0      0   1742.0       449000.0        0.002290  \n",
      "2070890       0             0      0    591.0       310000.0        0.001581  \n",
      "\n",
      "[121942 rows x 11 columns]\n"
     ]
    }
   ],
   "source": [
    "#empty dictionary that stores dataframes by period_ends/quarters\n",
    "dfs={}\n",
    "for date in df.period_end.unique():\n",
    "    #(df[df[\"period_end\"] == date])\n",
    "    #classifies by period_end and adds to dictionary\n",
    "    dfs[date] = df[df[\"period_end\"] == date]\n",
    "    print (dfs[date])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "period_end denotes end of the previous quarter\n",
      "\n",
      "For period_end 2012-12-31 :\n",
      "037833100    321\n",
      "594918104    304\n",
      "30231G102    303\n",
      "478160104    298\n",
      "459200101    269\n",
      "            ... \n",
      "37950E549      1\n",
      "372309104      1\n",
      "792860108      1\n",
      "67555N206      1\n",
      "511656100      1\n",
      "Name: stock_id, Length: 5773, dtype: int64\n",
      "\n",
      "For period_end 2012-09-30 :\n",
      "037833100    8\n",
      "742718109    7\n",
      "478160104    7\n",
      "30231G102    6\n",
      "594918104    5\n",
      "            ..\n",
      "030975106    1\n",
      "696429307    1\n",
      "78440X101    1\n",
      "981811102    1\n",
      "44106M102    1\n",
      "Name: stock_id, Length: 343, dtype: int64\n",
      "\n",
      "For period_end 2013-06-30 :\n",
      "478160104    399\n",
      "594918104    391\n",
      "037833100    381\n",
      "459200101    342\n",
      "369604103    341\n",
      "            ... \n",
      "86074q102      1\n",
      "04623u102      1\n",
      "369822101      1\n",
      "69373H106      1\n",
      "85375CBC4      1\n",
      "Name: stock_id, Length: 7100, dtype: int64\n",
      "\n",
      "For period_end 2014-12-31 :\n",
      "037833100    490\n",
      "478160104    441\n",
      "594918104    434\n",
      "369604103    400\n",
      "742718109    369\n",
      "            ... \n",
      "296991474      1\n",
      "00305P106      1\n",
      "875518EL2      1\n",
      "677862104      1\n",
      "78709y105      1\n",
      "Name: stock_id, Length: 7588, dtype: int64\n",
      "\n",
      "For period_end 2014-06-30 :\n",
      "037833100    429\n",
      "478160104    413\n",
      "594918104    386\n",
      "369604103    359\n",
      "30231G102    345\n",
      "            ... \n",
      "361438104      1\n",
      "g0457f107      1\n",
      "44949L105      1\n",
      "007924301      1\n",
      "78709y105      1\n",
      "Name: stock_id, Length: 7439, dtype: int64\n",
      "\n",
      "For period_end 2013-12-31 :\n",
      "037833100    422\n",
      "478160104    413\n",
      "594918104    387\n",
      "369604103    362\n",
      "459200101    350\n",
      "            ... \n",
      "87164u102      1\n",
      "258623107      1\n",
      "67070X101      1\n",
      "983919AF8      1\n",
      "023139116      1\n",
      "Name: stock_id, Length: 7316, dtype: int64\n",
      "\n",
      "For period_end 2014-03-31 :\n",
      "478160104    412\n",
      "037833100    409\n",
      "594918104    388\n",
      "369604103    361\n",
      "742718109    345\n",
      "            ... \n",
      "936772102      1\n",
      "65248E104      1\n",
      "92204a801      1\n",
      "37246C307      1\n",
      "78709y105      1\n",
      "Name: stock_id, Length: 7311, dtype: int64\n",
      "\n",
      "For period_end 2013-09-30 :\n",
      "478160104    408\n",
      "037833100    379\n",
      "594918104    374\n",
      "369604103    350\n",
      "459200101    341\n",
      "            ... \n",
      "464288190      1\n",
      "783925282      1\n",
      "74727K102      1\n",
      "D55040105      1\n",
      "530322106      1\n",
      "Name: stock_id, Length: 7088, dtype: int64\n",
      "\n",
      "For period_end 2013-03-31 :\n",
      "037833100    320\n",
      "478160104    310\n",
      "594918104    291\n",
      "30231G102    290\n",
      "459200101    273\n",
      "            ... \n",
      "44925C103      1\n",
      "23254L207      1\n",
      "870297306      1\n",
      "61748WAA6      1\n",
      "897888103      1\n",
      "Name: stock_id, Length: 5482, dtype: int64\n",
      "\n",
      "For period_end 2012-06-30 :\n",
      "037833100    7\n",
      "478160104    6\n",
      "78463V107    5\n",
      "459200101    5\n",
      "742718109    5\n",
      "            ..\n",
      "745867101    1\n",
      "268648102    1\n",
      "464287507    1\n",
      "227046109    1\n",
      "01988P108    1\n",
      "Name: stock_id, Length: 301, dtype: int64\n",
      "\n",
      "For period_end 2012-03-31 :\n",
      "037833100    8\n",
      "949746101    5\n",
      "78463V107    5\n",
      "30231G102    5\n",
      "478160104    5\n",
      "            ..\n",
      "00846U101    1\n",
      "706327103    1\n",
      "002824100    1\n",
      "747582104    1\n",
      "01988P108    1\n",
      "Name: stock_id, Length: 348, dtype: int64\n",
      "\n",
      "For period_end 2011-12-31 :\n",
      "037833100    6\n",
      "478160104    5\n",
      "30231G102    4\n",
      "464287465    4\n",
      "949746101    4\n",
      "            ..\n",
      "437076102    1\n",
      "268648102    1\n",
      "227046109    1\n",
      "004239109    1\n",
      "01988P108    1\n",
      "Name: stock_id, Length: 279, dtype: int64\n",
      "\n",
      "For period_end 2011-09-30 :\n",
      "949746101    3\n",
      "037833100    3\n",
      "H5833N103    3\n",
      "464287655    2\n",
      "464287184    2\n",
      "            ..\n",
      "004239109    1\n",
      "73935X583    1\n",
      "464288885    1\n",
      "73936D206    1\n",
      "371901109    1\n",
      "Name: stock_id, Length: 123, dtype: int64\n",
      "\n",
      "For period_end 2011-06-30 :\n",
      "949746101    3\n",
      "037411105    2\n",
      "189754104    2\n",
      "478160104    2\n",
      "25179M103    2\n",
      "            ..\n",
      "464286657    1\n",
      "81369Y886    1\n",
      "23331A109    1\n",
      "004239109    1\n",
      "74340W103    1\n",
      "Name: stock_id, Length: 120, dtype: int64\n",
      "\n",
      "For period_end 2011-03-31 :\n",
      "949746101    4\n",
      "037411105    2\n",
      "464287622    2\n",
      "039380100    2\n",
      "464287655    2\n",
      "            ..\n",
      "060505104    1\n",
      "876568502    1\n",
      "92220P105    1\n",
      "464287184    1\n",
      "72201R205    1\n",
      "Name: stock_id, Length: 116, dtype: int64\n",
      "\n",
      "For period_end 2010-12-31 :\n",
      "949746101    4\n",
      "037833100    3\n",
      "25179M103    2\n",
      "464287614    2\n",
      "464287689    2\n",
      "            ..\n",
      "054937107    1\n",
      "73936D206    1\n",
      "517942108    1\n",
      "874039100    1\n",
      "25960P109    1\n",
      "Name: stock_id, Length: 119, dtype: int64\n",
      "\n",
      "For period_end 2010-09-30 :\n",
      "73936D206    1\n",
      "464287598    1\n",
      "313747206    1\n",
      "44107P104    1\n",
      "78440X101    1\n",
      "084670108    1\n",
      "437306103    1\n",
      "464287457    1\n",
      "464287614    1\n",
      "101121101    1\n",
      "369604103    1\n",
      "464287630    1\n",
      "527288104    1\n",
      "227046109    1\n",
      "78463V107    1\n",
      "464288281    1\n",
      "464287564    1\n",
      "464287648    1\n",
      "828806109    1\n",
      "73935S105    1\n",
      "29476L107    1\n",
      "464288877    1\n",
      "464288158    1\n",
      "38259P508    1\n",
      "464287622    1\n",
      "464288885    1\n",
      "929042109    1\n",
      "053484101    1\n",
      "74460D109    1\n",
      "004239109    1\n",
      "464287465    1\n",
      "49427F108    1\n",
      "464285105    1\n",
      "458140100    1\n",
      "49446R109    1\n",
      "464287689    1\n",
      "015271109    1\n",
      "464287234    1\n",
      "464287200    1\n",
      "464288414    1\n",
      "037833100    1\n",
      "464287655    1\n",
      "084670702    1\n",
      "297178105    1\n",
      "464287226    1\n",
      "25960P109    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2010-06-30 :\n",
      "73936D206    1\n",
      "464287598    1\n",
      "313747206    1\n",
      "227046109    1\n",
      "78440X101    1\n",
      "464287465    1\n",
      "464285105    1\n",
      "464287614    1\n",
      "101121101    1\n",
      "369604103    1\n",
      "464287630    1\n",
      "38259P508    1\n",
      "464287655    1\n",
      "78463V107    1\n",
      "464288281    1\n",
      "464287648    1\n",
      "44107P104    1\n",
      "73935S105    1\n",
      "29476L107    1\n",
      "464288877    1\n",
      "464288158    1\n",
      "464287622    1\n",
      "464287457    1\n",
      "49446R109    1\n",
      "929042109    1\n",
      "053484101    1\n",
      "74460D109    1\n",
      "004239109    1\n",
      "828806109    1\n",
      "49427F108    1\n",
      "437306103    1\n",
      "458140100    1\n",
      "464287689    1\n",
      "464288885    1\n",
      "015271109    1\n",
      "464287234    1\n",
      "464288414    1\n",
      "037833100    1\n",
      "084670702    1\n",
      "912318102    1\n",
      "297178105    1\n",
      "464287226    1\n",
      "25960P109    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2010-03-31 :\n",
      "73936D206    1\n",
      "464287457    1\n",
      "44107P104    1\n",
      "78440X101    1\n",
      "004239109    1\n",
      "437306103    1\n",
      "464285105    1\n",
      "464287614    1\n",
      "101121101    1\n",
      "369604103    1\n",
      "464287598    1\n",
      "464287630    1\n",
      "227046109    1\n",
      "78463V107    1\n",
      "26613Q106    1\n",
      "464287648    1\n",
      "828806109    1\n",
      "554382101    1\n",
      "29476L107    1\n",
      "464288877    1\n",
      "25960P109    1\n",
      "313747206    1\n",
      "464288158    1\n",
      "38259P508    1\n",
      "464287689    1\n",
      "929042109    1\n",
      "00163T109    1\n",
      "053484101    1\n",
      "74460D109    1\n",
      "464287465    1\n",
      "73935S105    1\n",
      "458140100    1\n",
      "912318102    1\n",
      "015271109    1\n",
      "464287622    1\n",
      "464287234    1\n",
      "464288414    1\n",
      "037833100    1\n",
      "464287655    1\n",
      "084670702    1\n",
      "297178105    1\n",
      "464287226    1\n",
      "464288885    1\n",
      "517942108    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2009-12-31 :\n",
      "73936D206    1\n",
      "464287457    1\n",
      "313747206    1\n",
      "44107P104    1\n",
      "78440X101    1\n",
      "004239109    1\n",
      "437306103    1\n",
      "464287614    1\n",
      "828806109    1\n",
      "369604103    1\n",
      "464287598    1\n",
      "464287630    1\n",
      "227046109    1\n",
      "758849103    1\n",
      "26613Q106    1\n",
      "464287648    1\n",
      "464285105    1\n",
      "554382101    1\n",
      "29476L107    1\n",
      "464288877    1\n",
      "25960P109    1\n",
      "464288158    1\n",
      "38259P508    1\n",
      "464287226    1\n",
      "464287689    1\n",
      "929042109    1\n",
      "00163T109    1\n",
      "053484101    1\n",
      "74460D109    1\n",
      "464287465    1\n",
      "73935S105    1\n",
      "101121101    1\n",
      "912318102    1\n",
      "015271109    1\n",
      "084670207    1\n",
      "78463V107    1\n",
      "464287234    1\n",
      "464288414    1\n",
      "464287655    1\n",
      "464287622    1\n",
      "297178105    1\n",
      "458140100    1\n",
      "464288885    1\n",
      "517942108    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2009-09-30 :\n",
      "78440X101    1\n",
      "313747206    1\n",
      "29476L107    1\n",
      "44107P104    1\n",
      "26613Q106    1\n",
      "297178105    1\n",
      "00163T109    1\n",
      "015271109    1\n",
      "49446R109    1\n",
      "828806109    1\n",
      "101121101    1\n",
      "053484101    1\n",
      "74460D109    1\n",
      "49427F108    1\n",
      "437306103    1\n",
      "004239109    1\n",
      "929042109    1\n",
      "25960P109    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2009-06-30 :\n",
      "78440X101    1\n",
      "313747206    1\n",
      "29476L107    1\n",
      "554382101    1\n",
      "44107P104    1\n",
      "26613Q106    1\n",
      "297178105    1\n",
      "00163T109    1\n",
      "758849103    1\n",
      "015271109    1\n",
      "49446R109    1\n",
      "828806109    1\n",
      "101121101    1\n",
      "053484101    1\n",
      "74460D109    1\n",
      "49427F108    1\n",
      "437306103    1\n",
      "004239109    1\n",
      "929042109    1\n",
      "25960P109    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2009-03-31 :\n",
      "313747206    1\n",
      "929042109    1\n",
      "78440X101    1\n",
      "00163T109    1\n",
      "44107P104    1\n",
      "004239109    1\n",
      "74460D109    1\n",
      "49427F108    1\n",
      "053484101    1\n",
      "437306103    1\n",
      "101121101    1\n",
      "828806109    1\n",
      "49446R109    1\n",
      "758849103    1\n",
      "26613Q106    1\n",
      "297178105    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2008-12-31 :\n",
      "313747206    1\n",
      "929042109    1\n",
      "78440X101    1\n",
      "00163T109    1\n",
      "44107P104    1\n",
      "004239109    1\n",
      "74460D109    1\n",
      "49427F108    1\n",
      "053484101    1\n",
      "437306103    1\n",
      "101121101    1\n",
      "828806109    1\n",
      "49446R109    1\n",
      "743410102    1\n",
      "758849103    1\n",
      "297178105    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2008-09-30 :\n",
      "78440X101    1\n",
      "313747206    1\n",
      "297178105    1\n",
      "44107P104    1\n",
      "00163T109    1\n",
      "758849103    1\n",
      "743410102    1\n",
      "015271109    1\n",
      "49446R109    1\n",
      "828806109    1\n",
      "101121101    1\n",
      "053484101    1\n",
      "74460D109    1\n",
      "49427F108    1\n",
      "437306103    1\n",
      "004239109    1\n",
      "929042109    1\n",
      "05564E106    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2008-06-30 :\n",
      "554489104    1\n",
      "00163T109    1\n",
      "297178105    1\n",
      "44107P104    1\n",
      "758849103    1\n",
      "828806109    1\n",
      "743410102    1\n",
      "015271109    1\n",
      "49446R109    1\n",
      "101121101    1\n",
      "78440X101    1\n",
      "053484101    1\n",
      "74460D109    1\n",
      "49427F108    1\n",
      "437306103    1\n",
      "004239109    1\n",
      "929042109    1\n",
      "313747206    1\n",
      "05564E106    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2008-03-31 :\n",
      "554489104    1\n",
      "78440X101    1\n",
      "297178105    1\n",
      "44107P104    1\n",
      "758849103    1\n",
      "828806109    1\n",
      "743410102    1\n",
      "015271109    1\n",
      "30225T102    1\n",
      "49446R109    1\n",
      "00163T109    1\n",
      "101121101    1\n",
      "053484101    1\n",
      "74460D109    1\n",
      "49427F108    1\n",
      "437306103    1\n",
      "004239109    1\n",
      "929042109    1\n",
      "313747206    1\n",
      "05564E106    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2007-12-31 :\n",
      "554489104    1\n",
      "78440X101    1\n",
      "05564E106    1\n",
      "297178105    1\n",
      "44107P104    1\n",
      "758849103    1\n",
      "828806109    1\n",
      "743410102    1\n",
      "015271109    1\n",
      "49446R109    1\n",
      "00163T109    1\n",
      "101121101    1\n",
      "053484101    1\n",
      "74460D109    1\n",
      "49427F108    1\n",
      "437306103    1\n",
      "004239109    1\n",
      "929042109    1\n",
      "313747206    1\n",
      "517942108    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2007-09-30 :\n",
      "554489104    1\n",
      "101121101    1\n",
      "05564E106    1\n",
      "297178105    1\n",
      "828806109    1\n",
      "758849103    1\n",
      "743410102    1\n",
      "49446R109    1\n",
      "00163T109    1\n",
      "437306103    1\n",
      "929042109    1\n",
      "053484101    1\n",
      "49427F108    1\n",
      "74460D109    1\n",
      "004239109    1\n",
      "44107P104    1\n",
      "313747206    1\n",
      "78440X101    1\n",
      "517942108    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2007-06-30 :\n",
      "929042109    1\n",
      "78440X101    1\n",
      "05564E106    1\n",
      "554382101    1\n",
      "00163T109    1\n",
      "758849103    1\n",
      "743410102    1\n",
      "101121101    1\n",
      "49446R109    1\n",
      "828806109    1\n",
      "370021107    1\n",
      "437306103    1\n",
      "49427F108    1\n",
      "053484101    1\n",
      "004239109    1\n",
      "44107P104    1\n",
      "313747206    1\n",
      "517942108    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2007-03-31 :\n",
      "49427F108    1\n",
      "49446R109    1\n",
      "554382101    1\n",
      "44107P104    1\n",
      "00163T109    1\n",
      "758849103    1\n",
      "743410102    1\n",
      "101121101    1\n",
      "828806109    1\n",
      "78440X101    1\n",
      "370021107    1\n",
      "039583109    1\n",
      "053484101    1\n",
      "004239109    1\n",
      "929042109    1\n",
      "313747206    1\n",
      "05564E106    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2006-12-31 :\n",
      "49427F108    1\n",
      "929042109    1\n",
      "00163T109    1\n",
      "44107P104    1\n",
      "78440X101    1\n",
      "039583109    1\n",
      "101121101    1\n",
      "828806109    1\n",
      "49446R109    1\n",
      "743410102    1\n",
      "758849103    1\n",
      "554382101    1\n",
      "313747206    1\n",
      "Name: stock_id, dtype: int64\n",
      "\n",
      "For period_end 2014-09-30 :\n",
      "037833100    433\n",
      "478160104    412\n",
      "594918104    399\n",
      "369604103    362\n",
      "30231G102    335\n",
      "            ... \n",
      "65340G106      1\n",
      "70706p104      1\n",
      "16949N109      1\n",
      "963025101      1\n",
      "01890A108      1\n",
      "Name: stock_id, Length: 7355, dtype: int64\n",
      "\n",
      "For period_end 2015-03-31 :\n",
      "037833100    501\n",
      "478160104    436\n",
      "594918104    409\n",
      "369604103    398\n",
      "742718109    366\n",
      "            ... \n",
      "37950e366      1\n",
      "035710706      1\n",
      "316390517      1\n",
      "13215Q106      1\n",
      "78355W809      1\n",
      "Name: stock_id, Length: 7618, dtype: int64\n",
      "\n",
      "For period_end 2015-06-30 :\n",
      "037833100    503\n",
      "478160104    431\n",
      "594918104    414\n",
      "369604103    402\n",
      "742718109    360\n",
      "            ... \n",
      "714264207      1\n",
      "42866N104      1\n",
      "46284v101      1\n",
      "G81075AE6      1\n",
      "78709y105      1\n",
      "Name: stock_id, Length: 7672, dtype: int64\n",
      "\n",
      "For period_end 2015-09-30 :\n",
      "037833100    488\n",
      "478160104    430\n",
      "594918104    415\n",
      "369604103    400\n",
      "742718109    354\n",
      "            ... \n",
      "28849p100      1\n",
      "7044PC990      1\n",
      "77954Q106      1\n",
      "50208C108      1\n",
      "829214105      1\n",
      "Name: stock_id, Length: 7299, dtype: int64\n",
      "\n",
      "For period_end 2015-12-31 :\n",
      "037833100    492\n",
      "594918104    449\n",
      "478160104    445\n",
      "369604103    411\n",
      "742718109    378\n",
      "            ... \n",
      "277461406      1\n",
      "46187j205      1\n",
      "17878Y108      1\n",
      "12618T105      1\n",
      "78355W809      1\n",
      "Name: stock_id, Length: 7221, dtype: int64\n",
      "\n",
      "For period_end 2016-03-31 :\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "037833100    521\n",
      "594918104    480\n",
      "478160104    467\n",
      "369604103    426\n",
      "30231G102    404\n",
      "            ... \n",
      "90933W102      1\n",
      "98420v107      1\n",
      "92189F429      1\n",
      "903899102      1\n",
      "806870200      1\n",
      "Name: stock_id, Length: 7185, dtype: int64\n",
      "\n",
      "For period_end 2016-06-30 :\n",
      "037833100    506\n",
      "478160104    484\n",
      "594918104    478\n",
      "369604103    424\n",
      "30231G102    407\n",
      "            ... \n",
      "13123e500      1\n",
      "97717X784      1\n",
      "05343P109      1\n",
      "97717w604      1\n",
      "91822J103      1\n",
      "Name: stock_id, Length: 7118, dtype: int64\n",
      "\n",
      "For period_end 2016-09-30 :\n",
      "037833100    415\n",
      "478160104    379\n",
      "594918104    376\n",
      "369604103    328\n",
      "30231G102    316\n",
      "            ... \n",
      "44244K109      1\n",
      "n7902x106      1\n",
      "01879R106      1\n",
      "71377E105      1\n",
      "42217K106      1\n",
      "Name: stock_id, Length: 6519, dtype: int64\n",
      "\n",
      "For period_end 2016-12-31 :\n",
      "037833100    559\n",
      "594918104    542\n",
      "478160104    519\n",
      "369604103    455\n",
      "30231G102    436\n",
      "            ... \n",
      "22542D829      1\n",
      "74347b714      1\n",
      "73935x690      1\n",
      "64104P105      1\n",
      "15870P307      1\n",
      "Name: stock_id, Length: 7163, dtype: int64\n",
      "\n",
      "For period_end 2017-03-31 :\n",
      "037833100    536\n",
      "594918104    508\n",
      "478160104    491\n",
      "369604103    412\n",
      "30231G102    397\n",
      "            ... \n",
      "71361F100      1\n",
      "74431a101      1\n",
      "90184LAB8      1\n",
      "957090103      1\n",
      "066800103      1\n",
      "Name: stock_id, Length: 7072, dtype: int64\n",
      "\n",
      "For period_end 2017-06-30 :\n",
      "037833100    480\n",
      "594918104    468\n",
      "478160104    456\n",
      "369604103    379\n",
      "30231G102    375\n",
      "            ... \n",
      "25490K356      1\n",
      "159765106      1\n",
      "73935x625      1\n",
      "73937b597      1\n",
      "976524108      1\n",
      "Name: stock_id, Length: 6672, dtype: int64\n",
      "\n",
      "For period_end 2017-09-30 :\n",
      "037833100    587\n",
      "594918104    576\n",
      "478160104    531\n",
      "30231G102    437\n",
      "369604103    435\n",
      "            ... \n",
      "72766q105      1\n",
      "78464a722      1\n",
      "36164y101      1\n",
      "03209T109      1\n",
      "16944W104      1\n",
      "Name: stock_id, Length: 7214, dtype: int64\n",
      "\n",
      "For period_end 2017-12-31 :\n",
      "037833100    713\n",
      "594918104    675\n",
      "478160104    633\n",
      "30231G102    516\n",
      "46625H100    497\n",
      "            ... \n",
      "31866p102      1\n",
      "45174L108      1\n",
      "25459Y413      1\n",
      "58733r102      1\n",
      "78709y105      1\n",
      "Name: stock_id, Length: 7597, dtype: int64\n",
      "\n",
      "For period_end 2018-03-31 :\n",
      "037833100    709\n",
      "594918104    689\n",
      "478160104    629\n",
      "30231G102    526\n",
      "46625H100    514\n",
      "            ... \n",
      "731094108      1\n",
      "87911j103      1\n",
      "65339F846      1\n",
      "17273k109      1\n",
      "478373AB9      1\n",
      "Name: stock_id, Length: 7546, dtype: int64\n",
      "\n",
      "For period_end 2018-06-30 :\n",
      "037833100    716\n",
      "594918104    703\n",
      "478160104    633\n",
      "023135106    544\n",
      "30231G102    531\n",
      "            ... \n",
      "85857c108      1\n",
      "78467V806      1\n",
      "27828n102      1\n",
      "29272B105      1\n",
      "45882D109      1\n",
      "Name: stock_id, Length: 7627, dtype: int64\n",
      "\n",
      "For period_end 2018-09-30 :\n",
      "037833100    737\n",
      "594918104    725\n",
      "478160104    642\n",
      "023135106    571\n",
      "30231G102    529\n",
      "            ... \n",
      "05614L100      1\n",
      "36729W202      1\n",
      "320517204      1\n",
      "89465J109      1\n",
      "059915108      1\n",
      "Name: stock_id, Length: 7766, dtype: int64\n",
      "\n",
      "For period_end 2018-12-31 :\n",
      "594918104    514\n",
      "037833100    497\n",
      "478160104    412\n",
      "023135106    411\n",
      "46625H100    348\n",
      "            ... \n",
      "G5784H106      1\n",
      "67110P704      1\n",
      "449187707      1\n",
      "922907704      1\n",
      "68235P108      1\n",
      "Name: stock_id, Length: 6754, dtype: int64\n",
      "\n",
      "For period_end 2019-03-31 :\n",
      "594918104    854\n",
      "037833100    840\n",
      "478160104    703\n",
      "023135106    685\n",
      "46625H100    600\n",
      "            ... \n",
      "84265v105      1\n",
      "92912P108      1\n",
      "60871R100      1\n",
      "80689H102      1\n",
      "12811p108      1\n",
      "Name: stock_id, Length: 7744, dtype: int64\n",
      "\n",
      "For period_end 2019-06-30 :\n",
      "594918104    676\n",
      "037833100    643\n",
      "023135106    563\n",
      "478160104    533\n",
      "254687106    471\n",
      "            ... \n",
      "26433C105      1\n",
      "58733r102      1\n",
      "55977T109      1\n",
      "09061GAF8      1\n",
      "78709y105      1\n",
      "Name: stock_id, Length: 7333, dtype: int64\n",
      "\n",
      "For period_end 2019-09-30 :\n",
      "594918104    900\n",
      "037833100    873\n",
      "478160104    720\n",
      "023135106    720\n",
      "46625H100    653\n",
      "            ... \n",
      "292554102      1\n",
      "31846V203      1\n",
      "95790A101      1\n",
      "71377E105      1\n",
      "67062J102      1\n",
      "Name: stock_id, Length: 7873, dtype: int64\n",
      "\n",
      "For period_end 2019-12-31 :\n",
      "037833100    38\n",
      "594918104    32\n",
      "023135106    27\n",
      "78462F103    26\n",
      "478160104    25\n",
      "             ..\n",
      "700666100     1\n",
      "87265KAD4     1\n",
      "23305L206     1\n",
      "92204A884     1\n",
      "46428R107     1\n",
      "Name: stock_id, Length: 1370, dtype: int64\n",
      "\n",
      "For period_end 2020-03-31 :\n",
      "594918104    1167\n",
      "037833100    1104\n",
      "023135106     966\n",
      "478160104     884\n",
      "02079K305     768\n",
      "             ... \n",
      "93317Q105       1\n",
      "783925571       1\n",
      "85254J409       1\n",
      "384278107       1\n",
      "55274E102       1\n",
      "Name: stock_id, Length: 7889, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "def counter(currentdf):\n",
    "    #empty dictionary that will store number of times a stock appears\n",
    "    dfs2 = (currentdf.stock_id.value_counts())\n",
    "    return(dfs2)\n",
    "\n",
    "#counter(dfs[\"2012-12-31\"])\n",
    "\n",
    "print (\"period_end denotes end of the previous quarter\")\n",
    "\n",
    "for i in df.period_end.unique():\n",
    "    print (\"\\nFor period_end\", i, \":\")\n",
    "    print (counter(dfs[i]))\n",
    "        \n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# PROCESS\n",
    "#sort data by period end date\n",
    "#within each quarter, count how many times the stock appears\n",
    "\n",
    "#x1 The number of funds that held the stock in the past quarter\n",
    "#iCIK is fund identifier\n",
    "#stock_id is the stock identifier\n",
    "#divide timeframe into quarters - split csv into \n",
    "#find each individual stock in the 13f file\n",
    "#everytime another row of that stock id is found, add one to the count of the variable\n",
    "\n",
    "\n",
    "#load data set into dataframe\n",
    "#load everything within requested dates into second dataframe\n",
    "#array object "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}