bitcoin_blockchain_query.ipynb

{
  "cells": [
    {
      "metadata": {
        "_cell_guid": "b1076dfc-b9ad-4769-8c92-a6c4dae69d19",
        "_uuid": "8f2839f25d086af736a60e9eeb907d3b93b6e0e5",
        "trusted": true
      },
      "cell_type": "code",
      "source": "# This Python 3 environment comes with many helpful analytics libraries installed\n# It is defined by the kaggle/python docker image: https://github.com/kaggle/docker-python\n# For example, here's several helpful packages to load in \n\nimport numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\nimport bq_helper # helper functions for putting BigQuery results in Pandas DataFrames\nfrom matplotlib import pyplot as plt # plotting\n\n# Input data files are available in the \"../input/\" directory.\n# For example, running this (by clicking run or pressing Shift+Enter) will list the files in the input directory\n\nimport os\nprint(os.listdir(\"../input\"))\n\n# Any results you write to the current directory are saved as output.",
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "text": "[]\n",
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "_cell_guid": "79c7e3d0-c299-4dcb-8224-4455121ee9b0",
        "_uuid": "d629ff2d2480ee46fbb7e2d37f6b5fab8052498a",
        "trusted": true
      },
      "cell_type": "code",
      "source": "# create a helper object for our bigquery dataset\nbitcoin_blockchain = bq_helper.BigQueryHelper(active_project= \"bigquery-public-data\", \n                                       dataset_name = \"bitcoin_blockchain\")\n# print a list of all the tables in the hacker_news dataset\nbitcoin_blockchain.list_tables()",
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 2,
          "data": {
            "text/plain": "['blocks', 'transactions']"
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {
        "_cell_guid": "2056856a-7324-4ce9-abc8-dd529db47746",
        "_uuid": "140580dbfac292796ab9f835a56aa6685f4cee07",
        "trusted": true
      },
      "cell_type": "code",
      "source": "# print information on all the columns in the \"blocks\" table\n# in the bitcoin_blockchain dataset\nbitcoin_blockchain.table_schema(\"transactions\")",
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 3,
          "data": {
            "text/plain": "[SchemaField('timestamp', 'INTEGER', 'NULLABLE', None, ()),\n SchemaField('transaction_id', 'STRING', 'NULLABLE', None, ()),\n SchemaField('inputs', 'RECORD', 'REPEATED', None, (SchemaField('input_script_bytes', 'BYTES', 'NULLABLE', None, ()), SchemaField('input_script_string', 'STRING', 'NULLABLE', None, ()), SchemaField('input_script_string_error', 'STRING', 'NULLABLE', None, ()), SchemaField('input_sequence_number', 'INTEGER', 'NULLABLE', None, ()), SchemaField('input_pubkey_base58', 'STRING', 'NULLABLE', None, ()), SchemaField('input_pubkey_base58_error', 'STRING', 'NULLABLE', None, ()))),\n SchemaField('outputs', 'RECORD', 'REPEATED', None, (SchemaField('output_satoshis', 'INTEGER', 'NULLABLE', None, ()), SchemaField('output_script_bytes', 'BYTES', 'NULLABLE', None, ()), SchemaField('output_script_string', 'STRING', 'NULLABLE', None, ()), SchemaField('output_script_string_error', 'STRING', 'NULLABLE', None, ()), SchemaField('output_pubkey_base58', 'STRING', 'NULLABLE', None, ()), SchemaField('output_pubkey_base58_error', 'STRING', 'NULLABLE', None, ()))),\n SchemaField('block_id', 'STRING', 'NULLABLE', None, ()),\n SchemaField('previous_block', 'STRING', 'NULLABLE', None, ()),\n SchemaField('merkle_root', 'STRING', 'NULLABLE', None, ()),\n SchemaField('nonce', 'INTEGER', 'NULLABLE', None, ()),\n SchemaField('version', 'INTEGER', 'NULLABLE', None, ()),\n SchemaField('work_terahash', 'INTEGER', 'NULLABLE', None, ()),\n SchemaField('work_error', 'STRING', 'NULLABLE', None, ())]"
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {
        "_cell_guid": "8b01776f-baba-4c82-b3f9-49af512bb2d5",
        "_uuid": "a1c0adb82369ca7a8b661608094a2131e2f41dbd",
        "trusted": true
      },
      "cell_type": "code",
      "source": "# preview the first couple lines of the \"blocks\" table\nbitcoin_blockchain.head(\"transactions\")",
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 4,
          "data": {
            "text/plain": "       timestamp    ...     work_error\n0  1488040145000    ...           None\n1  1472776292000    ...           None\n2  1492374862000    ...           None\n3  1477326198000    ...           None\n4  1511252626000    ...           None\n\n[5 rows x 11 columns]",
            "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>timestamp</th>\n      <th>transaction_id</th>\n      <th>inputs</th>\n      <th>outputs</th>\n      <th>block_id</th>\n      <th>previous_block</th>\n      <th>merkle_root</th>\n      <th>nonce</th>\n      <th>version</th>\n      <th>work_terahash</th>\n      <th>work_error</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>1488040145000</td>\n      <td>fb31ab50aa936882e8b4a41b068023d3584aa8bf652817...</td>\n      <td>[{'input_script_bytes': b'H0E\\x02!\\x00\\xbeX8\\x...</td>\n      <td>[{'output_satoshis': 26975892, 'output_script_...</td>\n      <td>0000000000000000000261d50ff902034871137e8748f7...</td>\n      <td>00000000000000000249500b5ac5143f15c88ded7fa8fe...</td>\n      <td>4d1c1a590d2ce1fb5286419f489dcdf55d5339faf09ece...</td>\n      <td>1050553231</td>\n      <td>536870914</td>\n      <td>18931641524</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>1472776292000</td>\n      <td>1bf438fce6f069c1912a010b17d0f4c0303f4f28d6dd66...</td>\n      <td>[{'input_script_bytes': b\"H0E\\x02!\\x00\\x90\\x0c...</td>\n      <td>[{'output_satoshis': 524151, 'output_script_by...</td>\n      <td>000000000000000001b4443ec702e88675fb689dc8848d...</td>\n      <td>0000000000000000018cde3f6c33e586b9db21b45a8ace...</td>\n      <td>78b80ad3c8110b39e4be752a52753a3d5e611b1db8cdab...</td>\n      <td>2229443358</td>\n      <td>536870912</td>\n      <td>9481538743</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>1492374862000</td>\n      <td>6e08a2e66e55f80fd255c0cc79944638613138d6705204...</td>\n      <td>[{'input_script_bytes': b'H0E\\x02!\\x00\\xe5\\xf2...</td>\n      <td>[{'output_satoshis': 938567, 'output_script_by...</td>\n      <td>000000000000000000506f6c74e569ab33ef252aadc231...</td>\n      <td>00000000000000000057f545f49175cf2ca3a746ad5209...</td>\n      <td>0f72fa69878ad34e02a2afc6559ca26716dc92ff3201b3...</td>\n      <td>3472499757</td>\n      <td>536870914</td>\n      <td>22368906784</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>1477326198000</td>\n      <td>d3d4dd6f5bd6d87dd521d4851eaed495161e584e8c0e73...</td>\n      <td>[{'input_script_bytes': b'G0D\\x02 m@(\\x8a\\xcf\\...</td>\n      <td>[{'output_satoshis': 350000, 'output_script_by...</td>\n      <td>00000000000000000170adbfdacf6c5200cb93ecf629cc...</td>\n      <td>000000000000000001ab0c8b2b1b34973ec45a96588a0d...</td>\n      <td>6d3fb05be67a0632583fc8ea08116206d12548d8e37b04...</td>\n      <td>361808208</td>\n      <td>536870912</td>\n      <td>10892986963</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>1511252626000</td>\n      <td>deb8fcb54d28ef9ba53bf18c83f781e90b18f5011428d6...</td>\n      <td>[{'input_script_bytes': b\"G0D\\x02 f\\xa3\\x98r\\x...</td>\n      <td>[{'output_satoshis': 37798, 'output_script_byt...</td>\n      <td>00000000000000000080e525cbdded5452da02aaf8a183...</td>\n      <td>000000000000000000709033a803959fe993468d5655d3...</td>\n      <td>586ef8f46284245fd15f24ef9ac3dbe19e95d08934e226...</td>\n      <td>3548032990</td>\n      <td>536870912</td>\n      <td>58602376365</td>\n      <td>None</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {
        "_cell_guid": "82018f6f-69d2-4c72-ac97-a11a1d5ba519",
        "_uuid": "92f7016f3a9a1fc3feeaf5d7ad152641bc3078af",
        "trusted": true
      },
      "cell_type": "code",
      "source": "# preview the first fuve entries in the by column of the blocks table\nbitcoin_blockchain.head(\"transactions\", selected_columns=\"block_id\", num_rows=5)",
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 9,
          "data": {
            "text/plain": "                                            block_id\n0  0000000000000000000261d50ff902034871137e8748f7...\n1  000000000000000001b4443ec702e88675fb689dc8848d...\n2  000000000000000000506f6c74e569ab33ef252aadc231...\n3  00000000000000000170adbfdacf6c5200cb93ecf629cc...\n4  00000000000000000080e525cbdded5452da02aaf8a183...",
            "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>block_id</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>0000000000000000000261d50ff902034871137e8748f7...</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>000000000000000001b4443ec702e88675fb689dc8848d...</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>000000000000000000506f6c74e569ab33ef252aadc231...</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>00000000000000000170adbfdacf6c5200cb93ecf629cc...</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>00000000000000000080e525cbdded5452da02aaf8a183...</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {
        "_cell_guid": "61bdd859-db04-4b17-b079-504add4fcb07",
        "_uuid": "03009549b409cb9387b4c9ede3c90f42e174b85e",
        "trusted": true
      },
      "cell_type": "code",
      "source": "# this query looks in the blocks table in the bitcoin_blockchain\n# dataset, then gets the block_id column from every row where \n# the timestamp column is greater than 1288778654000.\nquery = \"\"\"SELECT version\n            FROM `bigquery-public-data.bitcoin_blockchain.blocks`\n            WHERE timestamp > 1515949679000; \"\"\"\n\n# check how big this query will be\nbitcoin_blockchain.estimate_query_size(query)",
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 6,
          "data": {
            "text/plain": "0.007907122373580933"
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {
        "_cell_guid": "bfbf3802-c9af-41ea-889e-f42cea77c823",
        "_uuid": "b93ea30d19afeb4dd6c772e1d454fdbed0ec67c0",
        "collapsed": true,
        "trusted": true
      },
      "cell_type": "code",
      "source": "# only run this query if it's less than 100 MB\nrecent_version = bitcoin_blockchain.query_to_pandas_safe(query, max_gb_scanned=0.1)",
      "execution_count": 7,
      "outputs": []
    },
    {
      "metadata": {
        "_cell_guid": "b6333ef3-fc1c-4f52-9990-a83214057e17",
        "_uuid": "374d0dc6ea358ff5fcb5e0915bb649a74394a5de",
        "trusted": true
      },
      "cell_type": "code",
      "source": "plt.hist(recent_version)",
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 8,
          "data": {
            "text/plain": "(array([6.4000e+01, 2.0000e+00, 9.0000e+00, 2.6268e+04, 1.0000e+00,\n        3.0000e+00, 1.3000e+01, 1.3000e+01, 3.3000e+01, 2.4000e+01]),\n array([ 0. ,  1.1,  2.2,  3.3,  4.4,  5.5,  6.6,  7.7,  8.8,  9.9, 11. ]),\n <a list of 10 Patch objects>)"
          },
          "metadata": {}
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": "<matplotlib.figure.Figure at 0x7fd34321a4a8>",
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZAAAAD8CAYAAABZ/vJZAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAHy1JREFUeJzt3Hu8V3Wd7/HXRy4K3kDZGAGKeehi\nTpkxSjl1TEtRp9BRSp0CPc6hTNOuZjUd7GKjnVPNOKNOjnLEGZU8momFEaKlTd62lwRCcquoCMpW\nQLwr8Jk/Pp/lXvz8sTd+9wY2nvfz8fg99u/3/a21vpf1Xd/Pd11+29wdERGRN2qrzV0AERHZMimA\niIhIEQUQEREpogAiIiJFFEBERKSIAoiIiBRRABERkSIKICIiUkQBREREivTd3AUoNWTIEB81atTm\nLoaIyBblrrvuesrdW3piW1tsABk1ahStra2buxgiIlsUM3ukp7alS1giIlJEAURERIoogIiISBEF\nEBERKaIAIiIiRRRARESkiAKIiIgUUQAREZEiCiAiIlJki/0lumwZRp3xq82W96KzD99seYv8/0Bn\nICIiUkQBREREiiiAiIhIEQUQEREpogAiIiJFugwgZjbSzG4yswVmNt/MTsv0M83scTO7N1+H1db5\nhpm1mdlCMzuklj4u09rM7Ixa+u5mdruZPWBmPzOz/j1dURER6VkbcgayGviKu78LGAucbGZ75nc/\ncfe98zUTIL87Bng3MA4438z6mFkf4DzgUGBP4Njads7JbY0GVgAn9lD9RERkI+kygLj7Une/O98/\nCywAhneyynhguru/7O4PA23Avvlqc/eH3P0VYDow3swMOBC4KtefBhxRWiEREdk03tA9EDMbBbwP\nuD2TTjGz+8xsqpkNzrThwGO11RZn2vrSdwZWuvvqhnQREenFNjiAmNl2wNXAF919FXABsAewN7AU\n+FG1aJPVvSC9WRkmm1mrmbW2t7dvaNFFRGQj2KAAYmb9iOBxmbv/HMDdn3T3Ne6+Fvg34hIVxBnE\nyNrqI4AlnaQ/BQwys74N6a/j7he6+xh3H9PS0rIhRRcRkY1kQ57CMuBiYIG7/7iWPqy22JHAvHw/\nAzjGzLY2s92B0cAdwJ3A6Hziqj9xo32GuztwE3B0rj8JuLZ71RIRkY1tQ/6Z4v7AZ4C5ZnZvpn2T\neIpqb+Jy0yLgswDuPt/MrgT+RDzBdbK7rwEws1OAWUAfYKq7z8/tfR2YbmbfB+4hApaIiPRiXQYQ\nd/89ze9TzOxknbOAs5qkz2y2nrs/RMclMBER2QLol+giIlJEAURERIoogIiISBEFEBERKaIAIiIi\nRRRARESkiAKIiIgUUQAREZEiCiAiIlJEAURERIoogIiISBEFEBERKaIAIiIiRRRARESkiAKIiIgU\nUQAREZEiCiAiIlJEAURERIoogIiISBEFEBERKaIAIiIiRRRARESkiAKIiIgUUQAREZEiCiAiIlJE\nAURERIoogIiISBEFEBERKaIAIiIiRRRARESkSJcBxMxGmtlNZrbAzOab2WmZvpOZzTazB/Lv4Ew3\nMzvXzNrM7D4z26e2rUm5/ANmNqmW/n4zm5vrnGtmtjEqKyIiPWdDzkBWA19x93cBY4GTzWxP4Axg\njruPBubkZ4BDgdH5mgxcABFwgCnAfsC+wJQq6OQyk2vrjet+1UREZGPqMoC4+1J3vzvfPwssAIYD\n44Fpudg04Ih8Px641MNtwCAzGwYcAsx29+XuvgKYDYzL73Zw91vd3YFLa9sSEZFe6g3dAzGzUcD7\ngNuBXdx9KUSQAYbmYsOBx2qrLc60ztIXN0kXEZFebIMDiJltB1wNfNHdV3W2aJM0L0hvVobJZtZq\nZq3t7e1dFVlERDaiDQogZtaPCB6XufvPM/nJvPxE/l2W6YuBkbXVRwBLukgf0ST9ddz9Qncf4+5j\nWlpaNqToIiKykWzIU1gGXAwscPcf176aAVRPUk0Crq2lT8ynscYCz+QlrlnAwWY2OG+eHwzMyu+e\nNbOxmdfE2rZERKSX6rsBy+wPfAaYa2b3Zto3gbOBK83sROBRYEJ+NxM4DGgDXgBOAHD35Wb2PeDO\nXO677r48358EXAIMAK7Pl4iI9GJdBhB3/z3N71MAHNRkeQdOXs+2pgJTm6S3Ant1VRYREek99Et0\nEREpogAiIiJFFEBERKSIAoiIiBRRABERkSIKICIiUkQBREREiiiAiIhIEQUQEREpogAiIiJFFEBE\nRKSIAoiIiBRRABERkSIKICIiUkQBREREiiiAiIhIEQUQEREpogAiIiJFFEBERKSIAoiIiBRRABER\nkSIKICIiUkQBREREiiiAiIhIEQUQEREpogAiIiJFFEBERKSIAoiIiBRRABERkSIKICIiUkQBRERE\ninQZQMxsqpktM7N5tbQzzexxM7s3X4fVvvuGmbWZ2UIzO6SWPi7T2szsjFr67mZ2u5k9YGY/M7P+\nPVlBERHZODbkDOQSYFyT9J+4+975mglgZnsCxwDvznXON7M+ZtYHOA84FNgTODaXBTgntzUaWAGc\n2J0KiYjIptFlAHH3m4HlG7i98cB0d3/Z3R8G2oB989Xm7g+5+yvAdGC8mRlwIHBVrj8NOOIN1kFE\nRDaD7twDOcXM7stLXIMzbTjwWG2ZxZm2vvSdgZXuvrohXUREernSAHIBsAewN7AU+FGmW5NlvSC9\nKTObbGatZtba3t7+xkosIiI9qiiAuPuT7r7G3dcC/0ZcooI4gxhZW3QEsKST9KeAQWbWtyF9ffle\n6O5j3H1MS0tLSdFFRKSHFAUQMxtW+3gkUD2hNQM4xsy2NrPdgdHAHcCdwOh84qo/caN9hrs7cBNw\ndK4/Cbi2pEwiIrJp9e1qATO7AjgAGGJmi4EpwAFmtjdxuWkR8FkAd59vZlcCfwJWAye7+5rczinA\nLKAPMNXd52cWXwemm9n3gXuAi3usdiIistF0GUDc/dgmyesd5N39LOCsJukzgZlN0h+i4xKYiIhs\nIfRLdBERKaIAIiIiRRRARESkiAKIiIgUUQAREZEiCiAiIlJEAURERIoogIiISBEFEBERKaIAIiIi\nRRRARESkiAKIiIgUUQAREZEiCiAiIlJEAURERIoogIiISBEFEBERKaIAIiIiRRRARESkiAKIiIgU\nUQAREZEiCiAiIlJEAURERIoogIiISBEFEBERKaIAIiIiRRRARESkiAKIiIgUUQAREZEiCiAiIlKk\nywBiZlPNbJmZzaul7WRms83sgfw7ONPNzM41szYzu8/M9qmtMymXf8DMJtXS329mc3Odc83MerqS\nIiLS8zbkDOQSYFxD2hnAHHcfDczJzwCHAqPzNRm4ACLgAFOA/YB9gSlV0MllJtfWa8xLRER6oS4D\niLvfDCxvSB4PTMv304AjaumXergNGGRmw4BDgNnuvtzdVwCzgXH53Q7ufqu7O3BpbVsiItKLld4D\n2cXdlwLk36GZPhx4rLbc4kzrLH1xk3QREenlevomerP7F16Q3nzjZpPNrNXMWtvb2wuLKCIiPaE0\ngDyZl5/Iv8syfTEwsrbcCGBJF+kjmqQ35e4XuvsYdx/T0tJSWHQREekJpQFkBlA9STUJuLaWPjGf\nxhoLPJOXuGYBB5vZ4Lx5fjAwK7971szG5tNXE2vbEhGRXqxvVwuY2RXAAcAQM1tMPE11NnClmZ0I\nPApMyMVnAocBbcALwAkA7r7czL4H3JnLfdfdqxvzJxFPeg0Ars+XiIj0cl0GEHc/dj1fHdRkWQdO\nXs92pgJTm6S3Ant1VQ4REeld9Et0EREpogAiIiJFFEBERKSIAoiIiBRRABERkSIKICIiUkQBRERE\niiiAiIhIEQUQEREpogAiIiJFFEBERKSIAoiIiBRRABERkSIKICIiUkQBREREiiiAiIhIEQUQEREp\nogAiIiJFFEBERKSIAoiIiBRRABERkSIKICIiUkQBREREiiiAiIhIEQUQEREpogAiIiJFFEBERKSI\nAoiIiBRRABERkSIKICIiUkQBREREinQrgJjZIjOba2b3mllrpu1kZrPN7IH8OzjTzczONbM2M7vP\nzPapbWdSLv+AmU3qXpVERGRT6IkzkI+4+97uPiY/nwHMcffRwJz8DHAoMDpfk4ELIAIOMAXYD9gX\nmFIFHRER6b02xiWs8cC0fD8NOKKWfqmH24BBZjYMOASY7e7L3X0FMBsYtxHKJSIiPai7AcSB35jZ\nXWY2OdN2cfelAPl3aKYPBx6rrbs409aX/jpmNtnMWs2stb29vZtFFxGR7ujbzfX3d/clZjYUmG1m\n93eyrDVJ807SX5/ofiFwIcCYMWOaLiMiIptGt85A3H1J/l0GXEPcw3gyL02Rf5fl4ouBkbXVRwBL\nOkkXEZFerDiAmNm2ZrZ99R44GJgHzACqJ6kmAdfm+xnAxHwaayzwTF7imgUcbGaD8+b5wZkmIiK9\nWHcuYe0CXGNm1XYud/dfm9mdwJVmdiLwKDAhl58JHAa0AS8AJwC4+3Iz+x5wZy73XXdf3o1yiYjI\nJlAcQNz9IeC9TdKfBg5qku7AyevZ1lRgamlZRERk09Mv0UVEpIgCiIiIFFEAERGRIgogIiJSRAFE\nRESKKICIiEgRBRARESmiACIiIkUUQEREpIgCiIiIFFEAERGRIgogIiJSRAFERESKKICIiEgRBRAR\nESmiACIiIkUUQEREpIgCiIiIFFEAERGRIgogIiJSRAFERESKKICIiEgRBRARESmiACIiIkUUQERE\npIgCiIiIFFEAERGRIgogIiJSRAFERESKKICIiEiRXhNAzGycmS00szYzO2Nzl0dERDrXKwKImfUB\nzgMOBfYEjjWzPTdvqUREpDO9IoAA+wJt7v6Qu78CTAfGb+YyiYhIJ/pu7gKk4cBjtc+Lgf02Vmaj\nzvjVxtp0pxadffhmyVdEZGPoLQHEmqT56xYymwxMzo/PmdnCwvyGAE8Vrlucn52z6fLaJDn18vx6\noL17bd22wPzezHXb1Pl1N6/deqogvSWALAZG1j6PAJY0LuTuFwIXdjczM2t19zHd3U5vzO/NXLdN\nnd+buW6bOr83c902dX6bum6d6S33QO4ERpvZ7mbWHzgGmLGZyyQiIp3oFWcg7r7azE4BZgF9gKnu\nPn8zF0tERDrRKwIIgLvPBGZuouy6fRmsF+f3Zq7bps7vzVy3TZ3fm7lumzq/TV239TL3192rFhER\n6VJvuQciIiJbmM12CcvMpgJ/DSxz970ybSfgZ8AoYBHwSXdfYWZfA/42V+0LvAtoAV4Abga2zvSr\n3H1KbsuA7wMTgDXAM8DbgLXAE7mtrYF3Ag/l6++AHwEfBnYAHgVeIX4d3wa8TPxm5XEi+P4c2BXY\nB9gDWAksA4YC2+Q21mY5H8n3q4FBWYbtsxxvAV4Fnq7V7z+ADxJPpD0JPA88TDyCtwbYnXhS7eWs\nQ/8s63zga8Sj0TdkPvOATwJXAP89l3u4ltdRwBTg7cTj00uBy4EfAJcCn8iyP5JlvzPruk9uY3jW\nZRHwtLuPMbO2LONzwO3A8e6+xMwOAi4gnrpbC8xz9/3M7MvA6bn91cAc4FPALln+qq++nHV9MNth\nGPBs5v9MtvUy4IGsK8DVxA9T++W6lvvr28CxWedVuQ0n+t8S4CVgr1rbrwb+AHwaGED0j0eA44HT\ngMOBbXP7zxOPWv4/4IuZ38LcxlzgBHd/yczuAfbOtts6619atyG5X17N/LfL+rxK9FcHRgMDs013\n7mZ+O+X3ltvun9uZn/m9jzgWFhN9bp22zH5yEXBi1v8B4vLM32de2xHH7OJc5+EsR78s+xLgn4F2\n4OvEcbRdLj8feH/WYw1xHC3NZfrntvrl/uifbd8/95kBC4AP5bb75HaGZD3PAk6m4/i+DPgH4rds\nVX6rgZOIvr+Cjt+5zSGOp61zWysyvzWZT99cZ4dsr5bcJ6tyP51AjFP/G2hx96fWNz66+3Iz+1Iu\n76zb726hY/wZCtzh7keY2d9mW0Icuye5+x9ZH3ffLC9ikN6HGECqtB8CZ+T7M4Bzmqz3ceDGfG/A\ndvm+Xzb82Px8AjH4bZWfP9Ekv6uJX8BX+c0F/i4/9ycOro8D9+aOMeDHwDmZXxswO5cfSBwEo4Bf\nEQfyB4A/AVcSg8z/JQImwLeA/5Pvt8t135r5PUwEP8udPCTza63V7xPAr/N9a7bdPKLTPU4MbPcD\nR1dtCRyU2/9lvS2BPxOdbjvg88C0bMsfAv+ayx5DBPergfOB6bWyrwV+DxzdsJ8+DvwSOLW2nbZ8\n7Zp5VduZkG0wgDjwHs026w9sXcvreSLQDgEOA67PdjoQuD2X+1figO2bbfoisGd+d2Duo8eyjQZk\n+hzg8/n+0Nq2nq+lV/ntAIzNNjqVuHc3mxjUFgD35TJDiUF0P2IQH5HbqfpDn2z/mbmfriYGrNK6\nHZvLDycO/lPr+TU5frqb39vy73Bi4Pz7/HwXcFO93zS2ZX7uA/yuVv96PxlE9N+VxLE1FLgE+BLR\nzwdmmW4gJkeDgYOJIH470d+rQf84OvrZWcByog8MA/bJ9KHEcbBnpj8PnJ7fTaNjXBiQ+b83P/8F\n8fDPI0SfHVKr241EUJyWaTsRE9Wdsi0fynIPy/1QjTGPAD+t9bmd8/05xLFX5Teki/FxODGWDGjs\nBw3rXA1MzPcfBAY3Hgfre222S1jufjOxI+vGEzuL/HtEk1WPJWbSeHgu0/vlq7qpcxLwXXdfm8vO\naJLfx4gDBKIR3wFcnMu/4u4rM7/z3H21R6veQsxm+hGdZBsz60t0rFeIwXR/4gB+IT8PJGZLBxKd\nGmAqsbMhZiPVvjgW2BH4h6zfs+7+VOZXzSIhZrpuZtsTs9tLM30+cfBtA1Qzh2nAEe4+h5jNNLal\nAztkW+5InPH0I4J8tT+uAj6adWgFts16n5rrP1lvWHe/rpbXtrVybw/c7O6PZl4PZfofsj0HEGc4\n2wFLcj+8nMvsnN+/mJ/HA5dmO90IDDKzYURwWuLuq4k+tJAIrLj7je6+KNfvCwzIerxIBDaA24AR\n2bbb0PFwR5XfKne/Ldv5Lfn3d8QZ09VZ/nHuvszd7yFmxEZHX6n6wxdy+WWZz4FEnymt2xXZRyEC\n1m4N+UHu86xbd/Or9h257/pmfiOBX2T6VcBBTdqSrP+VWX9Yt58cR8y4f+XuL7h7tcwI4LZMW53t\nPsrdV7j7b4h+NCL3YZ9cx+nor32J2f4qd1/q7ndnXZYRwX94ljNmqGY7EMfBxbmtjwD3esesfApx\n5tx4M7nat8/X0g4hJpzL3X0JMekYl/mtzWUGE2cdN2a5Zrr70/ndbcRVm2b5VV4bH1O9j9f7AVm/\nqh/8IvP7g7uvqOU3Yj35hM6iy8Z+EbOA+hnByobvVzR8HkgEgZ1qaX2IM4TnqJ2xELPUbxGD3fXE\nqftr+eW21lbbIi4jrCZmOfcAFxGzl8b8riOi/3PEaeR0YvbwPPEr+YnEQXNaplWd/P7M7wP1+hKz\n1ReIU+KBxCnt48SZzt3EJZB5Vf1yuQeJWeHoWn6jcrnJuY2VWZej620JHECcFbzWlsSp+tPEQPdS\nLa955Kw5132S+H1Ov6z308TB+FS+fxCYXFv+34mBeR5xSg0xYLxEXIp6sWH50zLvF4E/1tJHZju9\nnPvm4WyblcAPa8s9TFyyW0TMQgcSE4RniOBwFx0zrUXANzO/duCy2na+mvt/Yu7Du3Pd+4C/8o6Z\n7Eu53QnAfwL/Qgw0L+b+mdjQH1/Lixiofkf030uISzFX9VDd+mX+L9Tr1rDPJ/ZEfsRZ9ZPETLuq\n30rW7TcPEmeb9bY8vVb/PxJ9qN5P/pHoj3NreV2S5XqZuAw6CLgV+Ocm++46IjBV+d2ZZXsl87qP\nmMRVs+1RWd8FWY/pWfc/53qXE33v1nw/K+v1+1p/eiTzuy/Xq8amZZl2B/D9Wll/mnk+BxyZ21xF\n9JVpdIxD2+byd9Bx1WERDWcgNB8fq2NqnT5e+34icem/2fj8VeCiTsfwLSyAfAq4bj3bGgTcBOyV\nn58DvpLv/4Y4c3gtv9zWq7X1xxBRfb/8/E/EDOK62jLfAq4hZpODsmP+kjhghxKzs9/mTrmRvGRG\nRPdPEzPyGxrrR5zO3kEM/rOyHEfld18mBuLG+h2Xnex64h7GKDoO4qPoOoC81pbEvZyq3l8jzmZu\nIgaK+kDwAjCJOMO6jBiADs3lrgL+BzEYfLghr28A36kNJvOI2eYUYkB6OzHzupGO68YzgE837OPq\nksB78vPszLvKbw5x3fsbuey9xGWFp7JeQ3L9t2f6LcRsr19tH32EGER2zratLl0MJQ7uk2vlmUMM\n/N8h+kY1eE4nglOV12AiqLyjllf9cuslxMBzFPDWHqjbNCKANNatvs+v78H8diYG+1Mzv1XAFxoC\nyA0NbbkS+Fyt/kezbj+ZSpxF7VjLa3/i2PssMcguIoLaT3Kdat99nzhOq7odTkyqPgK8mzhO9yAm\nAVOJs927gL/J5d+V+2Mg8JfExK9qt1tyWyOJoHQHcWl4EfDuXGZGlvfDRF/4JHH1YA5wV61dvg18\nJfO7gzgT+WDm94XaOPQ94EwiOOzYSQBZZ3yk45hapx80rHM9OdY0pL92HGxJAWQhMCzfDwMWNix/\nDXBcJ9ubAnw1399PnNqSne4Z1g0g1xCnc1V+72HdgPIhYnZwXH6eRMw+BtaWuQO4vPb5MiJIHEfM\nREcRg+VE4trlQvI6aWP9iJnc7bnu83TcuxkJzG9Sv63omK1sQ1yTfznrtIiOG6nLiPtBCxsG9Wsy\nrxbgwVo5diXu20zJ8n6gdtCvzbzOAz5DzAYXZZ1fyrym18pY5bVbtkNLlvfMWl4riBn8BKIzL8i8\nJgLn18q1c657KR1B8adE4KryW5jtulttP1f3tg7LzxdnXsuA/6htfyJxj+dBOgbFp4Ftasu0Nqyz\nkJh41PM6k5ihHlbLa0K20ZBaXquy7RYRQX8tMKG27dK6/Yzolxc31O382j5vVrfutOUE4r5fdW9t\nLnB1vu+beTXmt4IYEKv6LwP+Zy2vGaw72F7c0D4HEH3rB8TZzXty353O64/T84hJUlW3qcSgPoro\nl7OALzeMJTflvn0LERyrcp1JBOe/yDJX9VhNHNtvIY6LlZle1e0I4rLW8oY2P7ZJfu3Av9TGoXuJ\nidkyOvrMa/mtb3zM/fK6ftDkmNqmoe5VW769qzG8tz3GO4MYqMm/11ZfmNmOxBMY9bQWMxuU7wcQ\n1+jvz69/QVzbI9f7c5NtXVnL7zDgCTN7R+3zjsC1ZjaOeDLhBOKmbpVfC9BiYdvM7yai8ccSg21/\nYoaygLimuCOx075AHHSY2WCio7wz63cdcICZtRD3Sf6U+f11rX7VrOqXmc9U4El3f6u7jyIuAdxP\nHFy71NuNOKirtlwB7Ghm+2VbfowYPD5KzF6q9vkB8Ki7v0R03AOJJ2T+krjkNou4wbkrMM/MRtfy\n+0SWZQUR+A7Oa7KH5+cFWYeDiAO7vWozMxuRdZ8A/IZ4MKF6omVWLjfPzI4GnnH3pcT1/Or6/ALi\nabA5ZjaQuKG9gDgAx5jZwHxi7xNZp8+4+58zv18TMzdy/w4E3mFmo81sLDEp+QBwv5ntnO15KHEA\n3lLL61HiPteAzOsg4FvuPir31VziacKZeU26tG7jiOD3VWBsrW4H0fEE07VZt18CfbqZ34dq9dsP\naMv8nif6HMSZxcNN2nIBEcw+RgSuz2cfqPr3rrGo9a3tt/ZcfygxID9Kx9WFnxOXEI/PfWm1ui0F\n/irr9jbi2LyfuGxUleWa7JOY2W7EWcEid3+CmJg9ktuqjukHiSsHdxGTqceBD+XyexGTsOOIY/zz\n7v4L4sGK/mY22MzeS9z0n2Vm76ryo+OfJFb3az9L3If4qLsPrfWZxcQDAE9kmV83Pmb7NPaDBbXv\nJxBB/6Uqwcx2zbasjoNObbYfEprZFcQsYghxDXUKMehfSXSeR4kZx/Jc/njixuQxtW28hzhd70MM\nRFe6+3fzu0HEGcGuxCxgJXGfYwgxG2wjDvZ6ft8h7j30JwaYh939qHwkdWviwNiVuByxNMv7DuLJ\nDctlTnb3X5vZXKJT9CEuST1OnNEYEUSeq+VjREcc4O7HZAf+d2I2MozoLGuy3DsQZxcriM7/v4in\npfbK7bya+XyMCGZGdOYJROd6Z+a/GjjS3WeZ2ZG5jRGZz+PZdj/MclSPY57q7peY2XbEGdOeWYdt\niQPreeIpmrPM7CnisttWxAF4ortfnnmdT5xerwF+7O7fNrMbiAO7b7bXU8B/Iy4D/IgIVsuIa8Kf\nyi7QN9ukJfdrO3GZrbo/tJqY6d9K3MBcSwTH/bJtX8wyLM59N4SOgWIPIsh/qZbX5cSgMSk/P0YM\nRKcRAzLZFqtz2xdlnqfnetU+/BVxOedlADN7IpedSswiS+tWDULPZv36EMfWPcT9ho9m//otcDYx\nqepOfgOJfW50nJ2+QsyWtwHeSwyEa4lLTeu0ZfaTq4nAvYq4T/A5ItD8J3H55vhc/yIiMLQQfeHV\nLNsXiRvHR2V5LMu6iOizj9NxnG1F3Ht6Meu3irgsNpc4JoYSZ/DP5Hc7E31xOdFfjQimM4l97sBM\ndz/dzBYTY8yahvo9mJ+fyTLdRNzH3D7L1J7lqh4O6ZPtMDrL/bbcbhVYbnP3z5nZImCMxwM2TcfH\nTP8OcbysJvpBvd/9Fjjb3X9dW/6ibMvqOFjtnfzjRv0SXUREivS2S1giIrKFUAAREZEiCiAiIlJE\nAURERIoogIiISBEFEBERKaIAIiIiRRRARESkyH8B5n9ftk5P+AIAAAAASUVORK5CYII=\n"
          },
          "metadata": {}
        }
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "name": "python",
      "version": "3.6.6",
      "mimetype": "text/x-python",
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "pygments_lexer": "ipython3",
      "nbconvert_exporter": "python",
      "file_extension": ".py"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 1
}