Skip to content

Instantly share code, notes, and snippets.

@chusqui

chusqui/insider-trading-tutorial-full.ipynb

Forked from janlukasschroeder/insider-trading-tutorial-full.ipynb
Last active February 21, 2022 07:09
Show Gist options
  • Save chusqui/17a7db1376c03dc85d504b6d083c4b8b to your computer and use it in GitHub Desktop.
Save chusqui/17a7db1376c03dc85d504b6d083c4b8b to your computer and use it in GitHub Desktop.
Download ZIP
Insider Trading - Python Tutorial
Display the source blob
Display the rendered blob
Raw
insider-trading-tutorial-full.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Insider Trading - Python Tutorial - SEC API"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"In this tutorial we \n",
"- explore the [SEC API](https://sec-api.io), \n",
"- extract SEC filings of type 4 (statement of changes in beneficial ownership of securities, aka insider trades) \n",
"- visualise sales and acquisitions (in $) of non-derivitate securities per day\n",
"\n",
"You can find a detailed documentation of SEC API here: https://sec-api.io/docs "
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Boilterplate\n",
"\n",
"Let's start by defining some boilerplate to fetch filings and format the returned values."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"# Package used to execute HTTP POST request to the API\n",
"import json\n",
"import urllib.request\n",
"\n",
"# Your API token from sec-api.io\n",
"TOKEN = YOUR_API_TOKEN\n",
"# API endpoint\n",
"API = \"https://api.sec-api.io\" + TOKEN\n",
"\n",
"# Define the filter parameters\n",
"filter = \"formType:\\\"4\\\" AND formType:(NOT \\\"N-4\\\") AND formType:(NOT \\\"4/A\\\") AND filedAt:[2020-01-01 TO 2022-02-01]\"\n",
"# Start with the first filing. Increase it when paginating. \n",
"# Set to 10000 if you want to fetch the next batch of filings. Set to 20000 for the next and so on.\n",
"start = 0\n",
"# Return 10,000 filings per API call\n",
"size = 10000\n",
"# Sort in descending order by filedAt\n",
"sort = [{ \"filedAt\": { \"order\": \"desc\" } }]\n",
"\n",
"payload = {\n",
" \"query\": { \"query_string\": { \"query\": filter } },\n",
" \"from\": start,\n",
" \"size\": size,\n",
" \"sort\": sort\n",
"}\n",
"\n",
"# Format your payload to JSON bytes\n",
"jsondata = json.dumps(payload)\n",
"jsondataasbytes = jsondata.encode('utf-8') # needs to be bytes\n",
"\n",
"# Instantiate the request \n",
"req = urllib.request.Request(API)\n",
"\n",
"# Set the correct HTTP header: Content-Type = application/json\n",
"req.add_header('Content-Type', 'application/json; charset=utf-8')\n",
"# Set the correct length of your request\n",
"req.add_header('Content-Length', len(jsondataasbytes))\n",
"\n",
"# Send the request to the API\n",
"response = urllib.request.urlopen(req, jsondataasbytes)\n",
"\n",
"# Read the response \n",
"res_body = response.read()\n",
"# Transform the response into JSON\n",
"filingsJson = json.loads(res_body.decode(\"utf-8\"))"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Inspect filings"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"scrolled": true
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"IOPub data rate exceeded.\n",
"The notebook server will temporarily stop sending output\n",
"to the client in order to avoid crashing it.\n",
"To change this limit, set the config variable\n",
"`--NotebookApp.iopub_data_rate_limit`.\n"
]
}
],
"source": [
"# Print the response. Most likely this will throw an error because we fetched a\n",
"# large amount of data (10,000 filings). Reduce the number of filings and you will see a result here.\n",
"print(json.dumps(filingsJson, indent=2))"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"21521\n"
]
}
],
"source": [
"# Show us how many filings matched our filter criteria. \n",
"# This number is most likely different from the number of filings returned by the API.\n",
"print(filingsJson['total'])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Compressing Filings (for demo purposes only)\n",
"\n",
"We reduce the number of filings per day to a maximum of 5 for demo purposes so that you can run this notebook on your local machine. You can run it without reducing the size, but it takes significantly longer because each SEC filing is downloaded in series. \n",
"\n",
"Feel free to add a parallel downloader to accelerate the process."
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"def compress_filings (filings):\n",
" store = {}\n",
" compressed_filings = []\n",
" for filing in filings:\n",
" filedAt = filing['filedAt']\n",
" if filedAt in store and store[filedAt] < 5:\n",
" compressed_filings.append(filing)\n",
" store[filedAt] += 1\n",
" elif filedAt not in store:\n",
" compressed_filings.append(filing)\n",
" store[filedAt] = 1\n",
" return compressed_filings"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[{'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-08-01',\n",
" 'formType': '4',\n",
" 'id': '9e56073b1a40b7a1c9d5e9eed3b6c7bd',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010784-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010784.txt',\n",
" 'ticker': 'DRI'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-08-01',\n",
" 'formType': '4',\n",
" 'id': 'e32dcb14f23fcab978203d38457ef61a',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010788-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010788.txt',\n",
" 'ticker': 'DRI'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-08-01',\n",
" 'formType': '4',\n",
" 'id': 'e4849f9d85d6e03927f979aba07f8e5e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010792-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010792.txt',\n",
" 'ticker': 'DRI'},\n",
" {'cik': '945841',\n",
" 'companyName': 'POOL CORP',\n",
" 'filedAt': '2019-08-01',\n",
" 'formType': '4',\n",
" 'id': '8bcdc14c786ac69b5e55d91fbd5973c7',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/945841/0000945841-19-000119-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/945841/0000945841-19-000119.txt',\n",
" 'ticker': 'POOL'},\n",
" {'cik': '91440',\n",
" 'companyName': 'SNAP-ON Inc',\n",
" 'filedAt': '2019-08-01',\n",
" 'formType': '4',\n",
" 'id': '4e1b26768f4a93a5a5fc87101daca657',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/91440/0001127602-19-025675-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/91440/0001127602-19-025675.txt',\n",
" 'ticker': 'SNA'},\n",
" {'cik': '943819',\n",
" 'companyName': 'RESMED INC',\n",
" 'filedAt': '2019-07-31',\n",
" 'formType': '4',\n",
" 'id': '35ba19b15daa1028409d1c45fd29c4c1',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/943819/0001127602-19-025470-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/943819/0001127602-19-025470.txt',\n",
" 'ticker': 'RMD'},\n",
" {'cik': '937098',\n",
" 'companyName': 'TRINET GROUP INC',\n",
" 'filedAt': '2019-07-31',\n",
" 'formType': '4',\n",
" 'id': 'c34cd75a3efe2b24e8c709d5204ecbae',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/937098/0000937098-19-000186-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/937098/0000937098-19-000186.txt',\n",
" 'ticker': 'TNET'},\n",
" {'cik': '97745',\n",
" 'companyName': 'THERMO FISHER SCIENTIFIC INC.',\n",
" 'filedAt': '2019-07-31',\n",
" 'formType': '4',\n",
" 'id': 'a6c643d9fb6e920ea24c6ba2b96fdcbe',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97745/0001127602-19-025508-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97745/0001127602-19-025508.txt',\n",
" 'ticker': 'TMO'},\n",
" {'cik': '1592176',\n",
" 'companyName': 'Kamerschen Robert W.',\n",
" 'filedAt': '2019-07-31',\n",
" 'formType': '4',\n",
" 'id': 'b1d46fc21be8a3442a918c098c057d94',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1592176/0000706688-19-000155-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1592176/0000706688-19-000155.txt',\n",
" 'ticker': ''},\n",
" {'cik': '913144',\n",
" 'companyName': 'RENAISSANCERE HOLDINGS LTD',\n",
" 'filedAt': '2019-07-31',\n",
" 'formType': '4',\n",
" 'id': 'f410770c9a0f428a5fe5136c5ba42d70',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/913144/0001209191-19-043844-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/913144/0001209191-19-043844.txt',\n",
" 'ticker': 'RNR'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-07-30',\n",
" 'formType': '4',\n",
" 'id': 'b5d716c2d6d757832501bdcbf65d5e4c',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010705-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010705.txt',\n",
" 'ticker': 'DRI'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-07-30',\n",
" 'formType': '4',\n",
" 'id': '659dd4985293fe5d804ca322858bb4bf',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010702-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010702.txt',\n",
" 'ticker': 'DRI'},\n",
" {'cik': '914208',\n",
" 'companyName': 'Invesco Ltd.',\n",
" 'filedAt': '2019-07-30',\n",
" 'formType': '4',\n",
" 'id': '80ace4ce45dc022a716a5bbc00199a8c',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/914208/0001209191-19-043653-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/914208/0001209191-19-043653.txt',\n",
" 'ticker': 'IVZ'},\n",
" {'cik': '912767',\n",
" 'companyName': 'UNIVERSAL FOREST PRODUCTS INC',\n",
" 'filedAt': '2019-07-30',\n",
" 'formType': '4',\n",
" 'id': '154bc2bed3c6aa2f352b0e81127d73fb',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/912767/0001214659-19-004823-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/912767/0001214659-19-004823.txt',\n",
" 'ticker': 'UFPI'},\n",
" {'cik': '910638',\n",
" 'companyName': '3D SYSTEMS CORP',\n",
" 'filedAt': '2019-07-30',\n",
" 'formType': '4',\n",
" 'id': '2daeef5dbc57899f97345d68e13d378b',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/910638/0001209191-19-043651-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/910638/0001209191-19-043651.txt',\n",
" 'ticker': 'DDD'},\n",
" {'cik': '94049',\n",
" 'companyName': 'STEPAN CO',\n",
" 'filedAt': '2019-07-29',\n",
" 'formType': '4',\n",
" 'id': '5501a19f748fa5a5e7056813da8b35a1',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/94049/0001127602-19-025350-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/94049/0001127602-19-025350.txt',\n",
" 'ticker': 'SCL'},\n",
" {'cik': '938885',\n",
" 'companyName': 'ROGERS JOHN W JR',\n",
" 'filedAt': '2019-07-29',\n",
" 'formType': '4',\n",
" 'id': '8d7432a462a2def533503cfc7ea9c7c3',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/938885/0001209191-19-043510-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/938885/0001209191-19-043510.txt',\n",
" 'ticker': ''},\n",
" {'cik': '97476',\n",
" 'companyName': 'TEXAS INSTRUMENTS INC',\n",
" 'filedAt': '2019-07-29',\n",
" 'formType': '4',\n",
" 'id': '57dfe40cd04e98deaf9280c200ce26ec',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97476/0001127602-19-025375-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97476/0001127602-19-025375.txt',\n",
" 'ticker': 'TXN'},\n",
" {'cik': '807707',\n",
" 'companyName': 'VOXX International Corp',\n",
" 'filedAt': '2019-07-29',\n",
" 'formType': '4',\n",
" 'id': '12bd06b372779cd123ea2fd3ff7cb29b',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/807707/0001567619-19-015304-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/807707/0001567619-19-015304.txt',\n",
" 'ticker': 'VOXX'},\n",
" {'cik': '91576',\n",
" 'companyName': 'KEYCORP /NEW/',\n",
" 'filedAt': '2019-07-29',\n",
" 'formType': '4',\n",
" 'id': 'd309e4e2731de5cf7c7c68fb7c13c810',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/91576/0001294671-19-000057-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/91576/0001294671-19-000057.txt',\n",
" 'ticker': 'KEY'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-07-26',\n",
" 'formType': '4',\n",
" 'id': '3c332bc45aca7065d2a16c80250e8f45',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010519-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010519.txt',\n",
" 'ticker': 'DRI'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-07-26',\n",
" 'formType': '4',\n",
" 'id': '097cc9d2adbf7a4f7dfc15b03e456490',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010521-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010521.txt',\n",
" 'ticker': 'DRI'},\n",
" {'cik': '937098',\n",
" 'companyName': 'TRINET GROUP INC',\n",
" 'filedAt': '2019-07-26',\n",
" 'formType': '4',\n",
" 'id': 'eb37f79fffb4c6bbf66a0e41b85ab704',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/937098/0000937098-19-000184-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/937098/0000937098-19-000184.txt',\n",
" 'ticker': 'TNET'},\n",
" {'cik': '945783',\n",
" 'companyName': 'SOCHET IRA',\n",
" 'filedAt': '2019-07-26',\n",
" 'formType': '4',\n",
" 'id': 'ab359c98c5458da3715c85fc5a53304e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/945783/0001415889-19-000870-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/945783/0001415889-19-000870.txt',\n",
" 'ticker': ''},\n",
" {'cik': '879635',\n",
" 'companyName': 'MID PENN BANCORP INC',\n",
" 'filedAt': '2019-07-26',\n",
" 'formType': '4',\n",
" 'id': '11be79578ea03a8df7c62630cacf7a96',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/879635/0001171843-19-004906-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/879635/0001171843-19-004906.txt',\n",
" 'ticker': 'MPB'},\n",
" {'cik': '97517',\n",
" 'companyName': 'TEXAS PACIFIC LAND TRUST',\n",
" 'filedAt': '2019-07-25',\n",
" 'formType': '4',\n",
" 'id': '36402f0081a7e6bdcda2bdee00780fe3',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000060-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000060.txt',\n",
" 'ticker': 'TPL'},\n",
" {'cik': '917273',\n",
" 'companyName': 'RAMBUS INC',\n",
" 'filedAt': '2019-07-25',\n",
" 'formType': '4',\n",
" 'id': 'b0ae50d49acc1fb166b35e1de6f6a1ce',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/917273/0001209191-19-043218-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/917273/0001209191-19-043218.txt',\n",
" 'ticker': 'RMBS'},\n",
" {'cik': '922621',\n",
" 'companyName': 'ERIE INDEMNITY CO',\n",
" 'filedAt': '2019-07-25',\n",
" 'formType': '4',\n",
" 'id': 'cb3466822abc857bb71ea7de7153e605',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025179-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025179.txt',\n",
" 'ticker': 'ERIE'},\n",
" {'cik': '922621',\n",
" 'companyName': 'ERIE INDEMNITY CO',\n",
" 'filedAt': '2019-07-25',\n",
" 'formType': '4',\n",
" 'id': '4276919972ee908b0cc816ff03b3e92a',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025183-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025183.txt',\n",
" 'ticker': 'ERIE'},\n",
" {'cik': '922621',\n",
" 'companyName': 'ERIE INDEMNITY CO',\n",
" 'filedAt': '2019-07-25',\n",
" 'formType': '4',\n",
" 'id': '5053b60809a3faa74e8ac4a29248123e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025186-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025186.txt',\n",
" 'ticker': 'ERIE'},\n",
" {'cik': '946647',\n",
" 'companyName': 'FIRST DEFIANCE FINANCIAL CORP',\n",
" 'filedAt': '2019-07-24',\n",
" 'formType': '4',\n",
" 'id': '4f5c7ac2cf841de0ff87bbc6ab2ff19c',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/946647/0001144204-19-035733-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/946647/0001144204-19-035733.txt',\n",
" 'ticker': 'FDEF'},\n",
" {'cik': '1782817',\n",
" 'companyName': 'Shukla Sath',\n",
" 'filedAt': '2019-07-24',\n",
" 'formType': '4',\n",
" 'id': '950a7724cc5ff4ae6c8063a9212529c4',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1782817/0001209191-19-042993-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1782817/0001209191-19-042993.txt',\n",
" 'ticker': ''},\n",
" {'cik': '922621',\n",
" 'companyName': 'ERIE INDEMNITY CO',\n",
" 'filedAt': '2019-07-24',\n",
" 'formType': '4',\n",
" 'id': '49f55e3c657a970f094668ec438b6bcb',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025115-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025115.txt',\n",
" 'ticker': 'ERIE'},\n",
" {'cik': '933141',\n",
" 'companyName': 'IBERIABANK CORP',\n",
" 'filedAt': '2019-07-24',\n",
" 'formType': '4',\n",
" 'id': 'a8c092b9875fba7a83937b10c9bb38fa',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/933141/0001562180-19-004047-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/933141/0001562180-19-004047.txt',\n",
" 'ticker': 'IBKC'},\n",
" {'cik': '88941',\n",
" 'companyName': 'SEMTECH CORP',\n",
" 'filedAt': '2019-07-24',\n",
" 'formType': '4',\n",
" 'id': 'd81973408cee736a4696ddf6e110c902',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/88941/0001593968-19-001650-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/88941/0001593968-19-001650.txt',\n",
" 'ticker': 'SMTC'},\n",
" {'cik': '97745',\n",
" 'companyName': 'THERMO FISHER SCIENTIFIC INC.',\n",
" 'filedAt': '2019-07-23',\n",
" 'formType': '4',\n",
" 'id': '23151796be0b495bb40366eeb353305e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97745/0001127602-19-025077-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97745/0001127602-19-025077.txt',\n",
" 'ticker': 'TMO'},\n",
" {'cik': '946563',\n",
" 'companyName': 'RETRACTABLE TECHNOLOGIES INC',\n",
" 'filedAt': '2019-07-23',\n",
" 'formType': '4',\n",
" 'id': '55cb7803a08f55eb4a7523fcf7515c22',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/946563/0001174567-19-000065-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/946563/0001174567-19-000065.txt',\n",
" 'ticker': 'RVP'},\n",
" {'cik': '810332',\n",
" 'companyName': 'MESA AIR GROUP INC',\n",
" 'filedAt': '2019-07-23',\n",
" 'formType': '4',\n",
" 'id': 'd9c3fb4a7770d74956ec1e9eac4d80a5',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/810332/0001209191-19-042987-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/810332/0001209191-19-042987.txt',\n",
" 'ticker': 'MESA'},\n",
" {'cik': '867374',\n",
" 'companyName': 'ELECTRONICS FOR IMAGING INC',\n",
" 'filedAt': '2019-07-23',\n",
" 'formType': '4',\n",
" 'id': '75953cc6c2b7f87d816b2cd539c8f11e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/867374/0000867374-19-000058-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/867374/0000867374-19-000058.txt',\n",
" 'ticker': 'EFII'},\n",
" {'cik': '867374',\n",
" 'companyName': 'ELECTRONICS FOR IMAGING INC',\n",
" 'filedAt': '2019-07-23',\n",
" 'formType': '4',\n",
" 'id': '8b6eaff07ce0c339ff8e82dffb885359',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/867374/0000867374-19-000061-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/867374/0000867374-19-000061.txt',\n",
" 'ticker': 'EFII'},\n",
" {'cik': '942698',\n",
" 'companyName': 'ALEXANDER PATRICK L',\n",
" 'filedAt': '2019-07-22',\n",
" 'formType': '4',\n",
" 'id': 'd944841cca1c7b18b9aded8fb191f929',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/942698/0001493152-19-010949-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/942698/0001493152-19-010949.txt',\n",
" 'ticker': ''},\n",
" {'cik': '901483',\n",
" 'companyName': 'ANTIN ROBERT L',\n",
" 'filedAt': '2019-07-22',\n",
" 'formType': '4',\n",
" 'id': 'bc2ef5699a166920ced27e6f77cdb306',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/901483/0001213900-19-013318-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/901483/0001213900-19-013318.txt',\n",
" 'ticker': ''},\n",
" {'cik': '861842',\n",
" 'companyName': 'CATHAY GENERAL BANCORP',\n",
" 'filedAt': '2019-07-22',\n",
" 'formType': '4',\n",
" 'id': '4c9214ab2dbfd1933bd61b08b1c553f6',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/861842/0001437749-19-014397-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/861842/0001437749-19-014397.txt',\n",
" 'ticker': 'CATY'},\n",
" {'cik': '87347',\n",
" 'companyName': 'SCHLUMBERGER LIMITED/NV',\n",
" 'filedAt': '2019-07-22',\n",
" 'formType': '4',\n",
" 'id': 'dbdb22539492ce5deb50a763cf103783',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/87347/0001127602-19-025018-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/87347/0001127602-19-025018.txt',\n",
" 'ticker': 'SLB'},\n",
" {'cik': '87347',\n",
" 'companyName': 'SCHLUMBERGER LIMITED/NV',\n",
" 'filedAt': '2019-07-22',\n",
" 'formType': '4',\n",
" 'id': '28347427085cd0bd52d8917c0eb65f1f',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/87347/0001127602-19-025020-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/87347/0001127602-19-025020.txt',\n",
" 'ticker': 'SLB'},\n",
" {'cik': '97517',\n",
" 'companyName': 'TEXAS PACIFIC LAND TRUST',\n",
" 'filedAt': '2019-07-19',\n",
" 'formType': '4',\n",
" 'id': 'ccae8c908180abe617f91754ea711558',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000056-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000056.txt',\n",
" 'ticker': 'TPL'},\n",
" {'cik': '9092',\n",
" 'companyName': 'BADGER METER INC',\n",
" 'filedAt': '2019-07-19',\n",
" 'formType': '4',\n",
" 'id': '265aff6d79b08e66bae5fa60f246b8bd',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/9092/0001209191-19-042746-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/9092/0001209191-19-042746.txt',\n",
" 'ticker': 'BMI'},\n",
" {'cik': '890491',\n",
" 'companyName': 'BARNES & NOBLE INC',\n",
" 'filedAt': '2019-07-19',\n",
" 'formType': '4',\n",
" 'id': '682909d1f74428c1b99dc3860b0e71b9',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/890491/0000950138-19-000389-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/890491/0000950138-19-000389.txt',\n",
" 'ticker': 'BKS'},\n",
" {'cik': '890491',\n",
" 'companyName': 'BARNES & NOBLE INC',\n",
" 'filedAt': '2019-07-19',\n",
" 'formType': '4',\n",
" 'id': 'e05480b25c8a19c95ab16df9f4943551',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/890491/0000950138-19-000393-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/890491/0000950138-19-000393.txt',\n",
" 'ticker': 'BKS'},\n",
" {'cik': '84129',\n",
" 'companyName': 'RITE AID CORP',\n",
" 'filedAt': '2019-07-19',\n",
" 'formType': '4',\n",
" 'id': '879ea15b0754715308faa92727ced670',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/84129/0001209191-19-042788-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/84129/0001209191-19-042788.txt',\n",
" 'ticker': 'RAD'},\n",
" {'cik': '938659',\n",
" 'companyName': 'GOLD JEFFREY',\n",
" 'filedAt': '2019-07-18',\n",
" 'formType': '4',\n",
" 'id': 'db8d833aab4f55ee456fbc2334242839',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/938659/0001567619-19-014985-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/938659/0001567619-19-014985.txt',\n",
" 'ticker': ''},\n",
" {'cik': '9984',\n",
" 'companyName': 'BARNES GROUP INC',\n",
" 'filedAt': '2019-07-18',\n",
" 'formType': '4',\n",
" 'id': '8d3c22be462579dbbe109017597e27bc',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/9984/0000009984-19-000067-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/9984/0000009984-19-000067.txt',\n",
" 'ticker': 'B'},\n",
" {'cik': '9984',\n",
" 'companyName': 'BARNES GROUP INC',\n",
" 'filedAt': '2019-07-18',\n",
" 'formType': '4',\n",
" 'id': 'c68d3c104f4accb9888223cc81e109d1',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/9984/0000009984-19-000068-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/9984/0000009984-19-000068.txt',\n",
" 'ticker': 'B'},\n",
" {'cik': '946644',\n",
" 'companyName': 'HEMISPHERX BIOPHARMA INC',\n",
" 'filedAt': '2019-07-18',\n",
" 'formType': '4',\n",
" 'id': 'd9a192fa109b7dc0538893e9b71fdd86',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/946644/0001191434-19-000009-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/946644/0001191434-19-000009.txt',\n",
" 'ticker': 'HEB'},\n",
" {'cik': '928464',\n",
" 'companyName': 'HIGH RIVER LIMITED PARTNERSHIP',\n",
" 'filedAt': '2019-07-18',\n",
" 'formType': '4',\n",
" 'id': '9de4f59646e763f69036888524e2e57d',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/928464/0001567619-19-014989-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/928464/0001567619-19-014989.txt',\n",
" 'ticker': ''},\n",
" {'cik': '938071',\n",
" 'companyName': 'DUFFIELD DAVID A',\n",
" 'filedAt': '2019-07-17',\n",
" 'formType': '4',\n",
" 'id': '2fcd93528117c9c09630fad1f1d7cf53',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/938071/0001327811-19-000148-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/938071/0001327811-19-000148.txt',\n",
" 'ticker': ''},\n",
" {'cik': '9389',\n",
" 'companyName': 'BALL Corp',\n",
" 'filedAt': '2019-07-17',\n",
" 'formType': '4',\n",
" 'id': 'ae5aada2f61fe1187197f1797d3288e9',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/9389/0001562180-19-003974-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/9389/0001562180-19-003974.txt',\n",
" 'ticker': 'BLL'},\n",
" {'cik': '1608717',\n",
" 'companyName': 'MATHER COURTNEY',\n",
" 'filedAt': '2019-07-17',\n",
" 'formType': '4',\n",
" 'id': '99497d00c927e7834654a7f00be94247',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1608717/0001127602-19-024753-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1608717/0001127602-19-024753.txt',\n",
" 'ticker': ''},\n",
" {'cik': '914475',\n",
" 'companyName': 'NEUROCRINE BIOSCIENCES INC',\n",
" 'filedAt': '2019-07-17',\n",
" 'formType': '4',\n",
" 'id': '622af9383a55f8b7446ee25816d7fb8b',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/914475/0001209191-19-042522-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/914475/0001209191-19-042522.txt',\n",
" 'ticker': 'NBIX'},\n",
" {'cik': '911649',\n",
" 'companyName': 'STANDARD DIVERSIFIED INC.',\n",
" 'filedAt': '2019-07-17',\n",
" 'formType': '4',\n",
" 'id': 'd2068faa22d305e00ff3f1a109bc7c45',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/911649/0001140361-19-013081-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/911649/0001140361-19-013081.txt',\n",
" 'ticker': 'SDIX'},\n",
" {'cik': '1776446',\n",
" 'companyName': 'HITCHCOCK JEREMY P.',\n",
" 'filedAt': '2019-07-16',\n",
" 'formType': '4',\n",
" 'id': 'b99125e7cc022e87e1801ac5ce0eb3f9',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1776446/0001144204-19-034851-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1776446/0001144204-19-034851.txt',\n",
" 'ticker': ''},\n",
" {'cik': '822708',\n",
" 'companyName': 'ZOOM TECHNOLOGIES INC',\n",
" 'filedAt': '2019-07-16',\n",
" 'formType': '4',\n",
" 'id': '085a449fbe48443c6597fc712095340a',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/822708/0001144204-19-034851-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/822708/0001144204-19-034851.txt',\n",
" 'ticker': 'ZOOM'},\n",
" {'cik': '916076',\n",
" 'companyName': 'MARTIN MARIETTA MATERIALS INC',\n",
" 'filedAt': '2019-07-16',\n",
" 'formType': '4',\n",
" 'id': 'e8c828e85ba33fe1b025a9c31d2b036c',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/916076/0001127602-19-024591-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/916076/0001127602-19-024591.txt',\n",
" 'ticker': 'MLM'},\n",
" {'cik': '928464',\n",
" 'companyName': 'HIGH RIVER LIMITED PARTNERSHIP',\n",
" 'filedAt': '2019-07-16',\n",
" 'formType': '4',\n",
" 'id': '78dbe2e689f5b2c6e1e39b00f0227349',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/928464/0001567619-19-014858-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/928464/0001567619-19-014858.txt',\n",
" 'ticker': ''},\n",
" {'cik': '935494',\n",
" 'companyName': 'NATIONAL INSTRUMENTS CORP',\n",
" 'filedAt': '2019-07-16',\n",
" 'formType': '4',\n",
" 'id': 'd8a980513ec0de6990c316ec2202eaa7',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/935494/0001567619-19-014892-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/935494/0001567619-19-014892.txt',\n",
" 'ticker': 'NATI'},\n",
" {'cik': '97517',\n",
" 'companyName': 'TEXAS PACIFIC LAND TRUST',\n",
" 'filedAt': '2019-07-15',\n",
" 'formType': '4',\n",
" 'id': '68f7ec3f480127b63a251df772686cef',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000052-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000052.txt',\n",
" 'ticker': 'TPL'},\n",
" {'cik': '908724',\n",
" 'companyName': 'DELL MICHAEL S',\n",
" 'filedAt': '2019-07-15',\n",
" 'formType': '4',\n",
" 'id': '11c947a36b762b9236748fbbc5799dd3',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/908724/0001123292-19-000998-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/908724/0001123292-19-000998.txt',\n",
" 'ticker': ''},\n",
" {'cik': '902791',\n",
" 'companyName': 'BARRETT BUSINESS SERVICES INC',\n",
" 'filedAt': '2019-07-15',\n",
" 'formType': '4',\n",
" 'id': 'f67f6866ee357066bb4371ea567a6ffa',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/902791/0001562180-19-003940-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/902791/0001562180-19-003940.txt',\n",
" 'ticker': 'BBSI'},\n",
" {'cik': '870826',\n",
" 'companyName': 'EVINE Live Inc.',\n",
" 'filedAt': '2019-07-15',\n",
" 'formType': '4',\n",
" 'id': '2409bcedb9b068b0cb77828954adb106',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/870826/0001437749-19-014008-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/870826/0001437749-19-014008.txt',\n",
" 'ticker': 'EVLV'},\n",
" {'cik': '870826',\n",
" 'companyName': 'EVINE Live Inc.',\n",
" 'filedAt': '2019-07-15',\n",
" 'formType': '4',\n",
" 'id': '9faa00daf4b1323028a1310f2660143e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/870826/0001437749-19-014009-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/870826/0001437749-19-014009.txt',\n",
" 'ticker': 'EVLV'},\n",
" {'cik': '97216',\n",
" 'companyName': 'TEREX CORP',\n",
" 'filedAt': '2019-07-12',\n",
" 'formType': '4',\n",
" 'id': '24753009d398a0bad3daf489128823e0',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97216/0000097216-19-000167-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97216/0000097216-19-000167.txt',\n",
" 'ticker': 'TEX'},\n",
" {'cik': '1699940',\n",
" 'companyName': 'SoftBank Vision Fund L.P.',\n",
" 'filedAt': '2019-07-12',\n",
" 'formType': '4',\n",
" 'id': '319a5aaf03c7378d7666fe7d050003bc',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1699940/0001209191-19-041996-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1699940/0001209191-19-041996.txt',\n",
" 'ticker': ''},\n",
" {'cik': '1736768',\n",
" 'companyName': 'Jones Mark Evan',\n",
" 'filedAt': '2019-07-12',\n",
" 'formType': '4',\n",
" 'id': 'b6371f960c21c88907165d82cedfcd2c',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1736768/0001726978-19-000225-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1736768/0001726978-19-000225.txt',\n",
" 'ticker': ''},\n",
" {'cik': '914475',\n",
" 'companyName': 'NEUROCRINE BIOSCIENCES INC',\n",
" 'filedAt': '2019-07-12',\n",
" 'formType': '4',\n",
" 'id': '3dce7aadf76d8cffa1b289672ce80133',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/914475/0001209191-19-041925-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/914475/0001209191-19-041925.txt',\n",
" 'ticker': 'NBIX'},\n",
" {'cik': '901733',\n",
" 'companyName': 'RANKIN ROGER F',\n",
" 'filedAt': '2019-07-12',\n",
" 'formType': '4',\n",
" 'id': '9e34b57c59e66aa0599dbd8bffdbddc8',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/901733/0001127602-19-024463-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/901733/0001127602-19-024463.txt',\n",
" 'ticker': ''}]"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"filings = compress_filings(filingsJson['filings'])\n",
"filings"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Download Filing 4 Data\n",
"\n",
"Let's implement the download and XML parse methods. The XML parser extracts all non-derivitative transactions listed in the 4 filing. It considers `disposal` and `acquisition` of items and calculates the sum of all transactions (sold and bought).\n",
"\n",
"**Important:** the downloader doesn't differentiate between filing issuer and reporter. In other words, we download the issuer's and reporter's filing. The reported transactions in both filings are the same and we double count transactions. That's OK for demonstration purposes but has to be cleaned when building a production version."
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import xml.etree.ElementTree as ET\n",
"import re\n",
"import time\n",
"\n",
"# Download the XML version of the filing. If it fails wait for 5, 10, 15, ... seconds and try again.\n",
"def download_xml (url, tries = 1):\n",
" try: \n",
" response = urllib.request.urlopen(url)\n",
" except:\n",
" print('Something went wrong. Wait for 5 seconds and try again.', tries)\n",
" if tries < 5:\n",
" time.sleep(5 * tries)\n",
" download_xml(url, tries + 1)\n",
" else: \n",
" # decode the response into a string\n",
" data = response.read().decode('utf-8')\n",
" # set up the regular expression extractoer in order to get the relevant part of the filing\n",
" matcher = re.compile('<\\?xml.*ownershipDocument>', flags=re.MULTILINE|re.DOTALL)\n",
" matches = matcher.search(data)\n",
" # the first matching group is the extracted XML of interest\n",
" xml = matches.group(0)\n",
" # instantiate the XML object\n",
" root = ET.fromstring(xml)\n",
" print(url)\n",
" return root "
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"# Calculate the total transaction amount in $ of a giving form 4 in XML\n",
"def calculate_transaction_amount (xml):\n",
" total = 0\n",
" \n",
" if xml is None:\n",
" return total\n",
" \n",
" nonDerivativeTransactions = xml.findall(\"./nonDerivativeTable/nonDerivativeTransaction\")\n",
"\n",
" for t in nonDerivativeTransactions:\n",
" # D for disposed or A for acquired\n",
" action = t.find('./transactionAmounts/transactionAcquiredDisposedCode/value').text\n",
" # number of shares disposed/acquired\n",
" shares = t.find('./transactionAmounts/transactionShares/value').text\n",
" # price\n",
" priceRaw = t.find('./transactionAmounts/transactionPricePerShare/value')\n",
" price = 0 if priceRaw is None else priceRaw.text\n",
" # set prefix to -1 if derivatives were disposed. set prefix to 1 if derivates were acquired.\n",
" prefix = -1 if action == 'D' else 1\n",
" # calculate transaction amount in $\n",
" amount = prefix * float(shares) * float(price)\n",
" total += amount\n",
" \n",
" return round(total, 2)"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"https://www.sec.gov/Archives/edgar/data/1592176/0000706688-19-000155.txt\n"
]
},
{
"data": {
"text/plain": [
"-77996.0"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Test the calc function by using just one filing \n",
"url = 'https://www.sec.gov/Archives/edgar/data/1592176/0000706688-19-000155.txt' \n",
"xml = download_xml(url) \n",
"amount = calculate_transaction_amount(xml)\n",
"amount"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"# Download the XML for each filing\n",
"# Calculate the total transaction amount per filing\n",
"# Save the calculate transaction value to the filing dict with key 'nonDerivativeTransactions' \n",
"def add_non_derivative_transaction_amounts ():\n",
" for filing in filings:\n",
" url = filing['linkToTxt']\n",
" xml = download_xml(url)\n",
" nonDerivativeTransactions = calculate_transaction_amount(xml)\n",
" filing['nonDerivativeTransactions'] = nonDerivativeTransactions"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"scrolled": true
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010784.txt\n",
"https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010788.txt\n",
"https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010792.txt\n",
"https://www.sec.gov/Archives/edgar/data/945841/0000945841-19-000119.txt\n",
"https://www.sec.gov/Archives/edgar/data/91440/0001127602-19-025675.txt\n",
"https://www.sec.gov/Archives/edgar/data/943819/0001127602-19-025470.txt\n",
"https://www.sec.gov/Archives/edgar/data/937098/0000937098-19-000186.txt\n",
"https://www.sec.gov/Archives/edgar/data/97745/0001127602-19-025508.txt\n",
"https://www.sec.gov/Archives/edgar/data/1592176/0000706688-19-000155.txt\n",
"https://www.sec.gov/Archives/edgar/data/913144/0001209191-19-043844.txt\n",
"https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010705.txt\n",
"https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010702.txt\n",
"https://www.sec.gov/Archives/edgar/data/914208/0001209191-19-043653.txt\n",
"https://www.sec.gov/Archives/edgar/data/912767/0001214659-19-004823.txt\n",
"https://www.sec.gov/Archives/edgar/data/910638/0001209191-19-043651.txt\n",
"https://www.sec.gov/Archives/edgar/data/94049/0001127602-19-025350.txt\n",
"https://www.sec.gov/Archives/edgar/data/938885/0001209191-19-043510.txt\n",
"https://www.sec.gov/Archives/edgar/data/97476/0001127602-19-025375.txt\n",
"https://www.sec.gov/Archives/edgar/data/807707/0001567619-19-015304.txt\n",
"https://www.sec.gov/Archives/edgar/data/91576/0001294671-19-000057.txt\n",
"https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010519.txt\n",
"https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010521.txt\n",
"https://www.sec.gov/Archives/edgar/data/937098/0000937098-19-000184.txt\n",
"https://www.sec.gov/Archives/edgar/data/945783/0001415889-19-000870.txt\n",
"https://www.sec.gov/Archives/edgar/data/879635/0001171843-19-004906.txt\n",
"https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000060.txt\n",
"https://www.sec.gov/Archives/edgar/data/917273/0001209191-19-043218.txt\n",
"https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025179.txt\n",
"https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025183.txt\n",
"https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025186.txt\n",
"https://www.sec.gov/Archives/edgar/data/946647/0001144204-19-035733.txt\n",
"https://www.sec.gov/Archives/edgar/data/1782817/0001209191-19-042993.txt\n",
"https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025115.txt\n",
"https://www.sec.gov/Archives/edgar/data/933141/0001562180-19-004047.txt\n",
"https://www.sec.gov/Archives/edgar/data/88941/0001593968-19-001650.txt\n",
"https://www.sec.gov/Archives/edgar/data/97745/0001127602-19-025077.txt\n",
"https://www.sec.gov/Archives/edgar/data/946563/0001174567-19-000065.txt\n",
"https://www.sec.gov/Archives/edgar/data/810332/0001209191-19-042987.txt\n",
"https://www.sec.gov/Archives/edgar/data/867374/0000867374-19-000058.txt\n",
"https://www.sec.gov/Archives/edgar/data/867374/0000867374-19-000061.txt\n",
"https://www.sec.gov/Archives/edgar/data/942698/0001493152-19-010949.txt\n",
"https://www.sec.gov/Archives/edgar/data/901483/0001213900-19-013318.txt\n",
"https://www.sec.gov/Archives/edgar/data/861842/0001437749-19-014397.txt\n",
"https://www.sec.gov/Archives/edgar/data/87347/0001127602-19-025018.txt\n",
"https://www.sec.gov/Archives/edgar/data/87347/0001127602-19-025020.txt\n",
"https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000056.txt\n",
"https://www.sec.gov/Archives/edgar/data/9092/0001209191-19-042746.txt\n",
"https://www.sec.gov/Archives/edgar/data/890491/0000950138-19-000389.txt\n",
"https://www.sec.gov/Archives/edgar/data/890491/0000950138-19-000393.txt\n",
"https://www.sec.gov/Archives/edgar/data/84129/0001209191-19-042788.txt\n",
"https://www.sec.gov/Archives/edgar/data/938659/0001567619-19-014985.txt\n",
"https://www.sec.gov/Archives/edgar/data/9984/0000009984-19-000067.txt\n",
"https://www.sec.gov/Archives/edgar/data/9984/0000009984-19-000068.txt\n",
"https://www.sec.gov/Archives/edgar/data/946644/0001191434-19-000009.txt\n",
"https://www.sec.gov/Archives/edgar/data/928464/0001567619-19-014989.txt\n",
"https://www.sec.gov/Archives/edgar/data/938071/0001327811-19-000148.txt\n",
"https://www.sec.gov/Archives/edgar/data/9389/0001562180-19-003974.txt\n",
"https://www.sec.gov/Archives/edgar/data/1608717/0001127602-19-024753.txt\n",
"https://www.sec.gov/Archives/edgar/data/914475/0001209191-19-042522.txt\n",
"https://www.sec.gov/Archives/edgar/data/911649/0001140361-19-013081.txt\n",
"Something went wrong. Wait for 5 seconds and try again. 1\n",
"Something went wrong. Wait for 5 seconds and try again. 2\n",
"Something went wrong. Wait for 5 seconds and try again. 3\n",
"Something went wrong. Wait for 5 seconds and try again. 4\n",
"Something went wrong. Wait for 5 seconds and try again. 5\n",
"Something went wrong. Wait for 5 seconds and try again. 1\n",
"Something went wrong. Wait for 5 seconds and try again. 2\n",
"Something went wrong. Wait for 5 seconds and try again. 3\n",
"Something went wrong. Wait for 5 seconds and try again. 4\n",
"Something went wrong. Wait for 5 seconds and try again. 5\n",
"https://www.sec.gov/Archives/edgar/data/916076/0001127602-19-024591.txt\n",
"https://www.sec.gov/Archives/edgar/data/928464/0001567619-19-014858.txt\n",
"https://www.sec.gov/Archives/edgar/data/935494/0001567619-19-014892.txt\n",
"https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000052.txt\n",
"https://www.sec.gov/Archives/edgar/data/908724/0001123292-19-000998.txt\n",
"https://www.sec.gov/Archives/edgar/data/902791/0001562180-19-003940.txt\n",
"https://www.sec.gov/Archives/edgar/data/870826/0001437749-19-014008.txt\n",
"https://www.sec.gov/Archives/edgar/data/870826/0001437749-19-014009.txt\n",
"https://www.sec.gov/Archives/edgar/data/97216/0000097216-19-000167.txt\n",
"https://www.sec.gov/Archives/edgar/data/1699940/0001209191-19-041996.txt\n",
"https://www.sec.gov/Archives/edgar/data/1736768/0001726978-19-000225.txt\n",
"https://www.sec.gov/Archives/edgar/data/914475/0001209191-19-041925.txt\n",
"https://www.sec.gov/Archives/edgar/data/901733/0001127602-19-024463.txt\n"
]
}
],
"source": [
"# Running the function prints the URL of each filing fetched\n",
"add_non_derivative_transaction_amounts()"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/plain": [
"[{'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-08-01',\n",
" 'formType': '4',\n",
" 'id': '9e56073b1a40b7a1c9d5e9eed3b6c7bd',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010784-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010784.txt',\n",
" 'nonDerivativeTransactions': -14359.44,\n",
" 'ticker': 'DRI'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-08-01',\n",
" 'formType': '4',\n",
" 'id': 'e32dcb14f23fcab978203d38457ef61a',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010788-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010788.txt',\n",
" 'nonDerivativeTransactions': -32749.6,\n",
" 'ticker': 'DRI'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-08-01',\n",
" 'formType': '4',\n",
" 'id': 'e4849f9d85d6e03927f979aba07f8e5e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010792-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010792.txt',\n",
" 'nonDerivativeTransactions': -6046.08,\n",
" 'ticker': 'DRI'},\n",
" {'cik': '945841',\n",
" 'companyName': 'POOL CORP',\n",
" 'filedAt': '2019-08-01',\n",
" 'formType': '4',\n",
" 'id': '8bcdc14c786ac69b5e55d91fbd5973c7',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/945841/0000945841-19-000119-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/945841/0000945841-19-000119.txt',\n",
" 'nonDerivativeTransactions': -591178.25,\n",
" 'ticker': 'POOL'},\n",
" {'cik': '91440',\n",
" 'companyName': 'SNAP-ON Inc',\n",
" 'filedAt': '2019-08-01',\n",
" 'formType': '4',\n",
" 'id': '4e1b26768f4a93a5a5fc87101daca657',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/91440/0001127602-19-025675-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/91440/0001127602-19-025675.txt',\n",
" 'nonDerivativeTransactions': 12361.41,\n",
" 'ticker': 'SNA'},\n",
" {'cik': '943819',\n",
" 'companyName': 'RESMED INC',\n",
" 'filedAt': '2019-07-31',\n",
" 'formType': '4',\n",
" 'id': '35ba19b15daa1028409d1c45fd29c4c1',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/943819/0001127602-19-025470-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/943819/0001127602-19-025470.txt',\n",
" 'nonDerivativeTransactions': -1563563.44,\n",
" 'ticker': 'RMD'},\n",
" {'cik': '937098',\n",
" 'companyName': 'TRINET GROUP INC',\n",
" 'filedAt': '2019-07-31',\n",
" 'formType': '4',\n",
" 'id': 'c34cd75a3efe2b24e8c709d5204ecbae',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/937098/0000937098-19-000186-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/937098/0000937098-19-000186.txt',\n",
" 'nonDerivativeTransactions': -447830.57,\n",
" 'ticker': 'TNET'},\n",
" {'cik': '97745',\n",
" 'companyName': 'THERMO FISHER SCIENTIFIC INC.',\n",
" 'filedAt': '2019-07-31',\n",
" 'formType': '4',\n",
" 'id': 'a6c643d9fb6e920ea24c6ba2b96fdcbe',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97745/0001127602-19-025508-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97745/0001127602-19-025508.txt',\n",
" 'nonDerivativeTransactions': -10579365.69,\n",
" 'ticker': 'TMO'},\n",
" {'cik': '1592176',\n",
" 'companyName': 'Kamerschen Robert W.',\n",
" 'filedAt': '2019-07-31',\n",
" 'formType': '4',\n",
" 'id': 'b1d46fc21be8a3442a918c098c057d94',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1592176/0000706688-19-000155-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1592176/0000706688-19-000155.txt',\n",
" 'nonDerivativeTransactions': -77996.0,\n",
" 'ticker': ''},\n",
" {'cik': '913144',\n",
" 'companyName': 'RENAISSANCERE HOLDINGS LTD',\n",
" 'filedAt': '2019-07-31',\n",
" 'formType': '4',\n",
" 'id': 'f410770c9a0f428a5fe5136c5ba42d70',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/913144/0001209191-19-043844-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/913144/0001209191-19-043844.txt',\n",
" 'nonDerivativeTransactions': -171222.72,\n",
" 'ticker': 'RNR'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-07-30',\n",
" 'formType': '4',\n",
" 'id': 'b5d716c2d6d757832501bdcbf65d5e4c',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010705-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010705.txt',\n",
" 'nonDerivativeTransactions': -555231.68,\n",
" 'ticker': 'DRI'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-07-30',\n",
" 'formType': '4',\n",
" 'id': '659dd4985293fe5d804ca322858bb4bf',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010702-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010702.txt',\n",
" 'nonDerivativeTransactions': -841160.88,\n",
" 'ticker': 'DRI'},\n",
" {'cik': '914208',\n",
" 'companyName': 'Invesco Ltd.',\n",
" 'filedAt': '2019-07-30',\n",
" 'formType': '4',\n",
" 'id': '80ace4ce45dc022a716a5bbc00199a8c',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/914208/0001209191-19-043653-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/914208/0001209191-19-043653.txt',\n",
" 'nonDerivativeTransactions': 0.0,\n",
" 'ticker': 'IVZ'},\n",
" {'cik': '912767',\n",
" 'companyName': 'UNIVERSAL FOREST PRODUCTS INC',\n",
" 'filedAt': '2019-07-30',\n",
" 'formType': '4',\n",
" 'id': '154bc2bed3c6aa2f352b0e81127d73fb',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/912767/0001214659-19-004823-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/912767/0001214659-19-004823.txt',\n",
" 'nonDerivativeTransactions': -240704.26,\n",
" 'ticker': 'UFPI'},\n",
" {'cik': '910638',\n",
" 'companyName': '3D SYSTEMS CORP',\n",
" 'filedAt': '2019-07-30',\n",
" 'formType': '4',\n",
" 'id': '2daeef5dbc57899f97345d68e13d378b',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/910638/0001209191-19-043651-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/910638/0001209191-19-043651.txt',\n",
" 'nonDerivativeTransactions': -189325.5,\n",
" 'ticker': 'DDD'},\n",
" {'cik': '94049',\n",
" 'companyName': 'STEPAN CO',\n",
" 'filedAt': '2019-07-29',\n",
" 'formType': '4',\n",
" 'id': '5501a19f748fa5a5e7056813da8b35a1',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/94049/0001127602-19-025350-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/94049/0001127602-19-025350.txt',\n",
" 'nonDerivativeTransactions': -292017.55,\n",
" 'ticker': 'SCL'},\n",
" {'cik': '938885',\n",
" 'companyName': 'ROGERS JOHN W JR',\n",
" 'filedAt': '2019-07-29',\n",
" 'formType': '4',\n",
" 'id': '8d7432a462a2def533503cfc7ea9c7c3',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/938885/0001209191-19-043510-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/938885/0001209191-19-043510.txt',\n",
" 'nonDerivativeTransactions': 0.0,\n",
" 'ticker': ''},\n",
" {'cik': '97476',\n",
" 'companyName': 'TEXAS INSTRUMENTS INC',\n",
" 'filedAt': '2019-07-29',\n",
" 'formType': '4',\n",
" 'id': '57dfe40cd04e98deaf9280c200ce26ec',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97476/0001127602-19-025375-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97476/0001127602-19-025375.txt',\n",
" 'nonDerivativeTransactions': -42760202.35,\n",
" 'ticker': 'TXN'},\n",
" {'cik': '807707',\n",
" 'companyName': 'VOXX International Corp',\n",
" 'filedAt': '2019-07-29',\n",
" 'formType': '4',\n",
" 'id': '12bd06b372779cd123ea2fd3ff7cb29b',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/807707/0001567619-19-015304-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/807707/0001567619-19-015304.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': 'VOXX'},\n",
" {'cik': '91576',\n",
" 'companyName': 'KEYCORP /NEW/',\n",
" 'filedAt': '2019-07-29',\n",
" 'formType': '4',\n",
" 'id': 'd309e4e2731de5cf7c7c68fb7c13c810',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/91576/0001294671-19-000057-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/91576/0001294671-19-000057.txt',\n",
" 'nonDerivativeTransactions': -1825981.74,\n",
" 'ticker': 'KEY'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-07-26',\n",
" 'formType': '4',\n",
" 'id': '3c332bc45aca7065d2a16c80250e8f45',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010519-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010519.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': 'DRI'},\n",
" {'cik': '940944',\n",
" 'companyName': 'DARDEN RESTAURANTS INC',\n",
" 'filedAt': '2019-07-26',\n",
" 'formType': '4',\n",
" 'id': '097cc9d2adbf7a4f7dfc15b03e456490',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010521-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/940944/0001225208-19-010521.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': 'DRI'},\n",
" {'cik': '937098',\n",
" 'companyName': 'TRINET GROUP INC',\n",
" 'filedAt': '2019-07-26',\n",
" 'formType': '4',\n",
" 'id': 'eb37f79fffb4c6bbf66a0e41b85ab704',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/937098/0000937098-19-000184-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/937098/0000937098-19-000184.txt',\n",
" 'nonDerivativeTransactions': -1678038.7,\n",
" 'ticker': 'TNET'},\n",
" {'cik': '945783',\n",
" 'companyName': 'SOCHET IRA',\n",
" 'filedAt': '2019-07-26',\n",
" 'formType': '4',\n",
" 'id': 'ab359c98c5458da3715c85fc5a53304e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/945783/0001415889-19-000870-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/945783/0001415889-19-000870.txt',\n",
" 'nonDerivativeTransactions': 140122.23,\n",
" 'ticker': ''},\n",
" {'cik': '879635',\n",
" 'companyName': 'MID PENN BANCORP INC',\n",
" 'filedAt': '2019-07-26',\n",
" 'formType': '4',\n",
" 'id': '11be79578ea03a8df7c62630cacf7a96',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/879635/0001171843-19-004906-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/879635/0001171843-19-004906.txt',\n",
" 'nonDerivativeTransactions': 0.0,\n",
" 'ticker': 'MPB'},\n",
" {'cik': '97517',\n",
" 'companyName': 'TEXAS PACIFIC LAND TRUST',\n",
" 'filedAt': '2019-07-25',\n",
" 'formType': '4',\n",
" 'id': '36402f0081a7e6bdcda2bdee00780fe3',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000060-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000060.txt',\n",
" 'nonDerivativeTransactions': 36902.88,\n",
" 'ticker': 'TPL'},\n",
" {'cik': '917273',\n",
" 'companyName': 'RAMBUS INC',\n",
" 'filedAt': '2019-07-25',\n",
" 'formType': '4',\n",
" 'id': 'b0ae50d49acc1fb166b35e1de6f6a1ce',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/917273/0001209191-19-043218-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/917273/0001209191-19-043218.txt',\n",
" 'nonDerivativeTransactions': -4871.76,\n",
" 'ticker': 'RMBS'},\n",
" {'cik': '922621',\n",
" 'companyName': 'ERIE INDEMNITY CO',\n",
" 'filedAt': '2019-07-25',\n",
" 'formType': '4',\n",
" 'id': 'cb3466822abc857bb71ea7de7153e605',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025179-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025179.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': 'ERIE'},\n",
" {'cik': '922621',\n",
" 'companyName': 'ERIE INDEMNITY CO',\n",
" 'filedAt': '2019-07-25',\n",
" 'formType': '4',\n",
" 'id': '4276919972ee908b0cc816ff03b3e92a',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025183-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025183.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': 'ERIE'},\n",
" {'cik': '922621',\n",
" 'companyName': 'ERIE INDEMNITY CO',\n",
" 'filedAt': '2019-07-25',\n",
" 'formType': '4',\n",
" 'id': '5053b60809a3faa74e8ac4a29248123e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025186-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025186.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': 'ERIE'},\n",
" {'cik': '946647',\n",
" 'companyName': 'FIRST DEFIANCE FINANCIAL CORP',\n",
" 'filedAt': '2019-07-24',\n",
" 'formType': '4',\n",
" 'id': '4f5c7ac2cf841de0ff87bbc6ab2ff19c',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/946647/0001144204-19-035733-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/946647/0001144204-19-035733.txt',\n",
" 'nonDerivativeTransactions': 0.0,\n",
" 'ticker': 'FDEF'},\n",
" {'cik': '1782817',\n",
" 'companyName': 'Shukla Sath',\n",
" 'filedAt': '2019-07-24',\n",
" 'formType': '4',\n",
" 'id': '950a7724cc5ff4ae6c8063a9212529c4',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1782817/0001209191-19-042993-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1782817/0001209191-19-042993.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': ''},\n",
" {'cik': '922621',\n",
" 'companyName': 'ERIE INDEMNITY CO',\n",
" 'filedAt': '2019-07-24',\n",
" 'formType': '4',\n",
" 'id': '49f55e3c657a970f094668ec438b6bcb',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025115-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/922621/0001127602-19-025115.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': 'ERIE'},\n",
" {'cik': '933141',\n",
" 'companyName': 'IBERIABANK CORP',\n",
" 'filedAt': '2019-07-24',\n",
" 'formType': '4',\n",
" 'id': 'a8c092b9875fba7a83937b10c9bb38fa',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/933141/0001562180-19-004047-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/933141/0001562180-19-004047.txt',\n",
" 'nonDerivativeTransactions': -319940.5,\n",
" 'ticker': 'IBKC'},\n",
" {'cik': '88941',\n",
" 'companyName': 'SEMTECH CORP',\n",
" 'filedAt': '2019-07-24',\n",
" 'formType': '4',\n",
" 'id': 'd81973408cee736a4696ddf6e110c902',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/88941/0001593968-19-001650-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/88941/0001593968-19-001650.txt',\n",
" 'nonDerivativeTransactions': -255000.0,\n",
" 'ticker': 'SMTC'},\n",
" {'cik': '97745',\n",
" 'companyName': 'THERMO FISHER SCIENTIFIC INC.',\n",
" 'filedAt': '2019-07-23',\n",
" 'formType': '4',\n",
" 'id': '23151796be0b495bb40366eeb353305e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97745/0001127602-19-025077-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97745/0001127602-19-025077.txt',\n",
" 'nonDerivativeTransactions': -2070209.04,\n",
" 'ticker': 'TMO'},\n",
" {'cik': '946563',\n",
" 'companyName': 'RETRACTABLE TECHNOLOGIES INC',\n",
" 'filedAt': '2019-07-23',\n",
" 'formType': '4',\n",
" 'id': '55cb7803a08f55eb4a7523fcf7515c22',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/946563/0001174567-19-000065-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/946563/0001174567-19-000065.txt',\n",
" 'nonDerivativeTransactions': 9868.5,\n",
" 'ticker': 'RVP'},\n",
" {'cik': '810332',\n",
" 'companyName': 'MESA AIR GROUP INC',\n",
" 'filedAt': '2019-07-23',\n",
" 'formType': '4',\n",
" 'id': 'd9c3fb4a7770d74956ec1e9eac4d80a5',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/810332/0001209191-19-042987-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/810332/0001209191-19-042987.txt',\n",
" 'nonDerivativeTransactions': -118648.31,\n",
" 'ticker': 'MESA'},\n",
" {'cik': '867374',\n",
" 'companyName': 'ELECTRONICS FOR IMAGING INC',\n",
" 'filedAt': '2019-07-23',\n",
" 'formType': '4',\n",
" 'id': '75953cc6c2b7f87d816b2cd539c8f11e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/867374/0000867374-19-000058-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/867374/0000867374-19-000058.txt',\n",
" 'nonDerivativeTransactions': 0.0,\n",
" 'ticker': 'EFII'},\n",
" {'cik': '867374',\n",
" 'companyName': 'ELECTRONICS FOR IMAGING INC',\n",
" 'filedAt': '2019-07-23',\n",
" 'formType': '4',\n",
" 'id': '8b6eaff07ce0c339ff8e82dffb885359',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/867374/0000867374-19-000061-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/867374/0000867374-19-000061.txt',\n",
" 'nonDerivativeTransactions': 0.0,\n",
" 'ticker': 'EFII'},\n",
" {'cik': '942698',\n",
" 'companyName': 'ALEXANDER PATRICK L',\n",
" 'filedAt': '2019-07-22',\n",
" 'formType': '4',\n",
" 'id': 'd944841cca1c7b18b9aded8fb191f929',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/942698/0001493152-19-010949-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/942698/0001493152-19-010949.txt',\n",
" 'nonDerivativeTransactions': -182450.0,\n",
" 'ticker': ''},\n",
" {'cik': '901483',\n",
" 'companyName': 'ANTIN ROBERT L',\n",
" 'filedAt': '2019-07-22',\n",
" 'formType': '4',\n",
" 'id': 'bc2ef5699a166920ced27e6f77cdb306',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/901483/0001213900-19-013318-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/901483/0001213900-19-013318.txt',\n",
" 'nonDerivativeTransactions': 0.0,\n",
" 'ticker': ''},\n",
" {'cik': '861842',\n",
" 'companyName': 'CATHAY GENERAL BANCORP',\n",
" 'filedAt': '2019-07-22',\n",
" 'formType': '4',\n",
" 'id': '4c9214ab2dbfd1933bd61b08b1c553f6',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/861842/0001437749-19-014397-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/861842/0001437749-19-014397.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': 'CATY'},\n",
" {'cik': '87347',\n",
" 'companyName': 'SCHLUMBERGER LIMITED/NV',\n",
" 'filedAt': '2019-07-22',\n",
" 'formType': '4',\n",
" 'id': 'dbdb22539492ce5deb50a763cf103783',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/87347/0001127602-19-025018-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/87347/0001127602-19-025018.txt',\n",
" 'nonDerivativeTransactions': -150769.52,\n",
" 'ticker': 'SLB'},\n",
" {'cik': '87347',\n",
" 'companyName': 'SCHLUMBERGER LIMITED/NV',\n",
" 'filedAt': '2019-07-22',\n",
" 'formType': '4',\n",
" 'id': '28347427085cd0bd52d8917c0eb65f1f',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/87347/0001127602-19-025020-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/87347/0001127602-19-025020.txt',\n",
" 'nonDerivativeTransactions': -180080.5,\n",
" 'ticker': 'SLB'},\n",
" {'cik': '97517',\n",
" 'companyName': 'TEXAS PACIFIC LAND TRUST',\n",
" 'filedAt': '2019-07-19',\n",
" 'formType': '4',\n",
" 'id': 'ccae8c908180abe617f91754ea711558',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000056-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000056.txt',\n",
" 'nonDerivativeTransactions': 37215.5,\n",
" 'ticker': 'TPL'},\n",
" {'cik': '9092',\n",
" 'companyName': 'BADGER METER INC',\n",
" 'filedAt': '2019-07-19',\n",
" 'formType': '4',\n",
" 'id': '265aff6d79b08e66bae5fa60f246b8bd',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/9092/0001209191-19-042746-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/9092/0001209191-19-042746.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': 'BMI'},\n",
" {'cik': '890491',\n",
" 'companyName': 'BARNES & NOBLE INC',\n",
" 'filedAt': '2019-07-19',\n",
" 'formType': '4',\n",
" 'id': '682909d1f74428c1b99dc3860b0e71b9',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/890491/0000950138-19-000389-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/890491/0000950138-19-000389.txt',\n",
" 'nonDerivativeTransactions': 0.0,\n",
" 'ticker': 'BKS'},\n",
" {'cik': '890491',\n",
" 'companyName': 'BARNES & NOBLE INC',\n",
" 'filedAt': '2019-07-19',\n",
" 'formType': '4',\n",
" 'id': 'e05480b25c8a19c95ab16df9f4943551',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/890491/0000950138-19-000393-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/890491/0000950138-19-000393.txt',\n",
" 'nonDerivativeTransactions': -15477.56,\n",
" 'ticker': 'BKS'},\n",
" {'cik': '84129',\n",
" 'companyName': 'RITE AID CORP',\n",
" 'filedAt': '2019-07-19',\n",
" 'formType': '4',\n",
" 'id': '879ea15b0754715308faa92727ced670',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/84129/0001209191-19-042788-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/84129/0001209191-19-042788.txt',\n",
" 'nonDerivativeTransactions': 119966.0,\n",
" 'ticker': 'RAD'},\n",
" {'cik': '938659',\n",
" 'companyName': 'GOLD JEFFREY',\n",
" 'filedAt': '2019-07-18',\n",
" 'formType': '4',\n",
" 'id': 'db8d833aab4f55ee456fbc2334242839',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/938659/0001567619-19-014985-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/938659/0001567619-19-014985.txt',\n",
" 'nonDerivativeTransactions': -1.68,\n",
" 'ticker': ''},\n",
" {'cik': '9984',\n",
" 'companyName': 'BARNES GROUP INC',\n",
" 'filedAt': '2019-07-18',\n",
" 'formType': '4',\n",
" 'id': '8d3c22be462579dbbe109017597e27bc',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/9984/0000009984-19-000067-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/9984/0000009984-19-000067.txt',\n",
" 'nonDerivativeTransactions': -2441696.4,\n",
" 'ticker': 'B'},\n",
" {'cik': '9984',\n",
" 'companyName': 'BARNES GROUP INC',\n",
" 'filedAt': '2019-07-18',\n",
" 'formType': '4',\n",
" 'id': 'c68d3c104f4accb9888223cc81e109d1',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/9984/0000009984-19-000068-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/9984/0000009984-19-000068.txt',\n",
" 'nonDerivativeTransactions': -179115.3,\n",
" 'ticker': 'B'},\n",
" {'cik': '946644',\n",
" 'companyName': 'HEMISPHERX BIOPHARMA INC',\n",
" 'filedAt': '2019-07-18',\n",
" 'formType': '4',\n",
" 'id': 'd9a192fa109b7dc0538893e9b71fdd86',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/946644/0001191434-19-000009-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/946644/0001191434-19-000009.txt',\n",
" 'nonDerivativeTransactions': 3799.6,\n",
" 'ticker': 'HEB'},\n",
" {'cik': '928464',\n",
" 'companyName': 'HIGH RIVER LIMITED PARTNERSHIP',\n",
" 'filedAt': '2019-07-18',\n",
" 'formType': '4',\n",
" 'id': '9de4f59646e763f69036888524e2e57d',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/928464/0001567619-19-014989-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/928464/0001567619-19-014989.txt',\n",
" 'nonDerivativeTransactions': 12056320.5,\n",
" 'ticker': ''},\n",
" {'cik': '938071',\n",
" 'companyName': 'DUFFIELD DAVID A',\n",
" 'filedAt': '2019-07-17',\n",
" 'formType': '4',\n",
" 'id': '2fcd93528117c9c09630fad1f1d7cf53',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/938071/0001327811-19-000148-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/938071/0001327811-19-000148.txt',\n",
" 'nonDerivativeTransactions': -61727.3,\n",
" 'ticker': ''},\n",
" {'cik': '9389',\n",
" 'companyName': 'BALL Corp',\n",
" 'filedAt': '2019-07-17',\n",
" 'formType': '4',\n",
" 'id': 'ae5aada2f61fe1187197f1797d3288e9',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/9389/0001562180-19-003974-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/9389/0001562180-19-003974.txt',\n",
" 'nonDerivativeTransactions': -161610.03,\n",
" 'ticker': 'BLL'},\n",
" {'cik': '1608717',\n",
" 'companyName': 'MATHER COURTNEY',\n",
" 'filedAt': '2019-07-17',\n",
" 'formType': '4',\n",
" 'id': '99497d00c927e7834654a7f00be94247',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1608717/0001127602-19-024753-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1608717/0001127602-19-024753.txt',\n",
" 'nonDerivativeTransactions': 40005.5,\n",
" 'ticker': ''},\n",
" {'cik': '914475',\n",
" 'companyName': 'NEUROCRINE BIOSCIENCES INC',\n",
" 'filedAt': '2019-07-17',\n",
" 'formType': '4',\n",
" 'id': '622af9383a55f8b7446ee25816d7fb8b',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/914475/0001209191-19-042522-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/914475/0001209191-19-042522.txt',\n",
" 'nonDerivativeTransactions': -1672372.94,\n",
" 'ticker': 'NBIX'},\n",
" {'cik': '911649',\n",
" 'companyName': 'STANDARD DIVERSIFIED INC.',\n",
" 'filedAt': '2019-07-17',\n",
" 'formType': '4',\n",
" 'id': 'd2068faa22d305e00ff3f1a109bc7c45',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/911649/0001140361-19-013081-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/911649/0001140361-19-013081.txt',\n",
" 'nonDerivativeTransactions': -56174.12,\n",
" 'ticker': 'SDIX'},\n",
" {'cik': '1776446',\n",
" 'companyName': 'HITCHCOCK JEREMY P.',\n",
" 'filedAt': '2019-07-16',\n",
" 'formType': '4',\n",
" 'id': 'b99125e7cc022e87e1801ac5ce0eb3f9',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1776446/0001144204-19-034851-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1776446/0001144204-19-034851.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': ''},\n",
" {'cik': '822708',\n",
" 'companyName': 'ZOOM TECHNOLOGIES INC',\n",
" 'filedAt': '2019-07-16',\n",
" 'formType': '4',\n",
" 'id': '085a449fbe48443c6597fc712095340a',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/822708/0001144204-19-034851-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/822708/0001144204-19-034851.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': 'ZOOM'},\n",
" {'cik': '916076',\n",
" 'companyName': 'MARTIN MARIETTA MATERIALS INC',\n",
" 'filedAt': '2019-07-16',\n",
" 'formType': '4',\n",
" 'id': 'e8c828e85ba33fe1b025a9c31d2b036c',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/916076/0001127602-19-024591-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/916076/0001127602-19-024591.txt',\n",
" 'nonDerivativeTransactions': 0.0,\n",
" 'ticker': 'MLM'},\n",
" {'cik': '928464',\n",
" 'companyName': 'HIGH RIVER LIMITED PARTNERSHIP',\n",
" 'filedAt': '2019-07-16',\n",
" 'formType': '4',\n",
" 'id': '78dbe2e689f5b2c6e1e39b00f0227349',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/928464/0001567619-19-014858-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/928464/0001567619-19-014858.txt',\n",
" 'nonDerivativeTransactions': 216270905.2,\n",
" 'ticker': ''},\n",
" {'cik': '935494',\n",
" 'companyName': 'NATIONAL INSTRUMENTS CORP',\n",
" 'filedAt': '2019-07-16',\n",
" 'formType': '4',\n",
" 'id': 'd8a980513ec0de6990c316ec2202eaa7',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/935494/0001567619-19-014892-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/935494/0001567619-19-014892.txt',\n",
" 'nonDerivativeTransactions': -85720.0,\n",
" 'ticker': 'NATI'},\n",
" {'cik': '97517',\n",
" 'companyName': 'TEXAS PACIFIC LAND TRUST',\n",
" 'filedAt': '2019-07-15',\n",
" 'formType': '4',\n",
" 'id': '68f7ec3f480127b63a251df772686cef',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000052-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97517/0001056823-19-000052.txt',\n",
" 'nonDerivativeTransactions': 39109.35,\n",
" 'ticker': 'TPL'},\n",
" {'cik': '908724',\n",
" 'companyName': 'DELL MICHAEL S',\n",
" 'filedAt': '2019-07-15',\n",
" 'formType': '4',\n",
" 'id': '11c947a36b762b9236748fbbc5799dd3',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/908724/0001123292-19-000998-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/908724/0001123292-19-000998.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': ''},\n",
" {'cik': '902791',\n",
" 'companyName': 'BARRETT BUSINESS SERVICES INC',\n",
" 'filedAt': '2019-07-15',\n",
" 'formType': '4',\n",
" 'id': 'f67f6866ee357066bb4371ea567a6ffa',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/902791/0001562180-19-003940-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/902791/0001562180-19-003940.txt',\n",
" 'nonDerivativeTransactions': -103906.26,\n",
" 'ticker': 'BBSI'},\n",
" {'cik': '870826',\n",
" 'companyName': 'EVINE Live Inc.',\n",
" 'filedAt': '2019-07-15',\n",
" 'formType': '4',\n",
" 'id': '2409bcedb9b068b0cb77828954adb106',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/870826/0001437749-19-014008-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/870826/0001437749-19-014008.txt',\n",
" 'nonDerivativeTransactions': 0.0,\n",
" 'ticker': 'EVLV'},\n",
" {'cik': '870826',\n",
" 'companyName': 'EVINE Live Inc.',\n",
" 'filedAt': '2019-07-15',\n",
" 'formType': '4',\n",
" 'id': '9faa00daf4b1323028a1310f2660143e',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/870826/0001437749-19-014009-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/870826/0001437749-19-014009.txt',\n",
" 'nonDerivativeTransactions': 0.0,\n",
" 'ticker': 'EVLV'},\n",
" {'cik': '97216',\n",
" 'companyName': 'TEREX CORP',\n",
" 'filedAt': '2019-07-12',\n",
" 'formType': '4',\n",
" 'id': '24753009d398a0bad3daf489128823e0',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/97216/0000097216-19-000167-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/97216/0000097216-19-000167.txt',\n",
" 'nonDerivativeTransactions': 13080.06,\n",
" 'ticker': 'TEX'},\n",
" {'cik': '1699940',\n",
" 'companyName': 'SoftBank Vision Fund L.P.',\n",
" 'filedAt': '2019-07-12',\n",
" 'formType': '4',\n",
" 'id': '319a5aaf03c7378d7666fe7d050003bc',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1699940/0001209191-19-041996-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1699940/0001209191-19-041996.txt',\n",
" 'nonDerivativeTransactions': 0,\n",
" 'ticker': ''},\n",
" {'cik': '1736768',\n",
" 'companyName': 'Jones Mark Evan',\n",
" 'filedAt': '2019-07-12',\n",
" 'formType': '4',\n",
" 'id': 'b6371f960c21c88907165d82cedfcd2c',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/1736768/0001726978-19-000225-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/1736768/0001726978-19-000225.txt',\n",
" 'nonDerivativeTransactions': -570548.02,\n",
" 'ticker': ''},\n",
" {'cik': '914475',\n",
" 'companyName': 'NEUROCRINE BIOSCIENCES INC',\n",
" 'filedAt': '2019-07-12',\n",
" 'formType': '4',\n",
" 'id': '3dce7aadf76d8cffa1b289672ce80133',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/914475/0001209191-19-041925-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/914475/0001209191-19-041925.txt',\n",
" 'nonDerivativeTransactions': -394528.84,\n",
" 'ticker': 'NBIX'},\n",
" {'cik': '901733',\n",
" 'companyName': 'RANKIN ROGER F',\n",
" 'filedAt': '2019-07-12',\n",
" 'formType': '4',\n",
" 'id': '9e34b57c59e66aa0599dbd8bffdbddc8',\n",
" 'linkToHtml': 'https://www.sec.gov/Archives/edgar/data/901733/0001127602-19-024463-index.htm',\n",
" 'linkToTxt': 'https://www.sec.gov/Archives/edgar/data/901733/0001127602-19-024463.txt',\n",
" 'nonDerivativeTransactions': 46592.46,\n",
" 'ticker': ''}]"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Let's inspect filings and ensure that the new key 'nonDerivativeTransactions' is set\n",
"filings"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Preperation for plotting\n",
"\n",
"We transform `filings` into a pandas dataframe with the following columns:\n",
"- filedAt\n",
"- type\n",
"- CIK\n",
"- ticker\n",
"- companyName\n",
"- linkToTxt\n",
"- linkToHtml\n",
"- nonDerivativeTransactions (previously added)\n"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import numpy as np\n",
"import pandas as pd\n",
"import matplotlib.pyplot as plt\n",
"import matplotlib\n",
"from pandas.io.json import json_normalize"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {
"scrolled": true
},
"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>cik</th>\n",
" <th>ticker</th>\n",
" <th>companyName</th>\n",
" <th>formType</th>\n",
" <th>filedAt</th>\n",
" <th>linkToTxt</th>\n",
" <th>linkToHtml</th>\n",
" <th>id</th>\n",
" <th>nonDerivativeTransactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>940944</td>\n",
" <td>DRI</td>\n",
" <td>DARDEN RESTAURANTS INC</td>\n",
" <td>4</td>\n",
" <td>2019-08-01</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>9e56073b1a40b7a1c9d5e9eed3b6c7bd</td>\n",
" <td>-1.435944e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>940944</td>\n",
" <td>DRI</td>\n",
" <td>DARDEN RESTAURANTS INC</td>\n",
" <td>4</td>\n",
" <td>2019-08-01</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>e32dcb14f23fcab978203d38457ef61a</td>\n",
" <td>-3.274960e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>940944</td>\n",
" <td>DRI</td>\n",
" <td>DARDEN RESTAURANTS INC</td>\n",
" <td>4</td>\n",
" <td>2019-08-01</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>e4849f9d85d6e03927f979aba07f8e5e</td>\n",
" <td>-6.046080e+03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>945841</td>\n",
" <td>POOL</td>\n",
" <td>POOL CORP</td>\n",
" <td>4</td>\n",
" <td>2019-08-01</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/945841...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/945841...</td>\n",
" <td>8bcdc14c786ac69b5e55d91fbd5973c7</td>\n",
" <td>-5.911782e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>91440</td>\n",
" <td>SNA</td>\n",
" <td>SNAP-ON Inc</td>\n",
" <td>4</td>\n",
" <td>2019-08-01</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/91440/...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/91440/...</td>\n",
" <td>4e1b26768f4a93a5a5fc87101daca657</td>\n",
" <td>1.236141e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>943819</td>\n",
" <td>RMD</td>\n",
" <td>RESMED INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-31</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/943819...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/943819...</td>\n",
" <td>35ba19b15daa1028409d1c45fd29c4c1</td>\n",
" <td>-1.563563e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>937098</td>\n",
" <td>TNET</td>\n",
" <td>TRINET GROUP INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-31</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/937098...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/937098...</td>\n",
" <td>c34cd75a3efe2b24e8c709d5204ecbae</td>\n",
" <td>-4.478306e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>97745</td>\n",
" <td>TMO</td>\n",
" <td>THERMO FISHER SCIENTIFIC INC.</td>\n",
" <td>4</td>\n",
" <td>2019-07-31</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97745/...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97745/...</td>\n",
" <td>a6c643d9fb6e920ea24c6ba2b96fdcbe</td>\n",
" <td>-1.057937e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>1592176</td>\n",
" <td></td>\n",
" <td>Kamerschen Robert W.</td>\n",
" <td>4</td>\n",
" <td>2019-07-31</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/159217...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/159217...</td>\n",
" <td>b1d46fc21be8a3442a918c098c057d94</td>\n",
" <td>-7.799600e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>913144</td>\n",
" <td>RNR</td>\n",
" <td>RENAISSANCERE HOLDINGS LTD</td>\n",
" <td>4</td>\n",
" <td>2019-07-31</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/913144...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/913144...</td>\n",
" <td>f410770c9a0f428a5fe5136c5ba42d70</td>\n",
" <td>-1.712227e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>940944</td>\n",
" <td>DRI</td>\n",
" <td>DARDEN RESTAURANTS INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-30</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>b5d716c2d6d757832501bdcbf65d5e4c</td>\n",
" <td>-5.552317e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>940944</td>\n",
" <td>DRI</td>\n",
" <td>DARDEN RESTAURANTS INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-30</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>659dd4985293fe5d804ca322858bb4bf</td>\n",
" <td>-8.411609e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>914208</td>\n",
" <td>IVZ</td>\n",
" <td>Invesco Ltd.</td>\n",
" <td>4</td>\n",
" <td>2019-07-30</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/914208...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/914208...</td>\n",
" <td>80ace4ce45dc022a716a5bbc00199a8c</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>912767</td>\n",
" <td>UFPI</td>\n",
" <td>UNIVERSAL FOREST PRODUCTS INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-30</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/912767...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/912767...</td>\n",
" <td>154bc2bed3c6aa2f352b0e81127d73fb</td>\n",
" <td>-2.407043e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>910638</td>\n",
" <td>DDD</td>\n",
" <td>3D SYSTEMS CORP</td>\n",
" <td>4</td>\n",
" <td>2019-07-30</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/910638...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/910638...</td>\n",
" <td>2daeef5dbc57899f97345d68e13d378b</td>\n",
" <td>-1.893255e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>94049</td>\n",
" <td>SCL</td>\n",
" <td>STEPAN CO</td>\n",
" <td>4</td>\n",
" <td>2019-07-29</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/94049/...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/94049/...</td>\n",
" <td>5501a19f748fa5a5e7056813da8b35a1</td>\n",
" <td>-2.920175e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>938885</td>\n",
" <td></td>\n",
" <td>ROGERS JOHN W JR</td>\n",
" <td>4</td>\n",
" <td>2019-07-29</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/938885...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/938885...</td>\n",
" <td>8d7432a462a2def533503cfc7ea9c7c3</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>97476</td>\n",
" <td>TXN</td>\n",
" <td>TEXAS INSTRUMENTS INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-29</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97476/...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97476/...</td>\n",
" <td>57dfe40cd04e98deaf9280c200ce26ec</td>\n",
" <td>-4.276020e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>807707</td>\n",
" <td>VOXX</td>\n",
" <td>VOXX International Corp</td>\n",
" <td>4</td>\n",
" <td>2019-07-29</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/807707...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/807707...</td>\n",
" <td>12bd06b372779cd123ea2fd3ff7cb29b</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>91576</td>\n",
" <td>KEY</td>\n",
" <td>KEYCORP /NEW/</td>\n",
" <td>4</td>\n",
" <td>2019-07-29</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/91576/...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/91576/...</td>\n",
" <td>d309e4e2731de5cf7c7c68fb7c13c810</td>\n",
" <td>-1.825982e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>940944</td>\n",
" <td>DRI</td>\n",
" <td>DARDEN RESTAURANTS INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-26</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>3c332bc45aca7065d2a16c80250e8f45</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>940944</td>\n",
" <td>DRI</td>\n",
" <td>DARDEN RESTAURANTS INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-26</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/940944...</td>\n",
" <td>097cc9d2adbf7a4f7dfc15b03e456490</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>937098</td>\n",
" <td>TNET</td>\n",
" <td>TRINET GROUP INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-26</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/937098...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/937098...</td>\n",
" <td>eb37f79fffb4c6bbf66a0e41b85ab704</td>\n",
" <td>-1.678039e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>945783</td>\n",
" <td></td>\n",
" <td>SOCHET IRA</td>\n",
" <td>4</td>\n",
" <td>2019-07-26</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/945783...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/945783...</td>\n",
" <td>ab359c98c5458da3715c85fc5a53304e</td>\n",
" <td>1.401222e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>879635</td>\n",
" <td>MPB</td>\n",
" <td>MID PENN BANCORP INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-26</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/879635...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/879635...</td>\n",
" <td>11be79578ea03a8df7c62630cacf7a96</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>97517</td>\n",
" <td>TPL</td>\n",
" <td>TEXAS PACIFIC LAND TRUST</td>\n",
" <td>4</td>\n",
" <td>2019-07-25</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97517/...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97517/...</td>\n",
" <td>36402f0081a7e6bdcda2bdee00780fe3</td>\n",
" <td>3.690288e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>917273</td>\n",
" <td>RMBS</td>\n",
" <td>RAMBUS INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-25</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/917273...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/917273...</td>\n",
" <td>b0ae50d49acc1fb166b35e1de6f6a1ce</td>\n",
" <td>-4.871760e+03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>922621</td>\n",
" <td>ERIE</td>\n",
" <td>ERIE INDEMNITY CO</td>\n",
" <td>4</td>\n",
" <td>2019-07-25</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/922621...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/922621...</td>\n",
" <td>cb3466822abc857bb71ea7de7153e605</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>922621</td>\n",
" <td>ERIE</td>\n",
" <td>ERIE INDEMNITY CO</td>\n",
" <td>4</td>\n",
" <td>2019-07-25</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/922621...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/922621...</td>\n",
" <td>4276919972ee908b0cc816ff03b3e92a</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>922621</td>\n",
" <td>ERIE</td>\n",
" <td>ERIE INDEMNITY CO</td>\n",
" <td>4</td>\n",
" <td>2019-07-25</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/922621...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/922621...</td>\n",
" <td>5053b60809a3faa74e8ac4a29248123e</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>97517</td>\n",
" <td>TPL</td>\n",
" <td>TEXAS PACIFIC LAND TRUST</td>\n",
" <td>4</td>\n",
" <td>2019-07-19</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97517/...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97517/...</td>\n",
" <td>ccae8c908180abe617f91754ea711558</td>\n",
" <td>3.721550e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>9092</td>\n",
" <td>BMI</td>\n",
" <td>BADGER METER INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-19</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/9092/0...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/9092/0...</td>\n",
" <td>265aff6d79b08e66bae5fa60f246b8bd</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>890491</td>\n",
" <td>BKS</td>\n",
" <td>BARNES &amp; NOBLE INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-19</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/890491...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/890491...</td>\n",
" <td>682909d1f74428c1b99dc3860b0e71b9</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>890491</td>\n",
" <td>BKS</td>\n",
" <td>BARNES &amp; NOBLE INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-19</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/890491...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/890491...</td>\n",
" <td>e05480b25c8a19c95ab16df9f4943551</td>\n",
" <td>-1.547756e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>84129</td>\n",
" <td>RAD</td>\n",
" <td>RITE AID CORP</td>\n",
" <td>4</td>\n",
" <td>2019-07-19</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/84129/...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/84129/...</td>\n",
" <td>879ea15b0754715308faa92727ced670</td>\n",
" <td>1.199660e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>938659</td>\n",
" <td></td>\n",
" <td>GOLD JEFFREY</td>\n",
" <td>4</td>\n",
" <td>2019-07-18</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/938659...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/938659...</td>\n",
" <td>db8d833aab4f55ee456fbc2334242839</td>\n",
" <td>-1.680000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>9984</td>\n",
" <td>B</td>\n",
" <td>BARNES GROUP INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-18</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/9984/0...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/9984/0...</td>\n",
" <td>8d3c22be462579dbbe109017597e27bc</td>\n",
" <td>-2.441696e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>9984</td>\n",
" <td>B</td>\n",
" <td>BARNES GROUP INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-18</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/9984/0...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/9984/0...</td>\n",
" <td>c68d3c104f4accb9888223cc81e109d1</td>\n",
" <td>-1.791153e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>946644</td>\n",
" <td>HEB</td>\n",
" <td>HEMISPHERX BIOPHARMA INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-18</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/946644...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/946644...</td>\n",
" <td>d9a192fa109b7dc0538893e9b71fdd86</td>\n",
" <td>3.799600e+03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>928464</td>\n",
" <td></td>\n",
" <td>HIGH RIVER LIMITED PARTNERSHIP</td>\n",
" <td>4</td>\n",
" <td>2019-07-18</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/928464...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/928464...</td>\n",
" <td>9de4f59646e763f69036888524e2e57d</td>\n",
" <td>1.205632e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>938071</td>\n",
" <td></td>\n",
" <td>DUFFIELD DAVID A</td>\n",
" <td>4</td>\n",
" <td>2019-07-17</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/938071...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/938071...</td>\n",
" <td>2fcd93528117c9c09630fad1f1d7cf53</td>\n",
" <td>-6.172730e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>9389</td>\n",
" <td>BLL</td>\n",
" <td>BALL Corp</td>\n",
" <td>4</td>\n",
" <td>2019-07-17</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/9389/0...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/9389/0...</td>\n",
" <td>ae5aada2f61fe1187197f1797d3288e9</td>\n",
" <td>-1.616100e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>1608717</td>\n",
" <td></td>\n",
" <td>MATHER COURTNEY</td>\n",
" <td>4</td>\n",
" <td>2019-07-17</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/160871...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/160871...</td>\n",
" <td>99497d00c927e7834654a7f00be94247</td>\n",
" <td>4.000550e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>914475</td>\n",
" <td>NBIX</td>\n",
" <td>NEUROCRINE BIOSCIENCES INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-17</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/914475...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/914475...</td>\n",
" <td>622af9383a55f8b7446ee25816d7fb8b</td>\n",
" <td>-1.672373e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td>911649</td>\n",
" <td>SDIX</td>\n",
" <td>STANDARD DIVERSIFIED INC.</td>\n",
" <td>4</td>\n",
" <td>2019-07-17</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/911649...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/911649...</td>\n",
" <td>d2068faa22d305e00ff3f1a109bc7c45</td>\n",
" <td>-5.617412e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td>1776446</td>\n",
" <td></td>\n",
" <td>HITCHCOCK JEREMY P.</td>\n",
" <td>4</td>\n",
" <td>2019-07-16</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/177644...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/177644...</td>\n",
" <td>b99125e7cc022e87e1801ac5ce0eb3f9</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td>822708</td>\n",
" <td>ZOOM</td>\n",
" <td>ZOOM TECHNOLOGIES INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-16</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/822708...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/822708...</td>\n",
" <td>085a449fbe48443c6597fc712095340a</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td>916076</td>\n",
" <td>MLM</td>\n",
" <td>MARTIN MARIETTA MATERIALS INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-16</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/916076...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/916076...</td>\n",
" <td>e8c828e85ba33fe1b025a9c31d2b036c</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>928464</td>\n",
" <td></td>\n",
" <td>HIGH RIVER LIMITED PARTNERSHIP</td>\n",
" <td>4</td>\n",
" <td>2019-07-16</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/928464...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/928464...</td>\n",
" <td>78dbe2e689f5b2c6e1e39b00f0227349</td>\n",
" <td>2.162709e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>935494</td>\n",
" <td>NATI</td>\n",
" <td>NATIONAL INSTRUMENTS CORP</td>\n",
" <td>4</td>\n",
" <td>2019-07-16</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/935494...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/935494...</td>\n",
" <td>d8a980513ec0de6990c316ec2202eaa7</td>\n",
" <td>-8.572000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65</th>\n",
" <td>97517</td>\n",
" <td>TPL</td>\n",
" <td>TEXAS PACIFIC LAND TRUST</td>\n",
" <td>4</td>\n",
" <td>2019-07-15</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97517/...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97517/...</td>\n",
" <td>68f7ec3f480127b63a251df772686cef</td>\n",
" <td>3.910935e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>908724</td>\n",
" <td></td>\n",
" <td>DELL MICHAEL S</td>\n",
" <td>4</td>\n",
" <td>2019-07-15</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/908724...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/908724...</td>\n",
" <td>11c947a36b762b9236748fbbc5799dd3</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>902791</td>\n",
" <td>BBSI</td>\n",
" <td>BARRETT BUSINESS SERVICES INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-15</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/902791...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/902791...</td>\n",
" <td>f67f6866ee357066bb4371ea567a6ffa</td>\n",
" <td>-1.039063e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>870826</td>\n",
" <td>EVLV</td>\n",
" <td>EVINE Live Inc.</td>\n",
" <td>4</td>\n",
" <td>2019-07-15</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/870826...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/870826...</td>\n",
" <td>2409bcedb9b068b0cb77828954adb106</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>69</th>\n",
" <td>870826</td>\n",
" <td>EVLV</td>\n",
" <td>EVINE Live Inc.</td>\n",
" <td>4</td>\n",
" <td>2019-07-15</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/870826...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/870826...</td>\n",
" <td>9faa00daf4b1323028a1310f2660143e</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70</th>\n",
" <td>97216</td>\n",
" <td>TEX</td>\n",
" <td>TEREX CORP</td>\n",
" <td>4</td>\n",
" <td>2019-07-12</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97216/...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/97216/...</td>\n",
" <td>24753009d398a0bad3daf489128823e0</td>\n",
" <td>1.308006e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>71</th>\n",
" <td>1699940</td>\n",
" <td></td>\n",
" <td>SoftBank Vision Fund L.P.</td>\n",
" <td>4</td>\n",
" <td>2019-07-12</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/169994...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/169994...</td>\n",
" <td>319a5aaf03c7378d7666fe7d050003bc</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td>1736768</td>\n",
" <td></td>\n",
" <td>Jones Mark Evan</td>\n",
" <td>4</td>\n",
" <td>2019-07-12</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/173676...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/173676...</td>\n",
" <td>b6371f960c21c88907165d82cedfcd2c</td>\n",
" <td>-5.705480e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td>914475</td>\n",
" <td>NBIX</td>\n",
" <td>NEUROCRINE BIOSCIENCES INC</td>\n",
" <td>4</td>\n",
" <td>2019-07-12</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/914475...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/914475...</td>\n",
" <td>3dce7aadf76d8cffa1b289672ce80133</td>\n",
" <td>-3.945288e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>74</th>\n",
" <td>901733</td>\n",
" <td></td>\n",
" <td>RANKIN ROGER F</td>\n",
" <td>4</td>\n",
" <td>2019-07-12</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/901733...</td>\n",
" <td>https://www.sec.gov/Archives/edgar/data/901733...</td>\n",
" <td>9e34b57c59e66aa0599dbd8bffdbddc8</td>\n",
" <td>4.659246e+04</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>75 rows × 9 columns</p>\n",
"</div>"
],
"text/plain": [
" cik ticker companyName formType filedAt \\\n",
"0 940944 DRI DARDEN RESTAURANTS INC 4 2019-08-01 \n",
"1 940944 DRI DARDEN RESTAURANTS INC 4 2019-08-01 \n",
"2 940944 DRI DARDEN RESTAURANTS INC 4 2019-08-01 \n",
"3 945841 POOL POOL CORP 4 2019-08-01 \n",
"4 91440 SNA SNAP-ON Inc 4 2019-08-01 \n",
".. ... ... ... ... ... \n",
"70 97216 TEX TEREX CORP 4 2019-07-12 \n",
"71 1699940 SoftBank Vision Fund L.P. 4 2019-07-12 \n",
"72 1736768 Jones Mark Evan 4 2019-07-12 \n",
"73 914475 NBIX NEUROCRINE BIOSCIENCES INC 4 2019-07-12 \n",
"74 901733 RANKIN ROGER F 4 2019-07-12 \n",
"\n",
" linkToTxt \\\n",
"0 https://www.sec.gov/Archives/edgar/data/940944... \n",
"1 https://www.sec.gov/Archives/edgar/data/940944... \n",
"2 https://www.sec.gov/Archives/edgar/data/940944... \n",
"3 https://www.sec.gov/Archives/edgar/data/945841... \n",
"4 https://www.sec.gov/Archives/edgar/data/91440/... \n",
".. ... \n",
"70 https://www.sec.gov/Archives/edgar/data/97216/... \n",
"71 https://www.sec.gov/Archives/edgar/data/169994... \n",
"72 https://www.sec.gov/Archives/edgar/data/173676... \n",
"73 https://www.sec.gov/Archives/edgar/data/914475... \n",
"74 https://www.sec.gov/Archives/edgar/data/901733... \n",
"\n",
" linkToHtml \\\n",
"0 https://www.sec.gov/Archives/edgar/data/940944... \n",
"1 https://www.sec.gov/Archives/edgar/data/940944... \n",
"2 https://www.sec.gov/Archives/edgar/data/940944... \n",
"3 https://www.sec.gov/Archives/edgar/data/945841... \n",
"4 https://www.sec.gov/Archives/edgar/data/91440/... \n",
".. ... \n",
"70 https://www.sec.gov/Archives/edgar/data/97216/... \n",
"71 https://www.sec.gov/Archives/edgar/data/169994... \n",
"72 https://www.sec.gov/Archives/edgar/data/173676... \n",
"73 https://www.sec.gov/Archives/edgar/data/914475... \n",
"74 https://www.sec.gov/Archives/edgar/data/901733... \n",
"\n",
" id nonDerivativeTransactions \n",
"0 9e56073b1a40b7a1c9d5e9eed3b6c7bd -14359.44 \n",
"1 e32dcb14f23fcab978203d38457ef61a -32749.60 \n",
"2 e4849f9d85d6e03927f979aba07f8e5e -6046.08 \n",
"3 8bcdc14c786ac69b5e55d91fbd5973c7 -591178.25 \n",
"4 4e1b26768f4a93a5a5fc87101daca657 12361.41 \n",
".. ... ... \n",
"70 24753009d398a0bad3daf489128823e0 13080.06 \n",
"71 319a5aaf03c7378d7666fe7d050003bc 0.00 \n",
"72 b6371f960c21c88907165d82cedfcd2c -570548.02 \n",
"73 3dce7aadf76d8cffa1b289672ce80133 -394528.84 \n",
"74 9e34b57c59e66aa0599dbd8bffdbddc8 46592.46 \n",
"\n",
"[75 rows x 9 columns]"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"filings = json_normalize(filings)\n",
"filings"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Bucketize\n",
"\n",
"For each day we summarize all transactions and create a new dictionary `bins`."
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"def getBins (filings):\n",
" bins = {}\n",
" for index, row in filings.iterrows():\n",
" filedAt = row['filedAt']\n",
" nonDerivativeTransactions = row['nonDerivativeTransactions']\n",
" value = bins[filedAt] + nonDerivativeTransactions if filedAt in bins else nonDerivativeTransactions\n",
" bins[filedAt] = round(value, 2)\n",
" return bins"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'2019-07-12': -905404.34,\n",
" '2019-07-15': -64796.91,\n",
" '2019-07-16': 216185185.2,\n",
" '2019-07-17': -1911878.89,\n",
" '2019-07-18': 9439306.72,\n",
" '2019-07-19': 141703.94,\n",
" '2019-07-22': -513300.02,\n",
" '2019-07-23': -2178988.85,\n",
" '2019-07-24': -574940.5,\n",
" '2019-07-25': 32031.12,\n",
" '2019-07-26': -1537916.47,\n",
" '2019-07-29': -44878201.64,\n",
" '2019-07-30': -1826422.32,\n",
" '2019-07-31': -12839978.42,\n",
" '2019-08-01': -631971.96}"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"bins = getBins(filings)\n",
"bins"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Plotting\n",
"\n",
"We plot a bar chart where each bar represents the total transactions per day."
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAA4AAAAIoCAYAAAA4DIVgAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAIABJREFUeJzt3XnYZGddJ/zvL3QCgQ4QCHQgydA6\nKKCJA5NmdYBuRYgvmzogkWDSisbBURkNCuokLEEMKDL6MjDEEQP6QuDFhQhqxKVHZFESiURAJGgb\nkiCLCSGdRCTknj/O6VB56OXp7uques79+VxXXak6der0/U1VnXq+dZaq1loAAACYvsMWPQAAAAAO\nDQUQAACgEwogAABAJxRAAACATiiAAAAAnVAAAQAAOqEAAgAAdEIBBAAA6IQCCAAA0AkFEAAAoBPr\nFj2AA3XMMce0jRs3LnoYh8SNN96Yu9zlLosexlxMKUsyrTxTypJMK48sy2tKeaaUJZlWHlmW15Ty\nTClLMr08u3PppZd+rrV2r9XMu+YL4MaNG3PJJZcsehiHxLZt27J58+ZFD2MuppQlmVaeKWVJppVH\nluU1pTxTypJMK48sy2tKeaaUJZlent2pqn9a7bx2AQUAAOiEAggAANAJBRAAAKATCiAAAEAnFEAA\nAIBOKIAAAACdUAABAAA6oQACAAB0QgEEAADohAIIAADQCQUQAACgEwogAABAJxRAAACATiiAAAAA\nnVAAAQAAOqEAAgAAdEIBBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCfWLXoAAABwqGx8wTvnvsyzTrol\nW+e43O3nPXFuy4KVbAEEAADohAIIAADQCQUQAACgEwogAABAJxRAAACATiiAAAAAnVAAAQAAOqEA\nAgAAdEIBBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE4ogAAAAJ1QAAEAADqhAAIAAHRCAQQA\nAOiEAggAANAJBRAAAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6seoCWFUbq2rrzO2fqKqPVNWH\nqupPqup+M/edUVUfHy9nzEw/uaour6orqupXqqrG6RdU1U1VddTMvL9cVa2qjjnglAAAAKyuAFbV\nc5JcnOTcqtpWVccm+WCSTa21b0rytiSvGOe9R5IXJnl4kocleWFVHT0u6rVJzkzydePllJl/5ook\nTx2XcViSLUmuPqB0AAAA3GavBXDcKvfiJKcnOTvJ1iQ3ttb+rLV20zjb+5McP15/QpJ3tdauba1d\nl+RdSU6pqvskuWtr7X2ttZbkjUm+Y+afenOSZ4zXNyd5T5JbDiAbAAAAM2roYnuYoeouGbbEPT3J\nca21C3Yxz6uT/HNr7aVV9bwkd2qtvXS87+wkNyfZluS81trjxumPTvL81tqTquqCJO9I8rwk355h\na+JvJnlDhq2Mn1vx752ZYUtiNmzYcPKFF164X+HXmh07dmT9+vWLHsZcTClLMq08U8qSTCuPLMtr\nSnmmlCWZVh5Z5uPyq6+f+zI3HJl8+ub5Le+k4+42v4Xtoym9zpLp5dmdLVu2XNpa27SaedftbYbW\n2o1VdXqSlyU5tqpOTHLOzq1/VfWsJJuSPHZ8SO1qMXuYPuu3k5yaYffRH9rDmM5Pcn6SbNq0qW3e\nvHlvMSZh27ZtmUrWKWVJppVnSlmSaeWRZXlNKc+UsiTTyiPLfGx9wTvnvsyzTrolr7x8r39Wr9r2\n0zbPbVn7akqvs2R6eeZhVccAttYuyrAF8BVJ7pXkrCSpqscl+dkkT2mtfXGc/aokJ8w8/Pgk14zT\nj9/F9FkXJjk3wy6kt+5TEgAAAPZoNccArp85w+cNST6a5KiqekiS12Uof5+ZecjFSR5fVUePJ395\nfJKLW2ufSnJDVT1iPPvn6UnePvtvtdauzFAoX3OgwQAAALi91WyrPjxD0TsmyT2TXJnkmRmOz1uf\n5P8ff83hytbaU1pr11bVuUk+MD7+Ja21a8frz0lyQZIjk/zBeLmd1trr9jsNAAAAu7WaYwCvy3AW\nz41JNs+cBOZxe3jM65O8fhfTL0ly4i6mb93NcjbubXwAAACszqp/CD7J55NcdrAGAgAAwMG16tMV\ntdYUQAAAgDVsX7YAAgAAsIYpgAAAAJ1QAAEAADqhAAIAAHRCAQQAAOiEAggAANAJBRAAAKATCiAA\nAEAnFEAAAIBOKIAAAACdUAABAAA6oQACAAB0QgEEAADohAIIAADQCQUQAACgEwogAABAJxRAAACA\nTiiAAAAAnVAAAQAAOqEAAgAAdEIBBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE4ogAAAAJ1Q\nAAEAADqhAAIAAHRCAQQAAOiEAggAANAJBRAAAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6oQAC\nAAB0QgEEAADohAIIAADQCQUQAACgEwogAABAJxRAAACATiiAAAAAnVAAAQAAOqEAAgAAdEIBBAAA\n6IQCCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE4ogAAAAJ1QAAEAADqhAAIAAHRCAQQAAOiEAggAANAJ\nBRAAAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6oQACAAB0QgEEAADohAIIAADQCQUQAACgEwog\nAABAJxRAAACATiiAAAAAnVAAAQAAOqEAAgAAdEIBBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCcUQAAA\ngE4ogAAAAJ1YdQGsqo1VtXXm9mOq6q+r6paqetqKeb9cVZeNl4tmpn9NVf1lVX28qt5SVUeM019U\nVa2q7j8z74+P0zYdUEIAAACSrLIAVtVzklyc5Nyq2lZVxya5MsnWJG/axUNubq09eLw8ZWb6y5O8\nqrX2dUmuS/LsmfsuT3LqzO2nJfnIqpMAAACwR3stgFV1VJIXJzk9ydkZSt+NrbXtrbUPJbl1Nf9Q\nVVWSb0nytnHSG5J8x8wsv5vkqeO8X5vk+iSfXVUKAAAA9mo1WwBvTXJEkrsmyVj8btjLY+5UVZdU\n1furamfJu2eSz7fWbhlvX5XkuJnHfCHJJ6vqxCTfk+Qtqw0BAADA3lVrbe8zVT0lw9a/YzMUs3Na\nazeN912Q5B2ttbfNzH/f1to145a8P03yrRkK3vtaa/cf5zkhye+31k6qqhcl2ZFht9JvSvKE8TEX\nJXlea+2SFeM5M8mZSbJhw4aTL7zwwv3+H7CW7NixI+vXr1/0MOZiSlmSaeWZUpZkWnlkWV5TyjOl\nLMm08sgyH5dfff3cl7nhyOTTN89veScdd7f5LWwfTel1lkwvz+5s2bLl0tbaqs6dsm41M7XWLqqq\nDyV5cpJNSc5Kcu4e5r9m/O8/VNW2JA9J8ltJ7l5V68atgMcnuWbFQ38vyS8kuaS19oVhr9FdLv/8\nJOcnyaZNm9rmzZtXE2PN27ZtW6aSdUpZkmnlmVKWZFp5ZFleU8ozpSzJtPLIMh9bX/DOuS/zrJNu\nySsvX9Wf1auy/bTNc1vWvprS6yyZXp55WM0xgOur6n7jzRuSfDTJUXuY/+iquuN4/Zgk35zkI23Y\n1PhnGU7ukiRnJHn77GNbazcneX6Sn9vHHAAAAOzFar6qODzJ65Ick+E4viuTPLOqHprkd5IcneTJ\nVfXi1to3JnlQktdV1a0ZCuZ5rbWdZ/N8fpILq+qlST6Y5NdW/mOttT725wQAADjE9loAW2vXJTml\nqjYm2dxau2C86+oMu3GunP+9SU7azbL+IcnDdjH9RbuZf/PexgcAAMDqrPqH4JN8PsllB2sgAAAA\nHFyrPlq1taYAAgAArGH7sgUQAACANUwBBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE4ogAAA\nAJ1QAAEAADqhAAIAAHRCAQQAAOiEAggAANAJBRAAAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6\noQACAAB0QgEEAADohAIIAADQCQUQAACgEwogAABAJxRAAACATiiAAAAAnVAAAQAAOqEAAgAAdEIB\nBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE4ogAAAAJ1QAAEAADqhAAIAAHRCAQQAAOiEAggA\nANAJBRAAAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6oQACAAB0QgEEAADohAIIAADQCQUQAACg\nEwogAABAJxRAAACATiiAAAAAnVAAAQAAOqEAAgAAdEIBBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCcU\nQAAAgE4ogAAAAJ1QAAEAADqhAAIAAHRCAQQAAOiEAggAANAJBRAAAKATCiAAAEAnFEAAAIBOKIAA\nAACdUAABAAA6oQACAAB0QgEEAADohAIIAADQCQUQAACgEwogAABAJxRAAACATiiAAAAAnVAAAQAA\nOqEAAgAAdEIBBAAA6IQCCAAA0IlVF8Cq2lhVW2duP6aq/rqqbqmqp62Y94yq+vh4OWNm+slVdXlV\nXVFVv1JVNU6/oKpuqqqjZub95apqVXXMASUEAAAgySoLYFU9J8nFSc6tqm1VdWySK5NsTfKmFfPe\nI8kLkzw8ycOSvLCqjh7vfm2SM5N83Xg5ZeahVyR56riMw5JsSXL1fqUCAADgq+y1AI5b5V6c5PQk\nZ2cofTe21ra31j6U5NYVD3lCkne11q5trV2X5F1JTqmq+yS5a2vtfa21luSNSb5j5nFvTvKM8frm\nJO9Jcsv+BgMAAOD2auhie5ih6i4ZtsQ9PclxrbULVtx/QZJ3tNbeNt5+XpI7tdZeOt4+O8nNSbYl\nOa+19rhx+qOTPL+19qSdy0jyvCTfnuQVSX4zyRuSbGqtfW7Fv3lmhi2J2bBhw8kXXnjh/qVfY3bs\n2JH169cvehhzMaUsybTyTClLMq08siyvKeWZUpZkWnlkmY/Lr75+7svccGTy6Zvnt7yTjrvb/Ba2\nj6b0Okuml2d3tmzZcmlrbdNq5l23txlaazdW1elJXpbk2Ko6Mck5rbWbdvOQ2tVi9jB91m8nOTXD\n7qM/tIcxnZ/k/CTZtGlT27x58x4zTMW2bdsylaxTypJMK8+UsiTTyiPL8ppSnillSaaVR5b52PqC\nd859mWeddEteefle/6xete2nbZ7bsvbVlF5nyfTyzMOqjgFsrV2UYQvgK5LcK8lZe5j9qiQnzNw+\nPsk14/TjdzF91oVJzs2wC+nKXUsBAAA4AKs5BnB9Vd1vvHlDko8mOWoPD7k4yeOr6ujx5C+PT3Jx\na+1TSW6oqkeMZ/88PcnbZx/YWrsyyc8mec2+RwEAAGBPVrOt+vAkr0tyTJJ7Zjj75zOr6qFJfifJ\n0UmeXFUvbq19Y2vt2qo6N8kHxse/pLV27Xj9OUkuSHJkkj8YL7fTWnvdAeQBAABgN1ZzDOB1Gc7i\nuTHJ5pmTwFyd2+/SOfuY1yd5/S6mX5LkxF1M37qb5Wzc2/gAAABYnVX/EHySzye57GANBAAAgINr\n1acraq0pgAAAAGvYvmwBBAAAYA1TAAEAADqhAAIAAHRCAQQAAOiEAggAANAJBRAAAKATCiAAAEAn\nFEAAAIBOKIAAAACdUAABAAA6oQACAAB0QgEEAADohAIIAADQCQUQAACgEwogAABAJxRAAACATiiA\nAAAAnVAAAQAAOqEAAgAAdEIBBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE4ogAAAAJ1QAAEA\nADqhAAIAAHRCAQQAAOiEAggAANAJBRAAAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6oQACAAB0\nQgEEAADohAIIAADQCQUQAACgEwogAABAJxRAAACATiiAAAAAnVAAAQAAOqEAAgAAdEIBBAAA6IQC\nCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE4ogAAAAJ1QAAEAADqhAAIAAHRCAQQAAOiEAggAANAJBRAA\nAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6oQACAAB0QgEEAADohAIIAADQCQUQAACgEwogAABA\nJxRAAACATiiAAAAAnVAAAQAAOqEAAgAAdEIBBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE4o\ngAAAAJ1QAAEAADpxwAWwqjZW1daZ21ur6rNVddl4+YGZ+86oqo+PlzNmpm+vqnevWO5lVfW3Bzo+\nAAAABusO5MFV9Zwk/y3JnccSeOp411taaz+yYt57JHlhkk1JWpJLq+qi1tp14yxHVdUJrbVPVtWD\nDmRcAAAAfLX93gJYVUcleXGS05OcnWRrkhv38JAnJHlXa+3asfS9K8kpM/e/Nckzxuvfk+TN+zs2\nAAAAvlq11vbvgVV3SXJ1kqcnOa61dsE4fWuSn0/y2SR/n+THx616z0typ9baS8f5zk5yc2vtF6tq\ne5LHJ7mgtfaoqvpgktOSvLW1duIu/u0zk5yZJBs2bDj5wgsv3K8Ma82OHTuyfv36RQ9jLqaUJZlW\nnillSaaVR5blNaU8U8qSTCuPLPNx+dXXz32ZG45MPn3z/JZ30nF3m9/C9tGUXmfJ9PLszpYtWy5t\nrW1azbz7vQtoa+3Gqjo9ycuSHFtVJyY5J8nvJXlza+2LVfVfkrwhybckqV0tZub6tUmuq6pTk3w0\nyU17+LfPT3J+kmzatKlt3rx5f2OsKdu2bctUsk4pSzKtPFPKkkwrjyzLa0p5ppQlmVYeWeZj6wve\nOfdlnnXSLXnl5Qd0ZNXtbD9t89yWta+m9DpLppdnHg7oJDCttYsybAF8RZJ7JTmrtfYvrbUvjrP8\napKTx+tXJTlh5uHHJ7lmxSLfkuR/xu6fAAAAc3cgxwCur6r7jTdvyLDV7qiqus/MbE8ZpyfJxUke\nX1VHV9XRGXb5vHjFYn8nQ5lcOR0AAIADdCDbqg9P8rokxyS5Z5IrkzwzyY9V1VOS3JJht86tSdJa\nu7aqzk3ygfHxL2mtXTu7wNbaDUleniRVu9pjFAAAgP11IMcAXpfklKramGTzzpPAJPnp8bKrx7w+\nyet3MX3jLqZtT/JVJ4ABAABg/xzwD8En+XySy+awHAAAAA6iAz5dUWtNAQQAAFgD5rEFEAAAgDVA\nAQQAAOiEAggAANAJBRAAAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6oQACAAB0QgEEAADohAII\nAADQCQUQAACgEwogAABAJxRAAACATiiAAAAAnVAAAQAAOqEAAgAAdEIBBAAA6IQCCAAA0AkFEAAA\noBMKIAAAQCcUQAAAgE4ogAAAAJ1QAAEAADqhAAIAAHRCAQQAAOiEAggAANAJBRAAAKATCiAAAEAn\nFEAAAIBOKIAAAACdUAABAAA6oQACAAB0QgEEAADohAIIAADQCQUQAACgEwogAABAJxRAAACATiiA\nAAAAnVAAAQAAOqEAAgAAdEIBBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE4ogAAAAJ1QAAEA\nADqhAAIAAHRCAQQAAOiEAggAANAJBRAAAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6oQACAAB0\nQgEEAADohAIIAADQCQUQAACgEwogAABAJ9YtegAAAFOz8QXvnPsyzzrplmyd83K3n/fEuS4PWH62\nAAIAAHRCAQQAAOiEAggAANAJBRAAAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6oQACAAB0QgEE\nAADohAIIAADQCQUQAACgEwe1AFbVxqraOnP7jlX1lqq6oqr+sqo2jtM3V1WrqmfPzPuQcdrzDuYY\nAQAAenHQCmBVPSfJxUnOraptVXVskmcnua61dv8kr0ry8pmHXJ7kGTO3T03yNwdrfAAAAL1ZdzAW\nWlVHJXlxkicneVCSbUluTPLUJC8aZ3tbkldXVY23r0xy16rakOQzSU5J8vsHY3wAAAA9qtba/Bda\ndZckVyd5epLjWmsXjNP/NskprbWrxtufSPLwJCcmeV6SP0pya5IPJvmBJP+UZEdr7RdXLP/MJGcm\nyYYNG06+8MIL557hQF1+9fVzX+aGI5NP3zzfZZ503N1WNd+880wpSzL/PKvNknhu9maRz8287dix\nI+vXr1/Iv+11tmfWAXvW6/tm3qwD9szrbD6m9DpLpvV3wJ5s2bLl0tbaptXMe1C2ALbWbqyq05O8\nLMmxVXViknOS1K5mn7n+1iRvSfLAJG9O8qjdLP/8JOcnyaZNm9rmzZvnN/g52XwQlrlt27Z894Ky\nbn3BO+e6vLNOuiWvvHy+L7/tp21e1XzzzpLMP89qsySem71Z5HMzb9u2bcui1nfz/lentD5LFvs6\nW/2cq7PI5+ZgWOT7Zt4WmWVKnzUHg9fZfExt/bysDkoBTJLW2kVV9aEMu4FuSnJWkquSnJDkqqpa\nl+RuSa6decw/V9WXknxbkudmNwUQAACYlu3nPXHuy9y2bdskSts8HaxjANcnued484YkH01yjyQX\nJTkjyfuSPC3Jn7bW2lcOA0wybCm8d2vtyyumw1xYuSwvzw0AwMF1sLYAHp7kdUmOyVAEr0zyzCT/\nkuQ3quqKDFv+Tl35wNbaew/SmADAFw2wH+b9vvGegcU5WMcAXpfklPF3/jbvPAnM6Om7mH9bhjOF\nrpz+ooMxPgAAgB4d1B+CT/L5JJcd5H8DAACAVThoJ4FJktaaAggAALAkDvYWQAAAAJaEAggAANAJ\nBRAAAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6oQACAAB0QgEEAADohAIIAADQCQUQAACgEwog\nAABAJxRAAACATiiAAAAAnVi36AGwNmw/74lzXd62bduy/bTNc10mAACwZ7YAAgAAdEIBBAAA6IQC\nCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE4ogAAAAJ1QAAEAADqhAAIAAHRCAQQAAOiEAggAANAJBRAA\nAKATCiAAAEAnFEAAAIBOKIAAAACdUAABAAA6oQACAAB0QgEEAADohAIIAADQCQUQAACgEwogAABA\nJxRAAACATiiAAAAAnVAAAQAAOqEAAgAAdEIBBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE4o\ngAAAAJ1QAAEAADqhAAIAAHRCAQQAAOiEAggAANAJBRAAAKATCiAAAEAnFEAAAIBOKIAAAACdUAAB\nAAA6oQACAAB0QgEEAADohAIIAADQCQUQAACgEwogAABAJxRAAACATiiAAAAAnVAAAQAAOqEAAgAA\ndEIBBAAA6IQCCAAA0AkFEAAAoBMKIAAAQCcUQAAAgE6sW/QAgAOz/bwnznV527Zty/bTNs91mQAA\nLAdbAAEAADqhAAIAAHRCAQQAAOiEAggAANCJ/SqAVbWxqrbu4f5tVfWxqrpsvNx7nH7HqnpLVV1R\nVX9ZVRvH6ZurqlXVs2eW8ZBx2vP2Z4wAAADc3j4XwKp6TpKLk5w7Fr1jdzPraa21B4+Xz4zTnp3k\nutba/ZO8KsnLZ+a/PMkzZm6fmuRv9nV8AAAA7No+/QxEVR2V5MVJnpzkQUm2JblxHxbx1CQvGq+/\nLcmrq6rG21cmuWtVbUjymSSnJPn9fRkfAAAAu7evWwBvTXJEkrsmSWtte2vtht3M++vj7p9nz5S8\n45J8cnzsLUmuT3LPmce8LcnTkzwqyV8n+eI+jg8AAIDdqNbavj2g6ilJzk5ybJK3JDmntXbTinmO\na61dPW4x/K0kv9lae2NVfTjJE1prV43zfSLJw5KclOR5SX5gXOblSS7KUAR3tNZ+ccXyz0xyZpJs\n2LDh5AsvvHDfUq9RO3bsyPr16xc9jLmYUpZkWnmmlCWZVh5ZlteU8kwpSzKtPLIsrynlmVKWZHp5\ndmfLli2XttY2rWbefdoFNElaaxdV1Ycy7Aa6KclPVtV3jndf1Fo7p7V29TjvDVX1pgwl741Jrkpy\nQpKrqmpdkrsluXZm2f9cVV9K8m1JnpuhAO5qDOcnOT9JNm3a1DZv3ryvMdakbdu2ZSpZp5QlmVae\nKWVJppVHluU1pTxTypJMK48sy2tKeaaUJZlennnY12MA1+cru2zekOSjSe7RWnvwzDzrkty9tfa5\nqjo8yZOS/PF490VJzkjyviRPS/KnrbX2lT1EkyTnJLl3a+3LK6YDAABwAPZ1C+DhSV6X5JgMRfDK\nJM9cMc8dk1w8lr87ZCh/vzre92tJfqOqrsiw5e/Ulf9Aa+29+zgmAAAAVmGfCmBr7bokp4y/37e5\ntXbBLua5McnJu3n8v2Y4ycvK6dsynFF05fQX7cv4AAAA2L39+iH4JJ9Pctk8BwIAAMDBtc8ngUmS\n1poCCAAAsMbs7xZAAAAA1hgFEAAAoBMKIAAAQCcUQAAAgE4ogAAAAJ1QAAEAADpRrbVFj+GAVNVn\nk/zTosdxiByT5HOLHsScTClLMq08U8qSTCuPLMtrSnmmlCWZVh5ZlteU8kwpSzK9PLtzv9bavVYz\n45ovgD2pqktaa5sWPY55mFKWZFp5ppQlmVYeWZbXlPJMKUsyrTyyLK8p5ZlSlmR6eebBLqAAAACd\nUAABAAA6oQCuLecvegBzNKUsybTyTClLMq08siyvKeWZUpZkWnlkWV5TyjOlLMn08hwwxwACAAB0\nwhZAAACATiiAsApVVYseA3vmOQLgYPNZwxQogLA6d9x5ZQor/6o6aub6ms1TgxdU1f3aRPZnr6rv\nqqqjFz2OAzU+N/+xqtYteizzUFXHVNUdxutr9j2z01TWAcm0siRJVT2wqu4yXl/Tearq5VX16PH6\nms3is2a5TW0dcCgogEuiqs6sqnOr6shFj+VAVdUPVtVrqurfL3osB6qqTq2qv0vyP6rqJ5JkLa/8\nq+q7q+rDSc6rqlckazdPVW1OcnmSk5PcYbGjOXBV9ayqen+S/5TkXxc9njl4U5LXJ/kPix7Igaiq\n06rqsiS/mOR/J2v3PZPc9jq7NMmvVNWrkrWbZ0rrs+S2PB9J8ookv52s3Tzj++ZPk/zgeFnLWTbH\nZ81SmtL67FCbxDeza9X4LcW6JD+Q5PkZ3oh/lOTdixzX/hizHJbkaUl+Ksmnkjy8qq5ura3JFUxV\n3S/JjyX5/iTXJXlbVX2utfbGxY5s/1TVA5L8aJLva639VVX9RVU9t7X2y4se2356bJL/3lr73dmJ\nVVVr5QNgfN9UkjMylItHtdY/gLLdAAATH0lEQVT+crGjOnBjrjsl+XiSk6tqe2vtX9bKczOzbv6h\nJE9P8iNJ3pfkH6rqka219y1yfPtqzHN4kuck+a4M64Erk/xJVf15a+131spzs9PU1mdV9cAkz03y\n/a2191fVlVX16Nbamvp7oKrunOTsJA9N8rNJjkjypKpa31rbsdDB7b81/1mT3LYe2JoJfNZU1eFJ\nfjgTWZ8tgi2AC1JVR7TBl5L8dZIHJXldku+rqnsudnT7pqqOHLN8OcmlSR6e5LVJHpMh15qxYgvs\nzj9gP9xa+2iS/5bkrKq6x0IGtx+q6o4zN49P8jcZvslMkl9NcnZVPeSQD2w/rMiSJI9Mcn1V3bmq\nzqmq76mqu66VlX5V3XF839ya5K+SvCXJF6vqsKo6o6rWzHtn9rmZ+eB9f5IPJPnmjOuBtfDczDwv\nX0ryjtbaY1trf5HkhCSXJPnsYke4b2by/FuSv03y9Nbae1trV2U4NfoDkrXx3Kzw75JcljW6PtuF\neyX5SJIrx/fTB5N8abFD2nettZuSvLG19rjxi5Kjkzx2DZe/JHlE1vBnzU7jeD+Q5M1Zo581O43r\n548kedpE1meHnAK4AFX1wiRvqqqtVXWP1tpfttZuzlCajk/yuKpaE89NVf1Ukj+oqrOq6uGttSta\na9cmeVuGLRuPXiv7mK/I8pAkN2f4UL5zkrTW3pXk7zNs4cyyP0dV9dNJfruqfqyqNia5JsnGJN82\nfhN4tySfSPKd4/xLm2cmy49W1c5dCv8iycOS/G6GrTXfk+Tla+HDbMVz86DW2oczbP1/R4aS/sgk\nr6+qnx/nXyvPzYmttTZ+SfKIJP9vhtKxpYZdw79moYPdixXPyze21rbX4KEZdsm7Y5KXVdU54/xL\n+7wkt8vz3Kr6+tbanyT57My4T86wXlh6VfXiqnrizKQbktwva3B9luwyz+eS7Ejy6gw5bkjyc1X1\ny1V110WMcbVWZhm/MN15/XeTHFnjcYDLbjZLVd2hhmOY/zxr97Nm5evsiiQXZ21+1qzM8hettTW5\nPlsGS/tET1VV/XiG/a5fm+Rbk7ywqu6TJOOukr+e5JkZ/lBfWlX176vq4gzH9/xshm9jv6Oqjqiq\nw8ZvZ34rwxvyP6547FIdoLuLLPdL8ozW2pUZPpB/aGb2FyQ5taruPm65WTpV9TU1HHvxjRmOW3pA\nkh8ZP5R/L8kTk7w3ydcnOTPJdy9rnl1keWCSZ9VwMo5PZdi6dFlr7ZwMu+oek+H5W0q7eW6+v4bd\npi7OsBfAd7TW/kuS702ytaruu0aemwckOaOq7jZ+CfSx8YutluFLk+9Lcv3CBrwHu8jy9Rn+3x81\nfpN8dZJvba09KUOWH1vW5yXZbZ4fnMlz26wZtqLNPnbZ1s/3qKrzM+yO/7Iadv1Ka+39Sf4wyf+T\nNbI+S/aY56OttR/P8MXWL7XWnpVhHfCoJF+7sAHvwS6yfNVhRWN5/dMkGw71+PbFrp6X1tqXW2u3\nJPmXDM/DWvqs2d3r7F+T/FmS/5W181mzuyw3r5w1S74+WyYK4CE0/tH6kCQvHr+JPTfJTRl2LUyS\ntNbenOQLSR5bVQ+tqtMWMti9+3SSl7bWTmutvSfJZ5J8prX2bztXIK21P0qyPclJVfXEqvqv4/Rl\n2zS/MsunM3wbmwyF8DuralOStNY+keSPk6xfyEhX59oMu649q7X2Z0kuSnL8uCL81QzHM31fa+1H\nMuw+tS3JYUu6otxllnF344sylMA717Al/XPj/Mcubrh7tas8xyW5JcN76LzxNZbW2hUZ/rBd1j8y\nVmb5vST3TXJzVd07ybdU1XuT/Ockv5Hh2Oa7L2y0e7a7LLckSWvtmtbadeP17Un+T5Jl3pq5q9fZ\nfZN8qaqqtXZrVR2R4b30oap6cFX9cLKU6+cbk/xua+3oDEX8J3be0Vp7Tb5yHOBaWJ8lu8lTw+54\nleELk+3J8LrLsMVmWU+otjLLWcnt/+hurX0hQ/m773jfsp5EZbevswxb//85a+uzZk95rkny8jX0\nWbO790wlyRpbny0NBfAQGT90v5yhXDx7nHxFhhXLA6vq5JnZ35jkNeN9dzqkA12l1tqO1tq7q+rw\nqnpJhg/hx1XVz1TVSTOz/mGSn8lQPI5YxFj3ZjdZtlTV2RlO/vJLGb7xf35VvTbDh/G/LHDIuzW+\nzq7P8P97pw9n+PBd31q7tbX2pdba31XV+gzfAt65tXbtsq0o95DluHEr02eT/GaGL0x+qYYzgD00\nwzEOS2cPeY5Pcsfx2+YvjfMeWVX/I8k9MhznsFT2kOWEDK+nz2RYf72ltfbIJP81Q/lbuvXZXrKs\nWzHvncbX2dHjPEtnL3kOn3mfPzTJXarqvCS/liX9e6C19sUMu+AlyQszbMm8TzKUibWyPttpd3nG\ndXPLcJbJZ1TVD1TVL2TYsnnpgoa7R3vI0mqws+y9M8Nukxn/Dlo6e3qdjYVvzXzWJHvNc+ta+axJ\n9v46G6evifXZMvE/6CCpqrvPXD9s5sPodRm2xpw8binbnmEl8uBx3vtn2DL4m0ke0Fr7tUM68F2o\nqmfWeNzVym9Vx5XIX7XWjs1wNtN/y7hFs6ruleF01r+X5P6ttVcd0oHvwn5keUlr7Q1JXpnkPhl2\nCX3SLnY9WIiVeXa+zlprN8zM9vAkn5ydVsOxWO/IsMvE7C6uC7OPWa4f73t3khdl+Nb/U0ke04bj\n6RbuAJ6bLUn+ZLz5xJ1ZF2kfs3x+vO+8Np6RcZz/h1trC/8D4wCel6dkeJ0lwzrg84doyHu0v3ky\nfCl0//H6o1trrz4kA96D3a2fW2s7xmwfyLD19dxx+pfHeZdufZbse57RLyd5a4YzT96aYZ22/dCN\netf247lpM2Xvn5P8z1qS48v253lZS581O6fv5XWWGn7eYqk/a3ZO39PrbJzlvkm+bry+FOuzpdda\nc5njJcm3Z3hx/n9Jfnpm+h3G/x6R4Scf3jJz368kefZ4/R5Jjl10jnEsj8uw29ZnkmydmV5JDtvN\nY05P8vPj9TsmueeicxxglvOS1OxzuAyX1eRJsm78708k+anx+qMyfLGQtfTc7CHLiYse/5zzfE2G\nrUvHLTrHAWZ5ZJJv3DnvonMcYJZvzrBr1DFJTlh0jjnlOT7DH0tfu+gc+5HlXkn+bhz/I5JsGqcv\nxfrsAPM8KslDx+lHLDrHHJ6bR47Tl+Kz8wCzPGrnvIvOMYc8j0zyTUnumrX5WbMyyzdkOE52KdZn\na+XidwDnqKoeluEbop/LcLKDH6nhrHh/277yTdjdMhwP821V9d8znI73ARl38WjDyRMWZvzG5U5J\n3pDk3klemuSpGc+EWVXr2nBQdBt3J7i+Dad9Tg0/X/GMDAd8pw2b7b94yEOM5pTlT9q4xmkL3nVl\nP/LckGGL5cYkX6jhIOqNGbfQttYWthvrvLMs2pzyfE2S57bW/jHDrscLcRBeZwvbFW/Oz8s/HfoE\ntzfnPAvdGrs/6+ckt7ThrH8XJ/lYkg/lKz8yvtDd8g9Cnn879CkGByHLwj47D0KWhe5aPM88bTg+\n8wsLiJFxrPPIcnmGDSgL37tkzVl0A53SJcmPJ/mF8frXJrkwyZH5yrcXr0ny9gwHDp+YoShekuSc\nRY99F1meOnP9WUneN3N7XYZdO/88yaYMb9b/leGUwj+56LFPOcs+5jk5yVEZDvj+WIY/+hY+/qlm\nmVoeWZYzy9Ty7EOWh2bYGvCkJP+YcYvmsl2mlEeW5cwytTxTyrKWLrYAHoCq+rEkJ2U4buxXM5wd\n8g+r6k4ZfovoHzL83MMnxm9e12fYtH1dhn3if7aqXtKGLWULtTJLa+3t4/R1Gd5oH66qE1prn8xw\nEpR1Gd60143zXZzkZ9qCt2COY5lMlmQuec5N8ta24G/Ix7FMJksyrTyyLGeWZFp55pDlY0ke3Jbg\neKVkWnlkWc4sybTyTCnLmrboBrpWL0m2Jnl/klMyHPN3doaz3B2d5FVJnjzO9w0Zzqz09TOPXYr9\n4feQ5aczsy91hn3FP5DkqF089vBFj3+qWeaQZymOIZlilqnlkWU5s0wtzwFmWbfo8U85jyzLmWVq\neaaUZa1fluKMTGvUt2b4HZU/zPDbN4dn+LHt6zIcmLrzeJG/S/KeDLvh7Dwj6LKdBnllljtm2Ayf\nJGmtfSjJzRmOibvtzExVVW08lfASmVKW5MDyLOwYkt2YUpZkWnlkWc4sybTyHEiWWw79cPdqSnlk\nWc4sybTyTCnLmqYA7qP6ymmMP5hhP+S01i7J8COaG6vqGzKcBOV/V9WdM/yQ+IlJPjnOe+shH/Ru\n7CHL+5Pct6q+eZyvkvxRkiPHN+HOk6Is9GDoWVPKkkwrz5SyJNPKI8tyZkmmlWdKWZJp5ZFlObMk\n08ozpSxToQDuRY0/ZLrzW4iZAveeJIdV1WPG23+b5KokD2yt/VKGA+7flmEX0O9qww8jL9Q+ZvlU\nht9V2fnGu3eSG5flTTilLMm08kwpSzKtPLIsZ5ZkWnmmlCWZVh5ZljNLMq08U8oyVU4CsxtV9cgk\n35/kY1V1fhtOl5v6ymlpP57kw0meUVXvaa1dVVUbMvykQ5I8O8md2xL8WPB+Zjk2yU0zi3leW4Ld\niaaUJZlWnillSaaVR5blzJJMK8+UsiTTyiPLcmZJppVnSlmmzhbAXRi/mXh1hl0575vkp6vq8UnS\nvrIP8g0ZfrTyiCS/WFWHZzgBzKfH+f5tScrfgWS57Yxxy/BmnFKWZFp5ppQlmVYeWZYzSzKtPFPK\nkkwrjyzLmSWZVp4pZemBArhrm5K8p7X25gw/TLkhyfeMW/hSVS9N8qYMP0p5ToYX77vH229YyIh3\nT5blzJJMK8+UsiTTyiPLcmZJppVnSlmSaeWRZTmzJNPKM6Usk2cX0CRV9Ygk17bW/n6c9LEk/6Gq\n7ttau6aqdiQ5JslTq2pbhh95f0Fr7RPj478/yV1aazcsYPi3I8tyZkmmlWdKWZJp5ZFlObMk08oz\npSzJtPLIspxZkmnlmVKWHnW9BbCq7l5V70zyriTfXVXrx7s+nuQLSS6oqt9KckKGMxfdtbX29621\nZ7bWPlHjWY1aa7cu+gUsy3JmSaaVZ0pZkmnlkWU5syTTyjOlLMm08siynFmSaeWZUpaeVev4JDtV\ndVyS/5zhBfuAJO9urf3+eN8RSb45yYbW2oVV9e0ZfufvieP9h7Xl+kkHWbJ8WZJp5ZlSlmRaeWRZ\nzizJtPJMKUsyrTyyLGeWZFp5ppSlZ90VwKo6PcOPtH+wtfaFqrpThi2hP5mkkpzfWrtmF4/770k+\n31p79SEd8B7IspxZkmnlmVKWZFp5ZFnOLMm08kwpSzKtPLIsZ5ZkWnmmlIVBF7uA1uA+VfVnSc5I\nclqS11bVMa21f22t3ZTkjzMckPotKx77n6rq0iSPTvKOQz32lWS57bFLlSWZVp4pZUmmlUeW2x67\nVFmSaeWZUpZkWnlkue2xS5UlmVaeKWXhq02+AFbVHdqwmfOoJFe31r41yQ8nuTbJ+Tvna629J8n2\nJA+sqrtV1V3Gu/4hydmttSe01rYf0sGvIMtyZkmmlWdKWZJp5ZFlObMk08ozpSzJtPLIspxZkmnl\nmVIWdm2yu4BW1bokL0lyhyS/n+SuSZ7WWjtjvL+SXJPk1Nba/xmnrc9w6tpHJblfkpNba1ctYPi3\nI8tyZkmmlWdKWZJp5ZFlObMk08ozpSzJtPLIspxZkmnlmVIW9mySWwCr6rFJLs2wWfqKJOcm+VKS\nLVX1sCQZv9l4SZIXzTz0iRm+4fibJCctwwtYliRLmCWZVp4pZUmmlUeWJEuYJZlWnillSaaVR5Yk\nS5glmVaeKWVhFVprk7tk2Of4e2duvybJc5JsTXLpOO2wJMcmeWuSjeO0pyZ5zKLHL8vyZ5lanill\nmVoeWZYzy9TyTCnL1PLIspxZppZnSllc9n6Z5BbADN9gvLWq7jDefk+Sf9dauyDJHarqR9twGtrj\nk3y5jfsnt9be3lr780UMeA9kWc4sybTyTClLMq08sixnlmRaeaaUJZlWHlmWM0syrTxTysJeTLIA\nttZuaq19sbX25XHStyX57Hj9+5I8qKrekeTNSf46uW2/5qUjy3JmSaaVZ0pZkmnlkWU5syTTyjOl\nLMm08siynFmSaeWZUhb2bt2iB3Awjd9itCQbklw0Tr4hyc8kOTHJP7bWrk5u2695acmyvKaUZ0pZ\nkmnlkWV5TSnPlLIk08ojy/KaUp4pZWH3JrkFcMatSQ5P8rkk3zR+c3F2kltba3+x8wW8RsiyvKaU\nZ0pZkmnlkWV5TSnPlLIk08ojy/KaUp4pZWE3JvszEDtV1SOSvHe8/Hpr7dcWPKT9JsvymlKeKWVJ\nppVHluU1pTxTypJMK48sy2tKeaaUhV3roQAen+R7k/xSa+2Lix7PgZBleU0pz5SyJNPKI8vymlKe\nKWVJppVHluU1pTxTysKuTb4AAgAAMJj6MYAAAACMFEAAAIBOKIAAAACdUAABAAA6oQACAAB0QgEE\nAADohAIIAADQCQUQAACgE/8X91miuaFL010AAAAASUVORK5CYII=\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x1093f24a8>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"# Set size of figure\n",
"plt.rcParams['figure.figsize'] = [15, 10]\n",
"\n",
"# Prettify y axis: 2000000 to $2M\n",
"def millions(x, pos):\n",
" return '${:,.0f}M'.format(x*1e-6)\n",
"\n",
"fig, ax = plt.subplots()\n",
"# Define bar plot\n",
"ax.bar(range(len(bins)), list(bins.values()), align='center')\n",
"ax.grid(True)\n",
"ax.yaxis.set_major_formatter(matplotlib.ticker.FuncFormatter(millions))\n",
"# Prettify x axis\n",
"fig.autofmt_xdate()\n",
"# Set x axis values\n",
"plt.xticks(range(len(bins)), list(bins.keys()))\n",
"plt.show()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"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.6.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment