Ações_Analises11.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Ações_Analises11.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyNw7Gyhr6SDqPxkijcNRfh/",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/fonsecajr/Projects/blob/master/A%C3%A7%C3%B5es_Analises11.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vqTw6UPgGFWh",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "# Refer site http://www.b3.com.br/pt_br/market-data-e-indices/"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VARj4ctKIsNv",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 232
        },
        "outputId": "6ab90a8c-bae1-40ff-820d-0e9d4cd54e33"
      },
      "source": [
        "!pip install yfinance"
      ],
      "execution_count": 45,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Requirement already satisfied: yfinance in /usr/local/lib/python3.6/dist-packages (0.1.54)\n",
            "Requirement already satisfied: numpy>=1.15 in /usr/local/lib/python3.6/dist-packages (from yfinance) (1.18.5)\n",
            "Requirement already satisfied: requests>=2.20 in /usr/local/lib/python3.6/dist-packages (from yfinance) (2.23.0)\n",
            "Requirement already satisfied: pandas>=0.24 in /usr/local/lib/python3.6/dist-packages (from yfinance) (1.0.5)\n",
            "Requirement already satisfied: multitasking>=0.0.7 in /usr/local/lib/python3.6/dist-packages (from yfinance) (0.0.9)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.6/dist-packages (from requests>=2.20->yfinance) (2020.4.5.2)\n",
            "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/local/lib/python3.6/dist-packages (from requests>=2.20->yfinance) (3.0.4)\n",
            "Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.6/dist-packages (from requests>=2.20->yfinance) (2.9)\n",
            "Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /usr/local/lib/python3.6/dist-packages (from requests>=2.20->yfinance) (1.24.3)\n",
            "Requirement already satisfied: python-dateutil>=2.6.1 in /usr/local/lib/python3.6/dist-packages (from pandas>=0.24->yfinance) (2.8.1)\n",
            "Requirement already satisfied: pytz>=2017.2 in /usr/local/lib/python3.6/dist-packages (from pandas>=0.24->yfinance) (2018.9)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.6/dist-packages (from python-dateutil>=2.6.1->pandas>=0.24->yfinance) (1.12.0)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bl5wWZ7_AIBr",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import pandas as pd; pd.set_option('display.min_rows', 50); pd.set_option('display.max_rows', 200)\n",
        "import numpy as np\n",
        "import yfinance as yf\n",
        "from google.colab import files"
      ],
      "execution_count": 46,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "TzM7gVE2AnSs",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def busca_carteira_teorica(indice):\n",
        "  url = 'http://bvmf.bmfbovespa.com.br/indices/ResumoCarteiraTeorica.aspx?Indice={}&idioma=pt-br'.format(indice.upper())\n",
        "  return pd.read_html(url, index_col='Código', thousands='.', decimal=',')[0][:-1]"
      ],
      "execution_count": 47,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "eV1jkk8yAxrN",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "ibov = busca_carteira_teorica('ibov')"
      ],
      "execution_count": 48,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "yilnt909DUKd",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "44005eff-3d76-483c-d52e-6c25684810db"
      },
      "source": [
        "ibov.sort_values('Part. (%)', ascending=False)"
      ],
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Ação</th>\n",
              "      <th>Tipo</th>\n",
              "      <th>Qtde. Teórica</th>\n",
              "      <th>Part. (%)</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Código</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>VALE3</th>\n",
              "      <td>VALE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>3292010807</td>\n",
              "      <td>10.557</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ITUB4</th>\n",
              "      <td>ITAUUNIBANCO</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4738562684</td>\n",
              "      <td>7.343</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>B3SA3</th>\n",
              "      <td>B3</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>2046021644</td>\n",
              "      <td>6.171</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PETR4</th>\n",
              "      <td>PETROBRAS</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>4520185835</td>\n",
              "      <td>5.645</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBDC4</th>\n",
              "      <td>BRADESCO</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4261649634</td>\n",
              "      <td>5.298</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PETR3</th>\n",
              "      <td>PETROBRAS</td>\n",
              "      <td>ON N2</td>\n",
              "      <td>2949857480</td>\n",
              "      <td>3.831</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ABEV3</th>\n",
              "      <td>AMBEV S/A</td>\n",
              "      <td>ON</td>\n",
              "      <td>4354228928</td>\n",
              "      <td>3.499</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBAS3</th>\n",
              "      <td>BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1418466803</td>\n",
              "      <td>2.743</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MGLU3</th>\n",
              "      <td>MAGAZ LUIZA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>661834080</td>\n",
              "      <td>2.682</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ITSA4</th>\n",
              "      <td>ITAUSA</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4494029326</td>\n",
              "      <td>2.608</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>JBSS3</th>\n",
              "      <td>JBS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1620646499</td>\n",
              "      <td>2.013</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LREN3</th>\n",
              "      <td>LOJAS RENNER</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>785308019</td>\n",
              "      <td>1.894</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>WEGE3</th>\n",
              "      <td>WEG</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>689271972</td>\n",
              "      <td>1.834</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GNDI3</th>\n",
              "      <td>INTERMEDICA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>458380483</td>\n",
              "      <td>1.752</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NTCO3</th>\n",
              "      <td>GRUPO NATURA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>706484775</td>\n",
              "      <td>1.726</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SUZB3</th>\n",
              "      <td>SUZANO S.A.</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>725859318</td>\n",
              "      <td>1.593</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RAIL3</th>\n",
              "      <td>RUMO S.A.</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1053753059</td>\n",
              "      <td>1.447</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RENT3</th>\n",
              "      <td>LOCALIZA</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>593233155</td>\n",
              "      <td>1.427</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBDC3</th>\n",
              "      <td>BRADESCO</td>\n",
              "      <td>ON N1</td>\n",
              "      <td>1253093907</td>\n",
              "      <td>1.421</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LAME4</th>\n",
              "      <td>LOJAS AMERIC</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>696190451</td>\n",
              "      <td>1.313</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RADL3</th>\n",
              "      <td>RAIADROGASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>207425426</td>\n",
              "      <td>1.307</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EQTL3</th>\n",
              "      <td>EQUATORIAL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1010186085</td>\n",
              "      <td>1.291</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VIVT4</th>\n",
              "      <td>TELEF BRASIL</td>\n",
              "      <td>PN</td>\n",
              "      <td>415131868</td>\n",
              "      <td>1.179</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BTOW3</th>\n",
              "      <td>B2W DIGITAL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>194807150</td>\n",
              "      <td>1.161</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>UGPA3</th>\n",
              "      <td>ULTRAPAR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1086422872</td>\n",
              "      <td>1.157</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SBSP3</th>\n",
              "      <td>SABESP</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>339982576</td>\n",
              "      <td>1.151</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBSE3</th>\n",
              "      <td>BBSEGURIDADE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>671601167</td>\n",
              "      <td>1.114</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRFS3</th>\n",
              "      <td>BRF SA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>811416229</td>\n",
              "      <td>1.038</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VVAR3</th>\n",
              "      <td>VIAVAREJO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1146662628</td>\n",
              "      <td>0.994</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CCRO3</th>\n",
              "      <td>CCR SA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1115695556</td>\n",
              "      <td>0.943</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GGBR4</th>\n",
              "      <td>GERDAU</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>1031246473</td>\n",
              "      <td>0.923</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BPAC11</th>\n",
              "      <td>BTGP BANCO</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>201102231</td>\n",
              "      <td>0.910</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRDT3</th>\n",
              "      <td>PETROBRAS BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>728125000</td>\n",
              "      <td>0.907</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HYPE3</th>\n",
              "      <td>HYPERA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>407518048</td>\n",
              "      <td>0.824</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HAPV3</th>\n",
              "      <td>HAPVIDA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>217060254</td>\n",
              "      <td>0.781</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>COGN3</th>\n",
              "      <td>COGNA ON</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1829322117</td>\n",
              "      <td>0.740</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>KLBN11</th>\n",
              "      <td>KLABIN S/A</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>637772642</td>\n",
              "      <td>0.735</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SULA11</th>\n",
              "      <td>SUL AMERICA</td>\n",
              "      <td>UNT EJ N2</td>\n",
              "      <td>278742752</td>\n",
              "      <td>0.717</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ENGI11</th>\n",
              "      <td>ENERGISA</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>250709436</td>\n",
              "      <td>0.693</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TIMP3</th>\n",
              "      <td>TIM PART S/A</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>807711660</td>\n",
              "      <td>0.662</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>YDUQ3</th>\n",
              "      <td>YDUQS PART</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>299667897</td>\n",
              "      <td>0.640</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EGIE3</th>\n",
              "      <td>ENGIE BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>254813401</td>\n",
              "      <td>0.636</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CMIG4</th>\n",
              "      <td>CEMIG</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>966005862</td>\n",
              "      <td>0.635</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PCAR3</th>\n",
              "      <td>P.ACUCAR-CBD</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>156575731</td>\n",
              "      <td>0.632</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SANB11</th>\n",
              "      <td>SANTANDER BR</td>\n",
              "      <td>UNT</td>\n",
              "      <td>362227661</td>\n",
              "      <td>0.630</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ELET3</th>\n",
              "      <td>ELETROBRAS</td>\n",
              "      <td>ON N1</td>\n",
              "      <td>358028908</td>\n",
              "      <td>0.624</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>IRBR3</th>\n",
              "      <td>IRBBRASIL RE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>923377994</td>\n",
              "      <td>0.613</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CSAN3</th>\n",
              "      <td>COSAN</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>153417832</td>\n",
              "      <td>0.609</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TOTS3</th>\n",
              "      <td>TOTVS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>403397655</td>\n",
              "      <td>0.532</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRML3</th>\n",
              "      <td>BR MALLS PAR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>843313591</td>\n",
              "      <td>0.510</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>QUAL3</th>\n",
              "      <td>QUALICORP</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>281558308</td>\n",
              "      <td>0.473</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRAP4</th>\n",
              "      <td>BRADESPAR</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>222089397</td>\n",
              "      <td>0.472</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FLRY3</th>\n",
              "      <td>FLEURY</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>305126422</td>\n",
              "      <td>0.442</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ELET6</th>\n",
              "      <td>ELETROBRAS</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>240022548</td>\n",
              "      <td>0.439</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CRFB3</th>\n",
              "      <td>CARREFOUR BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>384888219</td>\n",
              "      <td>0.438</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CSNA3</th>\n",
              "      <td>SID NACIONAL</td>\n",
              "      <td>ON</td>\n",
              "      <td>642387288</td>\n",
              "      <td>0.422</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>AZUL4</th>\n",
              "      <td>AZUL</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>317471474</td>\n",
              "      <td>0.412</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CYRE3</th>\n",
              "      <td>CYRELA REALT</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>281154098</td>\n",
              "      <td>0.381</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRKM5</th>\n",
              "      <td>BRASKEM</td>\n",
              "      <td>PNA N1</td>\n",
              "      <td>264632416</td>\n",
              "      <td>0.380</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EMBR3</th>\n",
              "      <td>EMBRAER</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>736171905</td>\n",
              "      <td>0.362</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TAEE11</th>\n",
              "      <td>TAESA</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>218568274</td>\n",
              "      <td>0.360</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CIEL3</th>\n",
              "      <td>CIELO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1118386806</td>\n",
              "      <td>0.349</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MULT3</th>\n",
              "      <td>MULTIPLAN</td>\n",
              "      <td>ON N2</td>\n",
              "      <td>270279854</td>\n",
              "      <td>0.342</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MRVE3</th>\n",
              "      <td>MRV</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>294706737</td>\n",
              "      <td>0.310</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MRFG3</th>\n",
              "      <td>MARFRIG</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>423143092</td>\n",
              "      <td>0.305</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CPFE3</th>\n",
              "      <td>CPFL ENERGIA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>170209781</td>\n",
              "      <td>0.300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ENBR3</th>\n",
              "      <td>ENERGIAS BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>295402225</td>\n",
              "      <td>0.299</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GOAU4</th>\n",
              "      <td>GERDAU MET</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>662644908</td>\n",
              "      <td>0.274</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>USIM5</th>\n",
              "      <td>USIMINAS</td>\n",
              "      <td>PNA N1</td>\n",
              "      <td>513781576</td>\n",
              "      <td>0.228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BEEF3</th>\n",
              "      <td>MINERVA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>259260688</td>\n",
              "      <td>0.194</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>IGTA3</th>\n",
              "      <td>IGUATEMI</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>86913923</td>\n",
              "      <td>0.180</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CVCB3</th>\n",
              "      <td>CVC BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>145617442</td>\n",
              "      <td>0.165</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GOLL4</th>\n",
              "      <td>GOL</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>134613917</td>\n",
              "      <td>0.154</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ECOR3</th>\n",
              "      <td>ECORODOVIAS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>171079276</td>\n",
              "      <td>0.128</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HGTX3</th>\n",
              "      <td>CIA HERING</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>126302831</td>\n",
              "      <td>0.106</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                Ação       Tipo Qtde. Teórica  Part. (%)\n",
              "Código                                                  \n",
              "VALE3           VALE      ON NM    3292010807     10.557\n",
              "ITUB4   ITAUUNIBANCO      PN N1    4738562684      7.343\n",
              "B3SA3             B3      ON NM    2046021644      6.171\n",
              "PETR4      PETROBRAS      PN N2    4520185835      5.645\n",
              "BBDC4       BRADESCO      PN N1    4261649634      5.298\n",
              "PETR3      PETROBRAS      ON N2    2949857480      3.831\n",
              "ABEV3      AMBEV S/A         ON    4354228928      3.499\n",
              "BBAS3         BRASIL      ON NM    1418466803      2.743\n",
              "MGLU3    MAGAZ LUIZA      ON NM     661834080      2.682\n",
              "ITSA4         ITAUSA      PN N1    4494029326      2.608\n",
              "JBSS3            JBS      ON NM    1620646499      2.013\n",
              "LREN3   LOJAS RENNER   ON EJ NM     785308019      1.894\n",
              "WEGE3            WEG      ON NM     689271972      1.834\n",
              "GNDI3    INTERMEDICA      ON NM     458380483      1.752\n",
              "NTCO3   GRUPO NATURA      ON NM     706484775      1.726\n",
              "SUZB3    SUZANO S.A.      ON NM     725859318      1.593\n",
              "RAIL3      RUMO S.A.      ON NM    1053753059      1.447\n",
              "RENT3       LOCALIZA   ON EJ NM     593233155      1.427\n",
              "BBDC3       BRADESCO      ON N1    1253093907      1.421\n",
              "LAME4   LOJAS AMERIC      PN N1     696190451      1.313\n",
              "RADL3   RAIADROGASIL      ON NM     207425426      1.307\n",
              "EQTL3     EQUATORIAL      ON NM    1010186085      1.291\n",
              "VIVT4   TELEF BRASIL         PN     415131868      1.179\n",
              "BTOW3    B2W DIGITAL      ON NM     194807150      1.161\n",
              "UGPA3       ULTRAPAR      ON NM    1086422872      1.157\n",
              "SBSP3         SABESP      ON NM     339982576      1.151\n",
              "BBSE3   BBSEGURIDADE      ON NM     671601167      1.114\n",
              "BRFS3         BRF SA      ON NM     811416229      1.038\n",
              "VVAR3      VIAVAREJO      ON NM    1146662628      0.994\n",
              "CCRO3         CCR SA      ON NM    1115695556      0.943\n",
              "GGBR4         GERDAU      PN N1    1031246473      0.923\n",
              "BPAC11    BTGP BANCO     UNT N2     201102231      0.910\n",
              "BRDT3   PETROBRAS BR      ON NM     728125000      0.907\n",
              "HYPE3         HYPERA      ON NM     407518048      0.824\n",
              "HAPV3        HAPVIDA      ON NM     217060254      0.781\n",
              "COGN3       COGNA ON      ON NM    1829322117      0.740\n",
              "KLBN11    KLABIN S/A     UNT N2     637772642      0.735\n",
              "SULA11   SUL AMERICA  UNT EJ N2     278742752      0.717\n",
              "ENGI11      ENERGISA     UNT N2     250709436      0.693\n",
              "TIMP3   TIM PART S/A      ON NM     807711660      0.662\n",
              "YDUQ3     YDUQS PART      ON NM     299667897      0.640\n",
              "EGIE3   ENGIE BRASIL      ON NM     254813401      0.636\n",
              "CMIG4          CEMIG      PN N1     966005862      0.635\n",
              "PCAR3   P.ACUCAR-CBD      ON NM     156575731      0.632\n",
              "SANB11  SANTANDER BR        UNT     362227661      0.630\n",
              "ELET3     ELETROBRAS      ON N1     358028908      0.624\n",
              "IRBR3   IRBBRASIL RE      ON NM     923377994      0.613\n",
              "CSAN3          COSAN      ON NM     153417832      0.609\n",
              "TOTS3          TOTVS      ON NM     403397655      0.532\n",
              "BRML3   BR MALLS PAR      ON NM     843313591      0.510\n",
              "QUAL3      QUALICORP      ON NM     281558308      0.473\n",
              "BRAP4      BRADESPAR      PN N1     222089397      0.472\n",
              "FLRY3         FLEURY      ON NM     305126422      0.442\n",
              "ELET6     ELETROBRAS     PNB N1     240022548      0.439\n",
              "CRFB3   CARREFOUR BR      ON NM     384888219      0.438\n",
              "CSNA3   SID NACIONAL         ON     642387288      0.422\n",
              "AZUL4           AZUL      PN N2     317471474      0.412\n",
              "CYRE3   CYRELA REALT      ON NM     281154098      0.381\n",
              "BRKM5        BRASKEM     PNA N1     264632416      0.380\n",
              "EMBR3        EMBRAER      ON NM     736171905      0.362\n",
              "TAEE11         TAESA     UNT N2     218568274      0.360\n",
              "CIEL3          CIELO      ON NM    1118386806      0.349\n",
              "MULT3      MULTIPLAN      ON N2     270279854      0.342\n",
              "MRVE3            MRV      ON NM     294706737      0.310\n",
              "MRFG3        MARFRIG      ON NM     423143092      0.305\n",
              "CPFE3   CPFL ENERGIA      ON NM     170209781      0.300\n",
              "ENBR3    ENERGIAS BR      ON NM     295402225      0.299\n",
              "GOAU4     GERDAU MET      PN N1     662644908      0.274\n",
              "USIM5       USIMINAS     PNA N1     513781576      0.228\n",
              "BEEF3        MINERVA      ON NM     259260688      0.194\n",
              "IGTA3       IGUATEMI      ON NM      86913923      0.180\n",
              "CVCB3     CVC BRASIL      ON NM     145617442      0.165\n",
              "GOLL4            GOL      PN N2     134613917      0.154\n",
              "ECOR3    ECORODOVIAS      ON NM     171079276      0.128\n",
              "HGTX3     CIA HERING      ON NM     126302831      0.106"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pRl5x3oCGT4Q",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "idiv = busca_carteira_teorica('idiv') "
      ],
      "execution_count": 50,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XZIYOCioGZsH",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "0429e12a-1c62-4d81-b1b1-9453f3a1210c"
      },
      "source": [
        "idiv.sort_values('Part. (%)', ascending=False)"
      ],
      "execution_count": 51,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Ação</th>\n",
              "      <th>Tipo</th>\n",
              "      <th>Qtde. Teórica</th>\n",
              "      <th>Part. (%)</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Código</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>EGIE3</th>\n",
              "      <td>ENGIE BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>430350077</td>\n",
              "      <td>5.350</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BPAC11</th>\n",
              "      <td>BTGP BANCO</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>230517903</td>\n",
              "      <td>5.200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBSE3</th>\n",
              "      <td>BBSEGURIDADE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>627317974</td>\n",
              "      <td>5.185</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CYRE3</th>\n",
              "      <td>CYRELA REALT</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>652799987</td>\n",
              "      <td>4.405</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ITSA4</th>\n",
              "      <td>ITAUSA</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>1521145798</td>\n",
              "      <td>4.399</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ITUB3</th>\n",
              "      <td>ITAUUNIBANCO</td>\n",
              "      <td>ON N1</td>\n",
              "      <td>585681949</td>\n",
              "      <td>4.225</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TAEE11</th>\n",
              "      <td>TAESA</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>507484570</td>\n",
              "      <td>4.167</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TRPL4</th>\n",
              "      <td>TRAN PAULIST</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>706521313</td>\n",
              "      <td>4.149</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ITUB4</th>\n",
              "      <td>ITAUUNIBANCO</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>497324728</td>\n",
              "      <td>3.840</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SAPR11</th>\n",
              "      <td>SANEPAR</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>400530910</td>\n",
              "      <td>3.748</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MRVE3</th>\n",
              "      <td>MRV</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>684267295</td>\n",
              "      <td>3.592</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CMIG4</th>\n",
              "      <td>CEMIG</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>1061002087</td>\n",
              "      <td>3.477</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>QUAL3</th>\n",
              "      <td>QUALICORP</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>399332735</td>\n",
              "      <td>3.341</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SANB11</th>\n",
              "      <td>SANTANDER BR</td>\n",
              "      <td>UNT</td>\n",
              "      <td>382664019</td>\n",
              "      <td>3.318</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CIEL3</th>\n",
              "      <td>CIELO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>2038696476</td>\n",
              "      <td>3.165</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PSSA3</th>\n",
              "      <td>PORTO SEGURO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>197486966</td>\n",
              "      <td>3.089</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TIET11</th>\n",
              "      <td>AES TIETE E</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>691647658</td>\n",
              "      <td>2.987</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VIVT4</th>\n",
              "      <td>TELEF BRASIL</td>\n",
              "      <td>PN</td>\n",
              "      <td>208096300</td>\n",
              "      <td>2.945</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>KLBN11</th>\n",
              "      <td>KLABIN S/A</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>507103400</td>\n",
              "      <td>2.911</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBAS3</th>\n",
              "      <td>BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>292273137</td>\n",
              "      <td>2.817</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ENBR3</th>\n",
              "      <td>ENERGIAS BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>536060575</td>\n",
              "      <td>2.706</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CPLE6</th>\n",
              "      <td>COPEL</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>147069346</td>\n",
              "      <td>2.673</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CCRO3</th>\n",
              "      <td>CCR SA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>634699248</td>\n",
              "      <td>2.673</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CSMG3</th>\n",
              "      <td>COPASA</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>146206806</td>\n",
              "      <td>2.527</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRAP4</th>\n",
              "      <td>BRADESPAR</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>235215034</td>\n",
              "      <td>2.489</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CPLE3</th>\n",
              "      <td>COPEL</td>\n",
              "      <td>ON N1</td>\n",
              "      <td>139195114</td>\n",
              "      <td>2.471</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRSR6</th>\n",
              "      <td>BANRISUL</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>470249545</td>\n",
              "      <td>1.985</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SLCE3</th>\n",
              "      <td>SLC AGRICOLA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>197555563</td>\n",
              "      <td>1.322</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SAPR4</th>\n",
              "      <td>SANEPAR</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>472507044</td>\n",
              "      <td>0.882</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TUPY3</th>\n",
              "      <td>TUPY</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>153120787</td>\n",
              "      <td>0.856</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ABCB4</th>\n",
              "      <td>ABC BRASIL</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>170112975</td>\n",
              "      <td>0.763</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>UNIP6</th>\n",
              "      <td>UNIPAR</td>\n",
              "      <td>PNB</td>\n",
              "      <td>106012332</td>\n",
              "      <td>0.742</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>WIZS3</th>\n",
              "      <td>WIZ S.A.</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>178299274</td>\n",
              "      <td>0.584</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TGMA3</th>\n",
              "      <td>TEGMA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>74315204</td>\n",
              "      <td>0.517</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LEVE3</th>\n",
              "      <td>METAL LEVE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>89374176</td>\n",
              "      <td>0.500</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                Ação      Tipo Qtde. Teórica  Part. (%)\n",
              "Código                                                 \n",
              "EGIE3   ENGIE BRASIL     ON NM     430350077      5.350\n",
              "BPAC11    BTGP BANCO    UNT N2     230517903      5.200\n",
              "BBSE3   BBSEGURIDADE     ON NM     627317974      5.185\n",
              "CYRE3   CYRELA REALT     ON NM     652799987      4.405\n",
              "ITSA4         ITAUSA     PN N1    1521145798      4.399\n",
              "ITUB3   ITAUUNIBANCO     ON N1     585681949      4.225\n",
              "TAEE11         TAESA    UNT N2     507484570      4.167\n",
              "TRPL4   TRAN PAULIST     PN N1     706521313      4.149\n",
              "ITUB4   ITAUUNIBANCO     PN N1     497324728      3.840\n",
              "SAPR11       SANEPAR    UNT N2     400530910      3.748\n",
              "MRVE3            MRV     ON NM     684267295      3.592\n",
              "CMIG4          CEMIG     PN N1    1061002087      3.477\n",
              "QUAL3      QUALICORP     ON NM     399332735      3.341\n",
              "SANB11  SANTANDER BR       UNT     382664019      3.318\n",
              "CIEL3          CIELO     ON NM    2038696476      3.165\n",
              "PSSA3   PORTO SEGURO     ON NM     197486966      3.089\n",
              "TIET11   AES TIETE E    UNT N2     691647658      2.987\n",
              "VIVT4   TELEF BRASIL        PN     208096300      2.945\n",
              "KLBN11    KLABIN S/A    UNT N2     507103400      2.911\n",
              "BBAS3         BRASIL     ON NM     292273137      2.817\n",
              "ENBR3    ENERGIAS BR     ON NM     536060575      2.706\n",
              "CPLE6          COPEL    PNB N1     147069346      2.673\n",
              "CCRO3         CCR SA     ON NM     634699248      2.673\n",
              "CSMG3         COPASA  ON EJ NM     146206806      2.527\n",
              "BRAP4      BRADESPAR     PN N1     235215034      2.489\n",
              "CPLE3          COPEL     ON N1     139195114      2.471\n",
              "BRSR6       BANRISUL    PNB N1     470249545      1.985\n",
              "SLCE3   SLC AGRICOLA     ON NM     197555563      1.322\n",
              "SAPR4        SANEPAR     PN N2     472507044      0.882\n",
              "TUPY3           TUPY     ON NM     153120787      0.856\n",
              "ABCB4     ABC BRASIL     PN N2     170112975      0.763\n",
              "UNIP6         UNIPAR       PNB     106012332      0.742\n",
              "WIZS3       WIZ S.A.     ON NM     178299274      0.584\n",
              "TGMA3          TEGMA     ON NM      74315204      0.517\n",
              "LEVE3     METAL LEVE     ON NM      89374176      0.500"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 51
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "o05pwR0rG2YO",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "ibrx = busca_carteira_teorica('ibrx')"
      ],
      "execution_count": 52,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6NRJaVsvHFBF",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "b36cdbb0-ade0-4d2c-969d-c6dcdf279ce2"
      },
      "source": [
        "ibrx.sort_values('Part. (%)', ascending=False)"
      ],
      "execution_count": 53,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Ação</th>\n",
              "      <th>Tipo</th>\n",
              "      <th>Qtde. Teórica</th>\n",
              "      <th>Part. (%)</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Código</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>VALE3</th>\n",
              "      <td>VALE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>3292010807</td>\n",
              "      <td>9.899</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ITUB4</th>\n",
              "      <td>ITAUUNIBANCO</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4738562684</td>\n",
              "      <td>6.885</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>B3SA3</th>\n",
              "      <td>B3</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>2046021644</td>\n",
              "      <td>5.786</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PETR4</th>\n",
              "      <td>PETROBRAS</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>4520185835</td>\n",
              "      <td>5.293</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBDC4</th>\n",
              "      <td>BRADESCO</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4261649634</td>\n",
              "      <td>4.968</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PETR3</th>\n",
              "      <td>PETROBRAS</td>\n",
              "      <td>ON N2</td>\n",
              "      <td>2949857480</td>\n",
              "      <td>3.592</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ABEV3</th>\n",
              "      <td>AMBEV S/A</td>\n",
              "      <td>ON</td>\n",
              "      <td>4354228928</td>\n",
              "      <td>3.281</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBAS3</th>\n",
              "      <td>BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1418466803</td>\n",
              "      <td>2.573</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MGLU3</th>\n",
              "      <td>MAGAZ LUIZA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>661834080</td>\n",
              "      <td>2.515</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ITSA4</th>\n",
              "      <td>ITAUSA</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4494029326</td>\n",
              "      <td>2.445</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>JBSS3</th>\n",
              "      <td>JBS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1620646499</td>\n",
              "      <td>1.887</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>WEGE3</th>\n",
              "      <td>WEG</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>740696136</td>\n",
              "      <td>1.848</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LREN3</th>\n",
              "      <td>LOJAS RENNER</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>785308019</td>\n",
              "      <td>1.776</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GNDI3</th>\n",
              "      <td>INTERMEDICA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>458380483</td>\n",
              "      <td>1.643</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NTCO3</th>\n",
              "      <td>GRUPO NATURA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>706484775</td>\n",
              "      <td>1.618</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SUZB3</th>\n",
              "      <td>SUZANO S.A.</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>725859318</td>\n",
              "      <td>1.494</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RAIL3</th>\n",
              "      <td>RUMO S.A.</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1053753059</td>\n",
              "      <td>1.357</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RENT3</th>\n",
              "      <td>LOCALIZA</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>593233155</td>\n",
              "      <td>1.338</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBDC3</th>\n",
              "      <td>BRADESCO</td>\n",
              "      <td>ON N1</td>\n",
              "      <td>1253093907</td>\n",
              "      <td>1.332</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RADL3</th>\n",
              "      <td>RAIADROGASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>213553757</td>\n",
              "      <td>1.262</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LAME4</th>\n",
              "      <td>LOJAS AMERIC</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>696190451</td>\n",
              "      <td>1.231</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EQTL3</th>\n",
              "      <td>EQUATORIAL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1010186085</td>\n",
              "      <td>1.210</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VIVT4</th>\n",
              "      <td>TELEF BRASIL</td>\n",
              "      <td>PN</td>\n",
              "      <td>415131868</td>\n",
              "      <td>1.105</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BTOW3</th>\n",
              "      <td>B2W DIGITAL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>194807150</td>\n",
              "      <td>1.088</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>UGPA3</th>\n",
              "      <td>ULTRAPAR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1086422872</td>\n",
              "      <td>1.085</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SBSP3</th>\n",
              "      <td>SABESP</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>339982576</td>\n",
              "      <td>1.079</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBSE3</th>\n",
              "      <td>BBSEGURIDADE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>671601167</td>\n",
              "      <td>1.044</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRFS3</th>\n",
              "      <td>BRF SA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>811416229</td>\n",
              "      <td>0.973</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VVAR3</th>\n",
              "      <td>VIAVAREJO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1146662628</td>\n",
              "      <td>0.932</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CCRO3</th>\n",
              "      <td>CCR SA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1115695556</td>\n",
              "      <td>0.884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GGBR4</th>\n",
              "      <td>GERDAU</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>1031246473</td>\n",
              "      <td>0.865</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BPAC11</th>\n",
              "      <td>BTGP BANCO</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>201102231</td>\n",
              "      <td>0.853</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRDT3</th>\n",
              "      <td>PETROBRAS BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>728125000</td>\n",
              "      <td>0.851</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HYPE3</th>\n",
              "      <td>HYPERA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>407518048</td>\n",
              "      <td>0.773</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HAPV3</th>\n",
              "      <td>HAPVIDA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>217060254</td>\n",
              "      <td>0.733</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ENEV3</th>\n",
              "      <td>ENEVA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>315006451</td>\n",
              "      <td>0.711</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>COGN3</th>\n",
              "      <td>COGNA ON</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1829322117</td>\n",
              "      <td>0.694</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>KLBN11</th>\n",
              "      <td>KLABIN S/A</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>637772642</td>\n",
              "      <td>0.689</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SULA11</th>\n",
              "      <td>SUL AMERICA</td>\n",
              "      <td>UNT EJ N2</td>\n",
              "      <td>278742752</td>\n",
              "      <td>0.673</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ENGI11</th>\n",
              "      <td>ENERGISA</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>250709436</td>\n",
              "      <td>0.650</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TIMP3</th>\n",
              "      <td>TIM PART S/A</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>807711660</td>\n",
              "      <td>0.620</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>YDUQ3</th>\n",
              "      <td>YDUQS PART</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>299667897</td>\n",
              "      <td>0.602</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CMIG4</th>\n",
              "      <td>CEMIG</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>966005862</td>\n",
              "      <td>0.596</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EGIE3</th>\n",
              "      <td>ENGIE BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>254813401</td>\n",
              "      <td>0.596</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PCAR3</th>\n",
              "      <td>P.ACUCAR-CBD</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>156575731</td>\n",
              "      <td>0.593</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SANB11</th>\n",
              "      <td>SANTANDER BR</td>\n",
              "      <td>UNT</td>\n",
              "      <td>362227661</td>\n",
              "      <td>0.591</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ELET3</th>\n",
              "      <td>ELETROBRAS</td>\n",
              "      <td>ON N1</td>\n",
              "      <td>358028908</td>\n",
              "      <td>0.585</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>IRBR3</th>\n",
              "      <td>IRBBRASIL RE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>923377994</td>\n",
              "      <td>0.574</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CSAN3</th>\n",
              "      <td>COSAN</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>153417832</td>\n",
              "      <td>0.571</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TOTS3</th>\n",
              "      <td>TOTVS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>403397655</td>\n",
              "      <td>0.498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRML3</th>\n",
              "      <td>BR MALLS PAR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>843313591</td>\n",
              "      <td>0.478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>QUAL3</th>\n",
              "      <td>QUALICORP</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>281558308</td>\n",
              "      <td>0.443</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRAP4</th>\n",
              "      <td>BRADESPAR</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>222089397</td>\n",
              "      <td>0.442</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CPLE6</th>\n",
              "      <td>COPEL</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>128297147</td>\n",
              "      <td>0.439</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TRPL4</th>\n",
              "      <td>TRAN PAULIST</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>395797044</td>\n",
              "      <td>0.438</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FLRY3</th>\n",
              "      <td>FLEURY</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>305126422</td>\n",
              "      <td>0.415</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CRFB3</th>\n",
              "      <td>CARREFOUR BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>384888219</td>\n",
              "      <td>0.411</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ELET6</th>\n",
              "      <td>ELETROBRAS</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>240022548</td>\n",
              "      <td>0.411</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CSNA3</th>\n",
              "      <td>SID NACIONAL</td>\n",
              "      <td>ON</td>\n",
              "      <td>642387288</td>\n",
              "      <td>0.395</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>AZUL4</th>\n",
              "      <td>AZUL</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>317471474</td>\n",
              "      <td>0.386</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CYRE3</th>\n",
              "      <td>CYRELA REALT</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>281154098</td>\n",
              "      <td>0.357</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRKM5</th>\n",
              "      <td>BRASKEM</td>\n",
              "      <td>PNA N1</td>\n",
              "      <td>264632416</td>\n",
              "      <td>0.356</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SAPR11</th>\n",
              "      <td>SANEPAR</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>200991234</td>\n",
              "      <td>0.354</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EMBR3</th>\n",
              "      <td>EMBRAER</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>736171905</td>\n",
              "      <td>0.339</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TAEE11</th>\n",
              "      <td>TAESA</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>218568274</td>\n",
              "      <td>0.338</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CIEL3</th>\n",
              "      <td>CIELO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1118386806</td>\n",
              "      <td>0.327</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MULT3</th>\n",
              "      <td>MULTIPLAN</td>\n",
              "      <td>ON N2</td>\n",
              "      <td>270279854</td>\n",
              "      <td>0.320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ALPA4</th>\n",
              "      <td>ALPARGATAS</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>187007704</td>\n",
              "      <td>0.306</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LCAM3</th>\n",
              "      <td>LOCAMERICA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>313436726</td>\n",
              "      <td>0.292</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MRVE3</th>\n",
              "      <td>MRV</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>294706737</td>\n",
              "      <td>0.291</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MRFG3</th>\n",
              "      <td>MARFRIG</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>423143092</td>\n",
              "      <td>0.286</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CESP6</th>\n",
              "      <td>CESP</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>182017689</td>\n",
              "      <td>0.284</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CPFE3</th>\n",
              "      <td>CPFL ENERGIA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>170209781</td>\n",
              "      <td>0.281</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ENBR3</th>\n",
              "      <td>ENERGIAS BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>295402225</td>\n",
              "      <td>0.281</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PSSA3</th>\n",
              "      <td>PORTO SEGURO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>94159042</td>\n",
              "      <td>0.277</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LIGT3</th>\n",
              "      <td>LIGHT S/A</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>303934060</td>\n",
              "      <td>0.276</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BIDI11</th>\n",
              "      <td>BANCO INTER</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>133321962</td>\n",
              "      <td>0.274</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NEOE3</th>\n",
              "      <td>NEOENERGIA</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>239251040</td>\n",
              "      <td>0.257</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GOAU4</th>\n",
              "      <td>GERDAU MET</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>662644908</td>\n",
              "      <td>0.257</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PRIO3</th>\n",
              "      <td>PETRORIO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>126730759</td>\n",
              "      <td>0.244</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>USIM5</th>\n",
              "      <td>USIMINAS</td>\n",
              "      <td>PNA N1</td>\n",
              "      <td>513781576</td>\n",
              "      <td>0.213</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CSMG3</th>\n",
              "      <td>COPASA</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>62969736</td>\n",
              "      <td>0.205</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EZTC3</th>\n",
              "      <td>EZTEC</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>95629772</td>\n",
              "      <td>0.204</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ALSO3</th>\n",
              "      <td>ALIANSCSONAE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>127374163</td>\n",
              "      <td>0.202</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LINX3</th>\n",
              "      <td>LINX</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>160913029</td>\n",
              "      <td>0.199</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>DTEX3</th>\n",
              "      <td>DURATEX</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>273622865</td>\n",
              "      <td>0.199</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MDIA3</th>\n",
              "      <td>M.DIASBRANCO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>83613641</td>\n",
              "      <td>0.188</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BEEF3</th>\n",
              "      <td>MINERVA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>259260688</td>\n",
              "      <td>0.181</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>IGTA3</th>\n",
              "      <td>IGUATEMI</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>86913923</td>\n",
              "      <td>0.168</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BPAN4</th>\n",
              "      <td>BANCO PAN</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>315644002</td>\n",
              "      <td>0.167</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRSR6</th>\n",
              "      <td>BANRISUL</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>202531540</td>\n",
              "      <td>0.161</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CVCB3</th>\n",
              "      <td>CVC BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>145617442</td>\n",
              "      <td>0.155</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GOLL4</th>\n",
              "      <td>GOL</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>134613917</td>\n",
              "      <td>0.145</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ECOR3</th>\n",
              "      <td>ECORODOVIAS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>171079276</td>\n",
              "      <td>0.120</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MYPK3</th>\n",
              "      <td>IOCHP-MAXION</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>139973015</td>\n",
              "      <td>0.113</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HGTX3</th>\n",
              "      <td>CIA HERING</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>126302831</td>\n",
              "      <td>0.099</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MOVI3</th>\n",
              "      <td>MOVIDA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>132725200</td>\n",
              "      <td>0.097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RAPT4</th>\n",
              "      <td>RANDON PART</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>176269235</td>\n",
              "      <td>0.095</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SMLS3</th>\n",
              "      <td>SMILES</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>58842428</td>\n",
              "      <td>0.053</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TCSA3</th>\n",
              "      <td>TECNISA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>54778381</td>\n",
              "      <td>0.040</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                Ação       Tipo Qtde. Teórica  Part. (%)\n",
              "Código                                                  \n",
              "VALE3           VALE      ON NM    3292010807      9.899\n",
              "ITUB4   ITAUUNIBANCO      PN N1    4738562684      6.885\n",
              "B3SA3             B3      ON NM    2046021644      5.786\n",
              "PETR4      PETROBRAS      PN N2    4520185835      5.293\n",
              "BBDC4       BRADESCO      PN N1    4261649634      4.968\n",
              "PETR3      PETROBRAS      ON N2    2949857480      3.592\n",
              "ABEV3      AMBEV S/A         ON    4354228928      3.281\n",
              "BBAS3         BRASIL      ON NM    1418466803      2.573\n",
              "MGLU3    MAGAZ LUIZA      ON NM     661834080      2.515\n",
              "ITSA4         ITAUSA      PN N1    4494029326      2.445\n",
              "JBSS3            JBS      ON NM    1620646499      1.887\n",
              "WEGE3            WEG      ON NM     740696136      1.848\n",
              "LREN3   LOJAS RENNER   ON EJ NM     785308019      1.776\n",
              "GNDI3    INTERMEDICA      ON NM     458380483      1.643\n",
              "NTCO3   GRUPO NATURA      ON NM     706484775      1.618\n",
              "SUZB3    SUZANO S.A.      ON NM     725859318      1.494\n",
              "RAIL3      RUMO S.A.      ON NM    1053753059      1.357\n",
              "RENT3       LOCALIZA   ON EJ NM     593233155      1.338\n",
              "BBDC3       BRADESCO      ON N1    1253093907      1.332\n",
              "RADL3   RAIADROGASIL      ON NM     213553757      1.262\n",
              "LAME4   LOJAS AMERIC      PN N1     696190451      1.231\n",
              "EQTL3     EQUATORIAL      ON NM    1010186085      1.210\n",
              "VIVT4   TELEF BRASIL         PN     415131868      1.105\n",
              "BTOW3    B2W DIGITAL      ON NM     194807150      1.088\n",
              "UGPA3       ULTRAPAR      ON NM    1086422872      1.085\n",
              "SBSP3         SABESP      ON NM     339982576      1.079\n",
              "BBSE3   BBSEGURIDADE      ON NM     671601167      1.044\n",
              "BRFS3         BRF SA      ON NM     811416229      0.973\n",
              "VVAR3      VIAVAREJO      ON NM    1146662628      0.932\n",
              "CCRO3         CCR SA      ON NM    1115695556      0.884\n",
              "GGBR4         GERDAU      PN N1    1031246473      0.865\n",
              "BPAC11    BTGP BANCO     UNT N2     201102231      0.853\n",
              "BRDT3   PETROBRAS BR      ON NM     728125000      0.851\n",
              "HYPE3         HYPERA      ON NM     407518048      0.773\n",
              "HAPV3        HAPVIDA      ON NM     217060254      0.733\n",
              "ENEV3          ENEVA      ON NM     315006451      0.711\n",
              "COGN3       COGNA ON      ON NM    1829322117      0.694\n",
              "KLBN11    KLABIN S/A     UNT N2     637772642      0.689\n",
              "SULA11   SUL AMERICA  UNT EJ N2     278742752      0.673\n",
              "ENGI11      ENERGISA     UNT N2     250709436      0.650\n",
              "TIMP3   TIM PART S/A      ON NM     807711660      0.620\n",
              "YDUQ3     YDUQS PART      ON NM     299667897      0.602\n",
              "CMIG4          CEMIG      PN N1     966005862      0.596\n",
              "EGIE3   ENGIE BRASIL      ON NM     254813401      0.596\n",
              "PCAR3   P.ACUCAR-CBD      ON NM     156575731      0.593\n",
              "SANB11  SANTANDER BR        UNT     362227661      0.591\n",
              "ELET3     ELETROBRAS      ON N1     358028908      0.585\n",
              "IRBR3   IRBBRASIL RE      ON NM     923377994      0.574\n",
              "CSAN3          COSAN      ON NM     153417832      0.571\n",
              "TOTS3          TOTVS      ON NM     403397655      0.498\n",
              "BRML3   BR MALLS PAR      ON NM     843313591      0.478\n",
              "QUAL3      QUALICORP      ON NM     281558308      0.443\n",
              "BRAP4      BRADESPAR      PN N1     222089397      0.442\n",
              "CPLE6          COPEL     PNB N1     128297147      0.439\n",
              "TRPL4   TRAN PAULIST      PN N1     395797044      0.438\n",
              "FLRY3         FLEURY      ON NM     305126422      0.415\n",
              "CRFB3   CARREFOUR BR      ON NM     384888219      0.411\n",
              "ELET6     ELETROBRAS     PNB N1     240022548      0.411\n",
              "CSNA3   SID NACIONAL         ON     642387288      0.395\n",
              "AZUL4           AZUL      PN N2     317471474      0.386\n",
              "CYRE3   CYRELA REALT      ON NM     281154098      0.357\n",
              "BRKM5        BRASKEM     PNA N1     264632416      0.356\n",
              "SAPR11       SANEPAR     UNT N2     200991234      0.354\n",
              "EMBR3        EMBRAER      ON NM     736171905      0.339\n",
              "TAEE11         TAESA     UNT N2     218568274      0.338\n",
              "CIEL3          CIELO      ON NM    1118386806      0.327\n",
              "MULT3      MULTIPLAN      ON N2     270279854      0.320\n",
              "ALPA4     ALPARGATAS      PN N1     187007704      0.306\n",
              "LCAM3     LOCAMERICA      ON NM     313436726      0.292\n",
              "MRVE3            MRV      ON NM     294706737      0.291\n",
              "MRFG3        MARFRIG      ON NM     423143092      0.286\n",
              "CESP6           CESP     PNB N1     182017689      0.284\n",
              "CPFE3   CPFL ENERGIA      ON NM     170209781      0.281\n",
              "ENBR3    ENERGIAS BR      ON NM     295402225      0.281\n",
              "PSSA3   PORTO SEGURO      ON NM      94159042      0.277\n",
              "LIGT3      LIGHT S/A      ON NM     303934060      0.276\n",
              "BIDI11   BANCO INTER     UNT N2     133321962      0.274\n",
              "NEOE3     NEOENERGIA   ON EJ NM     239251040      0.257\n",
              "GOAU4     GERDAU MET      PN N1     662644908      0.257\n",
              "PRIO3       PETRORIO      ON NM     126730759      0.244\n",
              "USIM5       USIMINAS     PNA N1     513781576      0.213\n",
              "CSMG3         COPASA   ON EJ NM      62969736      0.205\n",
              "EZTC3          EZTEC      ON NM      95629772      0.204\n",
              "ALSO3   ALIANSCSONAE      ON NM     127374163      0.202\n",
              "LINX3           LINX      ON NM     160913029      0.199\n",
              "DTEX3        DURATEX      ON NM     273622865      0.199\n",
              "MDIA3   M.DIASBRANCO      ON NM      83613641      0.188\n",
              "BEEF3        MINERVA      ON NM     259260688      0.181\n",
              "IGTA3       IGUATEMI      ON NM      86913923      0.168\n",
              "BPAN4      BANCO PAN      PN N1     315644002      0.167\n",
              "BRSR6       BANRISUL     PNB N1     202531540      0.161\n",
              "CVCB3     CVC BRASIL      ON NM     145617442      0.155\n",
              "GOLL4            GOL      PN N2     134613917      0.145\n",
              "ECOR3    ECORODOVIAS      ON NM     171079276      0.120\n",
              "MYPK3   IOCHP-MAXION      ON NM     139973015      0.113\n",
              "HGTX3     CIA HERING      ON NM     126302831      0.099\n",
              "MOVI3         MOVIDA      ON NM     132725200      0.097\n",
              "RAPT4    RANDON PART      PN N1     176269235      0.095\n",
              "SMLS3         SMILES      ON NM      58842428      0.053\n",
              "TCSA3        TECNISA      ON NM      54778381      0.040"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 53
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gF7dYZsXHJu3",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "dcfc0fe0-853b-4709-d3ed-45b6e9d5dfb7"
      },
      "source": [
        "pd.concat([ibov, ibrx], keys=['IBOV', 'IBRX'], axis=1)"
      ],
      "execution_count": 54,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead tr th {\n",
              "        text-align: left;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th></th>\n",
              "      <th colspan=\"4\" halign=\"left\">IBOV</th>\n",
              "      <th colspan=\"4\" halign=\"left\">IBRX</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th></th>\n",
              "      <th>Ação</th>\n",
              "      <th>Tipo</th>\n",
              "      <th>Qtde. Teórica</th>\n",
              "      <th>Part. (%)</th>\n",
              "      <th>Ação</th>\n",
              "      <th>Tipo</th>\n",
              "      <th>Qtde. Teórica</th>\n",
              "      <th>Part. (%)</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>ABEV3</th>\n",
              "      <td>AMBEV S/A</td>\n",
              "      <td>ON</td>\n",
              "      <td>4354228928</td>\n",
              "      <td>3.499</td>\n",
              "      <td>AMBEV S/A</td>\n",
              "      <td>ON</td>\n",
              "      <td>4354228928</td>\n",
              "      <td>3.281</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>AZUL4</th>\n",
              "      <td>AZUL</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>317471474</td>\n",
              "      <td>0.412</td>\n",
              "      <td>AZUL</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>317471474</td>\n",
              "      <td>0.386</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>B3SA3</th>\n",
              "      <td>B3</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>2046021644</td>\n",
              "      <td>6.171</td>\n",
              "      <td>B3</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>2046021644</td>\n",
              "      <td>5.786</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBAS3</th>\n",
              "      <td>BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1418466803</td>\n",
              "      <td>2.743</td>\n",
              "      <td>BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1418466803</td>\n",
              "      <td>2.573</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBDC3</th>\n",
              "      <td>BRADESCO</td>\n",
              "      <td>ON N1</td>\n",
              "      <td>1253093907</td>\n",
              "      <td>1.421</td>\n",
              "      <td>BRADESCO</td>\n",
              "      <td>ON N1</td>\n",
              "      <td>1253093907</td>\n",
              "      <td>1.332</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBDC4</th>\n",
              "      <td>BRADESCO</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4261649634</td>\n",
              "      <td>5.298</td>\n",
              "      <td>BRADESCO</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4261649634</td>\n",
              "      <td>4.968</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBSE3</th>\n",
              "      <td>BBSEGURIDADE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>671601167</td>\n",
              "      <td>1.114</td>\n",
              "      <td>BBSEGURIDADE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>671601167</td>\n",
              "      <td>1.044</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BEEF3</th>\n",
              "      <td>MINERVA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>259260688</td>\n",
              "      <td>0.194</td>\n",
              "      <td>MINERVA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>259260688</td>\n",
              "      <td>0.181</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BPAC11</th>\n",
              "      <td>BTGP BANCO</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>201102231</td>\n",
              "      <td>0.910</td>\n",
              "      <td>BTGP BANCO</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>201102231</td>\n",
              "      <td>0.853</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRAP4</th>\n",
              "      <td>BRADESPAR</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>222089397</td>\n",
              "      <td>0.472</td>\n",
              "      <td>BRADESPAR</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>222089397</td>\n",
              "      <td>0.442</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRDT3</th>\n",
              "      <td>PETROBRAS BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>728125000</td>\n",
              "      <td>0.907</td>\n",
              "      <td>PETROBRAS BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>728125000</td>\n",
              "      <td>0.851</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRFS3</th>\n",
              "      <td>BRF SA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>811416229</td>\n",
              "      <td>1.038</td>\n",
              "      <td>BRF SA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>811416229</td>\n",
              "      <td>0.973</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRKM5</th>\n",
              "      <td>BRASKEM</td>\n",
              "      <td>PNA N1</td>\n",
              "      <td>264632416</td>\n",
              "      <td>0.380</td>\n",
              "      <td>BRASKEM</td>\n",
              "      <td>PNA N1</td>\n",
              "      <td>264632416</td>\n",
              "      <td>0.356</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRML3</th>\n",
              "      <td>BR MALLS PAR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>843313591</td>\n",
              "      <td>0.510</td>\n",
              "      <td>BR MALLS PAR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>843313591</td>\n",
              "      <td>0.478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BTOW3</th>\n",
              "      <td>B2W DIGITAL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>194807150</td>\n",
              "      <td>1.161</td>\n",
              "      <td>B2W DIGITAL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>194807150</td>\n",
              "      <td>1.088</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CCRO3</th>\n",
              "      <td>CCR SA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1115695556</td>\n",
              "      <td>0.943</td>\n",
              "      <td>CCR SA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1115695556</td>\n",
              "      <td>0.884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CIEL3</th>\n",
              "      <td>CIELO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1118386806</td>\n",
              "      <td>0.349</td>\n",
              "      <td>CIELO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1118386806</td>\n",
              "      <td>0.327</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CMIG4</th>\n",
              "      <td>CEMIG</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>966005862</td>\n",
              "      <td>0.635</td>\n",
              "      <td>CEMIG</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>966005862</td>\n",
              "      <td>0.596</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>COGN3</th>\n",
              "      <td>COGNA ON</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1829322117</td>\n",
              "      <td>0.740</td>\n",
              "      <td>COGNA ON</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1829322117</td>\n",
              "      <td>0.694</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CPFE3</th>\n",
              "      <td>CPFL ENERGIA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>170209781</td>\n",
              "      <td>0.300</td>\n",
              "      <td>CPFL ENERGIA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>170209781</td>\n",
              "      <td>0.281</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CRFB3</th>\n",
              "      <td>CARREFOUR BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>384888219</td>\n",
              "      <td>0.438</td>\n",
              "      <td>CARREFOUR BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>384888219</td>\n",
              "      <td>0.411</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CSAN3</th>\n",
              "      <td>COSAN</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>153417832</td>\n",
              "      <td>0.609</td>\n",
              "      <td>COSAN</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>153417832</td>\n",
              "      <td>0.571</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CSNA3</th>\n",
              "      <td>SID NACIONAL</td>\n",
              "      <td>ON</td>\n",
              "      <td>642387288</td>\n",
              "      <td>0.422</td>\n",
              "      <td>SID NACIONAL</td>\n",
              "      <td>ON</td>\n",
              "      <td>642387288</td>\n",
              "      <td>0.395</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CVCB3</th>\n",
              "      <td>CVC BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>145617442</td>\n",
              "      <td>0.165</td>\n",
              "      <td>CVC BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>145617442</td>\n",
              "      <td>0.155</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CYRE3</th>\n",
              "      <td>CYRELA REALT</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>281154098</td>\n",
              "      <td>0.381</td>\n",
              "      <td>CYRELA REALT</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>281154098</td>\n",
              "      <td>0.357</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ECOR3</th>\n",
              "      <td>ECORODOVIAS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>171079276</td>\n",
              "      <td>0.128</td>\n",
              "      <td>ECORODOVIAS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>171079276</td>\n",
              "      <td>0.120</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EGIE3</th>\n",
              "      <td>ENGIE BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>254813401</td>\n",
              "      <td>0.636</td>\n",
              "      <td>ENGIE BRASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>254813401</td>\n",
              "      <td>0.596</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ELET3</th>\n",
              "      <td>ELETROBRAS</td>\n",
              "      <td>ON N1</td>\n",
              "      <td>358028908</td>\n",
              "      <td>0.624</td>\n",
              "      <td>ELETROBRAS</td>\n",
              "      <td>ON N1</td>\n",
              "      <td>358028908</td>\n",
              "      <td>0.585</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ELET6</th>\n",
              "      <td>ELETROBRAS</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>240022548</td>\n",
              "      <td>0.439</td>\n",
              "      <td>ELETROBRAS</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>240022548</td>\n",
              "      <td>0.411</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EMBR3</th>\n",
              "      <td>EMBRAER</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>736171905</td>\n",
              "      <td>0.362</td>\n",
              "      <td>EMBRAER</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>736171905</td>\n",
              "      <td>0.339</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ENBR3</th>\n",
              "      <td>ENERGIAS BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>295402225</td>\n",
              "      <td>0.299</td>\n",
              "      <td>ENERGIAS BR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>295402225</td>\n",
              "      <td>0.281</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ENGI11</th>\n",
              "      <td>ENERGISA</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>250709436</td>\n",
              "      <td>0.693</td>\n",
              "      <td>ENERGISA</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>250709436</td>\n",
              "      <td>0.650</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EQTL3</th>\n",
              "      <td>EQUATORIAL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1010186085</td>\n",
              "      <td>1.291</td>\n",
              "      <td>EQUATORIAL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1010186085</td>\n",
              "      <td>1.210</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FLRY3</th>\n",
              "      <td>FLEURY</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>305126422</td>\n",
              "      <td>0.442</td>\n",
              "      <td>FLEURY</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>305126422</td>\n",
              "      <td>0.415</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GGBR4</th>\n",
              "      <td>GERDAU</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>1031246473</td>\n",
              "      <td>0.923</td>\n",
              "      <td>GERDAU</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>1031246473</td>\n",
              "      <td>0.865</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GNDI3</th>\n",
              "      <td>INTERMEDICA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>458380483</td>\n",
              "      <td>1.752</td>\n",
              "      <td>INTERMEDICA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>458380483</td>\n",
              "      <td>1.643</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GOAU4</th>\n",
              "      <td>GERDAU MET</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>662644908</td>\n",
              "      <td>0.274</td>\n",
              "      <td>GERDAU MET</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>662644908</td>\n",
              "      <td>0.257</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GOLL4</th>\n",
              "      <td>GOL</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>134613917</td>\n",
              "      <td>0.154</td>\n",
              "      <td>GOL</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>134613917</td>\n",
              "      <td>0.145</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HAPV3</th>\n",
              "      <td>HAPVIDA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>217060254</td>\n",
              "      <td>0.781</td>\n",
              "      <td>HAPVIDA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>217060254</td>\n",
              "      <td>0.733</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HGTX3</th>\n",
              "      <td>CIA HERING</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>126302831</td>\n",
              "      <td>0.106</td>\n",
              "      <td>CIA HERING</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>126302831</td>\n",
              "      <td>0.099</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HYPE3</th>\n",
              "      <td>HYPERA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>407518048</td>\n",
              "      <td>0.824</td>\n",
              "      <td>HYPERA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>407518048</td>\n",
              "      <td>0.773</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>IGTA3</th>\n",
              "      <td>IGUATEMI</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>86913923</td>\n",
              "      <td>0.180</td>\n",
              "      <td>IGUATEMI</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>86913923</td>\n",
              "      <td>0.168</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>IRBR3</th>\n",
              "      <td>IRBBRASIL RE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>923377994</td>\n",
              "      <td>0.613</td>\n",
              "      <td>IRBBRASIL RE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>923377994</td>\n",
              "      <td>0.574</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ITSA4</th>\n",
              "      <td>ITAUSA</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4494029326</td>\n",
              "      <td>2.608</td>\n",
              "      <td>ITAUSA</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4494029326</td>\n",
              "      <td>2.445</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ITUB4</th>\n",
              "      <td>ITAUUNIBANCO</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4738562684</td>\n",
              "      <td>7.343</td>\n",
              "      <td>ITAUUNIBANCO</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>4738562684</td>\n",
              "      <td>6.885</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>JBSS3</th>\n",
              "      <td>JBS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1620646499</td>\n",
              "      <td>2.013</td>\n",
              "      <td>JBS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1620646499</td>\n",
              "      <td>1.887</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>KLBN11</th>\n",
              "      <td>KLABIN S/A</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>637772642</td>\n",
              "      <td>0.735</td>\n",
              "      <td>KLABIN S/A</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>637772642</td>\n",
              "      <td>0.689</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LAME4</th>\n",
              "      <td>LOJAS AMERIC</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>696190451</td>\n",
              "      <td>1.313</td>\n",
              "      <td>LOJAS AMERIC</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>696190451</td>\n",
              "      <td>1.231</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LREN3</th>\n",
              "      <td>LOJAS RENNER</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>785308019</td>\n",
              "      <td>1.894</td>\n",
              "      <td>LOJAS RENNER</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>785308019</td>\n",
              "      <td>1.776</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MGLU3</th>\n",
              "      <td>MAGAZ LUIZA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>661834080</td>\n",
              "      <td>2.682</td>\n",
              "      <td>MAGAZ LUIZA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>661834080</td>\n",
              "      <td>2.515</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MRFG3</th>\n",
              "      <td>MARFRIG</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>423143092</td>\n",
              "      <td>0.305</td>\n",
              "      <td>MARFRIG</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>423143092</td>\n",
              "      <td>0.286</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MRVE3</th>\n",
              "      <td>MRV</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>294706737</td>\n",
              "      <td>0.310</td>\n",
              "      <td>MRV</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>294706737</td>\n",
              "      <td>0.291</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MULT3</th>\n",
              "      <td>MULTIPLAN</td>\n",
              "      <td>ON N2</td>\n",
              "      <td>270279854</td>\n",
              "      <td>0.342</td>\n",
              "      <td>MULTIPLAN</td>\n",
              "      <td>ON N2</td>\n",
              "      <td>270279854</td>\n",
              "      <td>0.320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NTCO3</th>\n",
              "      <td>GRUPO NATURA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>706484775</td>\n",
              "      <td>1.726</td>\n",
              "      <td>GRUPO NATURA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>706484775</td>\n",
              "      <td>1.618</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PCAR3</th>\n",
              "      <td>P.ACUCAR-CBD</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>156575731</td>\n",
              "      <td>0.632</td>\n",
              "      <td>P.ACUCAR-CBD</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>156575731</td>\n",
              "      <td>0.593</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PETR3</th>\n",
              "      <td>PETROBRAS</td>\n",
              "      <td>ON N2</td>\n",
              "      <td>2949857480</td>\n",
              "      <td>3.831</td>\n",
              "      <td>PETROBRAS</td>\n",
              "      <td>ON N2</td>\n",
              "      <td>2949857480</td>\n",
              "      <td>3.592</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PETR4</th>\n",
              "      <td>PETROBRAS</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>4520185835</td>\n",
              "      <td>5.645</td>\n",
              "      <td>PETROBRAS</td>\n",
              "      <td>PN N2</td>\n",
              "      <td>4520185835</td>\n",
              "      <td>5.293</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>QUAL3</th>\n",
              "      <td>QUALICORP</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>281558308</td>\n",
              "      <td>0.473</td>\n",
              "      <td>QUALICORP</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>281558308</td>\n",
              "      <td>0.443</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RADL3</th>\n",
              "      <td>RAIADROGASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>207425426</td>\n",
              "      <td>1.307</td>\n",
              "      <td>RAIADROGASIL</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>213553757</td>\n",
              "      <td>1.262</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RAIL3</th>\n",
              "      <td>RUMO S.A.</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1053753059</td>\n",
              "      <td>1.447</td>\n",
              "      <td>RUMO S.A.</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1053753059</td>\n",
              "      <td>1.357</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RENT3</th>\n",
              "      <td>LOCALIZA</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>593233155</td>\n",
              "      <td>1.427</td>\n",
              "      <td>LOCALIZA</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>593233155</td>\n",
              "      <td>1.338</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SANB11</th>\n",
              "      <td>SANTANDER BR</td>\n",
              "      <td>UNT</td>\n",
              "      <td>362227661</td>\n",
              "      <td>0.630</td>\n",
              "      <td>SANTANDER BR</td>\n",
              "      <td>UNT</td>\n",
              "      <td>362227661</td>\n",
              "      <td>0.591</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SBSP3</th>\n",
              "      <td>SABESP</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>339982576</td>\n",
              "      <td>1.151</td>\n",
              "      <td>SABESP</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>339982576</td>\n",
              "      <td>1.079</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SULA11</th>\n",
              "      <td>SUL AMERICA</td>\n",
              "      <td>UNT EJ N2</td>\n",
              "      <td>278742752</td>\n",
              "      <td>0.717</td>\n",
              "      <td>SUL AMERICA</td>\n",
              "      <td>UNT EJ N2</td>\n",
              "      <td>278742752</td>\n",
              "      <td>0.673</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SUZB3</th>\n",
              "      <td>SUZANO S.A.</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>725859318</td>\n",
              "      <td>1.593</td>\n",
              "      <td>SUZANO S.A.</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>725859318</td>\n",
              "      <td>1.494</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TAEE11</th>\n",
              "      <td>TAESA</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>218568274</td>\n",
              "      <td>0.360</td>\n",
              "      <td>TAESA</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>218568274</td>\n",
              "      <td>0.338</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TIMP3</th>\n",
              "      <td>TIM PART S/A</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>807711660</td>\n",
              "      <td>0.662</td>\n",
              "      <td>TIM PART S/A</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>807711660</td>\n",
              "      <td>0.620</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TOTS3</th>\n",
              "      <td>TOTVS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>403397655</td>\n",
              "      <td>0.532</td>\n",
              "      <td>TOTVS</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>403397655</td>\n",
              "      <td>0.498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>UGPA3</th>\n",
              "      <td>ULTRAPAR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1086422872</td>\n",
              "      <td>1.157</td>\n",
              "      <td>ULTRAPAR</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1086422872</td>\n",
              "      <td>1.085</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>USIM5</th>\n",
              "      <td>USIMINAS</td>\n",
              "      <td>PNA N1</td>\n",
              "      <td>513781576</td>\n",
              "      <td>0.228</td>\n",
              "      <td>USIMINAS</td>\n",
              "      <td>PNA N1</td>\n",
              "      <td>513781576</td>\n",
              "      <td>0.213</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VALE3</th>\n",
              "      <td>VALE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>3292010807</td>\n",
              "      <td>10.557</td>\n",
              "      <td>VALE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>3292010807</td>\n",
              "      <td>9.899</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VIVT4</th>\n",
              "      <td>TELEF BRASIL</td>\n",
              "      <td>PN</td>\n",
              "      <td>415131868</td>\n",
              "      <td>1.179</td>\n",
              "      <td>TELEF BRASIL</td>\n",
              "      <td>PN</td>\n",
              "      <td>415131868</td>\n",
              "      <td>1.105</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VVAR3</th>\n",
              "      <td>VIAVAREJO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1146662628</td>\n",
              "      <td>0.994</td>\n",
              "      <td>VIAVAREJO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>1146662628</td>\n",
              "      <td>0.932</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>WEGE3</th>\n",
              "      <td>WEG</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>689271972</td>\n",
              "      <td>1.834</td>\n",
              "      <td>WEG</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>740696136</td>\n",
              "      <td>1.848</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>YDUQ3</th>\n",
              "      <td>YDUQS PART</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>299667897</td>\n",
              "      <td>0.640</td>\n",
              "      <td>YDUQS PART</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>299667897</td>\n",
              "      <td>0.602</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ALPA4</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ALPARGATAS</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>187007704</td>\n",
              "      <td>0.306</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ALSO3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ALIANSCSONAE</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>127374163</td>\n",
              "      <td>0.202</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BIDI11</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BANCO INTER</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>133321962</td>\n",
              "      <td>0.274</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BPAN4</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BANCO PAN</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>315644002</td>\n",
              "      <td>0.167</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRSR6</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BANRISUL</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>202531540</td>\n",
              "      <td>0.161</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CESP6</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CESP</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>182017689</td>\n",
              "      <td>0.284</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CPLE6</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>COPEL</td>\n",
              "      <td>PNB N1</td>\n",
              "      <td>128297147</td>\n",
              "      <td>0.439</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CSMG3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>COPASA</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>62969736</td>\n",
              "      <td>0.205</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>DTEX3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>DURATEX</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>273622865</td>\n",
              "      <td>0.199</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ENEV3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ENEVA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>315006451</td>\n",
              "      <td>0.711</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EZTC3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>EZTEC</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>95629772</td>\n",
              "      <td>0.204</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LCAM3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>LOCAMERICA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>313436726</td>\n",
              "      <td>0.292</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LIGT3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>LIGHT S/A</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>303934060</td>\n",
              "      <td>0.276</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LINX3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>LINX</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>160913029</td>\n",
              "      <td>0.199</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MDIA3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>M.DIASBRANCO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>83613641</td>\n",
              "      <td>0.188</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MOVI3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>MOVIDA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>132725200</td>\n",
              "      <td>0.097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MYPK3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IOCHP-MAXION</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>139973015</td>\n",
              "      <td>0.113</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NEOE3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NEOENERGIA</td>\n",
              "      <td>ON EJ NM</td>\n",
              "      <td>239251040</td>\n",
              "      <td>0.257</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PRIO3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>PETRORIO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>126730759</td>\n",
              "      <td>0.244</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PSSA3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>PORTO SEGURO</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>94159042</td>\n",
              "      <td>0.277</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RAPT4</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>RANDON PART</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>176269235</td>\n",
              "      <td>0.095</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SAPR11</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>SANEPAR</td>\n",
              "      <td>UNT N2</td>\n",
              "      <td>200991234</td>\n",
              "      <td>0.354</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>SMLS3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>SMILES</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>58842428</td>\n",
              "      <td>0.053</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TCSA3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>TECNISA</td>\n",
              "      <td>ON NM</td>\n",
              "      <td>54778381</td>\n",
              "      <td>0.040</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TRPL4</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>TRAN PAULIST</td>\n",
              "      <td>PN N1</td>\n",
              "      <td>395797044</td>\n",
              "      <td>0.438</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                IBOV             ...          IBRX          \n",
              "                Ação       Tipo  ... Qtde. Teórica Part. (%)\n",
              "ABEV3      AMBEV S/A         ON  ...    4354228928     3.281\n",
              "AZUL4           AZUL      PN N2  ...     317471474     0.386\n",
              "B3SA3             B3      ON NM  ...    2046021644     5.786\n",
              "BBAS3         BRASIL      ON NM  ...    1418466803     2.573\n",
              "BBDC3       BRADESCO      ON N1  ...    1253093907     1.332\n",
              "BBDC4       BRADESCO      PN N1  ...    4261649634     4.968\n",
              "BBSE3   BBSEGURIDADE      ON NM  ...     671601167     1.044\n",
              "BEEF3        MINERVA      ON NM  ...     259260688     0.181\n",
              "BPAC11    BTGP BANCO     UNT N2  ...     201102231     0.853\n",
              "BRAP4      BRADESPAR      PN N1  ...     222089397     0.442\n",
              "BRDT3   PETROBRAS BR      ON NM  ...     728125000     0.851\n",
              "BRFS3         BRF SA      ON NM  ...     811416229     0.973\n",
              "BRKM5        BRASKEM     PNA N1  ...     264632416     0.356\n",
              "BRML3   BR MALLS PAR      ON NM  ...     843313591     0.478\n",
              "BTOW3    B2W DIGITAL      ON NM  ...     194807150     1.088\n",
              "CCRO3         CCR SA      ON NM  ...    1115695556     0.884\n",
              "CIEL3          CIELO      ON NM  ...    1118386806     0.327\n",
              "CMIG4          CEMIG      PN N1  ...     966005862     0.596\n",
              "COGN3       COGNA ON      ON NM  ...    1829322117     0.694\n",
              "CPFE3   CPFL ENERGIA      ON NM  ...     170209781     0.281\n",
              "CRFB3   CARREFOUR BR      ON NM  ...     384888219     0.411\n",
              "CSAN3          COSAN      ON NM  ...     153417832     0.571\n",
              "CSNA3   SID NACIONAL         ON  ...     642387288     0.395\n",
              "CVCB3     CVC BRASIL      ON NM  ...     145617442     0.155\n",
              "CYRE3   CYRELA REALT      ON NM  ...     281154098     0.357\n",
              "ECOR3    ECORODOVIAS      ON NM  ...     171079276     0.120\n",
              "EGIE3   ENGIE BRASIL      ON NM  ...     254813401     0.596\n",
              "ELET3     ELETROBRAS      ON N1  ...     358028908     0.585\n",
              "ELET6     ELETROBRAS     PNB N1  ...     240022548     0.411\n",
              "EMBR3        EMBRAER      ON NM  ...     736171905     0.339\n",
              "ENBR3    ENERGIAS BR      ON NM  ...     295402225     0.281\n",
              "ENGI11      ENERGISA     UNT N2  ...     250709436     0.650\n",
              "EQTL3     EQUATORIAL      ON NM  ...    1010186085     1.210\n",
              "FLRY3         FLEURY      ON NM  ...     305126422     0.415\n",
              "GGBR4         GERDAU      PN N1  ...    1031246473     0.865\n",
              "GNDI3    INTERMEDICA      ON NM  ...     458380483     1.643\n",
              "GOAU4     GERDAU MET      PN N1  ...     662644908     0.257\n",
              "GOLL4            GOL      PN N2  ...     134613917     0.145\n",
              "HAPV3        HAPVIDA      ON NM  ...     217060254     0.733\n",
              "HGTX3     CIA HERING      ON NM  ...     126302831     0.099\n",
              "HYPE3         HYPERA      ON NM  ...     407518048     0.773\n",
              "IGTA3       IGUATEMI      ON NM  ...      86913923     0.168\n",
              "IRBR3   IRBBRASIL RE      ON NM  ...     923377994     0.574\n",
              "ITSA4         ITAUSA      PN N1  ...    4494029326     2.445\n",
              "ITUB4   ITAUUNIBANCO      PN N1  ...    4738562684     6.885\n",
              "JBSS3            JBS      ON NM  ...    1620646499     1.887\n",
              "KLBN11    KLABIN S/A     UNT N2  ...     637772642     0.689\n",
              "LAME4   LOJAS AMERIC      PN N1  ...     696190451     1.231\n",
              "LREN3   LOJAS RENNER   ON EJ NM  ...     785308019     1.776\n",
              "MGLU3    MAGAZ LUIZA      ON NM  ...     661834080     2.515\n",
              "MRFG3        MARFRIG      ON NM  ...     423143092     0.286\n",
              "MRVE3            MRV      ON NM  ...     294706737     0.291\n",
              "MULT3      MULTIPLAN      ON N2  ...     270279854     0.320\n",
              "NTCO3   GRUPO NATURA      ON NM  ...     706484775     1.618\n",
              "PCAR3   P.ACUCAR-CBD      ON NM  ...     156575731     0.593\n",
              "PETR3      PETROBRAS      ON N2  ...    2949857480     3.592\n",
              "PETR4      PETROBRAS      PN N2  ...    4520185835     5.293\n",
              "QUAL3      QUALICORP      ON NM  ...     281558308     0.443\n",
              "RADL3   RAIADROGASIL      ON NM  ...     213553757     1.262\n",
              "RAIL3      RUMO S.A.      ON NM  ...    1053753059     1.357\n",
              "RENT3       LOCALIZA   ON EJ NM  ...     593233155     1.338\n",
              "SANB11  SANTANDER BR        UNT  ...     362227661     0.591\n",
              "SBSP3         SABESP      ON NM  ...     339982576     1.079\n",
              "SULA11   SUL AMERICA  UNT EJ N2  ...     278742752     0.673\n",
              "SUZB3    SUZANO S.A.      ON NM  ...     725859318     1.494\n",
              "TAEE11         TAESA     UNT N2  ...     218568274     0.338\n",
              "TIMP3   TIM PART S/A      ON NM  ...     807711660     0.620\n",
              "TOTS3          TOTVS      ON NM  ...     403397655     0.498\n",
              "UGPA3       ULTRAPAR      ON NM  ...    1086422872     1.085\n",
              "USIM5       USIMINAS     PNA N1  ...     513781576     0.213\n",
              "VALE3           VALE      ON NM  ...    3292010807     9.899\n",
              "VIVT4   TELEF BRASIL         PN  ...     415131868     1.105\n",
              "VVAR3      VIAVAREJO      ON NM  ...    1146662628     0.932\n",
              "WEGE3            WEG      ON NM  ...     740696136     1.848\n",
              "YDUQ3     YDUQS PART      ON NM  ...     299667897     0.602\n",
              "ALPA4            NaN        NaN  ...     187007704     0.306\n",
              "ALSO3            NaN        NaN  ...     127374163     0.202\n",
              "BIDI11           NaN        NaN  ...     133321962     0.274\n",
              "BPAN4            NaN        NaN  ...     315644002     0.167\n",
              "BRSR6            NaN        NaN  ...     202531540     0.161\n",
              "CESP6            NaN        NaN  ...     182017689     0.284\n",
              "CPLE6            NaN        NaN  ...     128297147     0.439\n",
              "CSMG3            NaN        NaN  ...      62969736     0.205\n",
              "DTEX3            NaN        NaN  ...     273622865     0.199\n",
              "ENEV3            NaN        NaN  ...     315006451     0.711\n",
              "EZTC3            NaN        NaN  ...      95629772     0.204\n",
              "LCAM3            NaN        NaN  ...     313436726     0.292\n",
              "LIGT3            NaN        NaN  ...     303934060     0.276\n",
              "LINX3            NaN        NaN  ...     160913029     0.199\n",
              "MDIA3            NaN        NaN  ...      83613641     0.188\n",
              "MOVI3            NaN        NaN  ...     132725200     0.097\n",
              "MYPK3            NaN        NaN  ...     139973015     0.113\n",
              "NEOE3            NaN        NaN  ...     239251040     0.257\n",
              "PRIO3            NaN        NaN  ...     126730759     0.244\n",
              "PSSA3            NaN        NaN  ...      94159042     0.277\n",
              "RAPT4            NaN        NaN  ...     176269235     0.095\n",
              "SAPR11           NaN        NaN  ...     200991234     0.354\n",
              "SMLS3            NaN        NaN  ...      58842428     0.053\n",
              "TCSA3            NaN        NaN  ...      54778381     0.040\n",
              "TRPL4            NaN        NaN  ...     395797044     0.438\n",
              "\n",
              "[100 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 54
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FSn5_1WpJDOl",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def get_tickers(indice):\n",
        "  url = 'http://bvmf.bmfbovespa.com.br/indices/ResumoCarteiraTeorica.aspx?Indice={}&idioma=pt-br'.format(indice.upper())\n",
        "  return (pd.read_html(url, index_col='Código', thousands='.', decimal=',')[0][:-1].index + '.SA').to_list()"
      ],
      "execution_count": 55,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wi61RxK9JueS",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "92b5ade5-85fe-443d-cf5b-2a6f68e522ce"
      },
      "source": [
        "ibov_tickers = get_tickers('ibov')\n",
        "ibov_tickers"
      ],
      "execution_count": 56,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['ABEV3.SA',\n",
              " 'AZUL4.SA',\n",
              " 'B3SA3.SA',\n",
              " 'BBAS3.SA',\n",
              " 'BBDC3.SA',\n",
              " 'BBDC4.SA',\n",
              " 'BBSE3.SA',\n",
              " 'BEEF3.SA',\n",
              " 'BPAC11.SA',\n",
              " 'BRAP4.SA',\n",
              " 'BRDT3.SA',\n",
              " 'BRFS3.SA',\n",
              " 'BRKM5.SA',\n",
              " 'BRML3.SA',\n",
              " 'BTOW3.SA',\n",
              " 'CCRO3.SA',\n",
              " 'CIEL3.SA',\n",
              " 'CMIG4.SA',\n",
              " 'COGN3.SA',\n",
              " 'CPFE3.SA',\n",
              " 'CRFB3.SA',\n",
              " 'CSAN3.SA',\n",
              " 'CSNA3.SA',\n",
              " 'CVCB3.SA',\n",
              " 'CYRE3.SA',\n",
              " 'ECOR3.SA',\n",
              " 'EGIE3.SA',\n",
              " 'ELET3.SA',\n",
              " 'ELET6.SA',\n",
              " 'EMBR3.SA',\n",
              " 'ENBR3.SA',\n",
              " 'ENGI11.SA',\n",
              " 'EQTL3.SA',\n",
              " 'FLRY3.SA',\n",
              " 'GGBR4.SA',\n",
              " 'GNDI3.SA',\n",
              " 'GOAU4.SA',\n",
              " 'GOLL4.SA',\n",
              " 'HAPV3.SA',\n",
              " 'HGTX3.SA',\n",
              " 'HYPE3.SA',\n",
              " 'IGTA3.SA',\n",
              " 'IRBR3.SA',\n",
              " 'ITSA4.SA',\n",
              " 'ITUB4.SA',\n",
              " 'JBSS3.SA',\n",
              " 'KLBN11.SA',\n",
              " 'LAME4.SA',\n",
              " 'LREN3.SA',\n",
              " 'MGLU3.SA',\n",
              " 'MRFG3.SA',\n",
              " 'MRVE3.SA',\n",
              " 'MULT3.SA',\n",
              " 'NTCO3.SA',\n",
              " 'PCAR3.SA',\n",
              " 'PETR3.SA',\n",
              " 'PETR4.SA',\n",
              " 'QUAL3.SA',\n",
              " 'RADL3.SA',\n",
              " 'RAIL3.SA',\n",
              " 'RENT3.SA',\n",
              " 'SANB11.SA',\n",
              " 'SBSP3.SA',\n",
              " 'SULA11.SA',\n",
              " 'SUZB3.SA',\n",
              " 'TAEE11.SA',\n",
              " 'TIMP3.SA',\n",
              " 'TOTS3.SA',\n",
              " 'UGPA3.SA',\n",
              " 'USIM5.SA',\n",
              " 'VALE3.SA',\n",
              " 'VIVT4.SA',\n",
              " 'VVAR3.SA',\n",
              " 'WEGE3.SA',\n",
              " 'YDUQ3.SA']"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 56
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "auh7dmodKFdg",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 943
        },
        "outputId": "7c9383c5-00e2-4be0-ca3d-cf7464f7c8e6"
      },
      "source": [
        "ibov_tickers_retrive = yf.download(ibov_tickers, period='10y', group_by='tickers')\n",
        "ibov_tickers_retrive.head"
      ],
      "execution_count": 57,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "[*********************100%***********************]  75 of 75 completed\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<bound method NDFrame.head of            HGTX3.SA                    ...   MRVE3.SA                       \n",
              "               Open       High    Low  ...      Close  Adj Close      Volume\n",
              "Date                                   ...                                  \n",
              "2010-06-23      NaN        NaN    NaN  ...  12.263800   7.595331   3477169.0\n",
              "2010-06-24      NaN        NaN    NaN  ...  12.009200   7.437650   2405672.0\n",
              "2010-06-25      NaN        NaN    NaN  ...  12.318300   7.629084   2138375.0\n",
              "2010-06-28      NaN        NaN    NaN  ...  12.054700   7.465828   1372344.0\n",
              "2010-06-29      NaN        NaN    NaN  ...  11.682000   7.235006   4184571.0\n",
              "2010-06-30      NaN        NaN    NaN  ...  11.554700   7.156163   3399840.0\n",
              "2010-07-01      NaN        NaN    NaN  ...  11.745600   7.274395   3932014.0\n",
              "2010-07-02      NaN        NaN    NaN  ...  12.163800   7.533399   2432841.0\n",
              "2010-07-05      NaN        NaN    NaN  ...  11.963800   7.409532    731711.0\n",
              "2010-07-06      NaN        NaN    NaN  ...  12.636500   7.826156   4162351.0\n",
              "2010-07-07      NaN        NaN    NaN  ...  12.482000   7.730468   3493009.0\n",
              "2010-07-08      NaN        NaN    NaN  ...  12.454700   7.713560   2552850.0\n",
              "2010-07-12      NaN        NaN    NaN  ...  12.372900   7.662901   2409522.0\n",
              "2010-07-13      NaN        NaN    NaN  ...  12.772900   7.910631   3303591.0\n",
              "2010-07-14      NaN        NaN    NaN  ...  13.182000   8.163999   4041242.0\n",
              "2010-07-15      NaN        NaN    NaN  ...  13.227400   8.192118   6628412.0\n",
              "2010-07-16      NaN        NaN    NaN  ...  13.236500   8.197751   3514678.0\n",
              "2010-07-19      NaN        NaN    NaN  ...  13.736500   8.507417   3492019.0\n",
              "2010-07-20      NaN        NaN    NaN  ...  13.236500   8.197751   4514237.0\n",
              "2010-07-21      NaN        NaN    NaN  ...  13.272900   8.220295   1976677.0\n",
              "2010-07-22      NaN        NaN    NaN  ...  13.700200   8.484937   3316241.0\n",
              "2010-07-23      NaN        NaN    NaN  ...  13.636500   8.445483   3285661.0\n",
              "2010-07-26      NaN        NaN    NaN  ...  14.018300   8.681944   2168844.0\n",
              "2010-07-27      NaN        NaN    NaN  ...  14.236500   8.817082   2081505.0\n",
              "2010-07-28      NaN        NaN    NaN  ...  14.000200   8.670735   2670988.0\n",
              "...             ...        ...    ...  ...        ...        ...         ...\n",
              "2020-05-19    13.20  13.450000  12.52  ...  15.130000  15.130000   9583400.0\n",
              "2020-05-20    13.10  13.990000  12.93  ...  15.070000  15.070000   8417800.0\n",
              "2020-05-21    13.13  14.280000  13.10  ...  15.280000  15.280000   7037700.0\n",
              "2020-05-22    14.00  14.340000  12.81  ...  14.930000  14.930000   4580800.0\n",
              "2020-05-25    13.37  13.990000  13.37  ...  16.740000  16.740000   3553700.0\n",
              "2020-05-26    14.17  14.590000  13.53  ...  16.330000  16.330000   3750400.0\n",
              "2020-05-27    13.82  14.090000  13.43  ...  16.620001  16.620001   2665600.0\n",
              "2020-05-28    14.10  14.120000  13.33  ...  15.750000  15.750000   7049800.0\n",
              "2020-05-29    12.80  13.730000  12.70  ...  15.170000  15.170000  11385700.0\n",
              "2020-06-01    13.35  13.890000  13.13  ...  15.790000  15.790000   4389300.0\n",
              "2020-06-02    13.91  14.350000  13.71  ...  16.650000  16.650000   3717100.0\n",
              "2020-06-03    14.46  15.540000  14.46  ...  17.580000  17.580000   7467100.0\n",
              "2020-06-04    15.54  16.150000  15.27  ...  17.180000  17.180000   3982900.0\n",
              "2020-06-05    16.33  16.530001  15.43  ...  17.490000  17.490000   6544600.0\n",
              "2020-06-08    16.07  16.889999  15.72  ...  18.000000  18.000000   3958100.0\n",
              "2020-06-09    16.50  17.000000  15.76  ...  17.150000  17.150000   4837400.0\n",
              "2020-06-10    16.92  17.280001  15.23  ...  16.879999  16.879999   4490600.0\n",
              "2020-06-12    14.80  15.150000  14.14  ...  16.350000  16.350000   5512900.0\n",
              "2020-06-15    13.93  14.570000  13.58  ...  16.870001  16.870001   4134700.0\n",
              "2020-06-16    15.00  15.140000  14.02  ...  16.850000  16.850000   5360100.0\n",
              "2020-06-17    14.27  14.950000  14.03  ...  17.120001  17.120001   8889200.0\n",
              "2020-06-18    14.70  15.640000  14.56  ...  16.780001  16.780001   6634300.0\n",
              "2020-06-19    15.49  15.870000  15.11  ...  17.730000  17.730000   6866700.0\n",
              "2020-06-22    15.53  15.650000  14.66  ...  17.780001  17.780001   7322600.0\n",
              "2020-06-23     0.00   0.000000   0.00  ...  18.260000  18.260000         0.0\n",
              "\n",
              "[2483 rows x 450 columns]>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 57
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "2UPAqxEVLjKF",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 943
        },
        "outputId": "77c792a5-098b-451a-a6af-02b29f5a67b4"
      },
      "source": [
        "ifix = yf.download(get_tickers('ifix'), period='10y', group_by='tickers')\n",
        "ifix.head"
      ],
      "execution_count": 58,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "[*********************100%***********************]  120 of 120 completed\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<bound method NDFrame.head of              OUJP11.SA                          ...    PQDP11.SA                    \n",
              "                  Open        High         Low  ...        Close    Adj Close Volume\n",
              "Date                                            ...                                 \n",
              "2010-06-23         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-06-24         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-06-25         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-06-28         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-06-29         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-06-30         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-01         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-02         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-05         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-06         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-07         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-08         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-12         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-13         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-14         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-15         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-16         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-19         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-20         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-21         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-22         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-23         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-26         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-27         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "2010-07-28         NaN         NaN         NaN  ...          NaN          NaN    NaN\n",
              "...                ...         ...         ...  ...          ...          ...    ...\n",
              "2020-05-19  101.989998  101.989998  100.510002  ...  2705.000000  2705.000000   60.0\n",
              "2020-05-20  100.510002  101.209999  100.010002  ...  2772.000000  2772.000000   34.0\n",
              "2020-05-21  100.510002  100.940002  100.019997  ...  2770.000000  2770.000000   63.0\n",
              "2020-05-22  100.419998  101.870003  100.019997  ...  2825.399902  2825.399902  109.0\n",
              "2020-05-25  101.489998  101.900002  100.349998  ...  2877.550049  2877.550049   93.0\n",
              "2020-05-26  101.019997  101.570000  100.440002  ...  2840.000000  2840.000000   57.0\n",
              "2020-05-27  100.879997  101.000000  100.500000  ...  2890.000000  2890.000000   76.0\n",
              "2020-05-28  100.989998  100.989998  100.320000  ...  2825.000000  2825.000000   36.0\n",
              "2020-05-29  100.940002  101.500000  100.800003  ...  2868.000000  2868.000000   64.0\n",
              "2020-06-01  101.430000  101.430000  100.180000  ...  2825.110107  2825.110107   18.0\n",
              "2020-06-02  100.760002  101.080002  100.449997  ...  2833.000000  2833.000000   75.0\n",
              "2020-06-03  100.959999  101.910004  100.949997  ...  2879.000000  2879.000000   61.0\n",
              "2020-06-04  101.129997  101.940002  101.099998  ...  2880.000000  2880.000000   63.0\n",
              "2020-06-05  101.930000  105.800003  101.930000  ...  2901.080078  2901.080078   37.0\n",
              "2020-06-08  105.800003  106.000000  104.199997  ...  2989.989990  2989.989990  171.0\n",
              "2020-06-09  105.500000  106.000000  103.000000  ...  2950.000000  2950.000000  247.0\n",
              "2020-06-10  103.989998  104.000000  103.150002  ...  3040.000000  3040.000000   63.0\n",
              "2020-06-12  101.330002  104.930000  101.330002  ...  3090.000000  3090.000000  152.0\n",
              "2020-06-15  103.989998  104.000000  103.019997  ...  3090.000000  3090.000000   33.0\n",
              "2020-06-16  104.000000  104.000000  103.559998  ...  3040.000000  3040.000000   35.0\n",
              "2020-06-17  104.000000  106.000000  104.000000  ...  3065.000000  3065.000000   11.0\n",
              "2020-06-18  105.980003  108.000000  105.730003  ...  3061.000000  3061.000000   13.0\n",
              "2020-06-19  107.699997  108.500000  106.500000  ...  3099.979980  3099.979980  143.0\n",
              "2020-06-22  107.080002  110.000000  107.080002  ...  3062.120117  3062.120117   20.0\n",
              "2020-06-23    0.000000    0.000000    0.000000  ...  2998.800049  2998.800049    0.0\n",
              "\n",
              "[2479 rows x 720 columns]>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 58
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "n3D-zOaxL6tP",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 17
        },
        "outputId": "3728df14-bfe2-4121-9fd9-4c3799723d2b"
      },
      "source": [
        "ibov_tickers_retrive.to_excel('ibov.xlsx')\n",
        "files.download('ibov.xlsx')"
      ],
      "execution_count": 66,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "application/javascript": [
              "\n",
              "    async function download(id, filename, size) {\n",
              "      if (!google.colab.kernel.accessAllowed) {\n",
              "        return;\n",
              "      }\n",
              "      const div = document.createElement('div');\n",
              "      const label = document.createElement('label');\n",
              "      label.textContent = `Downloading \"${filename}\": `;\n",
              "      div.appendChild(label);\n",
              "      const progress = document.createElement('progress');\n",
              "      progress.max = size;\n",
              "      div.appendChild(progress);\n",
              "      document.body.appendChild(div);\n",
              "\n",
              "      const buffers = [];\n",
              "      let downloaded = 0;\n",
              "\n",
              "      const channel = await google.colab.kernel.comms.open(id);\n",
              "      // Send a message to notify the kernel that we're ready.\n",
              "      channel.send({})\n",
              "\n",
              "      for await (const message of channel.messages) {\n",
              "        // Send a message to notify the kernel that we're ready.\n",
              "        channel.send({})\n",
              "        if (message.buffers) {\n",
              "          for (const buffer of message.buffers) {\n",
              "            buffers.push(buffer);\n",
              "            downloaded += buffer.byteLength;\n",
              "            progress.value = downloaded;\n",
              "          }\n",
              "        }\n",
              "      }\n",
              "      const blob = new Blob(buffers, {type: 'application/binary'});\n",
              "      const a = document.createElement('a');\n",
              "      a.href = window.URL.createObjectURL(blob);\n",
              "      a.download = filename;\n",
              "      div.appendChild(a);\n",
              "      a.click();\n",
              "      div.remove();\n",
              "    }\n",
              "  "
            ],
            "text/plain": [
              "<IPython.core.display.Javascript object>"
            ]
          },
          "metadata": {
            "tags": []
          }
        },
        {
          "output_type": "display_data",
          "data": {
            "application/javascript": [
              "download(\"download_8d66c0bf-f8e0-4839-8e6f-42a1ba222aa2\", \"ibov.xlsx\", 8733608)"
            ],
            "text/plain": [
              "<IPython.core.display.Javascript object>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "62fuEYIiZmM2",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 17
        },
        "outputId": "7a018479-393a-42b3-9acd-2506d81ee717"
      },
      "source": [
        "ifix.to_excel('ifix.xlsx')\n",
        "files.download('ifix.xlsx')"
      ],
      "execution_count": 65,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "application/javascript": [
              "\n",
              "    async function download(id, filename, size) {\n",
              "      if (!google.colab.kernel.accessAllowed) {\n",
              "        return;\n",
              "      }\n",
              "      const div = document.createElement('div');\n",
              "      const label = document.createElement('label');\n",
              "      label.textContent = `Downloading \"${filename}\": `;\n",
              "      div.appendChild(label);\n",
              "      const progress = document.createElement('progress');\n",
              "      progress.max = size;\n",
              "      div.appendChild(progress);\n",
              "      document.body.appendChild(div);\n",
              "\n",
              "      const buffers = [];\n",
              "      let downloaded = 0;\n",
              "\n",
              "      const channel = await google.colab.kernel.comms.open(id);\n",
              "      // Send a message to notify the kernel that we're ready.\n",
              "      channel.send({})\n",
              "\n",
              "      for await (const message of channel.messages) {\n",
              "        // Send a message to notify the kernel that we're ready.\n",
              "        channel.send({})\n",
              "        if (message.buffers) {\n",
              "          for (const buffer of message.buffers) {\n",
              "            buffers.push(buffer);\n",
              "            downloaded += buffer.byteLength;\n",
              "            progress.value = downloaded;\n",
              "          }\n",
              "        }\n",
              "      }\n",
              "      const blob = new Blob(buffers, {type: 'application/binary'});\n",
              "      const a = document.createElement('a');\n",
              "      a.href = window.URL.createObjectURL(blob);\n",
              "      a.download = filename;\n",
              "      div.appendChild(a);\n",
              "      a.click();\n",
              "      div.remove();\n",
              "    }\n",
              "  "
            ],
            "text/plain": [
              "<IPython.core.display.Javascript object>"
            ]
          },
          "metadata": {
            "tags": []
          }
        },
        {
          "output_type": "display_data",
          "data": {
            "application/javascript": [
              "download(\"download_f23473cc-9714-4c43-9d89-193b6e28490c\", \"ifix.xlsx\", 6953338)"
            ],
            "text/plain": [
              "<IPython.core.display.Javascript object>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DQbyofmUZ84S",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 17
        },
        "outputId": "078c148f-55b9-40d8-9092-267a3387382f"
      },
      "source": [
        "ibov.to_csv('ibov.csv')\n",
        "files.download('ibov.csv')"
      ],
      "execution_count": 67,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "application/javascript": [
              "\n",
              "    async function download(id, filename, size) {\n",
              "      if (!google.colab.kernel.accessAllowed) {\n",
              "        return;\n",
              "      }\n",
              "      const div = document.createElement('div');\n",
              "      const label = document.createElement('label');\n",
              "      label.textContent = `Downloading \"${filename}\": `;\n",
              "      div.appendChild(label);\n",
              "      const progress = document.createElement('progress');\n",
              "      progress.max = size;\n",
              "      div.appendChild(progress);\n",
              "      document.body.appendChild(div);\n",
              "\n",
              "      const buffers = [];\n",
              "      let downloaded = 0;\n",
              "\n",
              "      const channel = await google.colab.kernel.comms.open(id);\n",
              "      // Send a message to notify the kernel that we're ready.\n",
              "      channel.send({})\n",
              "\n",
              "      for await (const message of channel.messages) {\n",
              "        // Send a message to notify the kernel that we're ready.\n",
              "        channel.send({})\n",
              "        if (message.buffers) {\n",
              "          for (const buffer of message.buffers) {\n",
              "            buffers.push(buffer);\n",
              "            downloaded += buffer.byteLength;\n",
              "            progress.value = downloaded;\n",
              "          }\n",
              "        }\n",
              "      }\n",
              "      const blob = new Blob(buffers, {type: 'application/binary'});\n",
              "      const a = document.createElement('a');\n",
              "      a.href = window.URL.createObjectURL(blob);\n",
              "      a.download = filename;\n",
              "      div.appendChild(a);\n",
              "      a.click();\n",
              "      div.remove();\n",
              "    }\n",
              "  "
            ],
            "text/plain": [
              "<IPython.core.display.Javascript object>"
            ]
          },
          "metadata": {
            "tags": []
          }
        },
        {
          "output_type": "display_data",
          "data": {
            "application/javascript": [
              "download(\"download_58fcbc1b-9da1-4643-a797-19f4a8ab0471\", \"ibov.csv\", 3181)"
            ],
            "text/plain": [
              "<IPython.core.display.Javascript object>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_7liERMHaIHI",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 17
        },
        "outputId": "7e619e0f-26d1-4733-a9a5-515c393bac1d"
      },
      "source": [
        "ifix.to_csv('ifix.csv')\n",
        "files.download('ifix.csv')"
      ],
      "execution_count": 68,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "application/javascript": [
              "\n",
              "    async function download(id, filename, size) {\n",
              "      if (!google.colab.kernel.accessAllowed) {\n",
              "        return;\n",
              "      }\n",
              "      const div = document.createElement('div');\n",
              "      const label = document.createElement('label');\n",
              "      label.textContent = `Downloading \"${filename}\": `;\n",
              "      div.appendChild(label);\n",
              "      const progress = document.createElement('progress');\n",
              "      progress.max = size;\n",
              "      div.appendChild(progress);\n",
              "      document.body.appendChild(div);\n",
              "\n",
              "      const buffers = [];\n",
              "      let downloaded = 0;\n",
              "\n",
              "      const channel = await google.colab.kernel.comms.open(id);\n",
              "      // Send a message to notify the kernel that we're ready.\n",
              "      channel.send({})\n",
              "\n",
              "      for await (const message of channel.messages) {\n",
              "        // Send a message to notify the kernel that we're ready.\n",
              "        channel.send({})\n",
              "        if (message.buffers) {\n",
              "          for (const buffer of message.buffers) {\n",
              "            buffers.push(buffer);\n",
              "            downloaded += buffer.byteLength;\n",
              "            progress.value = downloaded;\n",
              "          }\n",
              "        }\n",
              "      }\n",
              "      const blob = new Blob(buffers, {type: 'application/binary'});\n",
              "      const a = document.createElement('a');\n",
              "      a.href = window.URL.createObjectURL(blob);\n",
              "      a.download = filename;\n",
              "      div.appendChild(a);\n",
              "      a.click();\n",
              "      div.remove();\n",
              "    }\n",
              "  "
            ],
            "text/plain": [
              "<IPython.core.display.Javascript object>"
            ]
          },
          "metadata": {
            "tags": []
          }
        },
        {
          "output_type": "display_data",
          "data": {
            "application/javascript": [
              "download(\"download_b2b6c234-839c-4e13-ab04-470e9ba9b3c0\", \"ifix.csv\", 9218581)"
            ],
            "text/plain": [
              "<IPython.core.display.Javascript object>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    }
  ]
}