v2_eth_ct_rss.ipynb

{
  "cells": [
    {
      "attachments": {},
      "cell_type": "markdown",
      "metadata": {
        "colab_type": "text",
        "id": "view-in-github"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/m4rk-lewis/GPT-3_breaking_news_parse_with_sentiment_classify/blob/main/GPT_3_breaking_financial_news_summary_and_sentiment_classification.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "nH2D1SpjBXj9"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Requirement already satisfied: feedparser in c:\\python311\\lib\\site-packages (6.0.10)\n",
            "Requirement already satisfied: beautifulsoup4 in c:\\python311\\lib\\site-packages (4.12.2)\n",
            "Requirement already satisfied: openai in c:\\python311\\lib\\site-packages (0.27.6)\n",
            "Requirement already satisfied: sgmllib3k in c:\\python311\\lib\\site-packages (from feedparser) (1.0.0)\n",
            "Requirement already satisfied: soupsieve>1.2 in c:\\python311\\lib\\site-packages (from beautifulsoup4) (2.4.1)\n",
            "Requirement already satisfied: requests>=2.20 in c:\\python311\\lib\\site-packages (from openai) (2.28.1)\n",
            "Requirement already satisfied: tqdm in c:\\python311\\lib\\site-packages (from openai) (4.65.0)\n",
            "Requirement already satisfied: aiohttp in c:\\python311\\lib\\site-packages (from openai) (3.8.4)\n",
            "Requirement already satisfied: charset-normalizer<3,>=2 in c:\\python311\\lib\\site-packages (from requests>=2.20->openai) (2.1.1)\n",
            "Requirement already satisfied: idna<4,>=2.5 in c:\\python311\\lib\\site-packages (from requests>=2.20->openai) (3.4)\n",
            "Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\\python311\\lib\\site-packages (from requests>=2.20->openai) (1.26.11)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in c:\\python311\\lib\\site-packages (from requests>=2.20->openai) (2022.12.7)\n",
            "Requirement already satisfied: attrs>=17.3.0 in c:\\python311\\lib\\site-packages (from aiohttp->openai) (23.1.0)\n",
            "Requirement already satisfied: multidict<7.0,>=4.5 in c:\\python311\\lib\\site-packages (from aiohttp->openai) (6.0.4)\n",
            "Requirement already satisfied: async-timeout<5.0,>=4.0.0a3 in c:\\python311\\lib\\site-packages (from aiohttp->openai) (4.0.2)\n",
            "Requirement already satisfied: yarl<2.0,>=1.0 in c:\\python311\\lib\\site-packages (from aiohttp->openai) (1.9.2)\n",
            "Requirement already satisfied: frozenlist>=1.1.1 in c:\\python311\\lib\\site-packages (from aiohttp->openai) (1.3.3)\n",
            "Requirement already satisfied: aiosignal>=1.1.2 in c:\\python311\\lib\\site-packages (from aiohttp->openai) (1.3.1)\n",
            "Requirement already satisfied: colorama in c:\\users\\musea\\appdata\\roaming\\python\\python311\\site-packages (from tqdm->openai) (0.4.6)\n"
          ]
        },
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "\n",
            "[notice] A new release of pip available: 22.3.1 -> 23.1.2\n",
            "[notice] To update, run: python.exe -m pip install --upgrade pip\n"
          ]
        }
      ],
      "source": [
        "# credit to: @m4rk-lewis https://github.com/m4rk-lewis/GPT-3_breaking_news_parse_with_sentiment_classify\n",
        "\n",
        "# Step 1: Install required packages\n",
        "!pip install feedparser beautifulsoup4 openai"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 2,
      "metadata": {
        "id": "Pc3S-XJVBaIb"
      },
      "outputs": [],
      "source": [
        "# Step 2: Download and parse the RSS feed\n",
        "import feedparser\n",
        "def get_feed(url):\n",
        "    return feedparser.parse(url)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "metadata": {
        "id": "W5XIA-eyBfJU"
      },
      "outputs": [],
      "source": [
        "# Step 3: Extract HTML from the description\n",
        "from bs4 import BeautifulSoup\n",
        "\n",
        "def extract_text(html):\n",
        "    soup = BeautifulSoup(html, \"html.parser\")\n",
        "    return soup.get_text()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 25,
      "metadata": {
        "id": "r-NlATswBhpj"
      },
      "outputs": [],
      "source": [
        "from dotenv import load_dotenv\n",
        "load_dotenv()\n",
        "import os\n",
        "import openai\n",
        "\n",
        "# openai.api_key = \"insert-openAI-API-here\"\n",
        "openai.api_key = os.environ.get(\"api_key\")\n",
        "\n",
        "# Step 4: Summarize using GPT-3\n",
        "def summarize_text(text):\n",
        "    response = openai.Completion.create(\n",
        "        engine=\"text-davinci-003\", \n",
        "        prompt=f\"Summarize the following text: {text}\",\n",
        "        temperature=0.3,\n",
        "        max_tokens=50,\n",
        "        top_p=1,\n",
        "        frequency_penalty=0.0,\n",
        "        presence_penalty=0,\n",
        "    )\n",
        "    return response.choices[0].text.strip()\n",
        "\n",
        "# Step 5: Sentiment classification\n",
        "def sentiment_classification(text):\n",
        "    response = openai.Completion.create(\n",
        "        engine=\"text-davinci-003\", \n",
        "        prompt=f\"classify the sentiment of this breaking financial news article as a numerical float, with a range of -1 to 1 with 0.1 granularity, where -1 is maximum bearishness and 1 is maximum bullishness in relation to equities, reply only the float number as requested, do not include any text in the response: {text}\",       \n",
        "        temperature=0.3,\n",
        "        max_tokens=10,\n",
        "        top_p=1,\n",
        "        frequency_penalty=0.0,\n",
        "        presence_penalty=0,\n",
        "    )\n",
        "    sentiment_str = response.choices[0].text.strip()\n",
        "    try:\n",
        "        sentiment = float(sentiment_str)\n",
        "    except ValueError:\n",
        "        sentiment = None\n",
        "    return sentiment"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 26,
      "metadata": {
        "id": "4JbNpYxYBoo0"
      },
      "outputs": [],
      "source": [
        "# Step 6: Store the summarized information in a SQLite database\n",
        "import sqlite3\n",
        "\n",
        "def create_db():\n",
        "    conn = sqlite3.connect('eth_ct_rss.db')\n",
        "    cursor = conn.cursor()\n",
        "    cursor.execute('''CREATE TABLE IF NOT EXISTS news (published TEXT, title TEXT, summary TEXT, sentiment TEXT)''')\n",
        "    return conn, cursor\n",
        "\n",
        "def insert_news(cursor, published, title, summary, sentiment):\n",
        "    cursor.execute(\"INSERT INTO news (published, title, summary, sentiment) VALUES (?, ?, ?, ?)\", (published, title, summary, sentiment))\n",
        "    # Commit the changes to the database\n",
        "    conn.commit()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 27,
      "metadata": {
        "id": "BsdXg5TLBtdT"
      },
      "outputs": [],
      "source": [
        "# Step 7: Continuously monitor the RSS feed for updates\n",
        "import time\n",
        "\n",
        "def monitor_feed(url, conn, cursor\n",
        "                 # , interval=60\n",
        "                 ):\n",
        "    seen_titles = set()\n",
        "    \n",
        "    while True:\n",
        "        feed = get_feed(url)\n",
        "        # print(feed.entries[0])\n",
        "        for entry in feed.entries:\n",
        "            title = entry.title\n",
        "            if title not in seen_titles:\n",
        "                # if entry.category == \"News\" or entry.category ==\"Central Banks\":\n",
        "                    seen_titles.add(title)\n",
        "                    category = extract_text(entry.category)\n",
        "                    published = extract_text(entry.published)\n",
        "                    description = extract_text(entry.description)\n",
        "                    summary = summarize_text(description[:4000])\n",
        "                    sentiment = sentiment_classification(description[:4000])\n",
        "                    insert_news(cursor, published, title, summary, sentiment)  \n",
        "                    print(f\"{published}>>> {category}  >>> {title} >>> Summary: {summary} >>> Sentiment: {sentiment}\")\n",
        "                          \n",
        "        # Close the database connection and sleep\n",
        "        conn.close()\n",
        "        #time.sleep(interval)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 28,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 765
        },
        "id": "BtUcnCZRBxoU",
        "outputId": "1f37d8b6-38ee-4910-eab8-5ca9265b54c1"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Tue, 09 May 2023 16:56:59 +0100>>> PayPal  >>> PayPal’s crypto holdings increased by 56% in Q1 2023 to nearly $1B >>> Summary: Fintechs hold $861M in BTC and ETH, up 56% since Q4 2022. >>> Sentiment: 0.7\n",
            "Tue, 09 May 2023 14:30:00 +0100>>> Features  >>> $3.4B of Bitcoin in a popcorn tin: The Silk Road hacker’s story >>> Summary: Hacker stole billions and lived luxuriously for 10 years until caught due to small transaction. >>> Sentiment: -0.2\n",
            "Tue, 09 May 2023 01:50:14 +0100>>> Memecoin  >>> Worth it? Trader spends $120K on gas buying $155K worth of a memecoin >>> Summary: User spent 76% more in gas fees on a single memecoin trade. >>> Sentiment: -0.5\n",
            "Mon, 08 May 2023 17:00:00 +0100>>> Aave  >>> Aave v3 launches on Ethereum layer-2 network Metis >>> Summary: Big players in DeFi sector are deploying liquidity protocol Aave on Ethereum scaling network Metis. >>> Sentiment: 0.7\n",
            "Mon, 08 May 2023 14:30:00 +0100>>> Columns  >>> ‘Ethical’ SBF game axed, Web3 games sign-up process sucks, Tomb Chaser: Web3 Gamer >>> Summary: FTX kills Storybook Brawl, Animoca's MMA game, and why Web3 game onboarding is awful. >>> Sentiment: 0.0\n"
          ]
        },
        {
          "ename": "KeyboardInterrupt",
          "evalue": "",
          "output_type": "error",
          "traceback": [
            "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[1;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
            "Cell \u001b[1;32mIn[28], line 8\u001b[0m\n\u001b[0;32m      6\u001b[0m url \u001b[39m=\u001b[39m \u001b[39m\"\u001b[39m\u001b[39mhttps://cointelegraph.com/rss/tag/ethereum\u001b[39m\u001b[39m\"\u001b[39m\n\u001b[0;32m      7\u001b[0m conn, cursor \u001b[39m=\u001b[39m create_db()\n\u001b[1;32m----> 8\u001b[0m monitor_feed(url, conn, cursor)\n",
            "Cell \u001b[1;32mIn[27], line 20\u001b[0m, in \u001b[0;36mmonitor_feed\u001b[1;34m(url, conn, cursor)\u001b[0m\n\u001b[0;32m     18\u001b[0m published \u001b[39m=\u001b[39m extract_text(entry\u001b[39m.\u001b[39mpublished)\n\u001b[0;32m     19\u001b[0m description \u001b[39m=\u001b[39m extract_text(entry\u001b[39m.\u001b[39mdescription)\n\u001b[1;32m---> 20\u001b[0m summary \u001b[39m=\u001b[39m summarize_text(description[:\u001b[39m4000\u001b[39;49m])\n\u001b[0;32m     21\u001b[0m sentiment \u001b[39m=\u001b[39m sentiment_classification(description[:\u001b[39m4000\u001b[39m])\n\u001b[0;32m     22\u001b[0m insert_news(cursor, published, title, summary, sentiment)  \n",
            "Cell \u001b[1;32mIn[25], line 11\u001b[0m, in \u001b[0;36msummarize_text\u001b[1;34m(text)\u001b[0m\n\u001b[0;32m     10\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39msummarize_text\u001b[39m(text):\n\u001b[1;32m---> 11\u001b[0m     response \u001b[39m=\u001b[39m openai\u001b[39m.\u001b[39;49mCompletion\u001b[39m.\u001b[39;49mcreate(\n\u001b[0;32m     12\u001b[0m         engine\u001b[39m=\u001b[39;49m\u001b[39m\"\u001b[39;49m\u001b[39mtext-davinci-003\u001b[39;49m\u001b[39m\"\u001b[39;49m, \n\u001b[0;32m     13\u001b[0m         prompt\u001b[39m=\u001b[39;49m\u001b[39mf\u001b[39;49m\u001b[39m\"\u001b[39;49m\u001b[39mremove all unnecesary whitespace and formatting, then provide a short summary of less than 30 words of the following text: \u001b[39;49m\u001b[39m{\u001b[39;49;00mtext\u001b[39m}\u001b[39;49;00m\u001b[39m\"\u001b[39;49m,\n\u001b[0;32m     14\u001b[0m         temperature\u001b[39m=\u001b[39;49m\u001b[39m0.7\u001b[39;49m,\n\u001b[0;32m     15\u001b[0m         max_tokens\u001b[39m=\u001b[39;49m\u001b[39m50\u001b[39;49m,\n\u001b[0;32m     16\u001b[0m         top_p\u001b[39m=\u001b[39;49m\u001b[39m1\u001b[39;49m,\n\u001b[0;32m     17\u001b[0m         frequency_penalty\u001b[39m=\u001b[39;49m\u001b[39m0.5\u001b[39;49m,\n\u001b[0;32m     18\u001b[0m         presence_penalty\u001b[39m=\u001b[39;49m\u001b[39m0\u001b[39;49m,\n\u001b[0;32m     19\u001b[0m     )\n\u001b[0;32m     20\u001b[0m     \u001b[39mreturn\u001b[39;00m response\u001b[39m.\u001b[39mchoices[\u001b[39m0\u001b[39m]\u001b[39m.\u001b[39mtext\u001b[39m.\u001b[39mstrip()\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\site-packages\\openai\\api_resources\\completion.py:25\u001b[0m, in \u001b[0;36mCompletion.create\u001b[1;34m(cls, *args, **kwargs)\u001b[0m\n\u001b[0;32m     23\u001b[0m \u001b[39mwhile\u001b[39;00m \u001b[39mTrue\u001b[39;00m:\n\u001b[0;32m     24\u001b[0m     \u001b[39mtry\u001b[39;00m:\n\u001b[1;32m---> 25\u001b[0m         \u001b[39mreturn\u001b[39;00m \u001b[39msuper\u001b[39;49m()\u001b[39m.\u001b[39;49mcreate(\u001b[39m*\u001b[39;49margs, \u001b[39m*\u001b[39;49m\u001b[39m*\u001b[39;49mkwargs)\n\u001b[0;32m     26\u001b[0m     \u001b[39mexcept\u001b[39;00m TryAgain \u001b[39mas\u001b[39;00m e:\n\u001b[0;32m     27\u001b[0m         \u001b[39mif\u001b[39;00m timeout \u001b[39mis\u001b[39;00m \u001b[39mnot\u001b[39;00m \u001b[39mNone\u001b[39;00m \u001b[39mand\u001b[39;00m time\u001b[39m.\u001b[39mtime() \u001b[39m>\u001b[39m start \u001b[39m+\u001b[39m timeout:\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\site-packages\\openai\\api_resources\\abstract\\engine_api_resource.py:153\u001b[0m, in \u001b[0;36mEngineAPIResource.create\u001b[1;34m(cls, api_key, api_base, api_type, request_id, api_version, organization, **params)\u001b[0m\n\u001b[0;32m    127\u001b[0m \u001b[39m@classmethod\u001b[39m\n\u001b[0;32m    128\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mcreate\u001b[39m(\n\u001b[0;32m    129\u001b[0m     \u001b[39mcls\u001b[39m,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m    136\u001b[0m     \u001b[39m*\u001b[39m\u001b[39m*\u001b[39mparams,\n\u001b[0;32m    137\u001b[0m ):\n\u001b[0;32m    138\u001b[0m     (\n\u001b[0;32m    139\u001b[0m         deployment_id,\n\u001b[0;32m    140\u001b[0m         engine,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m    150\u001b[0m         api_key, api_base, api_type, api_version, organization, \u001b[39m*\u001b[39m\u001b[39m*\u001b[39mparams\n\u001b[0;32m    151\u001b[0m     )\n\u001b[1;32m--> 153\u001b[0m     response, _, api_key \u001b[39m=\u001b[39m requestor\u001b[39m.\u001b[39;49mrequest(\n\u001b[0;32m    154\u001b[0m         \u001b[39m\"\u001b[39;49m\u001b[39mpost\u001b[39;49m\u001b[39m\"\u001b[39;49m,\n\u001b[0;32m    155\u001b[0m         url,\n\u001b[0;32m    156\u001b[0m         params\u001b[39m=\u001b[39;49mparams,\n\u001b[0;32m    157\u001b[0m         headers\u001b[39m=\u001b[39;49mheaders,\n\u001b[0;32m    158\u001b[0m         stream\u001b[39m=\u001b[39;49mstream,\n\u001b[0;32m    159\u001b[0m         request_id\u001b[39m=\u001b[39;49mrequest_id,\n\u001b[0;32m    160\u001b[0m         request_timeout\u001b[39m=\u001b[39;49mrequest_timeout,\n\u001b[0;32m    161\u001b[0m     )\n\u001b[0;32m    163\u001b[0m     \u001b[39mif\u001b[39;00m stream:\n\u001b[0;32m    164\u001b[0m         \u001b[39m# must be an iterator\u001b[39;00m\n\u001b[0;32m    165\u001b[0m         \u001b[39massert\u001b[39;00m \u001b[39mnot\u001b[39;00m \u001b[39misinstance\u001b[39m(response, OpenAIResponse)\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\site-packages\\openai\\api_requestor.py:220\u001b[0m, in \u001b[0;36mAPIRequestor.request\u001b[1;34m(self, method, url, params, headers, files, stream, request_id, request_timeout)\u001b[0m\n\u001b[0;32m    209\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mrequest\u001b[39m(\n\u001b[0;32m    210\u001b[0m     \u001b[39mself\u001b[39m,\n\u001b[0;32m    211\u001b[0m     method,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m    218\u001b[0m     request_timeout: Optional[Union[\u001b[39mfloat\u001b[39m, Tuple[\u001b[39mfloat\u001b[39m, \u001b[39mfloat\u001b[39m]]] \u001b[39m=\u001b[39m \u001b[39mNone\u001b[39;00m,\n\u001b[0;32m    219\u001b[0m ) \u001b[39m-\u001b[39m\u001b[39m>\u001b[39m Tuple[Union[OpenAIResponse, Iterator[OpenAIResponse]], \u001b[39mbool\u001b[39m, \u001b[39mstr\u001b[39m]:\n\u001b[1;32m--> 220\u001b[0m     result \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mrequest_raw(\n\u001b[0;32m    221\u001b[0m         method\u001b[39m.\u001b[39;49mlower(),\n\u001b[0;32m    222\u001b[0m         url,\n\u001b[0;32m    223\u001b[0m         params\u001b[39m=\u001b[39;49mparams,\n\u001b[0;32m    224\u001b[0m         supplied_headers\u001b[39m=\u001b[39;49mheaders,\n\u001b[0;32m    225\u001b[0m         files\u001b[39m=\u001b[39;49mfiles,\n\u001b[0;32m    226\u001b[0m         stream\u001b[39m=\u001b[39;49mstream,\n\u001b[0;32m    227\u001b[0m         request_id\u001b[39m=\u001b[39;49mrequest_id,\n\u001b[0;32m    228\u001b[0m         request_timeout\u001b[39m=\u001b[39;49mrequest_timeout,\n\u001b[0;32m    229\u001b[0m     )\n\u001b[0;32m    230\u001b[0m     resp, got_stream \u001b[39m=\u001b[39m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_interpret_response(result, stream)\n\u001b[0;32m    231\u001b[0m     \u001b[39mreturn\u001b[39;00m resp, got_stream, \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mapi_key\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\site-packages\\openai\\api_requestor.py:520\u001b[0m, in \u001b[0;36mAPIRequestor.request_raw\u001b[1;34m(self, method, url, params, supplied_headers, files, stream, request_id, request_timeout)\u001b[0m\n\u001b[0;32m    518\u001b[0m     _thread_context\u001b[39m.\u001b[39msession \u001b[39m=\u001b[39m _make_session()\n\u001b[0;32m    519\u001b[0m \u001b[39mtry\u001b[39;00m:\n\u001b[1;32m--> 520\u001b[0m     result \u001b[39m=\u001b[39m _thread_context\u001b[39m.\u001b[39;49msession\u001b[39m.\u001b[39;49mrequest(\n\u001b[0;32m    521\u001b[0m         method,\n\u001b[0;32m    522\u001b[0m         abs_url,\n\u001b[0;32m    523\u001b[0m         headers\u001b[39m=\u001b[39;49mheaders,\n\u001b[0;32m    524\u001b[0m         data\u001b[39m=\u001b[39;49mdata,\n\u001b[0;32m    525\u001b[0m         files\u001b[39m=\u001b[39;49mfiles,\n\u001b[0;32m    526\u001b[0m         stream\u001b[39m=\u001b[39;49mstream,\n\u001b[0;32m    527\u001b[0m         timeout\u001b[39m=\u001b[39;49mrequest_timeout \u001b[39mif\u001b[39;49;00m request_timeout \u001b[39melse\u001b[39;49;00m TIMEOUT_SECS,\n\u001b[0;32m    528\u001b[0m         proxies\u001b[39m=\u001b[39;49m_thread_context\u001b[39m.\u001b[39;49msession\u001b[39m.\u001b[39;49mproxies,\n\u001b[0;32m    529\u001b[0m     )\n\u001b[0;32m    530\u001b[0m \u001b[39mexcept\u001b[39;00m requests\u001b[39m.\u001b[39mexceptions\u001b[39m.\u001b[39mTimeout \u001b[39mas\u001b[39;00m e:\n\u001b[0;32m    531\u001b[0m     \u001b[39mraise\u001b[39;00m error\u001b[39m.\u001b[39mTimeout(\u001b[39m\"\u001b[39m\u001b[39mRequest timed out: \u001b[39m\u001b[39m{}\u001b[39;00m\u001b[39m\"\u001b[39m\u001b[39m.\u001b[39mformat(e)) \u001b[39mfrom\u001b[39;00m \u001b[39me\u001b[39;00m\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\site-packages\\requests\\sessions.py:587\u001b[0m, in \u001b[0;36mSession.request\u001b[1;34m(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)\u001b[0m\n\u001b[0;32m    582\u001b[0m send_kwargs \u001b[39m=\u001b[39m {\n\u001b[0;32m    583\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39mtimeout\u001b[39m\u001b[39m\"\u001b[39m: timeout,\n\u001b[0;32m    584\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39mallow_redirects\u001b[39m\u001b[39m\"\u001b[39m: allow_redirects,\n\u001b[0;32m    585\u001b[0m }\n\u001b[0;32m    586\u001b[0m send_kwargs\u001b[39m.\u001b[39mupdate(settings)\n\u001b[1;32m--> 587\u001b[0m resp \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49msend(prep, \u001b[39m*\u001b[39;49m\u001b[39m*\u001b[39;49msend_kwargs)\n\u001b[0;32m    589\u001b[0m \u001b[39mreturn\u001b[39;00m resp\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\site-packages\\requests\\sessions.py:701\u001b[0m, in \u001b[0;36mSession.send\u001b[1;34m(self, request, **kwargs)\u001b[0m\n\u001b[0;32m    698\u001b[0m start \u001b[39m=\u001b[39m preferred_clock()\n\u001b[0;32m    700\u001b[0m \u001b[39m# Send the request\u001b[39;00m\n\u001b[1;32m--> 701\u001b[0m r \u001b[39m=\u001b[39m adapter\u001b[39m.\u001b[39;49msend(request, \u001b[39m*\u001b[39;49m\u001b[39m*\u001b[39;49mkwargs)\n\u001b[0;32m    703\u001b[0m \u001b[39m# Total elapsed time of the request (approximately)\u001b[39;00m\n\u001b[0;32m    704\u001b[0m elapsed \u001b[39m=\u001b[39m preferred_clock() \u001b[39m-\u001b[39m start\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\site-packages\\requests\\adapters.py:489\u001b[0m, in \u001b[0;36mHTTPAdapter.send\u001b[1;34m(self, request, stream, timeout, verify, cert, proxies)\u001b[0m\n\u001b[0;32m    487\u001b[0m \u001b[39mtry\u001b[39;00m:\n\u001b[0;32m    488\u001b[0m     \u001b[39mif\u001b[39;00m \u001b[39mnot\u001b[39;00m chunked:\n\u001b[1;32m--> 489\u001b[0m         resp \u001b[39m=\u001b[39m conn\u001b[39m.\u001b[39;49murlopen(\n\u001b[0;32m    490\u001b[0m             method\u001b[39m=\u001b[39;49mrequest\u001b[39m.\u001b[39;49mmethod,\n\u001b[0;32m    491\u001b[0m             url\u001b[39m=\u001b[39;49murl,\n\u001b[0;32m    492\u001b[0m             body\u001b[39m=\u001b[39;49mrequest\u001b[39m.\u001b[39;49mbody,\n\u001b[0;32m    493\u001b[0m             headers\u001b[39m=\u001b[39;49mrequest\u001b[39m.\u001b[39;49mheaders,\n\u001b[0;32m    494\u001b[0m             redirect\u001b[39m=\u001b[39;49m\u001b[39mFalse\u001b[39;49;00m,\n\u001b[0;32m    495\u001b[0m             assert_same_host\u001b[39m=\u001b[39;49m\u001b[39mFalse\u001b[39;49;00m,\n\u001b[0;32m    496\u001b[0m             preload_content\u001b[39m=\u001b[39;49m\u001b[39mFalse\u001b[39;49;00m,\n\u001b[0;32m    497\u001b[0m             decode_content\u001b[39m=\u001b[39;49m\u001b[39mFalse\u001b[39;49;00m,\n\u001b[0;32m    498\u001b[0m             retries\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mmax_retries,\n\u001b[0;32m    499\u001b[0m             timeout\u001b[39m=\u001b[39;49mtimeout,\n\u001b[0;32m    500\u001b[0m         )\n\u001b[0;32m    502\u001b[0m     \u001b[39m# Send the request.\u001b[39;00m\n\u001b[0;32m    503\u001b[0m     \u001b[39melse\u001b[39;00m:\n\u001b[0;32m    504\u001b[0m         \u001b[39mif\u001b[39;00m \u001b[39mhasattr\u001b[39m(conn, \u001b[39m\"\u001b[39m\u001b[39mproxy_pool\u001b[39m\u001b[39m\"\u001b[39m):\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\site-packages\\urllib3\\connectionpool.py:703\u001b[0m, in \u001b[0;36mHTTPConnectionPool.urlopen\u001b[1;34m(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, chunked, body_pos, **response_kw)\u001b[0m\n\u001b[0;32m    700\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_prepare_proxy(conn)\n\u001b[0;32m    702\u001b[0m \u001b[39m# Make the request on the httplib connection object.\u001b[39;00m\n\u001b[1;32m--> 703\u001b[0m httplib_response \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_make_request(\n\u001b[0;32m    704\u001b[0m     conn,\n\u001b[0;32m    705\u001b[0m     method,\n\u001b[0;32m    706\u001b[0m     url,\n\u001b[0;32m    707\u001b[0m     timeout\u001b[39m=\u001b[39;49mtimeout_obj,\n\u001b[0;32m    708\u001b[0m     body\u001b[39m=\u001b[39;49mbody,\n\u001b[0;32m    709\u001b[0m     headers\u001b[39m=\u001b[39;49mheaders,\n\u001b[0;32m    710\u001b[0m     chunked\u001b[39m=\u001b[39;49mchunked,\n\u001b[0;32m    711\u001b[0m )\n\u001b[0;32m    713\u001b[0m \u001b[39m# If we're going to release the connection in ``finally:``, then\u001b[39;00m\n\u001b[0;32m    714\u001b[0m \u001b[39m# the response doesn't need to know about the connection. Otherwise\u001b[39;00m\n\u001b[0;32m    715\u001b[0m \u001b[39m# it will also try to release it and we'll have a double-release\u001b[39;00m\n\u001b[0;32m    716\u001b[0m \u001b[39m# mess.\u001b[39;00m\n\u001b[0;32m    717\u001b[0m response_conn \u001b[39m=\u001b[39m conn \u001b[39mif\u001b[39;00m \u001b[39mnot\u001b[39;00m release_conn \u001b[39melse\u001b[39;00m \u001b[39mNone\u001b[39;00m\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\site-packages\\urllib3\\connectionpool.py:449\u001b[0m, in \u001b[0;36mHTTPConnectionPool._make_request\u001b[1;34m(self, conn, method, url, timeout, chunked, **httplib_request_kw)\u001b[0m\n\u001b[0;32m    444\u001b[0m             httplib_response \u001b[39m=\u001b[39m conn\u001b[39m.\u001b[39mgetresponse()\n\u001b[0;32m    445\u001b[0m         \u001b[39mexcept\u001b[39;00m \u001b[39mBaseException\u001b[39;00m \u001b[39mas\u001b[39;00m e:\n\u001b[0;32m    446\u001b[0m             \u001b[39m# Remove the TypeError from the exception chain in\u001b[39;00m\n\u001b[0;32m    447\u001b[0m             \u001b[39m# Python 3 (including for exceptions like SystemExit).\u001b[39;00m\n\u001b[0;32m    448\u001b[0m             \u001b[39m# Otherwise it looks like a bug in the code.\u001b[39;00m\n\u001b[1;32m--> 449\u001b[0m             six\u001b[39m.\u001b[39;49mraise_from(e, \u001b[39mNone\u001b[39;49;00m)\n\u001b[0;32m    450\u001b[0m \u001b[39mexcept\u001b[39;00m (SocketTimeout, BaseSSLError, SocketError) \u001b[39mas\u001b[39;00m e:\n\u001b[0;32m    451\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_raise_timeout(err\u001b[39m=\u001b[39me, url\u001b[39m=\u001b[39murl, timeout_value\u001b[39m=\u001b[39mread_timeout)\n",
            "File \u001b[1;32m<string>:3\u001b[0m, in \u001b[0;36mraise_from\u001b[1;34m(value, from_value)\u001b[0m\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\site-packages\\urllib3\\connectionpool.py:444\u001b[0m, in \u001b[0;36mHTTPConnectionPool._make_request\u001b[1;34m(self, conn, method, url, timeout, chunked, **httplib_request_kw)\u001b[0m\n\u001b[0;32m    441\u001b[0m \u001b[39mexcept\u001b[39;00m \u001b[39mTypeError\u001b[39;00m:\n\u001b[0;32m    442\u001b[0m     \u001b[39m# Python 3\u001b[39;00m\n\u001b[0;32m    443\u001b[0m     \u001b[39mtry\u001b[39;00m:\n\u001b[1;32m--> 444\u001b[0m         httplib_response \u001b[39m=\u001b[39m conn\u001b[39m.\u001b[39;49mgetresponse()\n\u001b[0;32m    445\u001b[0m     \u001b[39mexcept\u001b[39;00m \u001b[39mBaseException\u001b[39;00m \u001b[39mas\u001b[39;00m e:\n\u001b[0;32m    446\u001b[0m         \u001b[39m# Remove the TypeError from the exception chain in\u001b[39;00m\n\u001b[0;32m    447\u001b[0m         \u001b[39m# Python 3 (including for exceptions like SystemExit).\u001b[39;00m\n\u001b[0;32m    448\u001b[0m         \u001b[39m# Otherwise it looks like a bug in the code.\u001b[39;00m\n\u001b[0;32m    449\u001b[0m         six\u001b[39m.\u001b[39mraise_from(e, \u001b[39mNone\u001b[39;00m)\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\http\\client.py:1374\u001b[0m, in \u001b[0;36mHTTPConnection.getresponse\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m   1372\u001b[0m \u001b[39mtry\u001b[39;00m:\n\u001b[0;32m   1373\u001b[0m     \u001b[39mtry\u001b[39;00m:\n\u001b[1;32m-> 1374\u001b[0m         response\u001b[39m.\u001b[39;49mbegin()\n\u001b[0;32m   1375\u001b[0m     \u001b[39mexcept\u001b[39;00m \u001b[39mConnectionError\u001b[39;00m:\n\u001b[0;32m   1376\u001b[0m         \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mclose()\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\http\\client.py:318\u001b[0m, in \u001b[0;36mHTTPResponse.begin\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    316\u001b[0m \u001b[39m# read until we get a non-100 response\u001b[39;00m\n\u001b[0;32m    317\u001b[0m \u001b[39mwhile\u001b[39;00m \u001b[39mTrue\u001b[39;00m:\n\u001b[1;32m--> 318\u001b[0m     version, status, reason \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_read_status()\n\u001b[0;32m    319\u001b[0m     \u001b[39mif\u001b[39;00m status \u001b[39m!=\u001b[39m CONTINUE:\n\u001b[0;32m    320\u001b[0m         \u001b[39mbreak\u001b[39;00m\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\http\\client.py:279\u001b[0m, in \u001b[0;36mHTTPResponse._read_status\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    278\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39m_read_status\u001b[39m(\u001b[39mself\u001b[39m):\n\u001b[1;32m--> 279\u001b[0m     line \u001b[39m=\u001b[39m \u001b[39mstr\u001b[39m(\u001b[39mself\u001b[39m\u001b[39m.\u001b[39mfp\u001b[39m.\u001b[39mreadline(_MAXLINE \u001b[39m+\u001b[39m \u001b[39m1\u001b[39m), \u001b[39m\"\u001b[39m\u001b[39miso-8859-1\u001b[39m\u001b[39m\"\u001b[39m)\n\u001b[0;32m    280\u001b[0m     \u001b[39mif\u001b[39;00m \u001b[39mlen\u001b[39m(line) \u001b[39m>\u001b[39m _MAXLINE:\n\u001b[0;32m    281\u001b[0m         \u001b[39mraise\u001b[39;00m LineTooLong(\u001b[39m\"\u001b[39m\u001b[39mstatus line\u001b[39m\u001b[39m\"\u001b[39m)\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\socket.py:706\u001b[0m, in \u001b[0;36mSocketIO.readinto\u001b[1;34m(self, b)\u001b[0m\n\u001b[0;32m    704\u001b[0m \u001b[39mwhile\u001b[39;00m \u001b[39mTrue\u001b[39;00m:\n\u001b[0;32m    705\u001b[0m     \u001b[39mtry\u001b[39;00m:\n\u001b[1;32m--> 706\u001b[0m         \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_sock\u001b[39m.\u001b[39;49mrecv_into(b)\n\u001b[0;32m    707\u001b[0m     \u001b[39mexcept\u001b[39;00m timeout:\n\u001b[0;32m    708\u001b[0m         \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_timeout_occurred \u001b[39m=\u001b[39m \u001b[39mTrue\u001b[39;00m\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\ssl.py:1278\u001b[0m, in \u001b[0;36mSSLSocket.recv_into\u001b[1;34m(self, buffer, nbytes, flags)\u001b[0m\n\u001b[0;32m   1274\u001b[0m     \u001b[39mif\u001b[39;00m flags \u001b[39m!=\u001b[39m \u001b[39m0\u001b[39m:\n\u001b[0;32m   1275\u001b[0m         \u001b[39mraise\u001b[39;00m \u001b[39mValueError\u001b[39;00m(\n\u001b[0;32m   1276\u001b[0m           \u001b[39m\"\u001b[39m\u001b[39mnon-zero flags not allowed in calls to recv_into() on \u001b[39m\u001b[39m%s\u001b[39;00m\u001b[39m\"\u001b[39m \u001b[39m%\u001b[39m\n\u001b[0;32m   1277\u001b[0m           \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m\u001b[39m__class__\u001b[39m)\n\u001b[1;32m-> 1278\u001b[0m     \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mread(nbytes, buffer)\n\u001b[0;32m   1279\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[0;32m   1280\u001b[0m     \u001b[39mreturn\u001b[39;00m \u001b[39msuper\u001b[39m()\u001b[39m.\u001b[39mrecv_into(buffer, nbytes, flags)\n",
            "File \u001b[1;32mc:\\Python311\\Lib\\ssl.py:1134\u001b[0m, in \u001b[0;36mSSLSocket.read\u001b[1;34m(self, len, buffer)\u001b[0m\n\u001b[0;32m   1132\u001b[0m \u001b[39mtry\u001b[39;00m:\n\u001b[0;32m   1133\u001b[0m     \u001b[39mif\u001b[39;00m buffer \u001b[39mis\u001b[39;00m \u001b[39mnot\u001b[39;00m \u001b[39mNone\u001b[39;00m:\n\u001b[1;32m-> 1134\u001b[0m         \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_sslobj\u001b[39m.\u001b[39;49mread(\u001b[39mlen\u001b[39;49m, buffer)\n\u001b[0;32m   1135\u001b[0m     \u001b[39melse\u001b[39;00m:\n\u001b[0;32m   1136\u001b[0m         \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_sslobj\u001b[39m.\u001b[39mread(\u001b[39mlen\u001b[39m)\n",
            "\u001b[1;31mKeyboardInterrupt\u001b[0m: "
          ]
        }
      ],
      "source": [
        "'''\n",
        "# This code will download the RSS feed and process new entries every 60 seconds. \n",
        "Adjust the interval parameter in monitor_feed() to control how often the feed is checked.\n",
        "'''\n",
        "if __name__ == \"__main__\":\n",
        "    url = \"https://cointelegraph.com/rss/tag/ethereum\"\n",
        "    conn, cursor = create_db()\n",
        "    monitor_feed(url, conn, cursor)\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>published</th>\n",
              "      <th>title</th>\n",
              "      <th>summary</th>\n",
              "      <th>sentiment</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Tue, 09 May 2023 16:56:59 +0100</td>\n",
              "      <td>PayPal’s crypto holdings increased by 56% in Q...</td>\n",
              "      <td>Fintechs hold $861m in BTC and ETH, up 56% sin...</td>\n",
              "      <td>0.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Tue, 09 May 2023 14:30:00 +0100</td>\n",
              "      <td>$3.4B of Bitcoin in a popcorn tin: The Silk Ro...</td>\n",
              "      <td>Hacker stole billions, spent a decade living h...</td>\n",
              "      <td>-0.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Tue, 09 May 2023 01:50:14 +0100</td>\n",
              "      <td>Worth it? Trader spends $120K on gas buying $1...</td>\n",
              "      <td>User spent 76% of purchase price on gas fees f...</td>\n",
              "      <td>-0.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Mon, 08 May 2023 17:00:00 +0100</td>\n",
              "      <td>Aave v3 launches on Ethereum layer-2 network M...</td>\n",
              "      <td>Aave, a liquidity protocol, deploys on Metis, ...</td>\n",
              "      <td>0.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Mon, 08 May 2023 14:30:00 +0100</td>\n",
              "      <td>‘Ethical’ SBF game axed, Web3 games sign-up pr...</td>\n",
              "      <td>FTX kills Storybook Brawl, Animoca gets MMA ga...</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                         published   \n",
              "0  Tue, 09 May 2023 16:56:59 +0100  \\\n",
              "1  Tue, 09 May 2023 14:30:00 +0100   \n",
              "2  Tue, 09 May 2023 01:50:14 +0100   \n",
              "3  Mon, 08 May 2023 17:00:00 +0100   \n",
              "4  Mon, 08 May 2023 14:30:00 +0100   \n",
              "\n",
              "                                               title   \n",
              "0  PayPal’s crypto holdings increased by 56% in Q...  \\\n",
              "1  $3.4B of Bitcoin in a popcorn tin: The Silk Ro...   \n",
              "2  Worth it? Trader spends $120K on gas buying $1...   \n",
              "3  Aave v3 launches on Ethereum layer-2 network M...   \n",
              "4  ‘Ethical’ SBF game axed, Web3 games sign-up pr...   \n",
              "\n",
              "                                             summary  sentiment  \n",
              "0  Fintechs hold $861m in BTC and ETH, up 56% sin...        0.7  \n",
              "1  Hacker stole billions, spent a decade living h...       -0.5  \n",
              "2  User spent 76% of purchase price on gas fees f...       -0.4  \n",
              "3  Aave, a liquidity protocol, deploys on Metis, ...        0.8  \n",
              "4  FTX kills Storybook Brawl, Animoca gets MMA ga...        0.0  "
            ]
          },
          "execution_count": 1,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "import sqlite3\n",
        "import pandas as pd\n",
        "from datetime import datetime\n",
        "\n",
        "# create a connection\n",
        "con = sqlite3.connect('eth_ct_rss.db')\n",
        "data = pd.read_sql_query('Select * from news WHERE sentiment IS NOT NULL;', con)\n",
        "\n",
        "data['sentiment'] = data['sentiment'].astype(float)\n",
        "# parse_format = \"%a, %d %b %Y %H:%M:%S %z\"\n",
        "# format_output = \"%m-%d %H:%M\" # %Y-%m-%d %H:%M:%S\n",
        "# data['published'] = data['published'].apply(lambda x: datetime.strptime(x, parse_format).strftime(format_output))\n",
        "\n",
        "data.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjcAAAGaCAYAAADzQmIDAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/bCgiHAAAACXBIWXMAAA9hAAAPYQGoP6dpAABLqUlEQVR4nO3dd1xV9f8H8Ne9F7goeAEFWSKi4p6hIo5cJK7Sb5Yjd47KtIzMNFNTy9k3LbVQc5Ymampp5ogcP0dqmHvkXgxxcC9Dxr338/vjfr15Ay6g3HV4PXvcR3DO55z7fuPl3hdnyoQQAkREREQSIbd1AUREREQlieGGiIiIJIXhhoiIiCSF4YaIiIgkheGGiIiIJIXhhoiIiCSF4YaIiIgkheGGiIiIJIXhhoiIiCSF4YaI8pDJZPjkk08KHffJJ59AJpOZTKtSpQoGDx5smcLsxPXr1yGTybBy5Upbl0JE+WC4IXJQK1euhEwmg6urK+7cuZNnftu2bVGvXj0bVFaycnJy8OWXX6Jx48ZQqVTw9PRE3bp1MWLECFy4cMGiz7127VrMnz/fos9hSdu3by9SSCWSGidbF0BEzyY7OxuzZs3CggULSmydjx49gpPT0709XLx4EXJ5yf3d1LNnT/z666/o27cvhg8fjtzcXFy4cAHbtm1DixYtUKtWrRJ7rn9bu3Ytzpw5gzFjxphMDw4OxqNHj+Ds7Gyx5y4J27dvx6JFixhwqNRhuCFycI0aNcLSpUsxYcIEBAQElMg6XV1dn3pZpVJZIjUAwLFjx7Bt2zZ89tln+Oijj0zmLVy4EKmpqSX2XMXxeIsZEdkn7pYicnAfffQRdDodZs2aZXZcvXr10K5duzzT9Xo9AgMD8corrxin5XfMzYEDB9C0aVO4urqiWrVqWLx4cb7P8+9jbh48eICxY8eifv36cHd3h0qlQufOnXHy5MlCe7ty5QoAoGXLlnnmKRQKVKhQwWTanTt38Prrr8PX1xdKpRJ169bF8uXLTcbs3bsXMpkM69evx2effYZKlSrB1dUVHTp0wOXLl43j2rZti19++QU3btyATCaDTCZDlSpVAOR/zM3gwYPh7u6Omzdvolu3bnB3d0dgYCAWLVoEADh9+jTat28PNzc3BAcHY+3atXl6Sk1NxZgxYxAUFASlUonq1atj9uzZ0Ov1xjGPn/vzzz/HkiVLUK1aNSiVSjRt2hTHjh0zqefxcz+u/9/HRxFJFbfcEDm4kJAQDBw4EEuXLsX48eML3HrTu3dvfPLJJ0hKSoKfn59x+oEDB5CQkIA+ffoU+BynT59Gx44d4ePjg08++QRarRZTpkyBr69vofVdvXoVW7ZswauvvoqQkBAkJydj8eLFaNOmDc6dO2d2a1NwcDAAYM2aNWjZsqXZXWXJyclo3rw5ZDIZRo0aBR8fH/z6668YOnQoNBpNnl1Ls2bNglwux9ixY6FWqzFnzhz069cPR44cAQBMnDgRarUat2/fxrx58wAA7u7uZnvV6XTo3Lkznn/+ecyZMwdr1qzBqFGj4ObmhokTJ6Jfv354+eWXERMTg4EDByIiIgIhISEAgMzMTLRp0wZ37tzBG2+8gcqVK+PQoUOYMGECEhMT8xz7s3btWqSlpeGNN96ATCbDnDlz8PLLL+Pq1atwdnbGG2+8gYSEBOzevRvfffed2bqJJEcQkUNasWKFACCOHTsmrly5IpycnMQ777xjnN+mTRtRt25d4/cXL14UAMSCBQtM1jNy5Ejh7u4uMjMzjdMAiClTphi/79Gjh3B1dRU3btwwTjt37pxQKBTi328jwcHBYtCgQcbvs7KyhE6nMxlz7do1oVQqxbRp08z2qNfrRZs2bQQA4evrK/r27SsWLVpkUsdjQ4cOFf7+/uLevXsm0/v06SM8PDyM/e3Zs0cAELVr1xbZ2dnGcV9++aUAIE6fPm2c1rVrVxEcHJznua5duyYAiBUrVhinDRo0SAAQM2bMME57+PChKFOmjJDJZGLdunXG6RcuXMjzM54+fbpwc3MTf//9t8lzjR8/XigUCnHz5k2T565QoYJ48OCBcdxPP/0kAIitW7cap7399tt5/n2ISgPuliKSgKpVq2LAgAFYsmQJEhMT8x1To0YNNGrUCLGxscZpOp0OGzduxIsvvogyZcrku5xOp8POnTvRo0cPVK5c2Ti9du3aiIqKKrQ2pVJpPMBYp9Ph/v37cHd3R82aNXH8+HGzy8pkMuzcuROffvopvLy88MMPP+Dtt99GcHAwevfubTzmRgiBH3/8ES+++CKEELh3757xERUVBbVanee5hgwZAhcXF+P3rVu3BmDY0vQshg0bZvza09MTNWvWhJubG3r16mWcXrNmTXh6epo814YNG9C6dWt4eXmZ1B8ZGQmdTof9+/ebPE/v3r3h5eVV4vUTSQHDDZFEfPzxx9BqtWaPvenduzcOHjxoPHV87969uHv3Lnr37l3gMikpKXj06BFCQ0PzzKtZs2ahden1esybNw+hoaFQKpXw9vaGj48PTp06BbVaXejySqUSEydOxPnz55GQkIAffvgBzZs3x/r16zFq1ChjjampqViyZAl8fHxMHkOGDAEA3L1712S9TwY1AMag8PDhw0JrKoirqyt8fHxMpnl4eKBSpUp5jnfx8PAwea5Lly5hx44deeqPjIy0Wv1EUsFjbogkomrVqujfvz+WLFmC8ePH5zumd+/emDBhAjZs2IAxY8Zg/fr18PDwQKdOnSxW14wZMzBp0iS8/vrrmD59OsqXLw+5XI4xY8aYHChbFP7+/ujTpw969uyJunXrYv369Vi5cqVxPf3798egQYPyXbZBgwYm3ysUinzHCSGKVVNR1lmU59Lr9XjhhRcwbty4fMfWqFGj2OskKq0Ybogk5OOPP8b333+P2bNn5zs/JCQEzZo1Q2xsLEaNGoVNmzahR48eZk/f9vHxQZkyZXDp0qU88y5evFhoTRs3bkS7du2wbNkyk+mpqanw9vYudPn8ODs7o0GDBrh06RLu3bsHHx8flCtXDjqdzriloyRY8+yiatWqIT093WHrJ7In3C1FJCHVqlVD//79sXjxYiQlJeU7pnfv3vjjjz+wfPly3Lt3z+wuKcCwhSAqKgpbtmzBzZs3jdPPnz+PnTt3FlqTQqHIszVhw4YN+V5V+d8uXbpk8pyPpaam4vDhw/Dy8oKPjw8UCgV69uyJH3/8EWfOnMkzPiUlpdDnyo+bm1uRdp2VhF69euHw4cP5/kxTU1Oh1WqLvU43Nzfj8kSlCbfcEEnMxIkT8d133+HixYuoW7dunvm9evXC2LFjMXbsWJQvX75IWwqmTp2KHTt2oHXr1hg5ciS0Wi0WLFiAunXr4tSpU2aX7datG6ZNm4YhQ4agRYsWOH36NNasWYOqVasW+rwnT57Ea6+9hs6dO6N169YoX7487ty5g1WrViEhIQHz58837p6ZNWsW9uzZg/DwcAwfPhx16tTBgwcPcPz4cfz222948OBBoc/3b2FhYYiNjUV0dDSaNm0Kd3d3vPjii8VeT1F88MEH+Pnnn9GtWzcMHjwYYWFhyMjIwOnTp7Fx40Zcv3692Fu6wsLCAADvvPMOoqKioFAozJ7yTyQVDDdEElO9enX0798fq1atynd+pUqV0KJFCxw8eBDDhg0r0i0EGjRogJ07dyI6OhqTJ09GpUqVMHXqVCQmJhYabj766CNkZGRg7dq1iI2NxXPPPYdffvmlwOOCnvT8889j+vTp+PXXX/HFF18gJSUF5cqVQ+PGjTF79mz07NnTONbX1xdHjx7FtGnTsGnTJnz99deoUKEC6tatW+BuusKMHDkSJ06cwIoVKzBv3jwEBwdbLNyULVsW+/btw4wZM7BhwwasXr0aKpUKNWrUwNSpU+Hh4VHsdb788ssYPXo01q1bh++//x5CCIYbKhVkgkefERERkYTwmBsiIiKSFIYbIiIikhSGGyIiIpIUhhsiIiKSFIYbIiIikhSGGyIiIpKUUnmdG71ej4SEBJQrV46XJyciInIQQgikpaUhICAAcnnB22dKZbhJSEhAUFCQrcsgIiKip3Dr1i1UqlSpwPmlMtyUK1cOgOGHo1KpbFwNERERFYVGo0FQUJDxc7wgpTLcPN4VpVKpGG6IiIgcTGGHlPCAYiIiIpIUhhsiIiKSFIYbIiIikhSGGyIiIpIUhhsiIiKSFIYbIiIikpRSeSo4ERE5lnuZ93Dm7hm4KFwQ5h8GpZPS1iWRHWO4ISIiu3U/8z7G7ByDdWfWQavXAgC8XL0wtsVYjG81HnIZd0BQXgw3RERklzTZGrRa0QqX7l+CTuiM0x9mPcTE3yfihvoGFndbbMMKyV4x8hIRkV1acGQB/r7/t0mwedKS+CWIT4i3clXkCBhuiIjILi2OXwy90Bc430nuhGV/LbNiReQoGG6IiMgu3Um7Y3a+Vq/F9dTr1imGHArDDRER2SVPV0+z853kTvBx87FOMeRQGG6IiMguDWwwEAqZosD5Wr0W/ev3t2JF5CgYboiIyC5FR0TDw9Uj34CjkCnQtkpbdKjawQaVkb1juCEiIrsU5BGE/YP3o5Z3LQCAXCaH7H//9azdE1v7buV1bihfVnlVLFq0CFWqVIGrqyvCw8Nx9OjRAse2bdsWMpksz6Nr167GMYMHD84zv1OnTtZohYiIrKhuxbo4/dZpHBhyAPOi5uHrrl/j6rtXEftqLNxd3G1dHtkpi1/ELzY2FtHR0YiJiUF4eDjmz5+PqKgoXLx4ERUrVswzftOmTcjJyTF+f//+fTRs2BCvvvqqybhOnTphxYoVxu+VSl6Km4hIimQyGVpWbomWlVvauhRyEBbfcvPFF19g+PDhGDJkCOrUqYOYmBiULVsWy5cvz3d8+fLl4efnZ3zs3r0bZcuWzRNulEqlyTgvLy9Lt0JEREQOwKLhJicnB/Hx8YiMjPznCeVyREZG4vDhw0Vax7Jly9CnTx+4ubmZTN+7dy8qVqyImjVr4q233sL9+/cLXEd2djY0Go3Jg4iIiKTJouHm3r170Ol08PX1NZnu6+uLpKSkQpc/evQozpw5g2HDhplM79SpE1avXo24uDjMnj0b+/btQ+fOnaHT5X+J7pkzZ8LDw8P4CAoKevqmiIiIyK7Z9Y0zly1bhvr166NZs2Ym0/v06WP8un79+mjQoAGqVauGvXv3okOHvKcFTpgwAdHR0cbvNRoNAw4REZFEWXTLjbe3NxQKBZKTk02mJycnw8/Pz+yyGRkZWLduHYYOHVro81StWhXe3t64fPlyvvOVSiVUKpXJg4iIiKTJouHGxcUFYWFhiIuLM07T6/WIi4tDRESE2WU3bNiA7Oxs9O9f+NUnb9++jfv378Pf3/+ZayYiIiLHZvGzpaKjo7F06VKsWrUK58+fx1tvvYWMjAwMGTIEADBw4EBMmDAhz3LLli1Djx49UKFCBZPp6enp+OCDD/DHH3/g+vXriIuLQ/fu3VG9enVERUVZuh0iIrKy9WfXo/ai2ijzWRm4z3BH5OpInEk+Y+uy6F80WRq8ufVNlJ9dHq6fusLvcz9M/H0itHqt1Wux+DE3vXv3RkpKCiZPnoykpCQ0atQIO3bsMB5kfPPmTcjlphnr4sWLOHDgAHbt2pVnfQqFAqdOncKqVauQmpqKgIAAdOzYEdOnT+e1boiIJObFtS9i26VtJtPirsWhfkx9xHSNwRtN3rBRZfSkS/cvoUFMA2Rps4zTkjOSMeP/ZmBp/FJcHn0ZKlfrHRIiE0IIqz2bndBoNPDw8IBarebxN0REdmrWgVmYEJd3y/6Tboy5gcoela1UERWk4tyKSMlMKXB+mH8Y/hzx5zM/T1E/v3lTDiIiskv/PfTfQsdE74wudAxZ1s7LO80GGwCIT4xHUnrhl4ApKQw3RERkl+49ulfomEO3DlmhEjLnu1PfFWncujPrLFzJPxhuiIjIYemF3tYllHpF/TfQ6fO/0K4lMNwQEZFdUikLPybyOf/nrFAJmdOzds8ijXu59ssWruQfDDdERGSX3gx7s9Ax86LmWaESMqdnnZ6FBtFaFWohxCvEShUx3BARkZ2a2WEmwgPDC5w/te1U1PSuacWKqCC/DfgNTvL8ry7j5uyGPYP3WLUehhsiIrJLcrkcfwz7A7MjZ8PXzRdymRwKmQINfRtiV/9dmNxmsq1LpP9pGtgUV965gm6h3aBUKCGDDG7ObhjYYCASohPg527+lksljde54XVuiIiIHAKvc0NERESlEsMNERERSQrDDREREUkKww0RERFJCsMNERERSQrDDREREUlK/lfcISIisiOX7l/C8cTjcFG4oG2VtvAq42Xrkigfubpc7LuxDykZKajsURktglpAJpNZvQ6GGyIisls31Tfx+k+vI+5anHGaUqHEiLAR+Lzj53BRuNiwOnrSqhOrMO63cbibcdc4rapXVXzT9Rt0rNbRqrVwtxQREdmllIwUtFjWAnuv7zWZnq3LxqJji9BnYx+UwuvQ2qVvj3+LwT8NNgk2AHDt4TV0WdMFcVfjCljSMhhuiIjILs3/Yz6S0pOgE7o88/RCj80XNuPgrYM2qIyelKXNwthdY/OdJyAghMB7O9+zahBluCEiIru07K9l+Qabx5zkTlh5YqX1CqJ8/fL3L1Bnqwucr4cep++expm7Z6xWE8MNERHZpZTMFLPztXotEtISrFQNFSQxPREyFH7QcGJ6ohWqMWC4ISIiu+RT1sfsfCe5EwLLBVqpGiqIv7s/BArf5eTv7m+FagwYboiIyC4NbTwUCpmiwPlavRaDGw22XkGUr641usJD6VHgfDnkaODbAPUq1rNaTQw3RERkl8Y0HwP/cv5wkuW9aolcJsfLtV9Gi6AWNqiMnuTq5Ir/dvxvvvNkkEEmk2Fe1DyrXu+G4YaIiOySj5sPDr5+EG1D2ppMVyqUGNVsFH7o+YNNLhBHeQ19bihWdl8JXzdfk+lVvapie7/taB/S3qr1yEQpvEiARqOBh4cH1Go1VCqVrcshIqJC8ArFjkGr12Lv9b0Wu0JxUT+/GW4YboiIiBxCUT+/uVuKiIiIJIXhhoiIiCSF4YaIiIgkheGGiIiIJIXhhoiIiCSF4YaIiIgkheGGiIiIJMUq4WbRokWoUqUKXF1dER4ejqNHjxY4duXKlZDJZCYPV1dXkzFCCEyePBn+/v4oU6YMIiMjcenSJUu3QURERA7A4uEmNjYW0dHRmDJlCo4fP46GDRsiKioKd+/eLXAZlUqFxMRE4+PGjRsm8+fMmYOvvvoKMTExOHLkCNzc3BAVFYWsrCxLt0NERER2zuLh5osvvsDw4cMxZMgQ1KlTBzExMShbtiyWL19e4DIymQx+fn7Gh6/vP/eqEEJg/vz5+Pjjj9G9e3c0aNAAq1evRkJCArZs2WLpdoiIiMjOWTTc5OTkID4+HpGRkf88oVyOyMhIHD58uMDl0tPTERwcjKCgIHTv3h1nz541zrt27RqSkpJM1unh4YHw8PAC15mdnQ2NRmPyICIiImmyaLi5d+8edDqdyZYXAPD19UVSUlK+y9SsWRPLly/HTz/9hO+//x56vR4tWrTA7du3AcC4XHHWOXPmTHh4eBgfQUFBz9oaERER2Sm7O1sqIiICAwcORKNGjdCmTRts2rQJPj4+WLx48VOvc8KECVCr1cbHrVu3SrBiIiIisicWDTfe3t5QKBRITk42mZ6cnAw/P78ircPZ2RmNGzfG5cuXAcC4XHHWqVQqoVKpTB5EREQkTRYNNy4uLggLC0NcXJxxml6vR1xcHCIiIoq0Dp1Oh9OnT8Pf3x8AEBISAj8/P5N1ajQaHDlypMjrJCIiIulysvQTREdHY9CgQWjSpAmaNWuG+fPnIyMjA0OGDAEADBw4EIGBgZg5cyYAYNq0aWjevDmqV6+O1NRUzJ07Fzdu3MCwYcMAGM6kGjNmDD799FOEhoYiJCQEkyZNQkBAAHr06GHpdoiIiMjOWTzc9O7dGykpKZg8eTKSkpLQqFEj7Nixw3hA8M2bNyGX/7MB6eHDhxg+fDiSkpLg5eWFsLAwHDp0CHXq1DGOGTduHDIyMjBixAikpqaiVatW2LFjR56L/REREVHpIxNCCFsXYW0ajQYeHh5Qq9U8/oaIiMhBFPXz2+7OliIiIiJ6Fgw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpVgk3ixYtQpUqVeDq6orw8HAcPXq0wLFLly5F69at4eXlBS8vL0RGRuYZP3jwYMhkMpNHp06dLN0GEREROQCLh5vY2FhER0djypQpOH78OBo2bIioqCjcvXs33/F79+5F3759sWfPHhw+fBhBQUHo2LEj7ty5YzKuU6dOSExMND5++OEHS7dCREREDkAmhBCWfILw8HA0bdoUCxcuBADo9XoEBQVh9OjRGD9+fKHL63Q6eHl5YeHChRg4cCAAw5ab1NRUbNmy5alq0mg08PDwgFqthkqleqp1EBERkXUV9fPboltucnJyEB8fj8jIyH+eUC5HZGQkDh8+XKR1ZGZmIjc3F+XLlzeZvnfvXlSsWBE1a9bEW2+9hfv37xe4juzsbGg0GpMHERERSZNFw829e/eg0+ng6+trMt3X1xdJSUlFWseHH36IgIAAk4DUqVMnrF69GnFxcZg9ezb27duHzp07Q6fT5buOmTNnwsPDw/gICgp6+qaIiIjIrjnZugBzZs2ahXXr1mHv3r1wdXU1Tu/Tp4/x6/r166NBgwaoVq0a9u7diw4dOuRZz4QJExAdHW38XqPRMOAQERFJlEW33Hh7e0OhUCA5OdlkenJyMvz8/Mwu+/nnn2PWrFnYtWsXGjRoYHZs1apV4e3tjcuXL+c7X6lUQqVSmTyIiIhImiy65cbFxQVhYWGIi4tDjx49ABgOKI6Li8OoUaMKXG7OnDn47LPPsHPnTjRp0qTQ57l9+zbu378Pf3//kirdbmn1Wvzy9y84euconORO6FS9E5pXag6ZTGbr0shKMnIysP7sely8fxEeSg+8UucVhFYItXVZRES4rbmN2DOxSMlMQWWPyuhTrw/Klylf+IIlzOJnS8XGxmLQoEFYvHgxmjVrhvnz52P9+vW4cOECfH19MXDgQAQGBmLmzJkAgNmzZ2Py5MlYu3YtWrZsaVyPu7s73N3dkZ6ejqlTp6Jnz57w8/PDlStXMG7cOKSlpeH06dNQKpWF1uSoZ0sdu3MM/4n9D+6k3YGz3BkCAlq9Fs0Cm2FL7y3wLyf9cFfaxZ6JxbCtw5CRkwEnuRP0Qg+d0OG1eq9hWfdlcHVyLXwlREQlTKfX4YPdH+DLI18CABQyBbR6LZwVzpgdORtjmo8pkecp6ue3xY+56d27N1JSUjB58mQkJSWhUaNG2LFjh/Eg45s3b0Iu/2fv2DfffIOcnBy88sorJuuZMmUKPvnkEygUCpw6dQqrVq1CamoqAgIC0LFjR0yfPr1IwcZRXU+9jg6rOyAzNxMAkKvPNc47nnAcHVZ3wIk3T8BF4WKrEsnCdl/Zjb4/9gUACAiT18C6s+sAAGt6rrFJbURUuk3aMwnz/5gPAcP2Er3QAwBydDl4b+d78HT1xOBGg61Wj8W33NgjR9xy896O97Dw6EJohbbAMet6rkPver2tWBVZU4tlLXDkzhHjm0Z+Lo66iBoValixKiIq7R4+egi///ohR5dT4JggVRCuvXsNCrnimZ7LLq5zQyVn7em1ZoONXCY3/vVO0pOYlojDtw+bDTYKmQIbzm6wYlVERMC2v7eZDTYAcEtzC38m/GmlihhuHIYmx/yFB/VCj9RHqdYphqxOna0udIxcJocmmxeoJCLrUmerIUPhJ7VY8/2J4cZBhJYPNfvicZI7oZZ3LStWRNZUSVUJSoX5Y8q0ei3PmiIiq6tRoYbxWBtzqpevboVqDBhuHMRbTd4yO1+r12J42HArVUPW5u7ijtfqvwYnWcHnAJRxLoM+9foUOJ+IyBI6hHRAkCoIcln+kUIhU6BdlXYI8QqxWk0MNw5i6HND8Xzw83lePI+35rwf8T6e83/OFqWRlXzW/jP4l/PPE3DkMjlkkGFJtyVwd3G3UXVEVFop5Aqs7LESCpkCCpnpAcNOMie4u7jj665fW7UmhhsH4aJwwY7+O/Bhyw/h6eppnF7FswpiusZg7gtzbVccWYV/OX8cGXYEAxoOMDnlv2lAU2zvtx39GvSzYXVEVJq1D2mP/UP2o12VdsZpCpkCPWr1wNHhR61+2ARPBXeQU8GflK3NxvXU63BWOKOKZ5UCNwWSdKVlp+G25jZUShUCVYG2LoeIyCg5PRn3H92Hv7s/vMp4lei6i/r5zXDjgOGGiIioNOJ1boiIiKhUYrghIiIiSWG4ISIiIklhuCEiIiJJYbghIiIiSWG4IXJAOr0O9zPv41HuI1uXQkRkdxhuiByIOkuNCb9NgM9cH3jP9Yb7THd0X9cdR+8ctXVpRER2g9e54XVuyEE8fPQQrVa0wsV7F6ETOuN0hUwBmUyGn/r8hC6hXWxYIRGRZfE6N0QSM3nP5DzBBgB0QgedXod+m/ohS5tlo+qIiOwHww2RA8jMzcTyE8vzBJvHBARSs1Kx8dxGK1dGRGR/GG6IHMAt9S1k5maaHeMsd8aZu2esVBERkf1iuCFyAGWdyxY6Ri/0RRpHRCR1DDdEDqCSqhIa+DYwewd4ndChR60e1iuKiMhOMdwQOQCZTIYpbaZAL/T5zlfIFOhcvTMa+DawcmVERPaH4YbIQbxc+2Us6LwATnInyGVyOMmd4CR3AgC0rdIW615ZZ+MKiYjsA69zw+vckINJSk/CyhMr8ff9v6FSqtC7bm80r9QcMpnM1qUREVlUUT+/GW4YboiIiBwCL+JHREREpRLDDREREUkKww0RERFJCsMNERERSQrDDREREUkKww0RERFJipOtC5CKe/fu4eTJk0hPT4ebmxsaNmwIHx8fW5dVKgghcOXKFVy8eBFarRa+vr5o2LAhypQpY+vSyEJu3ryJ33//HWlpaVAqlQgPD0fDhg1tXRYVQXx8PPbt24eMjAzo9XrIZDLI5XJUr14dr7zyCpyc+LFEz84q17lZtGgR5s6di6SkJDRs2BALFixAs2bNChy/YcMGTJo0CdevX0doaChmz56NLl26GOcLITBlyhQsXboUqampaNmyJb755huEhoYWqZ6SvM6NEAI7duzA0aNHIZPJjBdS0+v1eO6559C1a1fI5dxAZilpaWlYs2YNkpOTjT9nvV4PJycn9OjRA3Xr1rVxhVSS9Ho9vvvuO1y/fj3PPHd3d7z99ttwdXW1fmFUKJ1Oh88//xxZWVlmxw0YMABVq1a1UlXkaOzmOjexsbGIjo7GlClTcPz4cTRs2BBRUVG4e/duvuMPHTqEvn37YujQofjrr7/Qo0cP9OjRA2fOnDGOmTNnDr766ivExMTgyJEjcHNzQ1RUVKG/NJawf/9+HD16FIAh6Oj1euj1hvv/HD9+HL///rvVayot9Ho9vv/+e6SkpBi/f/yz12q1+PHHH3Hr1i1blkglbMuWLfkGGwBIT0/HkiVLrFsQFdmCBQuK9B793XffQavVWqEikjKLb7kJDw9H06ZNsXDhQgCGD6CgoCCMHj0a48ePzzO+d+/eyMjIwLZt24zTmjdvjkaNGiEmJgZCCAQEBOD999/H2LFjAQBqtRq+vr5YuXIl+vTpU2hNj5NfQkJCvslPoVCY/PWXkZGR73pycnKwYMECPPkjzMnJMRnj5OSEd999F0qlEnK53GRXSWZmJgr68ctkMpQtW/apxj569Mj4IZ8fNze3pxqblZUFnU5XImPLli1r3MqVnZ1t9s2soLGXLl3Chg0bTMY6OTkZt+DodDpUrVoVr776ar7rLVOmjHFsTk4OcnNzC6zB1dUVCoWi2GNzc3PzvCaepFQqjZvhizNWq9UiOzu7wLEuLi5wdnYu9lidTmf2A8jZ2RkuLi7FHqvX6/Ho0aNnGqvVajF37lzIZDLjz0EIkeffYtCgQQgMDARgeD0olUrj2MzMzAJrKOrvfXHH/vv3vjhjpfIe8fDhQ3zzzTfGf2PA8HovqN66deuib9++z/wekZ/i/N7zPSLvWFu/RxR5z4uwoOzsbKFQKMTmzZtNpg8cOFC89NJL+S4TFBQk5s2bZzJt8uTJokGDBkIIIa5cuSIAiL/++stkzPPPPy/eeeedfNeZlZUl1Gq18XHr1i0BoMBHly5dTJYvW7ZsgWODg4PFJ598YnyYG9ukSROT9QYHBxc4tk6dOiZj69SpY7aGJzVp0qTAsd7e3iZj27RpU+DYsmXLmozt0qWL2Z/bk1555RWzY9PT041jBw0aZHbs3bt3jWNHjhxpduy7775r/Ldo0aKF2bFnzpwxrnfKlClmxx49etQ4ds6cOWbH7tmzxzh24cKFZsdu27bNOHbFihVmx65fv944dv369WbHrlixwjh227ZtZscuXLjQOHbPnj1mx86ZM8c49ujRo2bHTpkyxTj2zJkzZseOHTvWOPbatWtmxzZt2tT4b/zBBx+YHTto0CDjetPT082OfeWVV0xew+bGFuc9ok2bNiZjvb29Cxwr9feIJ98rzdULWO494tq1a8axY8eONTuW7xGGhz29R6jVagFAqNVqYY5Fd0vdu3cPOp0Ovr6+JtN9fX2RlJSU7zJJSUlmxz/+f3HWOXPmTHh4eBgfQUFBT9UPERER2T+L7pZKSEhAYGAgDh06hIiICOP0cePGYd++fThy5EieZVxcXLBq1Sr07dvXOO3rr7/G1KlTkZycjEOHDqFly5ZISEiAv7+/cUyvXr0gk8kQGxubZ53Z2dkmm9w0Gg2CgoKeebfUvXv3sHTpUuPmOiDvbikAGDp0KHx9fSW7yflpxpbEbqmDBw9i//79Jj+XJ3dLabVauLm5YdSoUfneMZubnPOOtfUmZ3NjU1JSsHTpUsjlcrO7pZ5//nm0atUKAHdLFTTW2u8Rf/75J3bt2lXk3VIqlQrjxo3jbinwPeLfY4u6W8qi59x5e3tDoVAgOTnZZHpycjL8/PzyXcbPz8/s+Mf/T05ONgk3ycnJaNSoUb7rVCqVxje4J7m5uZn8YhakoDFubm6oXr06bt68afwlffKXVyaTwd/fv8Aj/598sylMccYW5xTo4owtzlkoxRlb0L9PYWNbtGiBI0eOFPjG6+zsjNatW8Pd3b3Q9bq4uJj825XUWGdnZ5PwW1JjnZycinzKbHHGKhSKIv1OFHesXC5/5rFubm7w9vaGRqMxTpPJZHl+51544YV8z1CUyWRFruHx89l6rFTeI9q0aYN9+/aZhBlzr/UBAwaY/EHytO8RhbHU7z3fI4o/tjjvEUVaX4mtKR8uLi4ICwtDXFyccZper0dcXJzJlpwnRUREmIwHgN27dxvHh4SEwM/Pz2SMRqPBkSNHClynJb344otwdXXN82Yqk8mgVCrRvXt3q9dUWri7u6Nbt24AkGfLjEwmQ+XKlREeHm6L0shC+vTpk+9WuMc6d+7MSy/Yqa5duxZpXEBAAAICAixcDUmdxc+Wio2NxaBBg7B48WI0a9YM8+fPx/r163HhwgX4+vpi4MCBCAwMxMyZMwEYTgVv06YNZs2aha5du2LdunWYMWMGjh8/jnr16gEAZs+ejVmzZmHVqlUICQnBpEmTcOrUKZw7d65IWwxK8jo3gOFsrf/7v//DyZMnodVqoVAo0KBBA7Ru3RpeXl7PvH4y7+rVqzhw4ACuXbsGAChXrhyaNm2KiIgIXhBMgu7evYvNmzebHGOnUqnQqVMn1K5d24aVUWHOnTuHrVu3Frirol69eujZs6eVqyJHUtTPb6tcxG/hwoXGi/g1atQIX331lfEv6rZt26JKlSpYuXKlcfyGDRvw8ccfGy/iN2fOnHwv4rdkyRKkpqaiVatW+Prrr1GjRo0i1VPS4eYxnU6H7OxsKJVK4/5Usp7c3FxotVq4urqa/euepEGr1UKtVsPNzY0X7nMwjx49wv379+Hh4YGUlBR4eHigQoUKti6LHIBdhRt7Y6lwQ0RERJZjN1coJiIiIrImhhsiIiKSFIYbIiIikhSGGyIiIpIUhhsiIiKSFIYbIiIikhSGGyIiIpIUhhsiIiKSFIYbIiIikhSGGyIiIpIUhhsiIiKSFIYbIiIikhSGGyIiIpIUhhsiIiKSFIYbIiIikhSGGyIiIpIUhhsiIiKSFIYbIiIikhSGGyIiIpIUhhsiIiKSFIYbIiIikhSGGyIiIpIUhhsiIiKSFIYbIiKip/XoEbByJdCzJ9C1K/Dxx8CNG7auquTo9cDXXwO1agE+PkBoKPDFF4bpdkwmhBC2LsLaNBoNPDw8oFaroVKpbF0OERE5or//Bjp0AG7fBuRywwe+QgEIAXzzDTBihK0rfDaZmUDNmob+/s3Hx9C/p6dVSyrq5ze33BARERVXdjYQGQkkJhq+f7wlQ6czfP3GG8Dvv9uuvpLQpk3+wQYAUlKAiAjr1lMMDDdERETFtWkTcOuWIczkR6EA5s61bk0l6fZt4M8/zY+5cAE4e9Y69RQTww0REVFxbd9uCDAF0emAXbvs/tiUAi1bVrRxixdbto6nxHBDRERUXDk5hmNrzNHrC96yY++yskp2nJUx3BARERVX06bm58tkQJ06gLOzdeopad26lew4K2O4ISIiKq7Bgw3BRSbLf74QwLvvWrWkEtWyJVCxovkxHh7ASy9Zp55iYrghIiIqLm9vYM0awyngTk7/TJf/72O1Vy9g6FDb1FZSdu4s+LgiuRzYts269RQDww0REdHT6NkTOHLEEGTKljWEnEaNgBUrgB9+MH/AsSNo1Ag4f95wSvjj0CaXAy1aACdPAq1a2bQ8cywWbh48eIB+/fpBpVLB09MTQ4cORXp6utnxo0ePRs2aNVGmTBlUrlwZ77zzDtRqtck4mUyW57Fu3TpLtUFERFSwsDDDFpyMDCA3F4iPN+yykktk20FoKLB3r+HAaCEM/z94EKhXz9aVmeVU+JCn069fPyQmJmL37t3Izc3FkCFDMGLECKxduzbf8QkJCUhISMDnn3+OOnXq4MaNG3jzzTeRkJCAjRs3moxdsWIFOnXqZPze08pXSCQiIiL7ZZHbL5w/fx516tTBsWPH0KRJEwDAjh070KVLF9y+fRsBAQFFWs+GDRvQv39/ZGRkwOl/+zRlMhk2b96MHj16PHV9vP0CERGR47Hp7RcOHz4MT09PY7ABgMjISMjlchw5cqTI63lcvJOT6Qamt99+G97e3mjWrBmWL1+OwvJZdnY2NBqNyYOIiIikySK7pZKSklDxX6eQOTk5oXz58khKSirSOu7du4fp06djxL9uPDZt2jS0b98eZcuWxa5duzBy5Eikp6fjnXfeKXBdM2fOxNSpU4vfCBERETmcYm25GT9+fL4H9D75uHDhwjMXpdFo0LVrV9SpUweffPKJybxJkyahZcuWaNy4MT788EOMGzcOcwu5f8eECROgVquNj1u3bj1zjURERGSfirXl5v3338fgwYPNjqlatSr8/Pxw9+5dk+larRYPHjyAn5+f2eXT0tLQqVMnlCtXDps3b4ZzIVd3DA8Px/Tp05GdnQ2lUpnvGKVSWeA8IiIikpZihRsfHx/4+PgUOi4iIgKpqamIj49HWFgYAOD333+HXq9HeHh4gctpNBpERUVBqVTi559/hqura6HPdeLECXh5eTG8kH3KzjacGpqTYzh10tvb1hURERXfxYvAnTuAr6/hthIFXZnZTljkgOLatWujU6dOGD58OI4ePYqDBw9i1KhR6NOnj/FMqTt37qBWrVo4evQoAEOw6dixIzIyMrBs2TJoNBokJSUhKSkJuv/deGzr1q349ttvcebMGVy+fBnffPMNZsyYgdGjR1uiDaKnp9cDM2YA/v6Gy5i3a2f4esAA4P59W1dHRFQ0Bw4Y7qNVqxbQoYPhj7RGjYC4OFtXZp6wkPv374u+ffsKd3d3oVKpxJAhQ0RaWppx/rVr1wQAsWfPHiGEEHv27BEA8n1cu3ZNCCHEr7/+Kho1aiTc3d2Fm5ubaNiwoYiJiRE6na5YtanVagFAqNXqkmqXyNSIEUIYLnll+lAohKhVS4jUVFtXSERk3r59Qjg5CSGXm76PyeWGx6+/Wr2kon5+W+Q6N/aO17khi4qPB564DEIecjkwbRowcaL1aiIiKg4hDFtpLlwwbIn+N5kMqFwZuHrVqldjtul1bohKteXLTW+k9296PRATY716iIiK6/hx4Ny5/IMNYAg/N24A+/ZZt64iYrghKmnXrwNarfkxCQmGNwciInt040bJjrMyhhuikubjY37LDQB4eNj92QZEVIoV9cxOOz0DlOGGqKS99pr5LTcKheGuwURE9qplS6Cw+0B6eQEvvGCdeoqJ4YaopEVGGk79VijyzlMoAJUKeO8969dFRFRUCgUwZ475MTNmAHZ6jTmGG6KSJpcDP/8M9Oxp2PUkk/1zNkGtWsD//R8QFGTbGomICtOvH7BsmWE3OvDP+5i7O7BgAfDmm7arrRA8FZyngpMlXbsG7NxpuEJxWBjQogWPtSEix/LoEbBtm+EKxX5+wIsvAm5uNimlqJ/fDDcMN0RERA6B17khIiKiUonhhoiIiCSF4YaIiIgkheGGiIiIJIXhhoiIiCSF4YaIiIgkheGGiIjoad27B8yaBTRvDjRsCAwdCsTH27qqUq+Qu/sRERFRvv78E+jYEVCrAb3eMO3cOWD5cmD6dODjj21bXynGLTdERETFlZkJdO4MaDT/BBvgn5vmTppkuA0L2QTDDRERUXGtW2fYJaXT5T9foQA+/9y6NZERww0REVFxxcUZAkxBdDrgwIGCww9ZFMMNERFRcen1QGG3ZhSi8DFkEQw3RERExdWypfngIpcDYWGAE8/bsQWGGyIiouIaMABwczOEmPzo9UB0tHVrIiOGGyIiouLy8AB++glQKk2PvXn89ahRQN++tqmNGG6IiIieSvv2wJkzwLvvAlWqAH5+QKdOwPbtwFdfATKZrSsstWRClL6jnTQaDTw8PKBWq6FSqWxdDhERERVBUT+/ueWGiIiIJIXhhoiIiCSF4YaIiIgkheGGiIiIJIXhhoiIiCSF4YaIiIgkhdeFJrKkhw+BvXuBnBzgueeA0FBbV0REJU2tBvbsAbKzgYYNgVq1bF1RydLrDTcBvXMH8PUF2rQxf9NQO8BwQ2QJOTnA2LHAkiWGN7zHOnQAli8HKle2XW1EVDK0WuCjj4AFC4CsrH+mP/88sGIFULWq7WorKT//DIweDdy8+c+0gABg3jygVy/b1VUIi+2WevDgAfr16weVSgVPT08MHToU6enpZpdp27YtZDKZyePNN980GXPz5k107doVZcuWRcWKFfHBBx9Aq9Vaqg2i4hPCcNn1RYtMgw0A7NsHtGgB3L1rm9qIqOQMGQJ8/rlpsAGAQ4eAiAggIcE2dZWUrVuBHj2AW7dMpyckAL17Az/8YJOyisJi4aZfv344e/Ysdu/ejW3btmH//v0YMWJEocsNHz4ciYmJxsecOXOM83Q6Hbp27YqcnBwcOnQIq1atwsqVKzF58mRLtUFUfAcPAps2GTbl/ptWCyQlAV9+af26iKjkxMcD33+f/53BtVrg/n1D8HFUer3hthJAwXc/j4429GqHLBJuzp8/jx07duDbb79FeHg4WrVqhQULFmDdunVIKCTJli1bFn5+fsbHk5dX3rVrF86dO4fvv/8ejRo1QufOnTF9+nQsWrQIOTk5Ba4zOzsbGo3G5EFkMatWAU5m9vjqdMC331qvHiIqeUX5PV+2rOBgYO+OHAGuXTNff1ISEBdnvZqKwSLh5vDhw/D09ESTJk2M0yIjIyGXy3HkyBGzy65Zswbe3t6oV68eJkyYgMzMTJP11q9fH76+vsZpUVFR0Gg0OHv2bIHrnDlzJjw8PIyPoKCgZ+iOqBAJCYX/NZOS4rhvekQEJCYaAow5Go3h+DtHlJhYsuOszCIHFCclJaFixYqmT+TkhPLlyyMpKanA5V577TUEBwcjICAAp06dwocffoiLFy9i06ZNxvU+GWwAGL83t94JEyYgOjra+L1Go2HAIcsJCDD8RWcu4FSsyDsGEzkyf3/DGUPmfs9VKsDFxXo1lSR//6KNCwiwbB1PqVhbbsaPH5/ngN9/Py5cuPDUxYwYMQJRUVGoX78++vXrh9WrV2Pz5s24cuXKU68TAJRKJVQqlcmDyGIGDTL/hqdQAMOGWa8eIip5gwcX/ns+dKjj/hETHm4428tc/X5+QPv21qupGIoVbt5//32cP3/e7KNq1arw8/PD3X+dDaLVavHgwQP4+fkV+fnCw8MBAJcvXwYA+Pn5ITk52WTM4++Ls14ii2rZEnj5ZUCez6+Xk5PhDeHxgXpE5Jieew7o3z//D3+FAvD2NlwOwlHJ5f+c+FBQwJk3z/xxRzZUrHDj4+ODWrVqmX24uLggIiICqampiI+PNy77+++/Q6/XGwNLUZw4cQIA4P+/zWMRERE4ffq0SXDavXs3VCoV6tSpU5xWiCxHJjOcIjlqFKBUms5r2xY4fBjw8bFJaURUglasMAQYV1fT6a1aGU4Ht9NdNkXWrRuwZUve63IFBgKxsUCfPjYpqyhkQljmqMbOnTsjOTkZMTExyM3NxZAhQ9CkSROsXbsWAHDnzh106NABq1evRrNmzXDlyhWsXbsWXbp0QYUKFXDq1Cm89957qFSpEvbt2wfAcCp4o0aNEBAQgDlz5iApKQkDBgzAsGHDMGPGjCLXptFo4OHhAbVazV1UZFm8QjGR9KnVht/zrCzpX6HYz89wkUIbXaG4qJ/fFgs3Dx48wKhRo7B161bI5XL07NkTX331Fdzd3QEA169fR0hICPbs2YO2bdvi1q1b6N+/P86cOYOMjAwEBQXhP//5Dz7++GOTBm7cuIG33noLe/fuhZubGwYNGoRZs2bBqRibxhhuiIiIHI/Nw409Y7ghIiJyPEX9/OZdwYmIiEhSGG6IiIhIUhhuiIiISFIYboiIiEhSGG6IiIhIUhhuiIiISFIYboiIiEhSGG6IiIhIUhhuiIiISFIYboiIiEhSGG6IiIhIUhhuiIiISFIYboiIiEhSGG6IiIhIUhhuiIiISFIYboiIiEhSGG6IiIhIUhhuiIiISFIYboiIiEhSGG6IiIhIUhhuiIiISFIYboiIiEhSGG6IiIhIUhhuiIiISFIYboiIiEhSGG6IiIhIUhhuiIiISFIYboiIiEhSGG6IiIhIUhhuiIiISFIYboiIiEhSGG6IiIhIUiwWbh48eIB+/fpBpVLB09MTQ4cORXp6eoHjr1+/DplMlu9jw4YNxnH5zV+3bp2l2iAiIiIH42SpFffr1w+JiYnYvXs3cnNzMWTIEIwYMQJr167Nd3xQUBASExNNpi1ZsgRz585F586dTaavWLECnTp1Mn7v6elZ4vUTERGRY7JIuDl//jx27NiBY8eOoUmTJgCABQsWoEuXLvj8888REBCQZxmFQgE/Pz+TaZs3b0avXr3g7u5uMt3T0zPPWCIiIiLAQrulDh8+DE9PT2OwAYDIyEjI5XIcOXKkSOuIj4/HiRMnMHTo0Dzz3n77bXh7e6NZs2ZYvnw5hBBm15WdnQ2NRmPyICIiImmyyJabpKQkVKxY0fSJnJxQvnx5JCUlFWkdy5YtQ+3atdGiRQuT6dOmTUP79u1RtmxZ7Nq1CyNHjkR6ejreeeedAtc1c+ZMTJ06tfiNEBERkcMp1pab8ePHF3jQ7+PHhQsXnrmoR48eYe3atflutZk0aRJatmyJxo0b48MPP8S4ceMwd+5cs+ubMGEC1Gq18XHr1q1nrpGIiIjsU7G23Lz//vsYPHiw2TFVq1aFn58f7t69azJdq9XiwYMHRTpWZuPGjcjMzMTAgQMLHRseHo7p06cjOzsbSqUy3zFKpbLAeURERCQtxQo3Pj4+8PHxKXRcREQEUlNTER8fj7CwMADA77//Dr1ej/Dw8EKXX7ZsGV566aUiPdeJEyfg5eXF8EJEREQALHTMTe3atdGpUycMHz4cMTExyM3NxahRo9CnTx/jmVJ37txBhw4dsHr1ajRr1sy47OXLl7F//35s3749z3q3bt2K5ORkNG/eHK6urti9ezdmzJiBsWPHWqINIiIickAWu87NmjVrMGrUKHTo0AFyuRw9e/bEV199ZZyfm5uLixcvIjMz02S55cuXo1KlSujYsWOedTo7O2PRokV47733IIRA9erV8cUXX2D48OGWaoOIiIgcjEwUdh61BGk0Gnh4eECtVkOlUtm6HCIiIiqCon5+895SREREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpDDdEREQkKQw3REREJCkMN0RERCQpTrYugIiIyKEdPw5s3QpkZwONGgE9egAuLrauqlRjuCEiInoaDx4AvXoBcXGAkxMgkwG5uYC3N7B+PdCuna0rLLW4W4qIiKi49HqgWzdg717D91qtIdgAhtDTpQtw5ozNyivtGG6IiIiKKy4OOHwY0OnyztPrDWFnzhzr10UAGG6IiIiKLzbWsCuqIFqtYYwQ1quJjBhuiIiIikutNmyhMScn559dVWRVDDdERETFVaOG4QBicwICeNaUjTDcEBERFdewYea33MjlwFtvWa8eMsFwQ0REVFwhIcBnnxm+/vcWHIUCaNAAGDPG6mWRAcMNERHR05gwAfj+e6BmzX+mubsDo0cD+/cbviabkAlR+g7l1mg08PDwgFqthkqlsnU5RETkyIQAbtwAsrKA4GCgTBlbVyRZRf385hWKiYiInoVMBlSpYusq6AncLUVERESSwnBDREREksJwQ0RERJLCcENERESSwnBDREREksJwQ0RERJLCcENERESSUiqvc/P4uoUajcbGlRAREVFRPf7cLuz6w6Uy3KSlpQEAgoKCbFwJERERFVdaWho8PDwKnF8qb7+g1+uRkJCAcuXKQVbYLeufgkajQVBQEG7duiWp2ztIsS/25Dik2JcUewKk2Rd7sg9CCKSlpSEgIAByecFH1pTKLTdyuRyVKlWy+POoVCqHecEUhxT7Yk+OQ4p9SbEnQJp9sSfbM7fF5jEeUExERESSwnBDREREksJwYwFKpRJTpkyBUqm0dSklSop9sSfHIcW+pNgTIM2+2JNjKZUHFBMREZF0ccsNERERSQrDDREREUkKww0RERFJCsMNERERSQrDDREREUkKw81T0Ol0AAy3cZAKKfYEALm5uXj06JGtyyhRUuwJADIzM3H27Flbl1GipNgTkSNguCmmCRMmICIiAgDM3tfCkUixJwCYMWMGOnfujD/++MPWpZQYKfYEGPqqVKkS5s2bV+jdfh2FFHv67rvvsHjxYhw/ftz4B5EUSLGvuLg4XLx4EVqt1tal2ESpvLfU0/jxxx8xatQolCtXDnPnzrV1OSVCij0BwIULF9C/f3+kpaXhgw8+QEhICLRaLZycHPflLsWegH9egxUqVEC5cuWQnZ0NmUwGvV7vsEFbij3t3r0bI0aMMN5sODMzEyNHjsR7770HIYRFbkBsDVLsa+fOnXjjjTfg7u4OjUaDZs2aYfjw4YiKinLo12CxCTIrMzNTDB8+XMhkMvHtt9/aupwSIcWenjRz5kzRvXt34/fZ2dm2K6aESK2n27dvixYtWgg3Nzfx3//+VwghxIIFC0RISIjIycmxcXVPR4o9CSHEpUuXREREhJg+fbrQarXi+vXrYtiwYaJXr17i0aNHti7vqUmxr1OnTommTZuKuXPnCrVaLQ4ePCh69+4tatasKS5duiSEEEKv19u4Sutw7D/7rCAjIwMAEBgYiKFDhwIA/vvf/8LNzQ3e3t545ZVXbFneU5FiT4+lpaVhxYoV+OKLLwAA0dHRuHnzJipUqIDOnTujR48eti3wKUixp6tXr+L555/HL7/8Ak9PTwBAVlYW3N3dcfPmTVSrVs22BT4FqfX0+K/8s2fP4vTp09iwYQMUCgWCg4Mhl8vRuHFjuLq62rrMYpNiXzqdDgqFAocOHUJqaipef/11qFQqtGjRAnfu3MH69esxduxYbNmyxSG3Rj2NUrJ9qnjUarXxa29vbwwbNgxly5ZFy5YtUb9+fWzcuBGrV69Gr169MGzYMJw/f96G1RaNFHsCTPsCAGdnZ7i7u+PChQsYNGgQ/vrrL7Rs2RLnz5/HW2+9hdjYWAD2feC0FHsCTPtq3bo1Zs6cCU9PT+MxAa1atcK5c+eMY4QDHKci5Z4e777QarUIDQ3F2rVrAQBffvkl1qxZg927d2Ps2LE4evQoAMd5/Umpr8c9KRQKAMDly5dRuXJlk11P3t7eqF27Nn755Rf89NNPABzjdfjMbLzlyK7s2rVLNG/eXERGRor3339fHDlyRAghhEajEXPmzBGhoaEiJiZGpKWlCSGE+Omnn0Tz5s1FdHS0Lcs2S4o9CZG3r6NHjwohhEhMTBQvvfSS6Natm2jXrp24evWqEEIItVot3n33XeHr62vLss2SYk9C5O3r2LFjQgghtFqtybgrV66I6tWri6VLl9qizGIpDT09fq+4ffu2mDhxonjuuedEjRo1RMWKFUVMTIz44osvxIsvvigqVKhg48rNk2Jf/+7p8OHDQgghDhw4INzc3MTHH38srl+/Lnbt2iWqV68uxo4dK/7zn/+IV1991caVWw/Dzf/ExsYKLy8vMWnSJDFjxgzRpEkTERwcbNxPefHiRbFr1y5jCHhs+PDhIjIyUqSmptqibLOk2JMQhfc1ZcoUIZPJRGRkpMlyJ06cEFWqVBE7d+60RdlmSbEnIQru6/Lly8Yxj48BSEpKElWrVhULFiwwmW5vSlNPTx6ncf78eREWFib+/PNP43I3b94U/v7+YuXKlbYq3Swp9lVQT3///bcQQoipU6eK+vXri8DAQOHq6iqmTZsmhBBi1KhR4qWXXhI6nU7odDpbtmAVDDdCCJ1OJ/r16yeGDh1qnHblyhXRrl07ER4enu/BgI+njRkzRgQHB4usrCyr1VsUUuxJCPN9NW3aVAhh2KJRt25dERISIk6ePGkc9/vvvwtfX19x4sQJq9dtjhR7EsJ8XxERESavr8dvtm3bthWvvfaaEMI+g0Bp66l58+bGg2sPHjwoGjRoIG7evGkc9+eff4rAwECxefNma5ddKCn2VZT3Cp1OJx48eCB+++03kxAzaNAg0bp1a6vXbCs85gaGfbCnTp2Cj4+PcVrVqlWxYMECnD59Gt9++y0A032vzs7OSEpKwsmTJ/HOO+9AqVRavW5zpNgTYL6vs2fPYsGCBVCpVJgwYQJcXV3x0Ucf4fr167h//z527dqFZs2aoUqVKrZrIB9S7Akw39fJkyexfPlyAIb9/3K5HFqtFo0bN0ZSUhLS0tLs8sDH0tbTqVOnjD3dvn0bOTk52L9/PzIzM5GRkYGNGzeicuXKeO6552xVfoGk2Fdh7xVff/015HI5vLy80KFDB+OxN9euXcO5c+cwcuRIW5VufbZOV/YgKytLDBs2TERFRYn09HQhxD9/YY0dO1YEBQUZx969e1ccOnRILF++XISGhor27duLa9eu2aJss6TYkxCF9xUYGGgcu3HjRlG9enVRo0YNERgYKGrWrGk8NsKeSLEnIYr3Gnz8F2Z0dLQICgoSGo3G+gUXQWns6cnXX69evYSPj49o166dqF69uqhdu7b4448/bFJ3YaTYV3Fef5mZmeLYsWPiq6++ElWrVhUvvPCCSEhIsEndtlBqws3jF0BB+xrnz58vIiIixMaNG03Gnzp1Snh7e4stW7YYv+/atasIDQ0V8+bNs3zhZkixJyGeva9NmzYZx969e1fEx8eL7du3W7hq86TYkxAl9xp8fCBufHy8za+9xJ7y9vR4ekJCgti+fbuYPXu2WLNmjRUqN0+KfZXU6y81NVWsWLFC1K9fX8yfP98KlduXUhFuPv30U7Fw4cI807VarfEFdOfOHdGmTRvRr18/cevWLeOYq1evitDQUPHDDz8Ypx0/flzk5uZavnAzpNiTECXflz2QYk9ClExf69ats1q9RcGezL/+7OmYISn2VdLvFWq1ulQcPJwfSR9z8/3336NChQpYvXo1WrVqZTJPr9dDoVBALpdj69atkMlkGDVqFC5fvow5c+YYx2VnZyM7OxshISHGaY0bN7bZZe+l2BNgub5sSYo9ASXbl70cK8Seivb6s4djhqTYl6XeK1QqVem53cK/2TpdWcLt27dF+/bthVKpNHt9iRMnTogWLVqIwMBAsW/fPqHT6cS8efOEh4eHeOGFF8SkSZNEjRo1xIsvvigePHhgxQ7ykmJPQkizLyn2JIQ0+2JPjtGTENLsS4o92QtJhptt27aJ8uXLi08//VQIYTgIKzY2Vhw4cEBcuXJFCGHYxxoSEiJGjhwpEhMTTZbfs2ePGD16tHjhhRfEzJkzrV5/fqTYkxDS7EuKPQkhzb7Yk2P0JIQ0+5JiT/ZCJoQ0rsN8+PBhBAcHIyAgAADwxhtv4Pr166hWrRq2b98Of39/XLlyBa6urlixYgU6dOiAlJQUk1Pq/u3x/TpsRYo9AdLsS4o9AdLsiz05Rk+ANPuSYk92ydbp6ln99ttvIiQkRAQHB4tKlSqJIUOGiJSUFHH58mURGhoqwsLCxJo1a8SdO3fEX3/9JQYMGCAqV65scjVReyPFnoSQZl9S7EkIafbFnhyjJyGk2ZcUe7JnDh1ubt68KZo3by4mTZokLl++LDZs2CBCQkJEjx49xMOHD8WWLVvEli1bTI6Ez8nJESqVSnzzzTdCiLz3grE1KfYkhDT7kmJPQkizL/ZkYO89CSHNvqTYk71z6HCza9cuUaZMGZNk++OPP4qWLVuK0aNH57tMVlaWqFevnhg5cqS1yiwWKfYkhDT7kmJPQkizL/ZkYO89CSHNvqTYk71z6HPEHjx4gNq1a0On0xmnde/eHV26dEFcXBz27t2bZ5n4+HjodDr079/fipUWnRR7AqTZlxR7AqTZF3sysPeeAGn2JcWe7J1Dh5u6devi3LlzuHDhgnGaQqFAly5dEBQUhJ9//hkAcP/+ffz999/47rvvMGDAAERERKBu3boQdngstRR7AqTZlxR7AqTZF3tyjJ4AafYlxZ7sns22GZWQzp07izZt2oi0tDST6QMGDBDdu3cXjx49ErGxsaJOnToiKChIxMTE2KjSopNiT0JIsy8p9iSENPtiT47RkxDS7EuKPdkzhw83J06cEE5OTuKbb74R2dnZxukfffSRCA0NFUIY7rHx+H4bjkCKPQkhzb6k2JMQ0uyLPTkOKfYlxZ7smcOHGyGEmDhxoggICBDffvutSE9PFxqNRkRFRYkpU6bYurSnJsWehJBmX1LsSQhp9sWeHIcU+5JiT/ZKEuFGCCFGjhwp/P39RXh4uAgODhZ16tQRZ8+etXVZz0SKPQkhzb6k2JMQ0uyLPTkOKfYlxZ7skWSuUJyVlYXz58/j+PHjUCqVkjjCXIo9AdLsS4o9AdLsiz05Din2JcWe7JFkwg0RERER4OCnghMRERH9G8MNERERSQrDDREREUkKww0RERFJCsMNERERSQrDDREREUkKww0RERFJCsMNERERSQrDDREREUkKww0RERFJCsMNERERSQrDDREREUnK/wMh+FXN9ucFAwAAAABJRU5ErkJggg==",
            "text/plain": [
              "<Figure size 640x480 with 1 Axes>"
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        }
      ],
      "source": [
        "import matplotlib.pyplot as plt \n",
        "import matplotlib.dates as mdates\n",
        "\n",
        "data['published'] = pd.to_datetime(data['published'])\n",
        "sorted_data = data.sort_values('published')\n",
        "\n",
        "# Convert sentiment column to numeric type\n",
        "sorted_data['sentiment'] = pd.to_numeric(sorted_data['sentiment'])\n",
        "\n",
        "colors = ['red' if val < 0 else 'green' if val > 0 else 'grey' for val in sorted_data['sentiment']]\n",
        "\n",
        "fig, ax = plt.subplots()\n",
        "ax.scatter(sorted_data['published'], sorted_data['sentiment'], color=colors)\n",
        "\n",
        "# Set the x-axis formatter to display dates\n",
        "ax.xaxis.set_major_formatter(mdates.DateFormatter('%m-%d')) #Y-%m-%d\n",
        "\n",
        "# Auto-rotate the x-axis labels for better readability\n",
        "fig.autofmt_xdate()\n",
        " \n",
        "plt.axhline(0, color='black', linestyle='--')\n",
        "\n",
        "plt.title('Nvidia Sentiment')\n",
        " \n",
        "plt.show()"
      ]
    }
  ],
  "metadata": {
    "colab": {
      "include_colab_link": true,
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "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.11.2"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}