Testes.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "type object 'datetime.datetime' has no attribute 'utc'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m/tmp/ipykernel_198475/4004438009.py\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0mapple\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0myf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mTicker\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"AAPL\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m \u001b[0minformacoes\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mapple\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0minfo\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 6\u001b[0;31m \u001b[0mf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdatetime\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mutc\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      7\u001b[0m \u001b[0mf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdatetime\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mutcfromtimestamp\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0minformacoes\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'firstTradeDateEpochUtc'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      8\u001b[0m \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mAttributeError\u001b[0m: type object 'datetime.datetime' has no attribute 'utc'"
     ]
    }
   ],
   "source": [
    "import yfinance as yf\n",
    "from datetime import timedelta, datetime\n",
    "\n",
    "apple = yf.Ticker(\"AAPL\")\n",
    "informacoes = apple.info\n",
    "f = datetime.utc\n",
    "f = datetime.utcfromtimestamp(informacoes['firstTradeDateEpochUtc']).date()\n",
    "print(f)\n",
    "history = apple.history(start=f, end=f + timedelta(1))\n",
    "print(history.iloc[0,0])\n",
    "print(yf.Ticker(\"aapl\").fast_info['lastPrice'])\n",
    "history = co.history(period = \"1d\")\n",
    "lastValue = history.iloc[-1,0]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "173.0500030517578"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "apple = yf.Ticker(\"AAPL\")\n",
    "informacoes = apple.info\n",
    "history = apple.history(period=\"1d\")\n",
    "lastValue = history.iloc[-1,0]\n",
    "lastValue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "173.57000732421875\n"
     ]
    }
   ],
   "source": [
    "import yfinance as yf\n",
    "\n",
    "print(yf.Ticker(\"aapl\").fast_info['lastPrice'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {},
   "outputs": [],
   "source": [
    "import PyPDF2\n",
    "import re\n",
    "import pandas as pd\n",
    "import yfinance as yf\n",
    "\n",
    "# TODO API yahoo finance\n",
    "\n",
    "pdf_file = open('ru2000_membershiplist_20220624_0.pdf', 'rb')\n",
    "read_pdf = PyPDF2.PdfReader(pdf_file)\n",
    "pages = read_pdf.pages\n",
    "p = 0\n",
    "#df = pd.DataFrame(columns = ['Company', 'Ticker', 'IPO', 'First Value', 'Last Value', 'Last Date', 'How Much'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2004-08-01 00:00:00-04:00\n",
      "2023-05-01 00:00:00-04:00\n"
     ]
    }
   ],
   "source": [
    "co = yf.Ticker(\"GOOG\")\n",
    "history = co.history(period=\"max\", interval=\"3mo\",)\n",
    "print(history.index[0])\n",
    "print(history.index[-1])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2004-08-19 00:00:00-04:00\n",
      "2023-05-05 00:00:00-04:00\n"
     ]
    }
   ],
   "source": [
    "co = yf.Ticker(\"GOOG\")\n",
    "history = co.history(period=\"max\")\n",
    "print(history.index[0])\n",
    "print(history.index[-1])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2023-05-07 19:22:16.794701\n",
      "2023-05-07 19:22:16.794701+00:00\n",
      "2023-05-07 19:22:16.794701\n"
     ]
    }
   ],
   "source": [
    "\n",
    "from datetime import datetime, timezone\n",
    " \n",
    "# Get the datetime object using datetime\n",
    "# module\n",
    "dt_obj_w_tz = datetime.now()\n",
    "print(dt_obj_w_tz)\n",
    " \n",
    "# Add timezone information to the datetime\n",
    "# object\n",
    "dt_obj_w_tz = dt_obj_w_tz.replace(tzinfo=timezone.utc)\n",
    "print(dt_obj_w_tz)\n",
    " \n",
    "# Remove the timezone information from the datetime\n",
    "# object\n",
    "dt_obj_wo_tz = dt_obj_w_tz.replace(tzinfo=None)\n",
    "print(dt_obj_wo_tz)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2004-08-19 00:00:00-04:00\n",
      "2004-08-19 00:00:00\n"
     ]
    }
   ],
   "source": [
    "type(history)\n",
    "row = history.iloc[0]\n",
    "date = history.index[0]\n",
    "type(date)\n",
    "print(date)\n",
    "print(date.replace(tzinfo=None))\n",
    "#history.dtypes\n",
    "history.to_csv(\"teste.csv\", date_format='%Y-%m-%d')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "\n",
      "---------------------\n",
      "Página 3\n",
      "---------------------\n",
      "\n",
      "Company | Ticker\n",
      "APELLIS PHARMACEUTICALS | APLS | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                   Company Ticker        IPO  First Value  Last Value   \n",
      "0  APELLIS PHARMACEUTICALS   APLS 2017-11-01        13.87   76.709999  \\\n",
      "\n",
      "   Last Date    How Much  \n",
      "0 2023-05-01  453.064165  \n",
      "ASTEC INDS INC | ASTE | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                   Company Ticker        IPO  First Value  Last Value   \n",
      "0  APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1           ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "\n",
      "   Last Date     How Much  \n",
      "0 2023-05-01   453.064165  \n",
      "1 2023-05-05  1439.966594  \n",
      "ASTRA SPACE INC | ASTR | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                   Company Ticker        IPO  First Value  Last Value   \n",
      "0  APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1           ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "2          ASTRA SPACE INC   ASTR 2020-10-01     9.790000    0.448000   \n",
      "\n",
      "   Last Date     How Much  \n",
      "0 2023-05-01   453.064165  \n",
      "1 2023-05-05  1439.966594  \n",
      "2 2023-04-01   -95.423902  \n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/tmp/ipykernel_127498/2074426207.py:9: RuntimeWarning: divide by zero encountered in double_scalars\n",
      "  howMuchPercent = ((lastValue - firstValue) / firstValue) * 100\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ASTRONICS | ATRO | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                   Company Ticker        IPO  First Value  Last Value   \n",
      "0  APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1           ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "2          ASTRA SPACE INC   ASTR 2020-10-01     9.790000    0.448000   \n",
      "3                ASTRONICS   ATRO 1984-12-01     0.000000   14.690000   \n",
      "\n",
      "   Last Date     How Much  \n",
      "0 2023-05-01   453.064165  \n",
      "1 2023-05-05  1439.966594  \n",
      "2 2023-04-01   -95.423902  \n",
      "3 2023-05-05          inf  \n",
      "ATARA BIOTHERAPEUTICS | ATRA | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                   Company Ticker        IPO  First Value  Last Value   \n",
      "0  APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1           ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "2          ASTRA SPACE INC   ASTR 2020-10-01     9.790000    0.448000   \n",
      "3                ASTRONICS   ATRO 1984-12-01     0.000000   14.690000   \n",
      "4    ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000    2.860000   \n",
      "\n",
      "   Last Date     How Much  \n",
      "0 2023-05-01   453.064165  \n",
      "1 2023-05-05  1439.966594  \n",
      "2 2023-04-01   -95.423902  \n",
      "3 2023-05-05          inf  \n",
      "4 2023-04-01   -84.947369  \n",
      "ATEA PHARMACEUTICALS | AVIR | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                   Company Ticker        IPO  First Value  Last Value   \n",
      "0  APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1           ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "2          ASTRA SPACE INC   ASTR 2020-10-01     9.790000    0.448000   \n",
      "3                ASTRONICS   ATRO 1984-12-01     0.000000   14.690000   \n",
      "4    ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000    2.860000   \n",
      "5     ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001    3.320000   \n",
      "\n",
      "   Last Date     How Much  \n",
      "0 2023-05-01   453.064165  \n",
      "1 2023-05-05  1439.966594  \n",
      "2 2023-04-01   -95.423902  \n",
      "3 2023-05-05          inf  \n",
      "4 2023-04-01   -84.947369  \n",
      "5 2023-04-01   -88.911156  \n",
      "ATERIAN INC | ATER | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                   Company Ticker        IPO  First Value  Last Value   \n",
      "0  APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1           ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "2          ASTRA SPACE INC   ASTR 2020-10-01     9.790000    0.448000   \n",
      "3                ASTRONICS   ATRO 1984-12-01     0.000000   14.690000   \n",
      "4    ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000    2.860000   \n",
      "5     ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001    3.320000   \n",
      "6              ATERIAN INC   ATER 2019-06-01     8.160000    0.716200   \n",
      "\n",
      "   Last Date     How Much  \n",
      "0 2023-05-01   453.064165  \n",
      "1 2023-05-05  1439.966594  \n",
      "2 2023-04-01   -95.423902  \n",
      "3 2023-05-05          inf  \n",
      "4 2023-04-01   -84.947369  \n",
      "5 2023-04-01   -88.911156  \n",
      "6 2023-05-05   -91.223039  \n",
      "ATHIRA PHARMA | ATHA | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                   Company Ticker        IPO  First Value  Last Value   \n",
      "0  APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1           ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "2          ASTRA SPACE INC   ASTR 2020-10-01     9.790000    0.448000   \n",
      "3                ASTRONICS   ATRO 1984-12-01     0.000000   14.690000   \n",
      "4    ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000    2.860000   \n",
      "5     ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001    3.320000   \n",
      "6              ATERIAN INC   ATER 2019-06-01     8.160000    0.716200   \n",
      "7            ATHIRA PHARMA   ATHA 2020-09-01    18.250000    2.960000   \n",
      "\n",
      "   Last Date     How Much  \n",
      "0 2023-05-01   453.064165  \n",
      "1 2023-05-05  1439.966594  \n",
      "2 2023-04-01   -95.423902  \n",
      "3 2023-05-05          inf  \n",
      "4 2023-04-01   -84.947369  \n",
      "5 2023-04-01   -88.911156  \n",
      "6 2023-05-05   -91.223039  \n",
      "7 2023-05-05   -83.780822  \n",
      "ATI PHYSICAL THERAPY INC (A) | ATIP | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                        Company Ticker        IPO  First Value  Last Value   \n",
      "0       APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1                ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "2               ASTRA SPACE INC   ASTR 2020-10-01     9.790000    0.448000   \n",
      "3                     ASTRONICS   ATRO 1984-12-01     0.000000   14.690000   \n",
      "4         ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000    2.860000   \n",
      "5          ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001    3.320000   \n",
      "6                   ATERIAN INC   ATER 2019-06-01     8.160000    0.716200   \n",
      "7                 ATHIRA PHARMA   ATHA 2020-09-01    18.250000    2.960000   \n",
      "8  ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000    0.266000   \n",
      "\n",
      "   Last Date     How Much  \n",
      "0 2023-05-01   453.064165  \n",
      "1 2023-05-05  1439.966594  \n",
      "2 2023-04-01   -95.423902  \n",
      "3 2023-05-05          inf  \n",
      "4 2023-04-01   -84.947369  \n",
      "5 2023-04-01   -88.911156  \n",
      "6 2023-05-05   -91.223039  \n",
      "7 2023-05-05   -83.780822  \n",
      "8 2023-04-01   -97.260556  \n",
      "ATKORE INC | ATKR | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                        Company Ticker        IPO  First Value  Last Value   \n",
      "0       APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1                ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "2               ASTRA SPACE INC   ASTR 2020-10-01     9.790000    0.448000   \n",
      "3                     ASTRONICS   ATRO 1984-12-01     0.000000   14.690000   \n",
      "4         ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000    2.860000   \n",
      "5          ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001    3.320000   \n",
      "6                   ATERIAN INC   ATER 2019-06-01     8.160000    0.716200   \n",
      "7                 ATHIRA PHARMA   ATHA 2020-09-01    18.250000    2.960000   \n",
      "8  ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000    0.266000   \n",
      "9                    ATKORE INC   ATKR 2016-06-01    16.090000  125.559998   \n",
      "\n",
      "   Last Date     How Much  \n",
      "0 2023-05-01   453.064165  \n",
      "1 2023-05-05  1439.966594  \n",
      "2 2023-04-01   -95.423902  \n",
      "3 2023-05-05          inf  \n",
      "4 2023-04-01   -84.947369  \n",
      "5 2023-04-01   -88.911156  \n",
      "6 2023-05-05   -91.223039  \n",
      "7 2023-05-05   -83.780822  \n",
      "8 2023-04-01   -97.260556  \n",
      "9 2023-05-05   680.360450  \n",
      "ATLANTIC UNION BANKSHARES | AUB | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                         Company Ticker        IPO  First Value  Last Value   \n",
      "0        APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1                 ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "2                ASTRA SPACE INC   ASTR 2020-10-01     9.790000    0.448000   \n",
      "3                      ASTRONICS   ATRO 1984-12-01     0.000000   14.690000   \n",
      "4          ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000    2.860000   \n",
      "5           ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001    3.320000   \n",
      "6                    ATERIAN INC   ATER 2019-06-01     8.160000    0.716200   \n",
      "7                  ATHIRA PHARMA   ATHA 2020-09-01    18.250000    2.960000   \n",
      "8   ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000    0.266000   \n",
      "9                     ATKORE INC   ATKR 2016-06-01    16.090000  125.559998   \n",
      "10     ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   34.830002   \n",
      "\n",
      "    Last Date     How Much  \n",
      "0  2023-05-01   453.064165  \n",
      "1  2023-05-05  1439.966594  \n",
      "2  2023-04-01   -95.423902  \n",
      "3  2023-05-05          inf  \n",
      "4  2023-04-01   -84.947369  \n",
      "5  2023-04-01   -88.911156  \n",
      "6  2023-05-05   -91.223039  \n",
      "7  2023-05-05   -83.780822  \n",
      "8  2023-04-01   -97.260556  \n",
      "9  2023-05-05   680.360450  \n",
      "10 2023-04-01   772.138061  \n",
      "ATLANTICUS HOLDINGS CORP | ATLC | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                         Company Ticker        IPO  First Value  Last Value   \n",
      "0        APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1                 ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "2                ASTRA SPACE INC   ASTR 2020-10-01     9.790000    0.448000   \n",
      "3                      ASTRONICS   ATRO 1984-12-01     0.000000   14.690000   \n",
      "4          ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000    2.860000   \n",
      "5           ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001    3.320000   \n",
      "6                    ATERIAN INC   ATER 2019-06-01     8.160000    0.716200   \n",
      "7                  ATHIRA PHARMA   ATHA 2020-09-01    18.250000    2.960000   \n",
      "8   ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000    0.266000   \n",
      "9                     ATKORE INC   ATKR 2016-06-01    16.090000  125.559998   \n",
      "10     ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   34.830002   \n",
      "11      ATLANTICUS HOLDINGS CORP   ATLC 1999-04-01    14.361699   27.280001   \n",
      "\n",
      "    Last Date     How Much  \n",
      "0  2023-05-01   453.064165  \n",
      "1  2023-05-05  1439.966594  \n",
      "2  2023-04-01   -95.423902  \n",
      "3  2023-05-05          inf  \n",
      "4  2023-04-01   -84.947369  \n",
      "5  2023-04-01   -88.911156  \n",
      "6  2023-05-05   -91.223039  \n",
      "7  2023-05-05   -83.780822  \n",
      "8  2023-04-01   -97.260556  \n",
      "9  2023-05-05   680.360450  \n",
      "10 2023-04-01   772.138061  \n",
      "11 2023-04-01    89.949672  \n",
      "ATLAS AIR WORLDWIDE HOLDINGS | AAWW | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                         Company Ticker        IPO  First Value  Last Value   \n",
      "0        APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000   76.709999  \\\n",
      "1                 ASTEC INDS INC   ASTE 1986-06-01     2.675383   41.200001   \n",
      "2                ASTRA SPACE INC   ASTR 2020-10-01     9.790000    0.448000   \n",
      "3                      ASTRONICS   ATRO 1984-12-01     0.000000   14.690000   \n",
      "4          ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000    2.860000   \n",
      "5           ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001    3.320000   \n",
      "6                    ATERIAN INC   ATER 2019-06-01     8.160000    0.716200   \n",
      "7                  ATHIRA PHARMA   ATHA 2020-09-01    18.250000    2.960000   \n",
      "8   ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000    0.266000   \n",
      "9                     ATKORE INC   ATKR 2016-06-01    16.090000  125.559998   \n",
      "10     ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   34.830002   \n",
      "11      ATLANTICUS HOLDINGS CORP   ATLC 1999-04-01    14.361699   27.280001   \n",
      "12  ATLAS AIR WORLDWIDE HOLDINGS   AAWW 2004-07-01    16.850000  100.870003   \n",
      "\n",
      "    Last Date     How Much  \n",
      "0  2023-05-01   453.064165  \n",
      "1  2023-05-05  1439.966594  \n",
      "2  2023-04-01   -95.423902  \n",
      "3  2023-05-05          inf  \n",
      "4  2023-04-01   -84.947369  \n",
      "5  2023-04-01   -88.911156  \n",
      "6  2023-05-05   -91.223039  \n",
      "7  2023-05-05   -83.780822  \n",
      "8  2023-04-01   -97.260556  \n",
      "9  2023-05-05   680.360450  \n",
      "10 2023-04-01   772.138061  \n",
      "11 2023-04-01    89.949672  \n",
      "12 2023-01-01   498.635018  \n",
      "ATLAS TECHNICAL CONSULTANTS INC (A) | ATCX | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                                Company Ticker        IPO  First Value   \n",
      "0               APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000  \\\n",
      "1                        ASTEC INDS INC   ASTE 1986-06-01     2.675383   \n",
      "2                       ASTRA SPACE INC   ASTR 2020-10-01     9.790000   \n",
      "3                             ASTRONICS   ATRO 1984-12-01     0.000000   \n",
      "4                 ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000   \n",
      "5                  ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001   \n",
      "6                           ATERIAN INC   ATER 2019-06-01     8.160000   \n",
      "7                         ATHIRA PHARMA   ATHA 2020-09-01    18.250000   \n",
      "8          ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000   \n",
      "9                            ATKORE INC   ATKR 2016-06-01    16.090000   \n",
      "10            ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   \n",
      "11             ATLANTICUS HOLDINGS CORP   ATLC 1999-04-01    14.361699   \n",
      "12         ATLAS AIR WORLDWIDE HOLDINGS   AAWW 2004-07-01    16.850000   \n",
      "13  ATLAS TECHNICAL CONSULTANTS INC (A)   ATCX 2019-01-01    10.426000   \n",
      "\n",
      "    Last Value  Last Date     How Much  \n",
      "0    76.709999 2023-05-01   453.064165  \n",
      "1    41.200001 2023-05-05  1439.966594  \n",
      "2     0.448000 2023-04-01   -95.423902  \n",
      "3    14.690000 2023-05-05          inf  \n",
      "4     2.860000 2023-04-01   -84.947369  \n",
      "5     3.320000 2023-04-01   -88.911156  \n",
      "6     0.716200 2023-05-05   -91.223039  \n",
      "7     2.960000 2023-05-05   -83.780822  \n",
      "8     0.266000 2023-04-01   -97.260556  \n",
      "9   125.559998 2023-05-05   680.360450  \n",
      "10   34.830002 2023-04-01   772.138061  \n",
      "11   27.280001 2023-04-01    89.949672  \n",
      "12  100.870003 2023-01-01   498.635018  \n",
      "13   12.190000 2023-04-01    16.919240  \n",
      "ATN INTERNATIONAL | ATNI | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                                Company Ticker        IPO  First Value   \n",
      "0               APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000  \\\n",
      "1                        ASTEC INDS INC   ASTE 1986-06-01     2.675383   \n",
      "2                       ASTRA SPACE INC   ASTR 2020-10-01     9.790000   \n",
      "3                             ASTRONICS   ATRO 1984-12-01     0.000000   \n",
      "4                 ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000   \n",
      "5                  ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001   \n",
      "6                           ATERIAN INC   ATER 2019-06-01     8.160000   \n",
      "7                         ATHIRA PHARMA   ATHA 2020-09-01    18.250000   \n",
      "8          ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000   \n",
      "9                            ATKORE INC   ATKR 2016-06-01    16.090000   \n",
      "10            ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   \n",
      "11             ATLANTICUS HOLDINGS CORP   ATLC 1999-04-01    14.361699   \n",
      "12         ATLAS AIR WORLDWIDE HOLDINGS   AAWW 2004-07-01    16.850000   \n",
      "13  ATLAS TECHNICAL CONSULTANTS INC (A)   ATCX 2019-01-01    10.426000   \n",
      "14                    ATN INTERNATIONAL   ATNI 1991-11-01     4.110885   \n",
      "\n",
      "    Last Value  Last Date     How Much  \n",
      "0    76.709999 2023-05-01   453.064165  \n",
      "1    41.200001 2023-05-05  1439.966594  \n",
      "2     0.448000 2023-04-01   -95.423902  \n",
      "3    14.690000 2023-05-05          inf  \n",
      "4     2.860000 2023-04-01   -84.947369  \n",
      "5     3.320000 2023-04-01   -88.911156  \n",
      "6     0.716200 2023-05-05   -91.223039  \n",
      "7     2.960000 2023-05-05   -83.780822  \n",
      "8     0.266000 2023-04-01   -97.260556  \n",
      "9   125.559998 2023-05-05   680.360450  \n",
      "10   34.830002 2023-04-01   772.138061  \n",
      "11   27.280001 2023-04-01    89.949672  \n",
      "12  100.870003 2023-01-01   498.635018  \n",
      "13   12.190000 2023-04-01    16.919240  \n",
      "14   36.209999 2023-05-01   780.832192  \n",
      "ATOMERA | ATOM | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                                Company Ticker        IPO  First Value   \n",
      "0               APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000  \\\n",
      "1                        ASTEC INDS INC   ASTE 1986-06-01     2.675383   \n",
      "2                       ASTRA SPACE INC   ASTR 2020-10-01     9.790000   \n",
      "3                             ASTRONICS   ATRO 1984-12-01     0.000000   \n",
      "4                 ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000   \n",
      "5                  ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001   \n",
      "6                           ATERIAN INC   ATER 2019-06-01     8.160000   \n",
      "7                         ATHIRA PHARMA   ATHA 2020-09-01    18.250000   \n",
      "8          ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000   \n",
      "9                            ATKORE INC   ATKR 2016-06-01    16.090000   \n",
      "10            ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   \n",
      "11             ATLANTICUS HOLDINGS CORP   ATLC 1999-04-01    14.361699   \n",
      "12         ATLAS AIR WORLDWIDE HOLDINGS   AAWW 2004-07-01    16.850000   \n",
      "13  ATLAS TECHNICAL CONSULTANTS INC (A)   ATCX 2019-01-01    10.426000   \n",
      "14                    ATN INTERNATIONAL   ATNI 1991-11-01     4.110885   \n",
      "15                              ATOMERA   ATOM 2016-08-01     9.378000   \n",
      "\n",
      "    Last Value  Last Date     How Much  \n",
      "0    76.709999 2023-05-01   453.064165  \n",
      "1    41.200001 2023-05-05  1439.966594  \n",
      "2     0.448000 2023-04-01   -95.423902  \n",
      "3    14.690000 2023-05-05          inf  \n",
      "4     2.860000 2023-04-01   -84.947369  \n",
      "5     3.320000 2023-04-01   -88.911156  \n",
      "6     0.716200 2023-05-05   -91.223039  \n",
      "7     2.960000 2023-05-05   -83.780822  \n",
      "8     0.266000 2023-04-01   -97.260556  \n",
      "9   125.559998 2023-05-05   680.360450  \n",
      "10   34.830002 2023-04-01   772.138061  \n",
      "11   27.280001 2023-04-01    89.949672  \n",
      "12  100.870003 2023-01-01   498.635018  \n",
      "13   12.190000 2023-04-01    16.919240  \n",
      "14   36.209999 2023-05-01   780.832192  \n",
      "15    7.920000 2023-05-01   -15.547026  \n",
      "ATRICURE | ATRC | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                                Company Ticker        IPO  First Value   \n",
      "0               APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000  \\\n",
      "1                        ASTEC INDS INC   ASTE 1986-06-01     2.675383   \n",
      "2                       ASTRA SPACE INC   ASTR 2020-10-01     9.790000   \n",
      "3                             ASTRONICS   ATRO 1984-12-01     0.000000   \n",
      "4                 ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000   \n",
      "5                  ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001   \n",
      "6                           ATERIAN INC   ATER 2019-06-01     8.160000   \n",
      "7                         ATHIRA PHARMA   ATHA 2020-09-01    18.250000   \n",
      "8          ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000   \n",
      "9                            ATKORE INC   ATKR 2016-06-01    16.090000   \n",
      "10            ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   \n",
      "11             ATLANTICUS HOLDINGS CORP   ATLC 1999-04-01    14.361699   \n",
      "12         ATLAS AIR WORLDWIDE HOLDINGS   AAWW 2004-07-01    16.850000   \n",
      "13  ATLAS TECHNICAL CONSULTANTS INC (A)   ATCX 2019-01-01    10.426000   \n",
      "14                    ATN INTERNATIONAL   ATNI 1991-11-01     4.110885   \n",
      "15                              ATOMERA   ATOM 2016-08-01     9.378000   \n",
      "16                             ATRICURE   ATRC 2005-08-01    13.400000   \n",
      "\n",
      "    Last Value  Last Date     How Much  \n",
      "0    76.709999 2023-05-01   453.064165  \n",
      "1    41.200001 2023-05-05  1439.966594  \n",
      "2     0.448000 2023-04-01   -95.423902  \n",
      "3    14.690000 2023-05-05          inf  \n",
      "4     2.860000 2023-04-01   -84.947369  \n",
      "5     3.320000 2023-04-01   -88.911156  \n",
      "6     0.716200 2023-05-05   -91.223039  \n",
      "7     2.960000 2023-05-05   -83.780822  \n",
      "8     0.266000 2023-04-01   -97.260556  \n",
      "9   125.559998 2023-05-05   680.360450  \n",
      "10   34.830002 2023-04-01   772.138061  \n",
      "11   27.280001 2023-04-01    89.949672  \n",
      "12  100.870003 2023-01-01   498.635018  \n",
      "13   12.190000 2023-04-01    16.919240  \n",
      "14   36.209999 2023-05-01   780.832192  \n",
      "15    7.920000 2023-05-01   -15.547026  \n",
      "16   44.310001 2023-05-01   230.671661  \n",
      "ATRION CORP | ATRI | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                                Company Ticker        IPO  First Value   \n",
      "0               APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000  \\\n",
      "1                        ASTEC INDS INC   ASTE 1986-06-01     2.675383   \n",
      "2                       ASTRA SPACE INC   ASTR 2020-10-01     9.790000   \n",
      "3                             ASTRONICS   ATRO 1984-12-01     0.000000   \n",
      "4                 ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000   \n",
      "5                  ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001   \n",
      "6                           ATERIAN INC   ATER 2019-06-01     8.160000   \n",
      "7                         ATHIRA PHARMA   ATHA 2020-09-01    18.250000   \n",
      "8          ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000   \n",
      "9                            ATKORE INC   ATKR 2016-06-01    16.090000   \n",
      "10            ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   \n",
      "11             ATLANTICUS HOLDINGS CORP   ATLC 1999-04-01    14.361699   \n",
      "12         ATLAS AIR WORLDWIDE HOLDINGS   AAWW 2004-07-01    16.850000   \n",
      "13  ATLAS TECHNICAL CONSULTANTS INC (A)   ATCX 2019-01-01    10.426000   \n",
      "14                    ATN INTERNATIONAL   ATNI 1991-11-01     4.110885   \n",
      "15                              ATOMERA   ATOM 2016-08-01     9.378000   \n",
      "16                             ATRICURE   ATRC 2005-08-01    13.400000   \n",
      "17                          ATRION CORP   ATRI 1984-12-01    12.386710   \n",
      "\n",
      "    Last Value  Last Date     How Much  \n",
      "0    76.709999 2023-05-01   453.064165  \n",
      "1    41.200001 2023-05-05  1439.966594  \n",
      "2     0.448000 2023-04-01   -95.423902  \n",
      "3    14.690000 2023-05-05          inf  \n",
      "4     2.860000 2023-04-01   -84.947369  \n",
      "5     3.320000 2023-04-01   -88.911156  \n",
      "6     0.716200 2023-05-05   -91.223039  \n",
      "7     2.960000 2023-05-05   -83.780822  \n",
      "8     0.266000 2023-04-01   -97.260556  \n",
      "9   125.559998 2023-05-05   680.360450  \n",
      "10   34.830002 2023-04-01   772.138061  \n",
      "11   27.280001 2023-04-01    89.949672  \n",
      "12  100.870003 2023-01-01   498.635018  \n",
      "13   12.190000 2023-04-01    16.919240  \n",
      "14   36.209999 2023-05-01   780.832192  \n",
      "15    7.920000 2023-05-01   -15.547026  \n",
      "16   44.310001 2023-05-01   230.671661  \n",
      "17  613.156311 2023-05-05  4850.114391  \n",
      "AUDACY | AUD | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                                Company Ticker        IPO  First Value   \n",
      "0               APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000  \\\n",
      "1                        ASTEC INDS INC   ASTE 1986-06-01     2.675383   \n",
      "2                       ASTRA SPACE INC   ASTR 2020-10-01     9.790000   \n",
      "3                             ASTRONICS   ATRO 1984-12-01     0.000000   \n",
      "4                 ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000   \n",
      "5                  ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001   \n",
      "6                           ATERIAN INC   ATER 2019-06-01     8.160000   \n",
      "7                         ATHIRA PHARMA   ATHA 2020-09-01    18.250000   \n",
      "8          ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000   \n",
      "9                            ATKORE INC   ATKR 2016-06-01    16.090000   \n",
      "10            ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   \n",
      "11             ATLANTICUS HOLDINGS CORP   ATLC 1999-04-01    14.361699   \n",
      "12         ATLAS AIR WORLDWIDE HOLDINGS   AAWW 2004-07-01    16.850000   \n",
      "13  ATLAS TECHNICAL CONSULTANTS INC (A)   ATCX 2019-01-01    10.426000   \n",
      "14                    ATN INTERNATIONAL   ATNI 1991-11-01     4.110885   \n",
      "15                              ATOMERA   ATOM 2016-08-01     9.378000   \n",
      "16                             ATRICURE   ATRC 2005-08-01    13.400000   \n",
      "17                          ATRION CORP   ATRI 1984-12-01    12.386710   \n",
      "18                               AUDACY    AUD 1999-01-01    22.786970   \n",
      "\n",
      "    Last Value  Last Date     How Much  \n",
      "0    76.709999 2023-05-01   453.064165  \n",
      "1    41.200001 2023-05-05  1439.966594  \n",
      "2     0.448000 2023-04-01   -95.423902  \n",
      "3    14.690000 2023-05-05          inf  \n",
      "4     2.860000 2023-04-01   -84.947369  \n",
      "5     3.320000 2023-04-01   -88.911156  \n",
      "6     0.716200 2023-05-05   -91.223039  \n",
      "7     2.960000 2023-05-05   -83.780822  \n",
      "8     0.266000 2023-04-01   -97.260556  \n",
      "9   125.559998 2023-05-05   680.360450  \n",
      "10   34.830002 2023-04-01   772.138061  \n",
      "11   27.280001 2023-04-01    89.949672  \n",
      "12  100.870003 2023-01-01   498.635018  \n",
      "13   12.190000 2023-04-01    16.919240  \n",
      "14   36.209999 2023-05-01   780.832192  \n",
      "15    7.920000 2023-05-01   -15.547026  \n",
      "16   44.310001 2023-05-01   230.671661  \n",
      "17  613.156311 2023-05-05  4850.114391  \n",
      "18    0.130000 2023-04-01   -99.429499  \n",
      "AURA BIOSCIENCES | AURA | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                                Company Ticker        IPO  First Value   \n",
      "0               APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000  \\\n",
      "1                        ASTEC INDS INC   ASTE 1986-06-01     2.675383   \n",
      "2                       ASTRA SPACE INC   ASTR 2020-10-01     9.790000   \n",
      "3                             ASTRONICS   ATRO 1984-12-01     0.000000   \n",
      "4                 ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000   \n",
      "5                  ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001   \n",
      "6                           ATERIAN INC   ATER 2019-06-01     8.160000   \n",
      "7                         ATHIRA PHARMA   ATHA 2020-09-01    18.250000   \n",
      "8          ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000   \n",
      "9                            ATKORE INC   ATKR 2016-06-01    16.090000   \n",
      "10            ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   \n",
      "11             ATLANTICUS HOLDINGS CORP   ATLC 1999-04-01    14.361699   \n",
      "12         ATLAS AIR WORLDWIDE HOLDINGS   AAWW 2004-07-01    16.850000   \n",
      "13  ATLAS TECHNICAL CONSULTANTS INC (A)   ATCX 2019-01-01    10.426000   \n",
      "14                    ATN INTERNATIONAL   ATNI 1991-11-01     4.110885   \n",
      "15                              ATOMERA   ATOM 2016-08-01     9.378000   \n",
      "16                             ATRICURE   ATRC 2005-08-01    13.400000   \n",
      "17                          ATRION CORP   ATRI 1984-12-01    12.386710   \n",
      "18                               AUDACY    AUD 1999-01-01    22.786970   \n",
      "19                     AURA BIOSCIENCES   AURA 2021-10-01    14.850000   \n",
      "\n",
      "    Last Value  Last Date     How Much  \n",
      "0    76.709999 2023-05-01   453.064165  \n",
      "1    41.200001 2023-05-05  1439.966594  \n",
      "2     0.448000 2023-04-01   -95.423902  \n",
      "3    14.690000 2023-05-05          inf  \n",
      "4     2.860000 2023-04-01   -84.947369  \n",
      "5     3.320000 2023-04-01   -88.911156  \n",
      "6     0.716200 2023-05-05   -91.223039  \n",
      "7     2.960000 2023-05-05   -83.780822  \n",
      "8     0.266000 2023-04-01   -97.260556  \n",
      "9   125.559998 2023-05-05   680.360450  \n",
      "10   34.830002 2023-04-01   772.138061  \n",
      "11   27.280001 2023-04-01    89.949672  \n",
      "12  100.870003 2023-01-01   498.635018  \n",
      "13   12.190000 2023-04-01    16.919240  \n",
      "14   36.209999 2023-05-01   780.832192  \n",
      "15    7.920000 2023-05-01   -15.547026  \n",
      "16   44.310001 2023-05-01   230.671661  \n",
      "17  613.156311 2023-05-05  4850.114391  \n",
      "18    0.130000 2023-04-01   -99.429499  \n",
      "19    9.280000 2023-04-01   -37.508421  \n",
      "AURINIA PHARMACEUTICALS NASDAQ | AUPH | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                                Company Ticker        IPO  First Value   \n",
      "0               APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000  \\\n",
      "1                        ASTEC INDS INC   ASTE 1986-06-01     2.675383   \n",
      "2                       ASTRA SPACE INC   ASTR 2020-10-01     9.790000   \n",
      "3                             ASTRONICS   ATRO 1984-12-01     0.000000   \n",
      "4                 ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000   \n",
      "5                  ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001   \n",
      "6                           ATERIAN INC   ATER 2019-06-01     8.160000   \n",
      "7                         ATHIRA PHARMA   ATHA 2020-09-01    18.250000   \n",
      "8          ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000   \n",
      "9                            ATKORE INC   ATKR 2016-06-01    16.090000   \n",
      "10            ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   \n",
      "11             ATLANTICUS HOLDINGS CORP   ATLC 1999-04-01    14.361699   \n",
      "12         ATLAS AIR WORLDWIDE HOLDINGS   AAWW 2004-07-01    16.850000   \n",
      "13  ATLAS TECHNICAL CONSULTANTS INC (A)   ATCX 2019-01-01    10.426000   \n",
      "14                    ATN INTERNATIONAL   ATNI 1991-11-01     4.110885   \n",
      "15                              ATOMERA   ATOM 2016-08-01     9.378000   \n",
      "16                             ATRICURE   ATRC 2005-08-01    13.400000   \n",
      "17                          ATRION CORP   ATRI 1984-12-01    12.386710   \n",
      "18                               AUDACY    AUD 1999-01-01    22.786970   \n",
      "19                     AURA BIOSCIENCES   AURA 2021-10-01    14.850000   \n",
      "20       AURINIA PHARMACEUTICALS NASDAQ   AUPH 2014-09-01     3.200000   \n",
      "\n",
      "    Last Value  Last Date     How Much  \n",
      "0    76.709999 2023-05-01   453.064165  \n",
      "1    41.200001 2023-05-05  1439.966594  \n",
      "2     0.448000 2023-04-01   -95.423902  \n",
      "3    14.690000 2023-05-05          inf  \n",
      "4     2.860000 2023-04-01   -84.947369  \n",
      "5     3.320000 2023-04-01   -88.911156  \n",
      "6     0.716200 2023-05-05   -91.223039  \n",
      "7     2.960000 2023-05-05   -83.780822  \n",
      "8     0.266000 2023-04-01   -97.260556  \n",
      "9   125.559998 2023-05-05   680.360450  \n",
      "10   34.830002 2023-04-01   772.138061  \n",
      "11   27.280001 2023-04-01    89.949672  \n",
      "12  100.870003 2023-01-01   498.635018  \n",
      "13   12.190000 2023-04-01    16.919240  \n",
      "14   36.209999 2023-05-01   780.832192  \n",
      "15    7.920000 2023-05-01   -15.547026  \n",
      "16   44.310001 2023-05-01   230.671661  \n",
      "17  613.156311 2023-05-05  4850.114391  \n",
      "18    0.130000 2023-04-01   -99.429499  \n",
      "19    9.280000 2023-04-01   -37.508421  \n",
      "20   11.525000 2023-05-05   260.156233  \n",
      "AVANOS MEDICAL | AVNS | ̭̭2017-11-01 00:00:00-04:00 | ̭̭13.869999885559082 | ̭̭76.70999908447266 | ̭̭2023-05-01 00:00:00-04:00 | ̭̭453.06416523002423\n",
      "                                Company Ticker        IPO  First Value   \n",
      "0               APELLIS PHARMACEUTICALS   APLS 2017-11-01    13.870000  \\\n",
      "1                        ASTEC INDS INC   ASTE 1986-06-01     2.675383   \n",
      "2                       ASTRA SPACE INC   ASTR 2020-10-01     9.790000   \n",
      "3                             ASTRONICS   ATRO 1984-12-01     0.000000   \n",
      "4                 ATARA BIOTHERAPEUTICS   ATRA 2014-10-01    19.000000   \n",
      "5                  ATEA PHARMACEUTICALS   AVIR 2020-10-01    29.940001   \n",
      "6                           ATERIAN INC   ATER 2019-06-01     8.160000   \n",
      "7                         ATHIRA PHARMA   ATHA 2020-09-01    18.250000   \n",
      "8          ATI PHYSICAL THERAPY INC (A)   ATIP 2020-10-01     9.710000   \n",
      "9                            ATKORE INC   ATKR 2016-06-01    16.090000   \n",
      "10            ATLANTIC UNION BANKSHARES    AUB 1993-10-01     3.993634   \n",
      "11             ATLANTICUS HOLDINGS CORP   ATLC 1999-04-01    14.361699   \n",
      "12         ATLAS AIR WORLDWIDE HOLDINGS   AAWW 2004-07-01    16.850000   \n",
      "13  ATLAS TECHNICAL CONSULTANTS INC (A)   ATCX 2019-01-01    10.426000   \n",
      "14                    ATN INTERNATIONAL   ATNI 1991-11-01     4.110885   \n",
      "15                              ATOMERA   ATOM 2016-08-01     9.378000   \n",
      "16                             ATRICURE   ATRC 2005-08-01    13.400000   \n",
      "17                          ATRION CORP   ATRI 1984-12-01    12.386710   \n",
      "18                               AUDACY    AUD 1999-01-01    22.786970   \n",
      "19                     AURA BIOSCIENCES   AURA 2021-10-01    14.850000   \n",
      "20       AURINIA PHARMACEUTICALS NASDAQ   AUPH 2014-09-01     3.200000   \n",
      "21                       AVANOS MEDICAL   AVNS 2014-10-01    37.520000   \n",
      "\n",
      "    Last Value  Last Date     How Much  \n",
      "0    76.709999 2023-05-01   453.064165  \n",
      "1    41.200001 2023-05-05  1439.966594  \n",
      "2     0.448000 2023-04-01   -95.423902  \n",
      "3    14.690000 2023-05-05          inf  \n",
      "4     2.860000 2023-04-01   -84.947369  \n",
      "5     3.320000 2023-04-01   -88.911156  \n",
      "6     0.716200 2023-05-05   -91.223039  \n",
      "7     2.960000 2023-05-05   -83.780822  \n",
      "8     0.266000 2023-04-01   -97.260556  \n",
      "9   125.559998 2023-05-05   680.360450  \n",
      "10   34.830002 2023-04-01   772.138061  \n",
      "11   27.280001 2023-04-01    89.949672  \n",
      "12  100.870003 2023-01-01   498.635018  \n",
      "13   12.190000 2023-04-01    16.919240  \n",
      "14   36.209999 2023-05-01   780.832192  \n",
      "15    7.920000 2023-05-01   -15.547026  \n",
      "16   44.310001 2023-05-01   230.671661  \n",
      "17  613.156311 2023-05-05  4850.114391  \n",
      "18    0.130000 2023-04-01   -99.429499  \n",
      "19    9.280000 2023-04-01   -37.508421  \n",
      "20   11.525000 2023-05-05   260.156233  \n",
      "21   29.610001 2023-04-01   -21.082089  \n"
     ]
    },
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m/tmp/ipykernel_127498/2074426207.py\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m     45\u001b[0m                         \u001b[0mcompany\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msplited\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mc\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     46\u001b[0m                         \u001b[0mticker\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msplited\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mc\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 47\u001b[0;31m                         \u001b[0maddRow\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrows\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcompany\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mticker\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     48\u001b[0m                         \u001b[0;31m#df.loc[len(df.index)] = [company, ticker, ipo, firstValue, lastValue, lastDate, howMuchPercent]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     49\u001b[0m                         \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m \u001b[0mcompany\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;34m\" | \"\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mticker\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;34m\" | ̭̭\"\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mipo\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;34m\" | ̭̭\"\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfirstValue\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;34m\" | ̭̭\"\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlastValue\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;34m\" | ̭̭\"\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlastDate\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;34m\" | ̭̭\"\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mhowMuchPercent\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/tmp/ipykernel_127498/2074426207.py\u001b[0m in \u001b[0;36maddRow\u001b[0;34m(rows, company, ticker)\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;32mdef\u001b[0m \u001b[0maddRow\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrows\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcompany\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mticker\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      2\u001b[0m         \u001b[0mco\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0myf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mTicker\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mticker\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 3\u001b[0;31m         \u001b[0mhistory\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mco\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhistory\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mperiod\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m\"max\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0minterval\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m\"3mo\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      4\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m                 \u001b[0mipo\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mhistory\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtz_localize\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.10/site-packages/yfinance/base.py\u001b[0m in \u001b[0;36mhistory\u001b[0;34m(self, period, interval, start, end, prepost, actions, auto_adjust, back_adjust, repair, keepna, proxy, rounding, timeout, debug, raise_errors)\u001b[0m\n\u001b[1;32m    142\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mstart\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0mperiod\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0mperiod\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mlower\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;34m\"max\"\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    143\u001b[0m             \u001b[0;31m# Check can get TZ. Fail => probably delisted\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 144\u001b[0;31m             \u001b[0mtz\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_ticker_tz\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdebug\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mproxy\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    145\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mtz\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    146\u001b[0m                 \u001b[0;31m# Every valid ticker has a timezone. Missing = problem\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.10/site-packages/yfinance/base.py\u001b[0m in \u001b[0;36m_get_ticker_tz\u001b[0;34m(self, debug_mode, proxy, timeout)\u001b[0m\n\u001b[1;32m    935\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    936\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mtz\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 937\u001b[0;31m             \u001b[0mtz\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_fetch_ticker_tz\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdebug_mode\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mproxy\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    938\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    939\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mutils\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mis_valid_timezone\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mtz\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.10/site-packages/yfinance/base.py\u001b[0m in \u001b[0;36m_fetch_ticker_tz\u001b[0;34m(self, debug_mode, proxy, timeout)\u001b[0m\n\u001b[1;32m    955\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    956\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 957\u001b[0;31m             \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_data\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcache_get\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0murl\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0murl\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mparams\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mproxy\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mproxy\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mtimeout\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    958\u001b[0m             \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdata\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mjson\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    959\u001b[0m         \u001b[0;32mexcept\u001b[0m \u001b[0mException\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.10/site-packages/yfinance/data.py\u001b[0m in \u001b[0;36mwrapped\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m     41\u001b[0m         \u001b[0margs\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mtuple\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mtuple\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0marg\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0marg\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlist\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32melse\u001b[0m \u001b[0marg\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0marg\u001b[0m \u001b[0;32min\u001b[0m \u001b[0margs\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     42\u001b[0m         \u001b[0mkwargs\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m{\u001b[0m\u001b[0mk\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mtuple\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mv\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mv\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlist\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32melse\u001b[0m \u001b[0mv\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mk\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mv\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mkwargs\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m}\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 43\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     44\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     45\u001b[0m     \u001b[0;31m# copy over the lru_cache extra methods to this wrapper to be able to access them\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.10/site-packages/yfinance/data.py\u001b[0m in \u001b[0;36mcache_get\u001b[0;34m(self, url, user_agent_headers, params, proxy, timeout)\u001b[0m\n\u001b[1;32m    195\u001b[0m     \u001b[0;34m@\u001b[0m\u001b[0mlru_cache\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mmaxsize\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcache_maxsize\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    196\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mcache_get\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0murl\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0muser_agent_headers\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mproxy\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m30\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 197\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0murl\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0muser_agent_headers\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mproxy\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    198\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    199\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_get_proxy\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mproxy\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.10/site-packages/yfinance/data.py\u001b[0m in \u001b[0;36mget\u001b[0;34m(self, url, user_agent_headers, params, proxy, timeout)\u001b[0m\n\u001b[1;32m    184\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0murl\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0muser_agent_headers\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mproxy\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m30\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    185\u001b[0m         \u001b[0mproxy\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_proxy\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mproxy\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 186\u001b[0;31m         response = self._session.get(\n\u001b[0m\u001b[1;32m    187\u001b[0m             \u001b[0murl\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0murl\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    188\u001b[0m             \u001b[0mparams\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mparams\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.10/site-packages/requests/api.py\u001b[0m in \u001b[0;36mget\u001b[0;34m(url, params, **kwargs)\u001b[0m\n\u001b[1;32m     71\u001b[0m     \"\"\"\n\u001b[1;32m     72\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 73\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0mrequest\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"get\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0murl\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mparams\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     74\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     75\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.10/site-packages/requests/api.py\u001b[0m in \u001b[0;36mrequest\u001b[0;34m(method, url, **kwargs)\u001b[0m\n\u001b[1;32m     57\u001b[0m     \u001b[0;31m# cases, and look like a memory leak in others.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     58\u001b[0m     \u001b[0;32mwith\u001b[0m \u001b[0msessions\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mSession\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0msession\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 59\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0msession\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrequest\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mmethod\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0murl\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0murl\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     60\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     61\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.10/site-packages/requests/sessions.py\u001b[0m in \u001b[0;36mrequest\u001b[0;34m(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)\u001b[0m\n\u001b[1;32m    585\u001b[0m         }\n\u001b[1;32m    586\u001b[0m         \u001b[0msend_kwargs\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mupdate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msettings\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 587\u001b[0;31m         \u001b[0mresp\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mprep\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0msend_kwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    588\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    589\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mresp\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.10/site-packages/requests/sessions.py\u001b[0m in \u001b[0;36msend\u001b[0;34m(self, request, **kwargs)\u001b[0m\n\u001b[1;32m    699\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    700\u001b[0m         \u001b[0;31m# Send the request\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 701\u001b[0;31m         \u001b[0mr\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0madapter\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrequest\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    702\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    703\u001b[0m         \u001b[0;31m# Total elapsed time of the request (approximately)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.10/site-packages/requests/adapters.py\u001b[0m in \u001b[0;36msend\u001b[0;34m(self, request, stream, timeout, verify, cert, proxies)\u001b[0m\n\u001b[1;32m    487\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    488\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mchunked\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 489\u001b[0;31m                 resp = conn.urlopen(\n\u001b[0m\u001b[1;32m    490\u001b[0m                     \u001b[0mmethod\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mrequest\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmethod\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    491\u001b[0m                     \u001b[0murl\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0murl\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/lib/python3/dist-packages/urllib3/connectionpool.py\u001b[0m in \u001b[0;36murlopen\u001b[0;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[1;32m    697\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    698\u001b[0m             \u001b[0;31m# Make the request on the httplib connection object.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 699\u001b[0;31m             httplib_response = self._make_request(\n\u001b[0m\u001b[1;32m    700\u001b[0m                 \u001b[0mconn\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    701\u001b[0m                 \u001b[0mmethod\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/lib/python3/dist-packages/urllib3/connectionpool.py\u001b[0m in \u001b[0;36m_make_request\u001b[0;34m(self, conn, method, url, timeout, chunked, **httplib_request_kw)\u001b[0m\n\u001b[1;32m    380\u001b[0m         \u001b[0;31m# Trigger any extra validation we need to do.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    381\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 382\u001b[0;31m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_validate_conn\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mconn\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    383\u001b[0m         \u001b[0;32mexcept\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mSocketTimeout\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mBaseSSLError\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    384\u001b[0m             \u001b[0;31m# Py2 raises this as a BaseSSLError, Py3 raises it as socket timeout.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/lib/python3/dist-packages/urllib3/connectionpool.py\u001b[0m in \u001b[0;36m_validate_conn\u001b[0;34m(self, conn)\u001b[0m\n\u001b[1;32m   1010\u001b[0m         \u001b[0;31m# Force connect early to allow us to validate the connection.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1011\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mgetattr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mconn\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m\"sock\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m  \u001b[0;31m# AppEngine might not have  `.sock`\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1012\u001b[0;31m             \u001b[0mconn\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mconnect\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1013\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1014\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mconn\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mis_verified\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/lib/python3/dist-packages/urllib3/connection.py\u001b[0m in \u001b[0;36mconnect\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    351\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mconnect\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    352\u001b[0m         \u001b[0;31m# Add certificate verification\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 353\u001b[0;31m         \u001b[0mconn\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_new_conn\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    354\u001b[0m         \u001b[0mhostname\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhost\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    355\u001b[0m         \u001b[0mtls_in_tls\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mFalse\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/lib/python3/dist-packages/urllib3/connection.py\u001b[0m in \u001b[0;36m_new_conn\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    167\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    168\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 169\u001b[0;31m             conn = connection.create_connection(\n\u001b[0m\u001b[1;32m    170\u001b[0m                 \u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_dns_host\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mport\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtimeout\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mextra_kw\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    171\u001b[0m             )\n",
      "\u001b[0;32m/usr/lib/python3/dist-packages/urllib3/util/connection.py\u001b[0m in \u001b[0;36mcreate_connection\u001b[0;34m(address, timeout, source_address, socket_options)\u001b[0m\n\u001b[1;32m     84\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0msource_address\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     85\u001b[0m                 \u001b[0msock\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mbind\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msource_address\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 86\u001b[0;31m             \u001b[0msock\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mconnect\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msa\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     87\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0msock\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     88\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
     ]
    }
   ],
   "source": [
    "def addRow(rows, company, ticker):\n",
    "\tco = yf.Ticker(ticker)\n",
    "\thistory = co.history(period=\"max\", interval=\"3mo\")\n",
    "\ttry:\n",
    "\t\tipo = history.index[0].tz_localize(None)\n",
    "\t\tfirstValue = history.iloc[0,0]\n",
    "\t\tlastValue = history.iloc[-1,0]\n",
    "\t\tlastDate = history.index[-1].tz_localize(None)\n",
    "\t\thowMuchPercent = ((lastValue - firstValue) / firstValue) * 100\n",
    "\texcept:\n",
    "\t\tipo = None\n",
    "\t\tfirstValue = None\n",
    "\t\tlastValue = None\n",
    "\t\tlastDate = None\n",
    "\t\thowMuchPercent = None\n",
    "\trow = [company, ticker, ipo, firstValue, lastValue, lastDate, howMuchPercent]\n",
    "\t# add row in the dataframe\n",
    "\trows.append(row)\n",
    "\treturn \n",
    "\n",
    "\n",
    "columns = ['Company', 'Ticker', 'IPO', 'First Value', 'Last Value',\n",
    "\t   \t\t 'Last Date', 'How Much']\n",
    "rows = []\n",
    "# Lê até encontrar as strings que indicam final\n",
    "while True:\n",
    "\tpage = pages[p]\n",
    "\tpage_content = page.extract_text()\n",
    "\tparsed = ''.join(page_content)\n",
    "\tsplited = parsed.split('\\n')\n",
    "\tprint(\"\\n\\n---------------------\")\n",
    "\tprint(\"Página \" + str(p+1))\n",
    "\tprint(\"---------------------\\n\")\n",
    "\tif p != 9: # Tratamento normal - a não ser a página 10 (no else) que está fora do padrão\n",
    "\t\tc = 0\n",
    "\t\t#cabeçalhos\n",
    "\t\tprint(splited[c] + \" | \" + splited[c+1])\n",
    "\t\tc += 2\n",
    "\t\tended = False\n",
    "\t\twhile splited[c] != \"June 24, 2022\": #String do fim de cada página\n",
    "\t\t\tif splited[c] == \"ftserussell.com\": #String no final de toda a lista\n",
    "\t\t\t\tprint(\"----------------\\nTerminou\\n----------------\")\n",
    "\t\t\t\tended = True\n",
    "\t\t\t\tbreak\n",
    "\t\t\tcompany = splited[c]\n",
    "\t\t\tticker = splited[c+1]\n",
    "\t\t\taddRow(rows, company, ticker)\n",
    "\t\t\t#df.loc[len(df.index)] = [company, ticker, ipo, firstValue, lastValue, lastDate, howMuchPercent]\n",
    "\t\t\tprint( company + \" | \" + ticker + \" | ̭̭\" + str(ipo) + \" | ̭̭\" + str(firstValue) + \" | ̭̭\" + str(lastValue) + \" | ̭̭\" + str(lastDate) + \" | ̭̭\" + str(howMuchPercent))\n",
    "\t\t\tc += 2\n",
    "\t\t\t#df.to_csv('SuperTempShares.csv', date_format=\"%d/%m/%Y\")\n",
    "\t\t\tdf = pd.DataFrame(rows, columns = columns)\n",
    "\t\t\tprint(df)\n",
    "\t\t\tdf.to_excel('SuperTempShares.xlsx')\n",
    "\n",
    "\n",
    "\telse:\n",
    "\t\t# Na página 10 o PDF fica sem quebra de linhas entre colunas\n",
    "\t\t\n",
    "\t\t# cabeçalhos\n",
    "\t\tc = 0\n",
    "\t\t# separa o ticker, que está no lado direito\n",
    "\t\theaders = splited[c].rsplit(maxsplit=1)\n",
    "\t\tprint(headers[0] + \" | \" + headers[1])\n",
    "\t\tc += 1\n",
    "\t\twhile splited[c][:13] != \"June 24, 2022\":\n",
    "\t\t\t# separa o ticker, que está a direita\n",
    "\t\t\tsubsplited = splited[c].rsplit(maxsplit=1)\n",
    "\t\t\tcompany = subsplited[0]\n",
    "\t\t\tticker = subsplited[1]\n",
    "\t\t\taddRow(rows, ticker)\n",
    "\t\t\t#df.loc[len(df.index)] = [company, ticker, ipo, firstValue, lastValue, lastDate, howMuchPercent]\n",
    "\t\t\tprint( company + \" | \" + ticker + \" | ̭̭\" + str(ipo) + \" | ̭̭\" + str(firstValue) + \" | ̭̭\" + str(lastValue) + \" | ̭̭\" + str(lastDate) + \" | ̭̭\" + str(howMuchPercent))\n",
    "\t\t\tc += 1\n",
    "\n",
    "\tif ended:\n",
    "\t\tprint(\"----------------\\nTerminou Mesmo\\n----------------\")\n",
    "\t\tbreak\n",
    "\n",
    "\tp += 1\n",
    "\tdf = pd.DataFrame(rows, columns = columns)\n",
    "\t\n",
    "\t#print(df)\n",
    "\t#df.to_excel('TempShares.xlsx')\n",
    "\n",
    "print(df)\n",
    "df.to_excel('Shares.xlsx')\n",
    "\n",
    "#print(\"Sem eliminar as quebras\")\n",
    "#print(parsed)\n",
    "\n",
    "#parsed = re.sub('n', '', parsed)\n",
    "#print(\"Após eliminar as quebras\")\n",
    "#print(parsed)\n",
    "\n",
    "#print(\"Pegando apenas as 20 primeiras posições\")\n",
    "#novastring = parsed[0:20]\n",
    "#print(novastring)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Usando pdfplumber:\n"
     ]
    },
    {
     "ename": "FileNotFoundError",
     "evalue": "[Errno 2] No such file or directory: 'listagem.pdf'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[1], line 38\u001b[0m\n\u001b[0;32m     35\u001b[0m pdf_path \u001b[38;5;241m=\u001b[39m \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mlistagem.pdf\u001b[39m\u001b[38;5;124m\"\u001b[39m\n\u001b[0;32m     37\u001b[0m \u001b[38;5;28mprint\u001b[39m(\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mUsando pdfplumber:\u001b[39m\u001b[38;5;124m\"\u001b[39m)\n\u001b[1;32m---> 38\u001b[0m \u001b[43mextract_text_from_pdf\u001b[49m\u001b[43m(\u001b[49m\u001b[43mpdf_path\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m     40\u001b[0m \u001b[38;5;28mprint\u001b[39m(\u001b[38;5;124m\"\u001b[39m\u001b[38;5;130;01m\\n\u001b[39;00m\u001b[38;5;124mUsando PyMuPDF:\u001b[39m\u001b[38;5;124m\"\u001b[39m)\n\u001b[0;32m     41\u001b[0m extract_text_boxes_with_pymupdf(pdf_path)\n",
      "Cell \u001b[1;32mIn[1], line 6\u001b[0m, in \u001b[0;36mextract_text_from_pdf\u001b[1;34m(pdf_path)\u001b[0m\n\u001b[0;32m      4\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mextract_text_from_pdf\u001b[39m(pdf_path):\n\u001b[0;32m      5\u001b[0m     \u001b[38;5;66;03m# Usando pdfplumber para abrir o PDF\u001b[39;00m\n\u001b[1;32m----> 6\u001b[0m     \u001b[38;5;28;01mwith\u001b[39;00m \u001b[43mpdfplumber\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mopen\u001b[49m\u001b[43m(\u001b[49m\u001b[43mpdf_path\u001b[49m\u001b[43m)\u001b[49m \u001b[38;5;28;01mas\u001b[39;00m pdf:\n\u001b[0;32m      7\u001b[0m         \u001b[38;5;28;01mfor\u001b[39;00m page_num, page \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28menumerate\u001b[39m(pdf\u001b[38;5;241m.\u001b[39mpages):\n\u001b[0;32m      8\u001b[0m             \u001b[38;5;28mprint\u001b[39m(\u001b[38;5;124mf\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;130;01m\\n\u001b[39;00m\u001b[38;5;124mPágina \u001b[39m\u001b[38;5;132;01m{\u001b[39;00mpage_num\u001b[38;5;250m \u001b[39m\u001b[38;5;241m+\u001b[39m\u001b[38;5;250m \u001b[39m\u001b[38;5;241m1\u001b[39m\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m\"\u001b[39m)\n",
      "File \u001b[1;32mc:\\Users\\Jamur\\Prog\\LeitorDePDF\\.venv\\Lib\\site-packages\\pdfplumber\\pdf.py:86\u001b[0m, in \u001b[0;36mPDF.open\u001b[1;34m(cls, path_or_fp, pages, laparams, password, strict_metadata, repair, gs_path)\u001b[0m\n\u001b[0;32m     84\u001b[0m     path \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;01mNone\u001b[39;00m\n\u001b[0;32m     85\u001b[0m \u001b[38;5;28;01melif\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(path_or_fp, (\u001b[38;5;28mstr\u001b[39m, pathlib\u001b[38;5;241m.\u001b[39mPath)):\n\u001b[1;32m---> 86\u001b[0m     stream \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mopen\u001b[39;49m\u001b[43m(\u001b[49m\u001b[43mpath_or_fp\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[38;5;124;43mrb\u001b[39;49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[43m)\u001b[49m\n\u001b[0;32m     87\u001b[0m     stream_is_external \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;01mFalse\u001b[39;00m\n\u001b[0;32m     88\u001b[0m     path \u001b[38;5;241m=\u001b[39m pathlib\u001b[38;5;241m.\u001b[39mPath(path_or_fp)\n",
      "\u001b[1;31mFileNotFoundError\u001b[0m: [Errno 2] No such file or directory: 'listagem.pdf'"
     ]
    }
   ],
   "source": [
    "import pdfplumber\n",
    "import fitz  # PyMuPDF\n",
    "\n",
    "def extract_text_from_pdf(pdf_path):\n",
    "    # Usando pdfplumber para abrir o PDF\n",
    "    with pdfplumber.open(pdf_path) as pdf:\n",
    "        for page_num, page in enumerate(pdf.pages):\n",
    "            print(f\"\\nPágina {page_num + 1}\")\n",
    "            \n",
    "            # Extraindo caixas de texto usando pdfplumber\n",
    "            words = page.extract_words(use_text_flow=True)\n",
    "            \n",
    "            # Imprimindo as caixas de texto\n",
    "            for word in words:\n",
    "                print(f\"Texto: {word['text']}\")\n",
    "                print(f\"Caixa: {word['x0'], word['top'], word['x1'], word['bottom']}\\n\")\n",
    "\n",
    "def extract_text_boxes_with_pymupdf(pdf_path):\n",
    "    # Usando PyMuPDF para abrir o PDF\n",
    "    doc = fitz.open(pdf_path)\n",
    "    for page_num in range(len(doc)):\n",
    "        page = doc.load_page(page_num)\n",
    "        print(f\"\\nPágina {page_num + 1}\")\n",
    "\n",
    "        # Extraindo caixas de texto usando PyMuPDF\n",
    "        boxes = page.get_text(\"dict\")[\"blocks\"]\n",
    "        for box in boxes:\n",
    "            if \"lines\" in box:\n",
    "                for line in box[\"lines\"]:\n",
    "                    for span in line[\"spans\"]:\n",
    "                        print(f\"Texto: {span['text']}\")\n",
    "                        print(f\"Caixa: {span['bbox']}\\n\")\n",
    "\n",
    "# Caminho para o seu arquivo PDF\n",
    "pdf_path = \"listagem.pdf\"\n",
    "\n",
    "print(\"Usando pdfplumber:\")\n",
    "extract_text_from_pdf(pdf_path)\n",
    "\n",
    "print(\"\\nUsando PyMuPDF:\")\n",
    "extract_text_boxes_with_pymupdf(pdf_path)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Diretório atual de trabalho: c:\\Users\\Jamur\\Prog\\LeitorDePDF\n",
      "O arquivo listagem.pdf existe.\n",
      "Usando pdfplumber:\n",
      "\n",
      "Página 1\n",
      "\n",
      "Página 2\n",
      "\n",
      "Página 3\n",
      "\n",
      "Página 4\n",
      "\n",
      "Página 5\n",
      "\n",
      "Página 6\n",
      "\n",
      "Página 7\n",
      "\n",
      "Página 8\n",
      "\n",
      "Página 9\n",
      "\n",
      "Página 10\n",
      "\n",
      "Página 11\n",
      "\n",
      "Página 12\n",
      "\n",
      "Página 13\n",
      "\n",
      "Página 14\n",
      "\n",
      "Página 15\n",
      "\n",
      "Página 16\n",
      "\n",
      "Página 17\n",
      "\n",
      "Página 18\n",
      "\n",
      "Página 19\n",
      "\n",
      "Página 20\n",
      "\n",
      "Página 21\n",
      "\n",
      "Página 22\n",
      "\n",
      "Página 23\n",
      "\n",
      "Página 24\n",
      "\n",
      "Página 25\n",
      "\n",
      "Usando PyMuPDF:\n",
      "\n",
      "Página 1\n",
      "\n",
      "Página 2\n",
      "\n",
      "Página 3\n",
      "\n",
      "Página 4\n",
      "\n",
      "Página 5\n",
      "\n",
      "Página 6\n",
      "\n",
      "Página 7\n",
      "\n",
      "Página 8\n",
      "\n",
      "Página 9\n",
      "\n",
      "Página 10\n",
      "\n",
      "Página 11\n",
      "\n",
      "Página 12\n",
      "\n",
      "Página 13\n",
      "\n",
      "Página 14\n",
      "\n",
      "Página 15\n",
      "\n",
      "Página 16\n",
      "\n",
      "Página 17\n",
      "\n",
      "Página 18\n",
      "\n",
      "Página 19\n",
      "\n",
      "Página 20\n",
      "\n",
      "Página 21\n",
      "\n",
      "Página 22\n",
      "\n",
      "Página 23\n",
      "\n",
      "Página 24\n",
      "\n",
      "Página 25\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "\n",
    "# Verifique o diretório atual de trabalho\n",
    "current_directory = os.getcwd()\n",
    "print(f\"Diretório atual de trabalho: {current_directory}\")\n",
    "\n",
    "# Verifique se o arquivo existe no diretório atual\n",
    "file_path = 'listagem.pdf'\n",
    "if os.path.isfile(file_path):\n",
    "    print(f\"O arquivo {file_path} existe.\")\n",
    "else:\n",
    "    print(f\"O arquivo {file_path} não foi encontrado no diretório {current_directory}.\")\n",
    "\n",
    "# Continuação do seu código para extrair texto do PDF\n",
    "import pdfplumber\n",
    "import fitz  # PyMuPDF\n",
    "\n",
    "def extract_text_from_pdf(pdf_path):\n",
    "    with pdfplumber.open(pdf_path) as pdf:\n",
    "        for page_num, page in enumerate(pdf.pages):\n",
    "            print(f\"\\nPágina {page_num + 1}\")\n",
    "            words = page.extract_words(use_text_flow=True)\n",
    "            for word in words:\n",
    "                print(f\"Texto: {word['text']}\")\n",
    "                print(f\"Caixa: {word['x0'], word['top'], word['x1'], word['bottom']}\\n\")\n",
    "\n",
    "def extract_text_boxes_with_pymupdf(pdf_path):\n",
    "    doc = fitz.open(pdf_path)\n",
    "    for page_num in range(len(doc)):\n",
    "        page = doc.load_page(page_num)\n",
    "        print(f\"\\nPágina {page_num + 1}\")\n",
    "        boxes = page.get_text(\"dict\")[\"blocks\"]\n",
    "        for box in boxes:\n",
    "            if \"lines\" in box:\n",
    "                for line in box[\"lines\"]:\n",
    "                    for span in line[\"spans\"]:\n",
    "                        print(f\"Texto: {span['text']}\")\n",
    "                        print(f\"Caixa: {span['bbox']}\\n\")\n",
    "\n",
    "pdf_path = 'listagem.pdf'\n",
    "\n",
    "print(\"Usando pdfplumber:\")\n",
    "extract_text_from_pdf(pdf_path)\n",
    "\n",
    "print(\"\\nUsando PyMuPDF:\")\n",
    "extract_text_boxes_with_pymupdf(pdf_path)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "O PDF não está protegido por senha.\n",
      "\n",
      "Página 1\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 2\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 3\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 4\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 5\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 6\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 7\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 8\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 9\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 10\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 11\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 12\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 13\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 14\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 15\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 16\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 17\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 18\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 19\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 20\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 21\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 22\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 23\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 24\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n",
      "\n",
      "Página 25\n",
      "{'width': 595.3200073242188, 'height': 841.9200439453125, 'blocks': []}\n"
     ]
    }
   ],
   "source": [
    "import fitz  # PyMuPDF\n",
    "\n",
    "# Caminho para o seu arquivo PDF\n",
    "pdf_path = 'listagem.pdf'\n",
    "\n",
    "# Abrindo o PDF com PyMuPDF\n",
    "doc = fitz.open(pdf_path)\n",
    "\n",
    "# Verificar se o PDF está protegido\n",
    "if doc.is_encrypted:\n",
    "    print(\"O PDF está protegido por senha.\")\n",
    "else:\n",
    "    print(\"O PDF não está protegido por senha.\")\n",
    "\n",
    "# Iterar sobre as páginas e imprimir a estrutura\n",
    "for page_num in range(len(doc)):\n",
    "    page = doc.load_page(page_num)\n",
    "    print(f\"\\nPágina {page_num + 1}\")\n",
    "    \n",
    "    # Extraindo informações detalhadas\n",
    "    text = page.get_text(\"dict\")\n",
    "    print(text)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Texto extraído salvo em 'extracted_text.txt'\n"
     ]
    }
   ],
   "source": [
    "import pytesseract\n",
    "\n",
    "# Ajuste o caminho para onde o Tesseract está instalado no seu sistema\n",
    "pytesseract.pytesseract.tesseract_cmd = r'C:\\Program Files\\Tesseract-OCR\\tesseract.exe'  # Windows\n",
    "# pytesseract.pytesseract.tesseract_cmd = '/usr/local/bin/tesseract'  # Mac/Linux\n",
    "\n",
    "import fitz  # PyMuPDF\n",
    "from PIL import Image\n",
    "import pytesseract\n",
    "\n",
    "def pdf_to_text_with_ocr(pdf_path):\n",
    "    doc = fitz.open(pdf_path)\n",
    "    text = \"\"\n",
    "    \n",
    "    for page_num in range(len(doc)):\n",
    "        page = doc.load_page(page_num)\n",
    "        \n",
    "        # Converte a página do PDF em imagem\n",
    "        pix = page.get_pixmap()\n",
    "        img = Image.frombytes(\"RGB\", [pix.width, pix.height], pix.samples)\n",
    "        \n",
    "        # Usa OCR para extrair texto da imagem\n",
    "        page_text = pytesseract.image_to_string(img, lang=\"por\")  # Usando o idioma português\n",
    "        text += f\"\\nPágina {page_num + 1}\\n\"\n",
    "        text += page_text\n",
    "    \n",
    "    return text\n",
    "\n",
    "# Caminho para o seu arquivo PDF\n",
    "pdf_path = 'listagem.pdf'\n",
    "\n",
    "# Extrair texto usando OCR\n",
    "extracted_text = pdf_to_text_with_ocr(pdf_path)\n",
    "\n",
    "# Salvar o texto extraído em um arquivo\n",
    "with open(\"extracted_text.txt\", \"w\", encoding=\"utf-8\") as text_file:\n",
    "    text_file.write(extracted_text)\n",
    "\n",
    "print(\"Texto extraído salvo em 'extracted_text.txt'\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Imagens salvas na pasta 'imagens' e texto extraído salvo em 'extracted_text.txt'\n"
     ]
    }
   ],
   "source": [
    "import fitz  # PyMuPDF\n",
    "from PIL import Image\n",
    "import pytesseract\n",
    "import os\n",
    "\n",
    "# Configure o caminho do Tesseract, se necessário\n",
    "pytesseract.pytesseract.tesseract_cmd = r'C:\\Program Files\\Tesseract-OCR\\tesseract.exe'  # Windows\n",
    "# pytesseract.pytesseract.tesseract_cmd = '/usr/local/bin/tesseract'  # Mac/Linux\n",
    "\n",
    "def pdf_to_images_and_text_with_ocr(pdf_path, image_folder):\n",
    "    # Verifique se a pasta 'imagens' existe, se não, crie-a\n",
    "    if not os.path.exists(image_folder):\n",
    "        os.makedirs(image_folder)\n",
    "\n",
    "    doc = fitz.open(pdf_path)\n",
    "    text = \"\"\n",
    "\n",
    "    for page_num in range(len(doc)):\n",
    "        page = doc.load_page(page_num)\n",
    "        \n",
    "        # Converte a página do PDF em imagem\n",
    "        pix = page.get_pixmap()\n",
    "        img = Image.frombytes(\"RGB\", [pix.width, pix.height], pix.samples)\n",
    "        \n",
    "        # Salvar a imagem da página na pasta 'imagens'\n",
    "        image_path = os.path.join(image_folder, f\"pagina_{page_num + 1}.png\")\n",
    "        img.save(image_path)\n",
    "\n",
    "        # Usa OCR para extrair texto da imagem\n",
    "        page_text = pytesseract.image_to_string(img, lang=\"por\")  # Usando o idioma português\n",
    "        text += f\"\\nPágina {page_num + 1}\\n\"\n",
    "        text += page_text\n",
    "\n",
    "    return text\n",
    "\n",
    "# Caminho para o seu arquivo PDF\n",
    "pdf_path = 'listagem.pdf'\n",
    "# Pasta onde as imagens serão salvas\n",
    "image_folder = 'imagens'\n",
    "\n",
    "# Extrair texto e salvar imagens\n",
    "extracted_text = pdf_to_images_and_text_with_ocr(pdf_path, image_folder)\n",
    "\n",
    "# Salvar o texto extraído em um arquivo\n",
    "with open(\"extracted_text.txt\", \"w\", encoding=\"utf-8\") as text_file:\n",
    "    text_file.write(extracted_text)\n",
    "\n",
    "print(\"Imagens salvas na pasta 'imagens' e texto extraído salvo em 'extracted_text.txt'\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Imagens salvas na pasta 'imagens' e texto extraído salvo em 'extracted_text.txt'\n"
     ]
    }
   ],
   "source": [
    "import fitz  # PyMuPDF\n",
    "from PIL import Image\n",
    "import pytesseract\n",
    "import os\n",
    "\n",
    "# Configure o caminho do Tesseract, se necessário\n",
    "pytesseract.pytesseract.tesseract_cmd = r'C:\\Program Files\\Tesseract-OCR\\tesseract.exe'  # Windows\n",
    "# pytesseract.pytesseract.tesseract_cmd = '/usr/local/bin/tesseract'  # Mac/Linux\n",
    "\n",
    "def pdf_to_images_and_text_with_ocr(pdf_path, image_folder, zoom=2):\n",
    "    # Verifique se a pasta 'imagens' existe, se não, crie-a\n",
    "    if not os.path.exists(image_folder):\n",
    "        os.makedirs(image_folder)\n",
    "\n",
    "    doc = fitz.open(pdf_path)\n",
    "    text = \"\"\n",
    "\n",
    "    for page_num in range(len(doc)):\n",
    "        page = doc.load_page(page_num)\n",
    "        \n",
    "        # Aumentar a resolução da imagem\n",
    "        mat = fitz.Matrix(zoom, zoom)\n",
    "        pix = page.get_pixmap(matrix=mat)\n",
    "        \n",
    "        # Converte a página do PDF em imagem\n",
    "        img = Image.frombytes(\"RGB\", [pix.width, pix.height], pix.samples)\n",
    "        \n",
    "        # Salvar a imagem da página na pasta 'imagens'\n",
    "        image_path = os.path.join(image_folder, f\"pagina_{page_num + 1}.png\")\n",
    "        img.save(image_path, \"PNG\")\n",
    "\n",
    "        # Usa OCR para extrair texto da imagem\n",
    "        page_text = pytesseract.image_to_string(img, lang=\"por\")  # Usando o idioma português\n",
    "        text += f\"\\nPágina {page_num + 1}\\n\"\n",
    "        text += page_text\n",
    "\n",
    "    return text\n",
    "\n",
    "# Caminho para o seu arquivo PDF\n",
    "pdf_path = 'listagem.pdf'\n",
    "# Pasta onde as imagens serão salvas\n",
    "image_folder = 'imagens'\n",
    "\n",
    "# Extrair texto e salvar imagens\n",
    "extracted_text = pdf_to_images_and_text_with_ocr(pdf_path, image_folder, zoom=2)\n",
    "\n",
    "# Salvar o texto extraído em um arquivo\n",
    "with open(\"extracted_text.txt\", \"w\", encoding=\"utf-8\") as text_file:\n",
    "    text_file.write(extracted_text)\n",
    "\n",
    "print(\"Imagens salvas na pasta 'imagens' e texto extraído salvo em 'extracted_text.txt'\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['EVENTOS REMOVIDOS', 'ACES Algarve | - Algarve Central', 'Unidade de Saúde: USF GOLFINHO', 'Profissional: RUI FILIPE CARMO', '', 'Data Hora Tipo de evento Nome Nº SNS', '27-05-2024 08:30 PLANEAMENTO FAMILIAR TÂNIA SOFIA CABRITA PEREIRA 597520326', '27-05-2024 09:00 PLANEAMENTO FAMILIAR RUTE ISABEL CALARRÃO ARRAIOLOS 366330654', '27-05-2024 09:30 PLANEAMENTO FAMILIAR DÉBORA CRISTINA DOMINGOS VARELA s98679735', '27-05-2024 09:30 SAUDE MATERNA SELMA RAQUEL SOUSA MENDONÇA 596391485', '27-05-2024 09:48 SAUDE MATERNA NATHANA LAZZAROTTO CRISTOFOLI 592950183', '27-05-2024 10:00 PLANEAMENTO FAMILIAR CÁTIA SOFIA RODRIGUES DIAS MATEUS 596379034', '27-05-2024 10:06 SAUDE MATERNA ANA MARGARIDA GABADINHO TEIXEIRA 597294595', '27-05-2024 10:24 SAUDE MATERIPLANEAMENTO ANA SARA DA SILVA MAXIMIANO 398499153', '27-05-2024 10:30 PLANEAMENTO FAMILIAR CARINA ISABEL TEIXEIRA MARTINS 596931368', '27-05-2024 10:42 — SAUDE MATERNA SARA MARIA DOS SANTOS DOS REIS 593692013', '27-05-2024 11:00 PLANEAMENTO FAMILIAR MARTA ANDREIA GONÇALVES HENRIQUES 595979254', '27-05-2024 11:00 PLANEAMENTO FAMILIAR MARIA DA CONCEIÇÃO MARQUES FIALHO 495462297', '27-05-2024 11:30 PLANEAMENTO FAMILIAR ISABEL DE JESUS MOURÃO RODRIGUES CARNEIRINHO 595220120', '27-05-2024 11:30 PLANEAMENTO FAMILIAR TATIANA DA CONCEIÇÃO DOMINGOS VARELA 598679743', '27-05-2024 1200 PLANEAMENTO FAMILIAR TÂNIA SOFIA CABRITA PEREIRA 597520326', '27-05-2024 12:00 | SAUDE MATERNA INÊS ISABEL GRAÇA GUERREIRO 498578866', '27-05-2024 1230 PLANEAMENTO FAMILIAR ANDREEA GRAURE 593675465', '27-05-2024 1230 PLANEAMENTO FAMILIAR LUISA RAPELLI 594998346', '27-05-2024 1300 PLANEAMENTO FAMILIAR LORENA DE SOUZA ABE 594340002', '27-05-2024 1330 — RELATORIOS-EXAMES SANDRA CRISTINA MACHADO DA SILVA 181292296', '27-05-2024 1335 — RELATORIOS-EXAMES MARIA CECÍLIA GAIO 594953066', '27-05-2024 1340 — RECEITUARIO FERNANDA PALMA RAPOSO DIAS 597217689', '27-05-2024 1345 — RECEITUARIO JOÃO HENRIQUE TINTIM VEIGA 596921279', '27-05-2024 1350 — OUTRAS ANTÓNIO MANUEL PEREIRA ZITA 595128250', '27-05-2024 1355 RECEITUARIO ISABEL ENGRÁCIA ROSA LOURENÇO 593564532', '27-05-2024 1730 — SAUDE ADULTOS VERÓNICA DA CONCEIÇÃO MARTINS CORREIA 594904963', '27-05-2024 47:51 SAUDE ADULTOS MARIA HELENA DA SILVA RAMOS CAVACO 595246689', '27-05-2024 1800 — SAUDE ADULTOS PATRÍCIA ALEXANDRA LUÍSA VIEGAS 596168367', '27-05-2024 18:12 SAUDE ADULTOS HERMÍNIO FERNANDO PINTO DA SILVA s97673164', '27-05-2024 1820 — SAUDE ADULTOS REINALDO EMÍDIO DE BRITO NORTE 596940504', '27-05-2024 1840 — SAUDE ADULTOS MARIA MANUELA MENDES DOS SANTOS CASIMIRO REIS 595881287', '27-05-2024 18:54 SAUDE ADULTOS BRUNO ALEXANDRE SOUZA BRITO 360735966', '27-05-2024 19:15 — SAUDE ADULTOS JAIME COELHO 595095078', '', 'Processado por computador - SClinico - SPMS, EPE. Rev:: 28149 Documento Impresso em 2024-05-28 Pág. 1/25', '', 'Profissional: RUI FILIPE CARMO', '', '27-05-2024 19:20 — SAUDE ADULTOS IVONE DOS SANTOS PEDRO LEITE 598262079', '28-05-2024 1430 SAUDE INFANTIL CLÁUDIO ALEXANDRE RAMOS HEITOR 970391886', '28-05-2024 1430 SAUDE INFANTIL CLÁUDIO ALEXANDRE RAMOS HEITOR 970391886', '28-05-2024 1500 SAUDE INFANTIL ANDRÉ GARRIDO BENTO gr8ros772', '28-05-2024 1530 SAUDE INFANTIL LUCIANO CAETANO VIEIRA 592970748', '28-05-2024 1600 SAUDE MATER/PLANEAMENTO INÊS ISABEL GRAÇA GUERREIRO 498578866', '28-05-2024 1630 SAUDE ADULTOS PROGRAM. UTENTE RUI JORGE NOGUEIRA DO Ó VINHAS 595715685', '28-05-2024 1650 SAUDE ADULTOS PROGRAM. UTENTE MARTA SOFIA MOCHO GUERREIRO 595101969', '28-05-2024 17:00 — SAUDE ADULTOS PROGRAM. UTENTE SAMUEL DAVID COVAS SARDINHA 596844963', '28-05-2024 1710 SAUDE ADULTOS PROGRAM. UTENTE CRISTINA MARIA INÁCIO PALMEIRA SALES 595923914', '28-05-2024 4730 — SAUDE ADULTOS ANDREIA FILIPA HORTA SILVA 596035172', '28-05-2024 4740 SAUDE ADULTOS PROGRAM. UTENTE PEDRO MIGUEL JOAQUIM RODRIGUES soreso98s', '28-05-2024 1800 — SAUDE ADULTOS VANUZA DA CONCEIÇÃO GONÇALVES DE SOUSA 596501220', '28-05-2024 1812 SAUDE ADULTOS SÓNIA RAQUEL ENGROLA FIALHO 595472363', '28-05-2024 1820 — SAUDE ADULTOS MARIA JOSÉ SERRA APOLINÁRIO BARROS 596460598', '28-05-2024 1840 — SAUDE ADULTOS ANA FILIPA MASSANO VICENTE 594807438', '28-05-2024 1900 — SAUDE ADULTOS YOUSSEF EN-NYLE 594519413', '28-05-2024 19:20 — SAUDE ADULTOS MANUEL DOMINGOS CAVACO 590255359', '29-05-2024 08:30 — DIABETES / HIPERTENSOS MARIA MADALENA FARIAS SEBASTIÃO CÂNDIDO s98401970', '29052024 08:30 — DIABETES / HIPERTENSOS ANA CRISTINA LAVANDEIRA SIMÕES so7858407', '29-05-2024 0900 — DIABETES /HIPERTENSOS JOAQUIM ANTÓNIO MARIANO 595580856', '29-05-2024 0900 — DIABETES /HIPERTENSOS JOAQUIM ANTÓNIO MARIANO 595580856', '29-05-2024 0930 — DIABETES /HIPERTENSOS MARIA MARLENE ROQUE NORONHA CABRAL 598504269', '29-05-2024 09:30 — DIABETES /HIPERTENSOS MARIA MARLENE ROQUE NORONHA CABRAL 598504269', '29-05-2024 10:00 — DIABETES / HIPERTENSOS ANTÓNIO MANUEL FERNANDES MARQUES 363608548', '29-05-2024 10:00 | DIABETES / HIPERTENSOS ANTÔNIO MANUEL FERNANDES MARQUES 363608548', '29-05-2024 10:30 DIABETES / HIPERTENSOS JOÃO MANÉ 595609592', '29-05-2024 10:30 DIABETES / HIPERTENSOS MANUEL MARTINS CAVACO 597953344', '29-05-2024 1100 — DIABETES / HIPERTENSOS ANA ISABEL DA CRUZ PARAMOS 494439073', '29-05-2024 1100 DIABETES / HIPERTENSOS DANIEL JOSEPH GABIN 595551877', '29-05-2024 1130 DIABETES / HIPERTENSOS JOÃO MANÉ 595609592', '29-05-2024 1130 DIABETES / HIPERTENSOS DANIEL JOSEPH GABIN 595551877', '29-05-2024 1200 — DIABETES / HIPERTENSOS ANTÓNIO CANDEIAS HORTA CORDEIRO 596601224', '29-05-2024 1200 — SAUDE DE ADULTOS - DIABETES ANA ISABEL DA CRUZ PARAMOS 494439073', '29-05-2024 1230 — DIABETES / HIPERTENSOS ANTÓNIO CANDEIAS HORTA CORDEIRO 596601224', '29-05-2024 1230 — DIABETES / HIPERTENSOS JOSÉ ANTÓNIO DOS SANTOS PEREIRA 597520359', '2rBEBRAdO poftBmpiRHRSTESONREBTENÇOS, EPE. Rev:: 28149/0SÉ ANTÔNIO DOS SANTAS EEREIREo Impresso em 2024-05-28 SBERp3925', '']\n"
     ]
    }
   ],
   "source": [
    "import fitz  # PyMuPDF\n",
    "from PIL import Image\n",
    "import pytesseract\n",
    "import os\n",
    "\n",
    "# Configure o caminho do Tesseract, se necessário\n",
    "pytesseract.pytesseract.tesseract_cmd = r'C:\\Program Files\\Tesseract-OCR\\tesseract.exe'  # Windows\n",
    "# pytesseract.pytesseract.tesseract_cmd = '/usr/local/bin/tesseract'  # Mac/Linux\n",
    "\n",
    "def pdf_to_lines_with_ocr(pdf_path, zoom=2):\n",
    "    doc = fitz.open(pdf_path)\n",
    "    lines = []\n",
    "\n",
    "    for page_num in range(len(doc)):\n",
    "        page = doc.load_page(page_num)\n",
    "        \n",
    "        # Aumentar a resolução da imagem\n",
    "        mat = fitz.Matrix(zoom, zoom)\n",
    "        pix = page.get_pixmap(matrix=mat)\n",
    "        \n",
    "        # Converte a página do PDF em imagem\n",
    "        img = Image.frombytes(\"RGB\", [pix.width, pix.height], pix.samples)\n",
    "        \n",
    "        # Usa OCR para extrair texto da imagem\n",
    "        page_text = pytesseract.image_to_string(img, lang=\"por\", config='--psm 6 --oem 3 -c preserve_interword_spaces=1')  # Usando o idioma português\n",
    "        \n",
    "        # Separa o texto em linhas\n",
    "        page_lines = page_text.split('\\n')\n",
    "        lines.extend(page_lines)\n",
    "\n",
    "    return lines\n",
    "\n",
    "# Caminho para o seu arquivo PDF\n",
    "pdf_path = 'primeiras_paginas.pdf'\n",
    "\n",
    "# Extrair linhas de texto\n",
    "extracted_lines = pdf_to_lines_with_ocr(pdf_path, zoom=2)\n",
    "\n",
    "print(extracted_lines)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "As duas primeiras páginas foram salvas em primeiras_paginas.pdf\n"
     ]
    }
   ],
   "source": [
    "from PyPDF2 import PdfReader, PdfWriter\n",
    "\n",
    "def extract_first_pages(input_pdf_path, output_pdf_path, num_pages=2):\n",
    "    pdf_reader = PdfReader(input_pdf_path)\n",
    "    pdf_writer = PdfWriter()\n",
    "\n",
    "    for page_num in range(num_pages):\n",
    "        pdf_writer.add_page(pdf_reader.pages[page_num])\n",
    "\n",
    "    with open(output_pdf_path, 'wb') as output_file:\n",
    "        pdf_writer.write(output_file)\n",
    "\n",
    "# Caminho para o seu arquivo PDF original\n",
    "input_pdf_path = 'listagem.pdf'\n",
    "# Caminho para o novo arquivo PDF com as duas primeiras páginas\n",
    "output_pdf_path = 'primeiras_paginas.pdf'\n",
    "\n",
    "# Extrai as duas primeiras páginas\n",
    "extract_first_pages(input_pdf_path, output_pdf_path)\n",
    "\n",
    "print(f\"As duas primeiras páginas foram salvas em {output_pdf_path}\")\n"
   ]
  }
 ],
 "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.12.3"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}