<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>tsx_sales_estimate</th>
      <th>tsx_eps_estimate</th>
      <th>cad_ig_sprds</th>
      <th>us_ig_sprds</th>
      <th>us_hy_sprds</th>
      <th>cad_ig_er_index</th>
      <th>vix</th>
      <th>eco_surprises</th>
      <th>tsx</th>
    </tr>
    <tr>
      <th>Date</th>
      <th></th>
      <th></th>
      <th></th>
      <th></th>
      <th></th>
      <th></th>
      <th></th>
      <th></th>
      <th></th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>2005-12-31</th>
      <td>8605.669700</td>
      <td>924.145600</td>
      <td>0.613091</td>
      <td>0.966886</td>
      <td>3.417578</td>
      <td>104.565000</td>
      <td>12.065000</td>
      <td>0.297000</td>
      <td>11048.199700</td>
    </tr>
    <tr>
      <th>2006-03-31</th>
      <td>9465.494467</td>
      <td>1113.065333</td>
      <td>0.592794</td>
      <td>0.860316</td>
      <td>3.143145</td>
      <td>104.563333</td>
      <td>12.226667</td>
      <td>0.714667</td>
      <td>11914.863267</td>
    </tr>
    <tr>
      <th>2006-06-30</th>
      <td>9004.094100</td>
      <td>1085.737833</td>
      <td>0.597217</td>
      <td>0.892499</td>
      <td>3.017390</td>
      <td>104.586667</td>
      <td>13.703333</td>
      <td>0.596667</td>
      <td>11853.853167</td>
    </tr>
    <tr>
      <th>2006-09-30</th>
      <td>7079.684433</td>
      <td>871.376367</td>
      <td>0.629744</td>
      <td>0.941318</td>
      <td>3.300809</td>
      <td>104.690000</td>
      <td>13.080000</td>
      <td>0.520333</td>
      <td>11888.659833</td>
    </tr>
    <tr>
      <th>2006-12-31</th>
      <td>7126.533033</td>
      <td>890.780333</td>
      <td>0.595792</td>
      <td>0.892584</td>
      <td>2.965914</td>
      <td>105.166667</td>
      <td>11.190000</td>
      <td>0.776667</td>
      <td>12668.453100</td>
    </tr>
  </tbody>
</table>
</div>

            tsx_sales_estimate  tsx_eps_estimate  cad_ig_sprds  us_ig_sprds  \
Date                                                                          
2005-12-31         8605.669700        924.145600      0.613091     0.966886   
2006-03-31         9465.494467       1113.065333      0.592794     0.860316   
2006-06-30         9004.094100       1085.737833      0.597217     0.892499   
2006-09-30         7079.684433        871.376367      0.629744     0.941318   
2006-12-31         7126.533033        890.780333      0.595792     0.892584   

            us_hy_sprds  cad_ig_er_index        vix  eco_surprises  \
Date                                                                 
2005-12-31     3.417578       104.565000  12.065000       0.297000   
2006-03-31     3.143145       104.563333  12.226667       0.714667   
2006-06-30     3.017390       104.586667  13.703333       0.596667   
2006-09-30     3.300809       104.690000  13.080000       0.520333   
2006-12-31     2.965914       105.166667  11.190000       0.776667   

                     tsx  
Date                      
2005-12-31  11048.199700  
2006-03-31  11914.863267  
2006-06-30  11853.853167  
2006-09-30  11888.659833  
2006-12-31  12668.453100  

Vizly: AI-powered data analysis

Notebook

make Date a datime index and resample to quarterly data