reboot.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f0ad2193",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests\n",
    "import json\n",
    "import glob, os\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "from urllib.request import urlopen\n",
    "import certifi\n",
    "api = 'c4ad87b03bec1878bc0be6156d4472b0'\n",
    "pd.options.display.float_format = '{:,.2f}'.format\n",
    "pd.set_option('display.max_columns', 1000)\n",
    "pd.set_option('display.max_rows', 100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "0a4b40f2",
   "metadata": {},
   "outputs": [],
   "source": [
    "prices_request = requests.get(f'https://financialmodelingprep.com/api/v3/available-traded/list?apikey={api}').json()\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "3ee9b41c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_ticker_list = pd.json_normalize(prices_request)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0085506f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=8dac8156-1f2e-4d99-abb0-b81de054a49f style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('8dac8156-1f2e-4d99-abb0-b81de054a49f').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>symbol</th>\n",
       "      <th>name</th>\n",
       "      <th>price</th>\n",
       "      <th>exchange</th>\n",
       "      <th>exchangeShortName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5JS.SI</td>\n",
       "      <td>Indofood Agri Resources Ltd.</td>\n",
       "      <td>0.31</td>\n",
       "      <td>SES</td>\n",
       "      <td>EURONEXT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>JMUEX</td>\n",
       "      <td>JPMorgan U.S. Equity Fund</td>\n",
       "      <td>17.06</td>\n",
       "      <td>Nasdaq</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CSRYX</td>\n",
       "      <td>Columbia Select Large Cap Value Fund</td>\n",
       "      <td>31.56</td>\n",
       "      <td>Nasdaq</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NWXQX</td>\n",
       "      <td>Nationwide Mid Cap Market Index Fund</td>\n",
       "      <td>16.02</td>\n",
       "      <td>Nasdaq</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GRSO</td>\n",
       "      <td>Grow Solutions Holdings, Inc.</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Other OTC</td>\n",
       "      <td>PNK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>4270.SR</td>\n",
       "      <td>Saudi Printing and Packaging Co.</td>\n",
       "      <td>16.58</td>\n",
       "      <td>Saudi</td>\n",
       "      <td>SAU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4828.T</td>\n",
       "      <td>Business Engineering Corporation</td>\n",
       "      <td>2,357.00</td>\n",
       "      <td>Tokyo</td>\n",
       "      <td>JPX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>MDY</td>\n",
       "      <td>SPDR S&amp;P MIDCAP 400 ETF Trust</td>\n",
       "      <td>437.19</td>\n",
       "      <td>New York Stock Exchange Arca</td>\n",
       "      <td>AMEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PWZ</td>\n",
       "      <td>Invesco California AMT-Free Municipal Bond ETF</td>\n",
       "      <td>24.21</td>\n",
       "      <td>New York Stock Exchange Arca</td>\n",
       "      <td>AMEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SGAS.DE</td>\n",
       "      <td>iShares MSCI USA ESG Screened UCITS ETF</td>\n",
       "      <td>6.89</td>\n",
       "      <td>XETRA</td>\n",
       "      <td>XETRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>USLB</td>\n",
       "      <td>Invesco Russell 1000 Low Beta Equal Weight ETF</td>\n",
       "      <td>37.26</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BLUE</td>\n",
       "      <td>bluebird bio, Inc.</td>\n",
       "      <td>7.42</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>600079.SS</td>\n",
       "      <td>Humanwell Healthcare (Group) Co.,Ltd.</td>\n",
       "      <td>21.82</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>SHH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>RFACR</td>\n",
       "      <td>RF Acquisition Corp.</td>\n",
       "      <td>0.07</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>LNN</td>\n",
       "      <td>Lindsay Corporation</td>\n",
       "      <td>165.84</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CLS.TO</td>\n",
       "      <td>Celestica Inc.</td>\n",
       "      <td>14.87</td>\n",
       "      <td>Toronto Stock Exchange</td>\n",
       "      <td>TSX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>VOT</td>\n",
       "      <td>Vanguard Mid-Cap Growth Index Fund</td>\n",
       "      <td>179.47</td>\n",
       "      <td>New York Stock Exchange Arca</td>\n",
       "      <td>AMEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>WAL-PA</td>\n",
       "      <td>Western Alliance Bancorporation</td>\n",
       "      <td>20.95</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>OFSSH</td>\n",
       "      <td>OFS Capital Corporation 4.95% Notes due 2028</td>\n",
       "      <td>21.20</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NTLA</td>\n",
       "      <td>Intellia Therapeutics, Inc.</td>\n",
       "      <td>36.03</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1726.TW</td>\n",
       "      <td>Yung Chi Paint &amp; Varnish Mfg.Co.,Ltd</td>\n",
       "      <td>70.30</td>\n",
       "      <td>Taiwan</td>\n",
       "      <td>TAI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>EURL</td>\n",
       "      <td>Direxion Daily FTSE Europe Bull 3X Shares</td>\n",
       "      <td>16.79</td>\n",
       "      <td>New York Stock Exchange Arca</td>\n",
       "      <td>AMEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>9858.HK</td>\n",
       "      <td>China Youran Dairy Group Limited</td>\n",
       "      <td>2.06</td>\n",
       "      <td>HKSE</td>\n",
       "      <td>HKSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>TGHN.DE</td>\n",
       "      <td>Logwin AG</td>\n",
       "      <td>260.00</td>\n",
       "      <td>XETRA</td>\n",
       "      <td>XETRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>ZZ-B.ST</td>\n",
       "      <td>Zinzino AB (publ)</td>\n",
       "      <td>24.95</td>\n",
       "      <td>Stockholm Stock Exchange</td>\n",
       "      <td>STO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>JPNE.F</td>\n",
       "      <td>Lyxor MSCI Japan ESG Leaders Extra (DR) UCITS ETF</td>\n",
       "      <td>21.97</td>\n",
       "      <td>Frankfurt</td>\n",
       "      <td>XETRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>KTHGF</td>\n",
       "      <td>Kantone Holdings Limited</td>\n",
       "      <td>0.06</td>\n",
       "      <td>Other OTC</td>\n",
       "      <td>PNK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>CENTRUM.NS</td>\n",
       "      <td>Centrum Capital Limited</td>\n",
       "      <td>26.30</td>\n",
       "      <td>National Stock Exchange of India</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0564.HK</td>\n",
       "      <td>Zhengzhou Coal Mining Machinery Group Company Limited</td>\n",
       "      <td>7.37</td>\n",
       "      <td>HKSE</td>\n",
       "      <td>HKSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>PBD</td>\n",
       "      <td>Invesco Global Clean Energy ETF</td>\n",
       "      <td>18.72</td>\n",
       "      <td>New York Stock Exchange Arca</td>\n",
       "      <td>AMEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>SZLSF</td>\n",
       "      <td>StageZero Life Sciences Ltd.</td>\n",
       "      <td>0.05</td>\n",
       "      <td>Other OTC</td>\n",
       "      <td>PNK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>WTED.DE</td>\n",
       "      <td>WisdomTree Emerging Markets SmallCap Dividend UCITS ETF</td>\n",
       "      <td>16.05</td>\n",
       "      <td>XETRA</td>\n",
       "      <td>XETRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>CORRX</td>\n",
       "      <td>Columbia Contrarian Core Fund</td>\n",
       "      <td>25.09</td>\n",
       "      <td>Nasdaq</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>BLND</td>\n",
       "      <td>Blend Labs, Inc.</td>\n",
       "      <td>1.22</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>4904.TW</td>\n",
       "      <td>Far EasTone Telecommunications Co., Ltd.</td>\n",
       "      <td>65.50</td>\n",
       "      <td>Taiwan</td>\n",
       "      <td>TAI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>ARKG</td>\n",
       "      <td>ARK Genomic Revolution ETF</td>\n",
       "      <td>29.06</td>\n",
       "      <td>BATS</td>\n",
       "      <td>ETF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>ZUGN.SW</td>\n",
       "      <td>Zug Estates Holding AG</td>\n",
       "      <td>1,655.00</td>\n",
       "      <td>Swiss Exchange</td>\n",
       "      <td>OSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>VOD.L</td>\n",
       "      <td>Vodafone Group Public Limited Company</td>\n",
       "      <td>83.80</td>\n",
       "      <td>London Stock Exchange</td>\n",
       "      <td>LSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>LEM.V</td>\n",
       "      <td>Leading Edge Materials Corp.</td>\n",
       "      <td>0.16</td>\n",
       "      <td>TSXV</td>\n",
       "      <td>TSX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>IREN.SW</td>\n",
       "      <td>Investis Holding SA</td>\n",
       "      <td>101.00</td>\n",
       "      <td>Swiss Exchange</td>\n",
       "      <td>OSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>DKGR</td>\n",
       "      <td>Universal Apparel &amp; Textile Company</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Other OTC</td>\n",
       "      <td>PNK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>WSBFX</td>\n",
       "      <td>Boston Trust Walden Balanced Fund</td>\n",
       "      <td>20.85</td>\n",
       "      <td>Nasdaq</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>FRT-PC</td>\n",
       "      <td>Federal Realty Investment Trust</td>\n",
       "      <td>21.05</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>FYT</td>\n",
       "      <td>First Trust Small Cap Value AlphaDEX Fund</td>\n",
       "      <td>44.69</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>ASOMY</td>\n",
       "      <td>ASOS Plc</td>\n",
       "      <td>6.17</td>\n",
       "      <td>Other OTC</td>\n",
       "      <td>PNK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>ACWV</td>\n",
       "      <td>iShares MSCI Global Min Vol Factor ETF</td>\n",
       "      <td>94.58</td>\n",
       "      <td>BATS</td>\n",
       "      <td>ETF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>BLKB.SW</td>\n",
       "      <td>Basellandschaftliche Kantonalbank</td>\n",
       "      <td>914.00</td>\n",
       "      <td>Swiss Exchange</td>\n",
       "      <td>OSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>CRICF</td>\n",
       "      <td>Churchill Resources Inc.</td>\n",
       "      <td>0.09</td>\n",
       "      <td>Other OTC</td>\n",
       "      <td>PNK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>WEBNF</td>\n",
       "      <td>Westpac Banking Corporation</td>\n",
       "      <td>15.50</td>\n",
       "      <td>Other OTC</td>\n",
       "      <td>PNK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>ENB-PT.TO</td>\n",
       "      <td>Enbridge Inc</td>\n",
       "      <td>14.62</td>\n",
       "      <td>Toronto Stock Exchange</td>\n",
       "      <td>TSX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39770</th>\n",
       "      <td>NICK</td>\n",
       "      <td>Nicholas Financial, Inc.</td>\n",
       "      <td>6.25</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39771</th>\n",
       "      <td>INDT</td>\n",
       "      <td>INDUS Realty Trust, Inc.</td>\n",
       "      <td>63.61</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39772</th>\n",
       "      <td>MKFG</td>\n",
       "      <td>Markforged Holding Corporation</td>\n",
       "      <td>0.87</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39773</th>\n",
       "      <td>SONX</td>\n",
       "      <td>Sonendo, Inc.</td>\n",
       "      <td>1.57</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39774</th>\n",
       "      <td>SUI</td>\n",
       "      <td>Sun Communities, Inc.</td>\n",
       "      <td>138.85</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39775</th>\n",
       "      <td>FSNT.F</td>\n",
       "      <td>Fashionette AG</td>\n",
       "      <td>4.37</td>\n",
       "      <td>Frankfurt</td>\n",
       "      <td>XETRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39776</th>\n",
       "      <td>3336.HK</td>\n",
       "      <td>Ju Teng International Holdings Limited</td>\n",
       "      <td>1.35</td>\n",
       "      <td>HKSE</td>\n",
       "      <td>HKSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39777</th>\n",
       "      <td>3928.HK</td>\n",
       "      <td>S&amp;T Holdings Limited</td>\n",
       "      <td>0.70</td>\n",
       "      <td>HKSE</td>\n",
       "      <td>HKSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39778</th>\n",
       "      <td>HF.SN</td>\n",
       "      <td>Hortifrut S.A.</td>\n",
       "      <td>1,326.80</td>\n",
       "      <td>Santiago</td>\n",
       "      <td>SGO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39779</th>\n",
       "      <td>PFE</td>\n",
       "      <td>Pfizer Inc.</td>\n",
       "      <td>51.32</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39780</th>\n",
       "      <td>3067.T</td>\n",
       "      <td>Tokyo Ichiban Foods Co., Ltd.</td>\n",
       "      <td>485.00</td>\n",
       "      <td>Tokyo</td>\n",
       "      <td>JPX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39781</th>\n",
       "      <td>STNG</td>\n",
       "      <td>Scorpio Tankers Inc.</td>\n",
       "      <td>54.87</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39782</th>\n",
       "      <td>WAH.DE</td>\n",
       "      <td>Wolftank-Adisa Holding AG</td>\n",
       "      <td>12.55</td>\n",
       "      <td>XETRA</td>\n",
       "      <td>XETRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39783</th>\n",
       "      <td>HAI.TO</td>\n",
       "      <td>Haivision Systems Inc.</td>\n",
       "      <td>2.95</td>\n",
       "      <td>Toronto Stock Exchange</td>\n",
       "      <td>TSX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39784</th>\n",
       "      <td>KYCH</td>\n",
       "      <td>Keyarch Acquisition Corporation</td>\n",
       "      <td>10.08</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39785</th>\n",
       "      <td>RAREF</td>\n",
       "      <td>Canada Rare Earth Corp.</td>\n",
       "      <td>0.03</td>\n",
       "      <td>Other OTC</td>\n",
       "      <td>PNK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39786</th>\n",
       "      <td>FN.TO</td>\n",
       "      <td>First National Financial Corporation</td>\n",
       "      <td>35.29</td>\n",
       "      <td>Toronto Stock Exchange</td>\n",
       "      <td>TSX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39787</th>\n",
       "      <td>IAT.L</td>\n",
       "      <td>Invesco Asia Trust plc</td>\n",
       "      <td>325.00</td>\n",
       "      <td>London Stock Exchange</td>\n",
       "      <td>LSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39788</th>\n",
       "      <td>CTIC</td>\n",
       "      <td>CTI BioPharma Corp.</td>\n",
       "      <td>5.57</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39789</th>\n",
       "      <td>6035.T</td>\n",
       "      <td>IR Japan Holdings, Ltd.</td>\n",
       "      <td>1,756.00</td>\n",
       "      <td>Tokyo</td>\n",
       "      <td>JPX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39790</th>\n",
       "      <td>9692.T</td>\n",
       "      <td>Computer Engineering &amp; Consulting, Ltd.</td>\n",
       "      <td>1,509.00</td>\n",
       "      <td>Tokyo</td>\n",
       "      <td>JPX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39791</th>\n",
       "      <td>3176.T</td>\n",
       "      <td>Sanyo Trading Co., Ltd.</td>\n",
       "      <td>1,074.00</td>\n",
       "      <td>Tokyo</td>\n",
       "      <td>JPX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39792</th>\n",
       "      <td>MGI</td>\n",
       "      <td>MoneyGram International, Inc.</td>\n",
       "      <td>10.91</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39793</th>\n",
       "      <td>HCL-INSYS.NS</td>\n",
       "      <td>HCL Infosystems Limited</td>\n",
       "      <td>18.35</td>\n",
       "      <td>National Stock Exchange of India</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39794</th>\n",
       "      <td>600649.SS</td>\n",
       "      <td>Shanghai Chengtou Holding Co.,Ltd</td>\n",
       "      <td>4.07</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>SHH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39795</th>\n",
       "      <td>ONDS</td>\n",
       "      <td>Ondas Holdings Inc.</td>\n",
       "      <td>1.92</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39796</th>\n",
       "      <td>AVAC</td>\n",
       "      <td>Avalon Acquisition Inc.</td>\n",
       "      <td>10.13</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39797</th>\n",
       "      <td>NMS</td>\n",
       "      <td>Nuveen Minnesota Quality Municipal Income Fund</td>\n",
       "      <td>11.57</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39798</th>\n",
       "      <td>603519.SS</td>\n",
       "      <td>Jiangsu Liba Enterprise Joint-Stock Co., Ltd.</td>\n",
       "      <td>11.57</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>SHH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39799</th>\n",
       "      <td>032500.KQ</td>\n",
       "      <td>Kmw Inc.</td>\n",
       "      <td>28,250.00</td>\n",
       "      <td>KOSDAQ</td>\n",
       "      <td>KOE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39800</th>\n",
       "      <td>095660.KQ</td>\n",
       "      <td>NEOWIZ</td>\n",
       "      <td>36,500.00</td>\n",
       "      <td>KOSDAQ</td>\n",
       "      <td>KOE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39801</th>\n",
       "      <td>3576.TW</td>\n",
       "      <td>United Renewable Energy Co., Ltd.</td>\n",
       "      <td>20.30</td>\n",
       "      <td>Taiwan</td>\n",
       "      <td>TAI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39802</th>\n",
       "      <td>GJTL.JK</td>\n",
       "      <td>PT. Gajah Tunggal Tbk</td>\n",
       "      <td>560.00</td>\n",
       "      <td>Jakarta Stock Exchange</td>\n",
       "      <td>JKT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39803</th>\n",
       "      <td>0KD1.L</td>\n",
       "      <td>Tubacex, S.A.</td>\n",
       "      <td>1.98</td>\n",
       "      <td>London Stock Exchange</td>\n",
       "      <td>LSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39804</th>\n",
       "      <td>AMSIY</td>\n",
       "      <td>ArcelorMittal South Africa Ltd</td>\n",
       "      <td>0.20</td>\n",
       "      <td>Other OTC</td>\n",
       "      <td>PNK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39805</th>\n",
       "      <td>1438.TW</td>\n",
       "      <td>SanDi Properties Co.,Ltd.</td>\n",
       "      <td>31.85</td>\n",
       "      <td>Taiwan</td>\n",
       "      <td>TAI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39806</th>\n",
       "      <td>6363.T</td>\n",
       "      <td>Torishima Pump Mfg. Co., Ltd.</td>\n",
       "      <td>1,434.00</td>\n",
       "      <td>Tokyo</td>\n",
       "      <td>JPX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39807</th>\n",
       "      <td>7077.T</td>\n",
       "      <td>ALiNK Internet, Inc.</td>\n",
       "      <td>920.00</td>\n",
       "      <td>Tokyo</td>\n",
       "      <td>JPX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39808</th>\n",
       "      <td>600835.SS</td>\n",
       "      <td>Shanghai Mechanical &amp; Electrical Industry Co.,Ltd.</td>\n",
       "      <td>11.31</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>SHH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39809</th>\n",
       "      <td>ZENITHEXPO.NS</td>\n",
       "      <td>Zenith Exports Limited</td>\n",
       "      <td>92.50</td>\n",
       "      <td>National Stock Exchange of India</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39810</th>\n",
       "      <td>600406.SS</td>\n",
       "      <td>NARI Technology Co., Ltd.</td>\n",
       "      <td>24.80</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>SHH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39811</th>\n",
       "      <td>SBO.OL</td>\n",
       "      <td>Selvaag Bolig ASA</td>\n",
       "      <td>29.50</td>\n",
       "      <td>Oslo Stock Exchange</td>\n",
       "      <td>OSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39812</th>\n",
       "      <td>8133.HK</td>\n",
       "      <td>Solomon Worldwide Holdings Limited</td>\n",
       "      <td>0.30</td>\n",
       "      <td>HKSE</td>\n",
       "      <td>HKSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39813</th>\n",
       "      <td>DOCS.L</td>\n",
       "      <td>Dr. Martens plc</td>\n",
       "      <td>174.70</td>\n",
       "      <td>London Stock Exchange</td>\n",
       "      <td>LSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39814</th>\n",
       "      <td>MLTM.TA</td>\n",
       "      <td>Malam - Team Ltd</td>\n",
       "      <td>7,679.00</td>\n",
       "      <td>Tel Aviv</td>\n",
       "      <td>TLV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39815</th>\n",
       "      <td>9532.T</td>\n",
       "      <td>Osaka Gas Co., Ltd.</td>\n",
       "      <td>2,119.00</td>\n",
       "      <td>Tokyo</td>\n",
       "      <td>JPX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39816</th>\n",
       "      <td>BKY.L</td>\n",
       "      <td>Berkeley Energia Limited</td>\n",
       "      <td>16.00</td>\n",
       "      <td>London Stock Exchange</td>\n",
       "      <td>LSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39817</th>\n",
       "      <td>AHL-PD</td>\n",
       "      <td>Aspen Insurance Holdings Limited</td>\n",
       "      <td>18.71</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39818</th>\n",
       "      <td>600346.SS</td>\n",
       "      <td>Hengli Petrochemical Co.,Ltd.</td>\n",
       "      <td>16.52</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>SHH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39819</th>\n",
       "      <td>TRUS.JK</td>\n",
       "      <td>PT Trust Finance Indonesia Tbk</td>\n",
       "      <td>360.00</td>\n",
       "      <td>Jakarta Stock Exchange</td>\n",
       "      <td>JKT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "          symbol                                  name    price  \\\n",
       "0         5JS.SI          Indofood Agri Resources Ltd.     0.31   \n",
       "1          JMUEX             JPMorgan U.S. Equity Fund    17.06   \n",
       "2          CSRYX  Columbia Select Large Cap Value Fund    31.56   \n",
       "3          NWXQX  Nationwide Mid Cap Market Index Fund    16.02   \n",
       "4           GRSO         Grow Solutions Holdings, Inc.     0.00   \n",
       "...          ...                                   ...      ...   \n",
       "39815     9532.T                   Osaka Gas Co., Ltd. 2,119.00   \n",
       "39816      BKY.L              Berkeley Energia Limited    16.00   \n",
       "39817     AHL-PD      Aspen Insurance Holdings Limited    18.71   \n",
       "39818  600346.SS         Hengli Petrochemical Co.,Ltd.    16.52   \n",
       "39819    TRUS.JK        PT Trust Finance Indonesia Tbk   360.00   \n",
       "\n",
       "                      exchange exchangeShortName  \n",
       "0                          SES          EURONEXT  \n",
       "1                       Nasdaq            NASDAQ  \n",
       "2                       Nasdaq            NASDAQ  \n",
       "3                       Nasdaq            NASDAQ  \n",
       "4                    Other OTC               PNK  \n",
       "...                        ...               ...  \n",
       "39815                    Tokyo               JPX  \n",
       "39816    London Stock Exchange               LSE  \n",
       "39817  New York Stock Exchange              NYSE  \n",
       "39818                 Shanghai               SHH  \n",
       "39819   Jakarta Stock Exchange               JKT  \n",
       "\n",
       "[39820 rows x 5 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ticker_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "e39b222d",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_ticker_list['exchange'].value_counts()\n",
    "list_of_us_exchanges = ['New York Stock Exchange','NASDAQ Capital Market','NASDAQ Global Select',\n",
    "                       'NASDAQ Global Market']\n",
    "df_nasdaq = df_ticker_list[df_ticker_list['exchange'].isin(list_of_us_exchanges)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "4508b8ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=d6a8aa65-82be-40e7-ba19-be2df44af6b1 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('d6a8aa65-82be-40e7-ba19-be2df44af6b1').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>symbol</th>\n",
       "      <th>name</th>\n",
       "      <th>price</th>\n",
       "      <th>exchange</th>\n",
       "      <th>exchangeShortName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>USLB</td>\n",
       "      <td>Invesco Russell 1000 Low Beta Equal Weight ETF</td>\n",
       "      <td>37.26</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BLUE</td>\n",
       "      <td>bluebird bio, Inc.</td>\n",
       "      <td>7.42</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>RFACR</td>\n",
       "      <td>RF Acquisition Corp.</td>\n",
       "      <td>0.07</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>LNN</td>\n",
       "      <td>Lindsay Corporation</td>\n",
       "      <td>165.84</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>WAL-PA</td>\n",
       "      <td>Western Alliance Bancorporation</td>\n",
       "      <td>20.95</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>OFSSH</td>\n",
       "      <td>OFS Capital Corporation 4.95% Notes due 2028</td>\n",
       "      <td>21.20</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NTLA</td>\n",
       "      <td>Intellia Therapeutics, Inc.</td>\n",
       "      <td>36.03</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>BLND</td>\n",
       "      <td>Blend Labs, Inc.</td>\n",
       "      <td>1.22</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>FRT-PC</td>\n",
       "      <td>Federal Realty Investment Trust</td>\n",
       "      <td>21.05</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>FYT</td>\n",
       "      <td>First Trust Small Cap Value AlphaDEX Fund</td>\n",
       "      <td>44.69</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>XNCR</td>\n",
       "      <td>Xencor, Inc.</td>\n",
       "      <td>25.84</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>CHSCM</td>\n",
       "      <td>CHS Inc.</td>\n",
       "      <td>24.20</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>CSSEN</td>\n",
       "      <td>Chicken Soup for the Soul Enter</td>\n",
       "      <td>25.41</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>CAL</td>\n",
       "      <td>Caleres, Inc.</td>\n",
       "      <td>19.64</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>EVGO</td>\n",
       "      <td>EVgo, Inc.</td>\n",
       "      <td>4.44</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>LRCX</td>\n",
       "      <td>Lam Research Corporation</td>\n",
       "      <td>437.36</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>PEZ</td>\n",
       "      <td>Invesco DWA Consumer Cyclicals Momentum ETF</td>\n",
       "      <td>62.85</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>TAC</td>\n",
       "      <td>TransAlta Corporation</td>\n",
       "      <td>8.94</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>RLJ</td>\n",
       "      <td>RLJ Lodging Trust</td>\n",
       "      <td>10.81</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>BRLIW</td>\n",
       "      <td>Brilliant Acquisition Corporation</td>\n",
       "      <td>0.03</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>CFB</td>\n",
       "      <td>CrossFirst Bankshares, Inc.</td>\n",
       "      <td>12.36</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>CHEAW</td>\n",
       "      <td>Chenghe Acquisition Co.</td>\n",
       "      <td>0.06</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>BSCS</td>\n",
       "      <td>Invesco BulletShares 2028 Corporate Bond ETF</td>\n",
       "      <td>19.71</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>LPTH</td>\n",
       "      <td>LightPath Technologies, Inc.</td>\n",
       "      <td>1.15</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>GLT</td>\n",
       "      <td>Glatfelter Corporation</td>\n",
       "      <td>2.80</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>RITM</td>\n",
       "      <td>Rithm Capital Corp.</td>\n",
       "      <td>8.40</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>HOUS</td>\n",
       "      <td>Anywhere Real Estate Inc.</td>\n",
       "      <td>6.76</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>FDT</td>\n",
       "      <td>First Trust Developed Markets Ex-US AlphaDEX Fund</td>\n",
       "      <td>48.60</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>CNO</td>\n",
       "      <td>CNO Financial Group, Inc.</td>\n",
       "      <td>22.20</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>CVT</td>\n",
       "      <td>Cvent Holding Corp.</td>\n",
       "      <td>5.09</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>CONN</td>\n",
       "      <td>Conn's, Inc.</td>\n",
       "      <td>5.81</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>WMB</td>\n",
       "      <td>The Williams Companies, Inc.</td>\n",
       "      <td>32.35</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>CM</td>\n",
       "      <td>Canadian Imperial Bank of Commerce</td>\n",
       "      <td>40.57</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>TUR</td>\n",
       "      <td>iShares MSCI Turkey ETF</td>\n",
       "      <td>36.76</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>FHN-PC</td>\n",
       "      <td>First Horizon Corporation</td>\n",
       "      <td>25.18</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>CPA</td>\n",
       "      <td>Copa Holdings, S.A.</td>\n",
       "      <td>84.23</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>NICE</td>\n",
       "      <td>NICE Ltd.</td>\n",
       "      <td>194.11</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>LEE</td>\n",
       "      <td>Lee Enterprises, Incorporated</td>\n",
       "      <td>17.50</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>COOP</td>\n",
       "      <td>Mr. Cooper Group Inc.</td>\n",
       "      <td>40.42</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>INCY</td>\n",
       "      <td>Incyte Corporation</td>\n",
       "      <td>81.07</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>PDP</td>\n",
       "      <td>Invesco DWA Momentum ETF</td>\n",
       "      <td>70.93</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>NCNA</td>\n",
       "      <td>NuCana plc</td>\n",
       "      <td>0.67</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>BZFDW</td>\n",
       "      <td>BuzzFeed, Inc.</td>\n",
       "      <td>0.04</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>FHN-PB</td>\n",
       "      <td>First Horizon Corporation</td>\n",
       "      <td>24.65</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>OMAB</td>\n",
       "      <td>Grupo Aeroportuario del Centro Norte, S.A.B. de C.V.</td>\n",
       "      <td>60.84</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>SHG</td>\n",
       "      <td>Shinhan Financial Group Co., Ltd.</td>\n",
       "      <td>29.44</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>MITT-PC</td>\n",
       "      <td>AG Mortgage Investment Trust, Inc.</td>\n",
       "      <td>16.79</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>CUBI-PE</td>\n",
       "      <td>Customers Bancorp, Inc.</td>\n",
       "      <td>25.55</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>CATH</td>\n",
       "      <td>Global X S&amp;P 500 Catholic Values ETF</td>\n",
       "      <td>46.61</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>ZBH</td>\n",
       "      <td>Zimmer Biomet Holdings, Inc.</td>\n",
       "      <td>125.43</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39570</th>\n",
       "      <td>ETB</td>\n",
       "      <td>Eaton Vance Tax-Managed Buy-Write Income Fund</td>\n",
       "      <td>13.26</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39571</th>\n",
       "      <td>SLNH</td>\n",
       "      <td>Soluna Holdings, Inc.</td>\n",
       "      <td>0.31</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39572</th>\n",
       "      <td>JPM-PC</td>\n",
       "      <td>JPMorgan Chase &amp; Co.</td>\n",
       "      <td>25.40</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39586</th>\n",
       "      <td>MAA</td>\n",
       "      <td>Mid-America Apartment Communities, Inc.</td>\n",
       "      <td>154.11</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39587</th>\n",
       "      <td>GTES</td>\n",
       "      <td>Gates Industrial Corporation plc</td>\n",
       "      <td>11.07</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39588</th>\n",
       "      <td>VCTR</td>\n",
       "      <td>Victory Capital Holdings, Inc.</td>\n",
       "      <td>27.16</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39589</th>\n",
       "      <td>KSPN</td>\n",
       "      <td>Kaspien Holdings Inc.</td>\n",
       "      <td>0.66</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39590</th>\n",
       "      <td>BRBR</td>\n",
       "      <td>BellRing Brands, Inc.</td>\n",
       "      <td>25.23</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39592</th>\n",
       "      <td>IHG</td>\n",
       "      <td>InterContinental Hotels Group PLC</td>\n",
       "      <td>58.69</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39593</th>\n",
       "      <td>TSN</td>\n",
       "      <td>Tyson Foods, Inc.</td>\n",
       "      <td>61.38</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39594</th>\n",
       "      <td>CCJ</td>\n",
       "      <td>Cameco Corporation</td>\n",
       "      <td>21.77</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39595</th>\n",
       "      <td>PSN</td>\n",
       "      <td>Parsons Corporation</td>\n",
       "      <td>45.91</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39596</th>\n",
       "      <td>BGS</td>\n",
       "      <td>B&amp;G Foods, Inc.</td>\n",
       "      <td>11.87</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39600</th>\n",
       "      <td>XPO</td>\n",
       "      <td>XPO Logistics, Inc.</td>\n",
       "      <td>34.39</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39650</th>\n",
       "      <td>OSTR</td>\n",
       "      <td>Oyster Enterprises Acquisition Corp.</td>\n",
       "      <td>10.07</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39664</th>\n",
       "      <td>GLOP-PC</td>\n",
       "      <td>GasLog Partners LP</td>\n",
       "      <td>23.89</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39668</th>\n",
       "      <td>AIHS</td>\n",
       "      <td>Senmiao Technology Limited</td>\n",
       "      <td>0.94</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39670</th>\n",
       "      <td>AMT</td>\n",
       "      <td>American Tower Corporation</td>\n",
       "      <td>208.69</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39672</th>\n",
       "      <td>PCSB</td>\n",
       "      <td>PCSB Financial Corporation</td>\n",
       "      <td>19.26</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39673</th>\n",
       "      <td>SND</td>\n",
       "      <td>Smart Sand, Inc.</td>\n",
       "      <td>1.69</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39674</th>\n",
       "      <td>CXAC</td>\n",
       "      <td>C5 Acquisition Corporation</td>\n",
       "      <td>10.15</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39690</th>\n",
       "      <td>AVDL</td>\n",
       "      <td>Avadel Pharmaceuticals plc</td>\n",
       "      <td>7.03</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39692</th>\n",
       "      <td>INZY</td>\n",
       "      <td>Inozyme Pharma, Inc.</td>\n",
       "      <td>1.18</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39696</th>\n",
       "      <td>IMAQ</td>\n",
       "      <td>International Media Acquisition Corp.</td>\n",
       "      <td>10.19</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39708</th>\n",
       "      <td>SURG</td>\n",
       "      <td>SurgePays, Inc.</td>\n",
       "      <td>6.90</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39721</th>\n",
       "      <td>DALS</td>\n",
       "      <td>DA32 Life Science Tech Acquisition Corp.</td>\n",
       "      <td>9.89</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39724</th>\n",
       "      <td>BTA</td>\n",
       "      <td>BlackRock Long-Term Municipal Advantage Trust</td>\n",
       "      <td>9.42</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39725</th>\n",
       "      <td>BWV</td>\n",
       "      <td>Blue Water Vaccines, Inc.</td>\n",
       "      <td>1.04</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39733</th>\n",
       "      <td>AREB</td>\n",
       "      <td>American Rebel Holdings, Inc.</td>\n",
       "      <td>0.16</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39744</th>\n",
       "      <td>AMX</td>\n",
       "      <td>América Móvil, S.A.B. de C.V.</td>\n",
       "      <td>18.21</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39746</th>\n",
       "      <td>PEGY</td>\n",
       "      <td>Pineapple Energy Inc.</td>\n",
       "      <td>1.64</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39751</th>\n",
       "      <td>TWIN</td>\n",
       "      <td>Twin Disc, Incorporated</td>\n",
       "      <td>9.01</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39755</th>\n",
       "      <td>IMNM</td>\n",
       "      <td>Immunome, Inc.</td>\n",
       "      <td>3.75</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39763</th>\n",
       "      <td>LWAY</td>\n",
       "      <td>Lifeway Foods, Inc.</td>\n",
       "      <td>5.97</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39766</th>\n",
       "      <td>FEAM</td>\n",
       "      <td>5E Advanced Materials Inc.</td>\n",
       "      <td>7.64</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39767</th>\n",
       "      <td>FAMI</td>\n",
       "      <td>Farmmi, Inc.</td>\n",
       "      <td>0.44</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39770</th>\n",
       "      <td>NICK</td>\n",
       "      <td>Nicholas Financial, Inc.</td>\n",
       "      <td>6.25</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39771</th>\n",
       "      <td>INDT</td>\n",
       "      <td>INDUS Realty Trust, Inc.</td>\n",
       "      <td>63.61</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39772</th>\n",
       "      <td>MKFG</td>\n",
       "      <td>Markforged Holding Corporation</td>\n",
       "      <td>0.87</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39773</th>\n",
       "      <td>SONX</td>\n",
       "      <td>Sonendo, Inc.</td>\n",
       "      <td>1.57</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39774</th>\n",
       "      <td>SUI</td>\n",
       "      <td>Sun Communities, Inc.</td>\n",
       "      <td>138.85</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39779</th>\n",
       "      <td>PFE</td>\n",
       "      <td>Pfizer Inc.</td>\n",
       "      <td>51.32</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39781</th>\n",
       "      <td>STNG</td>\n",
       "      <td>Scorpio Tankers Inc.</td>\n",
       "      <td>54.87</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39784</th>\n",
       "      <td>KYCH</td>\n",
       "      <td>Keyarch Acquisition Corporation</td>\n",
       "      <td>10.08</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39788</th>\n",
       "      <td>CTIC</td>\n",
       "      <td>CTI BioPharma Corp.</td>\n",
       "      <td>5.57</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39792</th>\n",
       "      <td>MGI</td>\n",
       "      <td>MoneyGram International, Inc.</td>\n",
       "      <td>10.91</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39795</th>\n",
       "      <td>ONDS</td>\n",
       "      <td>Ondas Holdings Inc.</td>\n",
       "      <td>1.92</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39796</th>\n",
       "      <td>AVAC</td>\n",
       "      <td>Avalon Acquisition Inc.</td>\n",
       "      <td>10.13</td>\n",
       "      <td>NASDAQ Global Market</td>\n",
       "      <td>NASDAQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39797</th>\n",
       "      <td>NMS</td>\n",
       "      <td>Nuveen Minnesota Quality Municipal Income Fund</td>\n",
       "      <td>11.57</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39817</th>\n",
       "      <td>AHL-PD</td>\n",
       "      <td>Aspen Insurance Holdings Limited</td>\n",
       "      <td>18.71</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>NYSE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "       symbol                                            name  price  \\\n",
       "10       USLB  Invesco Russell 1000 Low Beta Equal Weight ETF  37.26   \n",
       "11       BLUE                              bluebird bio, Inc.   7.42   \n",
       "13      RFACR                            RF Acquisition Corp.   0.07   \n",
       "14        LNN                             Lindsay Corporation 165.84   \n",
       "17     WAL-PA                 Western Alliance Bancorporation  20.95   \n",
       "...       ...                                             ...    ...   \n",
       "39792     MGI                   MoneyGram International, Inc.  10.91   \n",
       "39795    ONDS                             Ondas Holdings Inc.   1.92   \n",
       "39796    AVAC                         Avalon Acquisition Inc.  10.13   \n",
       "39797     NMS  Nuveen Minnesota Quality Municipal Income Fund  11.57   \n",
       "39817  AHL-PD                Aspen Insurance Holdings Limited  18.71   \n",
       "\n",
       "                      exchange exchangeShortName  \n",
       "10        NASDAQ Global Market            NASDAQ  \n",
       "11        NASDAQ Global Select            NASDAQ  \n",
       "13        NASDAQ Global Market            NASDAQ  \n",
       "14     New York Stock Exchange              NYSE  \n",
       "17     New York Stock Exchange              NYSE  \n",
       "...                        ...               ...  \n",
       "39792     NASDAQ Global Select            NASDAQ  \n",
       "39795    NASDAQ Capital Market            NASDAQ  \n",
       "39796     NASDAQ Global Market            NASDAQ  \n",
       "39797  New York Stock Exchange              NYSE  \n",
       "39817  New York Stock Exchange              NYSE  \n",
       "\n",
       "[8111 rows x 5 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_nasdaq"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "88b64e9a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_nasdaq_sort = df_nasdaq[df_nasdaq['price']>9.99]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "90e5333d",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_nasdaq_tickers = pd.read_excel('NASDAQ_tickers.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "746436a4",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tech_tickers = pd.read_excel('NASDAQ_tickers.xlsx', sheet_name='GICS - Industry')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "1741ef3c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=4da264ba-88a8-4f2b-83e7-49c63757f831 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('4da264ba-88a8-4f2b-83e7-49c63757f831').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Ticker</th>\n",
       "      <th>Industry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>KBR INC</td>\n",
       "      <td>KBR</td>\n",
       "      <td>IT Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GTT COMMUNICATIONS INC</td>\n",
       "      <td>GTT</td>\n",
       "      <td>IT Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>INPIXON</td>\n",
       "      <td>INPX</td>\n",
       "      <td>IT Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EURONET WORLDWIDE INC</td>\n",
       "      <td>EEFT</td>\n",
       "      <td>IT Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>INTERNATIONAL MONEY EXPR INC</td>\n",
       "      <td>IMXI</td>\n",
       "      <td>IT Services</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "                        Company Ticker     Industry\n",
       "0                       KBR INC    KBR  IT Services\n",
       "1        GTT COMMUNICATIONS INC    GTT  IT Services\n",
       "2                       INPIXON   INPX  IT Services\n",
       "3         EURONET WORLDWIDE INC   EEFT  IT Services\n",
       "4  INTERNATIONAL MONEY EXPR INC   IMXI  IT Services"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tech_tickers.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "f85137df",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tech_sector_tickers = pd.read_excel('NASDAQ_tickers.xlsx', sheet_name='GICS - Sector')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "b8d133a6",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=d709d231-049e-45ae-9940-23ea1270f6be style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('d709d231-049e-45ae-9940-23ea1270f6be').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Ticker</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Sector</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>KBR INC</td>\n",
       "      <td>KBR</td>\n",
       "      <td>IT Services</td>\n",
       "      <td>IT Consulting &amp; Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>INPIXON</td>\n",
       "      <td>INPX</td>\n",
       "      <td>IT Services</td>\n",
       "      <td>IT Consulting &amp; Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AMERI HOLDINGS INC</td>\n",
       "      <td>AMRH</td>\n",
       "      <td>IT Services</td>\n",
       "      <td>IT Consulting &amp; Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BOOZ ALLEN HAMILTON HLDG CP</td>\n",
       "      <td>BAH</td>\n",
       "      <td>IT Services</td>\n",
       "      <td>IT Consulting &amp; Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>COGNIZANT TECH SOLUTIONS</td>\n",
       "      <td>CTSH</td>\n",
       "      <td>IT Services</td>\n",
       "      <td>IT Consulting &amp; Services</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "                       Company Ticker     Industry                    Sector\n",
       "0                      KBR INC    KBR  IT Services  IT Consulting & Services\n",
       "1                      INPIXON   INPX  IT Services  IT Consulting & Services\n",
       "2           AMERI HOLDINGS INC   AMRH  IT Services  IT Consulting & Services\n",
       "3  BOOZ ALLEN HAMILTON HLDG CP    BAH  IT Services  IT Consulting & Services\n",
       "4     COGNIZANT TECH SOLUTIONS   CTSH  IT Services  IT Consulting & Services"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tech_sector_tickers.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "627ac864",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_mcap(ticker):\n",
    "    \n",
    "    \n",
    "    prices_request = requests.get(f'https://financialmodelingprep.com/api/v3/historical-market-capitalization/{ticker}?limit=1260&apikey={api}').json()\n",
    "    \n",
    "\n",
    "    #dates_df = pd.DataFrame.from_dict(prices_request,orient='columns')\n",
    "    out_file = open(f\"MarketCap/{ticker}.json\", \"w\") \n",
    "    json.dump(prices_request, out_file, indent = 4) \n",
    "    out_file.close() \n",
    "    \n",
    "    with open(f'MarketCap/{ticker}.json','r') as f:\n",
    "        data = json.loads(f.read())\n",
    "    # Flatten data\n",
    "    df_nested_list = pd.json_normalize(data)\n",
    "    df_nested_list['Ticker'] = ticker\n",
    "    df_nested_list.to_csv(f\"MarketCap/{ticker}.csv\")\n",
    "    #return df_nested_list\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "95ca090c",
   "metadata": {},
   "outputs": [],
   "source": [
    "tickers = df_tech_sector_tickers['Ticker']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "2e383718",
   "metadata": {},
   "outputs": [],
   "source": [
    "# call the function\n",
    "result = [get_mcap(ticker) for ticker in tickers]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "87cda177",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=1b1251a5-d383-4d65-a0c4-3b26e8a7f377 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('1b1251a5-d383-4d65-a0c4-3b26e8a7f377').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>symbol</th>\n",
       "      <th>date</th>\n",
       "      <th>marketCap</th>\n",
       "      <th>Ticker</th>\n",
       "      <th>Error Message</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CSCO</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>195,526,279,168.00</td>\n",
       "      <td>CSCO</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CSCO</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>194,724,086,900.00</td>\n",
       "      <td>CSCO</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CSCO</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>196,408,409,200.00</td>\n",
       "      <td>CSCO</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CSCO</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>197,805,164,300.00</td>\n",
       "      <td>CSCO</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CSCO</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>202,529,482,800.00</td>\n",
       "      <td>CSCO</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>HUBS</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>12,816,344,064.00</td>\n",
       "      <td>HUBS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>HUBS</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>13,966,629,000.00</td>\n",
       "      <td>HUBS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>HUBS</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>14,353,295,600.00</td>\n",
       "      <td>HUBS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>HUBS</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>14,546,628,900.00</td>\n",
       "      <td>HUBS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>HUBS</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>15,231,067,500.00</td>\n",
       "      <td>HUBS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AEIS</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>3,345,413,632.00</td>\n",
       "      <td>AEIS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>AEIS</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>3,170,834,500.00</td>\n",
       "      <td>AEIS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>AEIS</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>3,321,114,600.00</td>\n",
       "      <td>AEIS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>AEIS</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>3,355,507,100.00</td>\n",
       "      <td>AEIS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AEIS</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>3,510,646,900.00</td>\n",
       "      <td>AEIS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>FEIM</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>48,895,928.00</td>\n",
       "      <td>FEIM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>FEIM</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>50,292,900.00</td>\n",
       "      <td>FEIM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>FEIM</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>52,621,300.00</td>\n",
       "      <td>FEIM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>FEIM</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>48,709,600.00</td>\n",
       "      <td>FEIM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>FEIM</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>48,337,100.00</td>\n",
       "      <td>FEIM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>PRGX</td>\n",
       "      <td>2021-03-10</td>\n",
       "      <td>177,468,780.00</td>\n",
       "      <td>PRGX</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>PRGX</td>\n",
       "      <td>2021-03-09</td>\n",
       "      <td>177,468,780.00</td>\n",
       "      <td>PRGX</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>PRGX</td>\n",
       "      <td>2021-03-08</td>\n",
       "      <td>177,468,780.00</td>\n",
       "      <td>PRGX</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>PRGX</td>\n",
       "      <td>2021-03-05</td>\n",
       "      <td>177,468,780.00</td>\n",
       "      <td>PRGX</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>PRGX</td>\n",
       "      <td>2021-03-04</td>\n",
       "      <td>177,468,780.00</td>\n",
       "      <td>PRGX</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>ASYS</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>144,865,408.00</td>\n",
       "      <td>ASYS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>ASYS</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>110,181,600.00</td>\n",
       "      <td>ASYS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>ASYS</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>112,141,600.00</td>\n",
       "      <td>ASYS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>ASYS</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>118,161,700.00</td>\n",
       "      <td>ASYS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ASYS</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>112,421,600.00</td>\n",
       "      <td>ASYS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>ADTN</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>1,593,499,136.00</td>\n",
       "      <td>ADTN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>ADTN</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>1,445,952,900.00</td>\n",
       "      <td>ADTN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>ADTN</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>1,470,802,700.00</td>\n",
       "      <td>ADTN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>ADTN</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>1,500,312,000.00</td>\n",
       "      <td>ADTN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>ADTN</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>1,595,828,700.00</td>\n",
       "      <td>ADTN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>EVTC</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>2,123,635,584.00</td>\n",
       "      <td>EVTC</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>EVTC</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>2,005,619,700.00</td>\n",
       "      <td>EVTC</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>EVTC</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>2,001,707,500.00</td>\n",
       "      <td>EVTC</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>EVTC</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>1,999,751,500.00</td>\n",
       "      <td>EVTC</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>EVTC</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>2,072,125,900.00</td>\n",
       "      <td>EVTC</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>SHSP</td>\n",
       "      <td>2022-02-09</td>\n",
       "      <td>220,362,576.00</td>\n",
       "      <td>SHSP</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>SHSP</td>\n",
       "      <td>2022-02-08</td>\n",
       "      <td>220,362,570.00</td>\n",
       "      <td>SHSP</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>SHSP</td>\n",
       "      <td>2022-02-07</td>\n",
       "      <td>220,362,570.00</td>\n",
       "      <td>SHSP</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>SHSP</td>\n",
       "      <td>2022-02-05</td>\n",
       "      <td>220,362,570.00</td>\n",
       "      <td>SHSP</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>SHSP</td>\n",
       "      <td>2022-02-04</td>\n",
       "      <td>220,362,570.00</td>\n",
       "      <td>SHSP</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>FSCT</td>\n",
       "      <td>2020-08-18</td>\n",
       "      <td>1,431,265,290.00</td>\n",
       "      <td>FSCT</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>FSCT</td>\n",
       "      <td>2020-08-17</td>\n",
       "      <td>1,419,988,180.00</td>\n",
       "      <td>FSCT</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>FSCT</td>\n",
       "      <td>2020-08-14</td>\n",
       "      <td>1,419,988,180.00</td>\n",
       "      <td>FSCT</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>FSCT</td>\n",
       "      <td>2020-08-13</td>\n",
       "      <td>1,419,988,180.00</td>\n",
       "      <td>FSCT</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>FSCT</td>\n",
       "      <td>2020-08-12</td>\n",
       "      <td>1,420,478,000.00</td>\n",
       "      <td>FSCT</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2291</th>\n",
       "      <td>OSS</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>64,103,680.00</td>\n",
       "      <td>OSS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2292</th>\n",
       "      <td>OSS</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>56,291,000.00</td>\n",
       "      <td>OSS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2293</th>\n",
       "      <td>OSS</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>57,693,300.00</td>\n",
       "      <td>OSS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2294</th>\n",
       "      <td>OSS</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>58,494,600.00</td>\n",
       "      <td>OSS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2295</th>\n",
       "      <td>OSS</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>59,696,600.00</td>\n",
       "      <td>OSS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2296</th>\n",
       "      <td>VRTU</td>\n",
       "      <td>2021-02-12</td>\n",
       "      <td>1,574,629,371.53</td>\n",
       "      <td>VRTU</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2297</th>\n",
       "      <td>VRTU</td>\n",
       "      <td>2021-02-11</td>\n",
       "      <td>1,553,707,984.53</td>\n",
       "      <td>VRTU</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2298</th>\n",
       "      <td>VRTU</td>\n",
       "      <td>2021-02-10</td>\n",
       "      <td>1,553,556,578.97</td>\n",
       "      <td>VRTU</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2299</th>\n",
       "      <td>VRTU</td>\n",
       "      <td>2021-02-09</td>\n",
       "      <td>1,553,102,574.20</td>\n",
       "      <td>VRTU</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2300</th>\n",
       "      <td>VRTU</td>\n",
       "      <td>2021-02-08</td>\n",
       "      <td>1,551,286,403.75</td>\n",
       "      <td>VRTU</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2301</th>\n",
       "      <td>BL</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>3,615,307,008.00</td>\n",
       "      <td>BL</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2302</th>\n",
       "      <td>BL</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>3,918,375,800.00</td>\n",
       "      <td>BL</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2303</th>\n",
       "      <td>BL</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>4,102,488,600.00</td>\n",
       "      <td>BL</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2304</th>\n",
       "      <td>BL</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>4,078,577,900.00</td>\n",
       "      <td>BL</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2305</th>\n",
       "      <td>BL</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>4,243,562,100.00</td>\n",
       "      <td>BL</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2306</th>\n",
       "      <td>CRM</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>144,850,010,112.00</td>\n",
       "      <td>CRM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2307</th>\n",
       "      <td>CRM</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>129,010,000,000.00</td>\n",
       "      <td>CRM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2308</th>\n",
       "      <td>CRM</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>128,270,000,000.00</td>\n",
       "      <td>CRM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2309</th>\n",
       "      <td>CRM</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>130,440,000,000.00</td>\n",
       "      <td>CRM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2310</th>\n",
       "      <td>CRM</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>134,750,000,000.00</td>\n",
       "      <td>CRM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2311</th>\n",
       "      <td>LRCX</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>61,391,007,744.00</td>\n",
       "      <td>LRCX</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2312</th>\n",
       "      <td>LRCX</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>59,828,235,100.00</td>\n",
       "      <td>LRCX</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2313</th>\n",
       "      <td>LRCX</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>60,541,498,900.00</td>\n",
       "      <td>LRCX</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2314</th>\n",
       "      <td>LRCX</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>60,833,350,600.00</td>\n",
       "      <td>LRCX</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2315</th>\n",
       "      <td>LRCX</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>63,858,243,400.00</td>\n",
       "      <td>LRCX</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2316</th>\n",
       "      <td>PRSP</td>\n",
       "      <td>2021-05-06</td>\n",
       "      <td>4,730,400,414.72</td>\n",
       "      <td>PRSP</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2317</th>\n",
       "      <td>PRSP</td>\n",
       "      <td>2021-05-05</td>\n",
       "      <td>4,713,177,600.00</td>\n",
       "      <td>PRSP</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2318</th>\n",
       "      <td>PRSP</td>\n",
       "      <td>2021-05-04</td>\n",
       "      <td>4,709,964,800.00</td>\n",
       "      <td>PRSP</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2319</th>\n",
       "      <td>PRSP</td>\n",
       "      <td>2021-05-03</td>\n",
       "      <td>4,703,539,200.00</td>\n",
       "      <td>PRSP</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2320</th>\n",
       "      <td>PRSP</td>\n",
       "      <td>2021-04-30</td>\n",
       "      <td>4,701,932,800.00</td>\n",
       "      <td>PRSP</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2321</th>\n",
       "      <td>APPS</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>1,604,072,192.00</td>\n",
       "      <td>APPS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2322</th>\n",
       "      <td>APPS</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>1,440,694,400.00</td>\n",
       "      <td>APPS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2323</th>\n",
       "      <td>APPS</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>1,506,045,500.00</td>\n",
       "      <td>APPS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2324</th>\n",
       "      <td>APPS</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>1,527,829,200.00</td>\n",
       "      <td>APPS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2325</th>\n",
       "      <td>APPS</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>1,645,659,200.00</td>\n",
       "      <td>APPS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2326</th>\n",
       "      <td>PLXS</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>2,957,226,240.00</td>\n",
       "      <td>PLXS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2327</th>\n",
       "      <td>PLXS</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>2,863,569,600.00</td>\n",
       "      <td>PLXS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2328</th>\n",
       "      <td>PLXS</td>\n",
       "      <td>2022-12-16</td>\n",
       "      <td>2,872,134,100.00</td>\n",
       "      <td>PLXS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2329</th>\n",
       "      <td>PLXS</td>\n",
       "      <td>2022-12-15</td>\n",
       "      <td>2,911,917,400.00</td>\n",
       "      <td>PLXS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2330</th>\n",
       "      <td>PLXS</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>2,984,024,700.00</td>\n",
       "      <td>PLXS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2331</th>\n",
       "      <td>TIVO</td>\n",
       "      <td>2020-06-02</td>\n",
       "      <td>0.00</td>\n",
       "      <td>TIVO</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2332</th>\n",
       "      <td>TIVO</td>\n",
       "      <td>2020-06-01</td>\n",
       "      <td>774,185,160.00</td>\n",
       "      <td>TIVO</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2333</th>\n",
       "      <td>TIVO</td>\n",
       "      <td>2020-05-29</td>\n",
       "      <td>774,185,160.00</td>\n",
       "      <td>TIVO</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2334</th>\n",
       "      <td>TIVO</td>\n",
       "      <td>2020-05-28</td>\n",
       "      <td>814,864,840.00</td>\n",
       "      <td>TIVO</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2335</th>\n",
       "      <td>TIVO</td>\n",
       "      <td>2020-05-27</td>\n",
       "      <td>882,240,560.00</td>\n",
       "      <td>TIVO</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2336</th>\n",
       "      <td>KEM</td>\n",
       "      <td>2020-06-12</td>\n",
       "      <td>1,599,104,490.00</td>\n",
       "      <td>KEM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2337</th>\n",
       "      <td>KEM</td>\n",
       "      <td>2020-06-11</td>\n",
       "      <td>1,597,929,110.00</td>\n",
       "      <td>KEM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2338</th>\n",
       "      <td>KEM</td>\n",
       "      <td>2020-06-10</td>\n",
       "      <td>1,597,929,110.00</td>\n",
       "      <td>KEM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2339</th>\n",
       "      <td>KEM</td>\n",
       "      <td>2020-06-09</td>\n",
       "      <td>1,597,929,110.00</td>\n",
       "      <td>KEM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2340</th>\n",
       "      <td>KEM</td>\n",
       "      <td>2020-06-08</td>\n",
       "      <td>1,591,464,520.00</td>\n",
       "      <td>KEM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "     symbol        date          marketCap Ticker Error Message\n",
       "0      CSCO  2022-12-20 195,526,279,168.00   CSCO           NaN\n",
       "1      CSCO  2022-12-19 194,724,086,900.00   CSCO           NaN\n",
       "2      CSCO  2022-12-16 196,408,409,200.00   CSCO           NaN\n",
       "3      CSCO  2022-12-15 197,805,164,300.00   CSCO           NaN\n",
       "4      CSCO  2022-12-14 202,529,482,800.00   CSCO           NaN\n",
       "...     ...         ...                ...    ...           ...\n",
       "2336    KEM  2020-06-12   1,599,104,490.00    KEM           NaN\n",
       "2337    KEM  2020-06-11   1,597,929,110.00    KEM           NaN\n",
       "2338    KEM  2020-06-10   1,597,929,110.00    KEM           NaN\n",
       "2339    KEM  2020-06-09   1,597,929,110.00    KEM           NaN\n",
       "2340    KEM  2020-06-08   1,591,464,520.00    KEM           NaN\n",
       "\n",
       "[2341 rows x 5 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path = '/Users/brendan/Desktop/Python/Software 2020/MarketCap'\n",
    "csv_files = [f for f in os.listdir(path) if f.endswith('csv')]\n",
    "raw_data_df = []\n",
    "for file in csv_files:\n",
    "    file = pd.read_csv('/Users/brendan/Desktop/Python/Software 2020/MarketCap/'+file)\n",
    "    df = pd.DataFrame(file)\n",
    "    #df['ticker'] = file\n",
    "    raw_data_df.append(df)\n",
    "master_df = pd.concat(raw_data_df, ignore_index=True)\n",
    "master_df = master_df.drop('Unnamed: 0',axis=1)\n",
    "master_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "327d0459",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_prices(ticker):\n",
    "    \n",
    "    \n",
    "    prices_request = requests.get(f'https://financialmodelingprep.com/api/v3/historical-price-full/{ticker}?apikey={api}').json()\n",
    "    \n",
    "\n",
    "    #dates_df = pd.DataFrame.from_dict(prices_request,orient='columns')\n",
    "    out_file = open(f\"Prices/{ticker}.json\", \"w\") \n",
    "    json.dump(prices_request, out_file, indent = 4) \n",
    "    out_file.close() \n",
    "    \n",
    "    with open(f'Prices/{ticker}.json','r') as f:\n",
    "        data = json.loads(f.read())\n",
    "    # Flatten data\n",
    "    df_nested_list = pd.json_normalize(data)\n",
    "    df_nested_list['Ticker'] = ticker\n",
    "    df_nested_list.to_csv(f\"Prices/{ticker}.csv\")\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "ccc9e618",
   "metadata": {},
   "outputs": [],
   "source": [
    "# call the function\n",
    "result_price = [get_prices(ticker) for ticker in tickers]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "e35cc20d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=fbb7b675-fd01-437d-a0d7-401de548560c style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('fbb7b675-fd01-437d-a0d7-401de548560c').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Error Message</th>\n",
       "      <th>Ticker</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>CSCO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>HUBS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>AEIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>FEIM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>PRGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>ASYS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>ADTN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>EVTC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>SHSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>FSCT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>AMKR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>VPG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>XELA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>WSTG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>QUIK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>TER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>UI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>AMSWA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>FORM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>V</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>QRVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>CIEN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>MX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>FLT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>SWKS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>LPTH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>ENPH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>NCR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>IEC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>NXTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>MCHP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>CDNS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>IVAC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>EGOV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>PEGA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>DAIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>QTWO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>RBBN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>TSRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>DGII</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>GWRE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>VSH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>ZS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>SMAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>TDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>ACIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>UEPS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>VRNT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>ACIW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>STCN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>VIAV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>MEI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>DBD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>XRX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>EVOP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>SATS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>EXLS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>SVMK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>TRT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>KTCC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>SWI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>NATI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>TEUM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>GSKY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>LITE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>NTAP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>BLIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>BNFT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>SITM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>447</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>ALOT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>KEYS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>SEAC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>WTT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>OBLG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>COHU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>RST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>IDEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>SPLK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>CTSH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>CODA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>AZPN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>MU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>MKSI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>EMAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>SCON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>FARO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>RESN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>CDW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>CNXN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>OSS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>VRTU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>BL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>CRM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>LRCX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>PRSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>APPS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>PLXS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>TIVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>0</td>\n",
       "      <td>Limit Reach . Please upgrade your plan or visit our documentation for more details at https://financialmodelingprep.com/developer/docs/pricing</td>\n",
       "      <td>KEM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "     Unnamed: 0                                      Error Message Ticker\n",
       "0             0  Limit Reach . Please upgrade your plan or visi...   CSCO\n",
       "1             0  Limit Reach . Please upgrade your plan or visi...   HUBS\n",
       "2             0  Limit Reach . Please upgrade your plan or visi...   AEIS\n",
       "3             0  Limit Reach . Please upgrade your plan or visi...   FEIM\n",
       "4             0  Limit Reach . Please upgrade your plan or visi...   PRGX\n",
       "..          ...                                                ...    ...\n",
       "472           0  Limit Reach . Please upgrade your plan or visi...   PRSP\n",
       "473           0  Limit Reach . Please upgrade your plan or visi...   APPS\n",
       "474           0  Limit Reach . Please upgrade your plan or visi...   PLXS\n",
       "475           0  Limit Reach . Please upgrade your plan or visi...   TIVO\n",
       "476           0  Limit Reach . Please upgrade your plan or visi...    KEM\n",
       "\n",
       "[477 rows x 3 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path = '/Users/brendan/Desktop/Python/Software 2020/Prices'\n",
    "csv_files = [f for f in os.listdir(path) if f.endswith('csv')]\n",
    "raw_data_df = []\n",
    "for file in csv_files:\n",
    "    file = pd.read_csv('/Users/brendan/Desktop/Python/Software 2020/Prices/'+file)\n",
    "    df = pd.DataFrame(file)\n",
    "    #df['ticker'] = file\n",
    "    raw_data_df.append(df)\n",
    "master_df_prices = pd.concat(raw_data_df, ignore_index=True)\n",
    "#master_df_price = master_df.drop('Unnamed: 0',axis=1)\n",
    "master_df_prices"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "616a6d05",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}