{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Загрузка данных" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Index(['Date', 'Open', 'High', 'Low', 'Close', 'Adj Close', 'Volume',\n", " 'SP_open', 'SP_high', 'SP_low', 'SP_close', 'SP_Ajclose', 'SP_volume',\n", " 'DJ_open', 'DJ_high', 'DJ_low', 'DJ_close', 'DJ_Ajclose', 'DJ_volume',\n", " 'EG_open', 'EG_high', 'EG_low', 'EG_close', 'EG_Ajclose', 'EG_volume',\n", " 'EU_Price', 'EU_open', 'EU_high', 'EU_low', 'EU_Trend', 'OF_Price',\n", " 'OF_Open', 'OF_High', 'OF_Low', 'OF_Volume', 'OF_Trend', 'OS_Price',\n", " 'OS_Open', 'OS_High', 'OS_Low', 'OS_Trend', 'SF_Price', 'SF_Open',\n", " 'SF_High', 'SF_Low', 'SF_Volume', 'SF_Trend', 'USB_Price', 'USB_Open',\n", " 'USB_High', 'USB_Low', 'USB_Trend', 'PLT_Price', 'PLT_Open', 'PLT_High',\n", " 'PLT_Low', 'PLT_Trend', 'PLD_Price', 'PLD_Open', 'PLD_High', 'PLD_Low',\n", " 'PLD_Trend', 'RHO_PRICE', 'USDI_Price', 'USDI_Open', 'USDI_High',\n", " 'USDI_Low', 'USDI_Volume', 'USDI_Trend', 'GDX_Open', 'GDX_High',\n", " 'GDX_Low', 'GDX_Close', 'GDX_Adj Close', 'GDX_Volume', 'USO_Open',\n", " 'USO_High', 'USO_Low', 'USO_Close', 'USO_Adj Close', 'USO_Volume'],\n", " dtype='object')\n" ] }, { "data": { "text/html": [ "
\n", " | Date | \n", "Open | \n", "High | \n", "Low | \n", "Close | \n", "Adj Close | \n", "Volume | \n", "SP_open | \n", "SP_high | \n", "SP_low | \n", "... | \n", "GDX_Low | \n", "GDX_Close | \n", "GDX_Adj Close | \n", "GDX_Volume | \n", "USO_Open | \n", "USO_High | \n", "USO_Low | \n", "USO_Close | \n", "USO_Adj Close | \n", "USO_Volume | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2011-12-15 | \n", "154.740005 | \n", "154.949997 | \n", "151.710007 | \n", "152.330002 | \n", "152.330002 | \n", "21521900 | \n", "123.029999 | \n", "123.199997 | \n", "121.989998 | \n", "... | \n", "51.570000 | \n", "51.680000 | \n", "48.973877 | \n", "20605600 | \n", "36.900002 | \n", "36.939999 | \n", "36.049999 | \n", "36.130001 | \n", "36.130001 | \n", "12616700 | \n", "
1 | \n", "2011-12-16 | \n", "154.309998 | \n", "155.369995 | \n", "153.899994 | \n", "155.229996 | \n", "155.229996 | \n", "18124300 | \n", "122.230003 | \n", "122.949997 | \n", "121.300003 | \n", "... | \n", "52.040001 | \n", "52.680000 | \n", "49.921513 | \n", "16285400 | \n", "36.180000 | \n", "36.500000 | \n", "35.730000 | \n", "36.270000 | \n", "36.270000 | \n", "12578800 | \n", "
2 | \n", "2011-12-19 | \n", "155.479996 | \n", "155.860001 | \n", "154.360001 | \n", "154.869995 | \n", "154.869995 | \n", "12547200 | \n", "122.059998 | \n", "122.320000 | \n", "120.029999 | \n", "... | \n", "51.029999 | \n", "51.169998 | \n", "48.490578 | \n", "15120200 | \n", "36.389999 | \n", "36.450001 | \n", "35.930000 | \n", "36.200001 | \n", "36.200001 | \n", "7418200 | \n", "
3 | \n", "2011-12-20 | \n", "156.820007 | \n", "157.429993 | \n", "156.580002 | \n", "156.979996 | \n", "156.979996 | \n", "9136300 | \n", "122.180000 | \n", "124.139999 | \n", "120.370003 | \n", "... | \n", "52.369999 | \n", "52.990002 | \n", "50.215282 | \n", "11644900 | \n", "37.299999 | \n", "37.610001 | \n", "37.220001 | \n", "37.560001 | \n", "37.560001 | \n", "10041600 | \n", "
4 | \n", "2011-12-21 | \n", "156.979996 | \n", "157.529999 | \n", "156.130005 | \n", "157.160004 | \n", "157.160004 | \n", "11996100 | \n", "123.930000 | \n", "124.360001 | \n", "122.750000 | \n", "... | \n", "52.419998 | \n", "52.959999 | \n", "50.186852 | \n", "8724300 | \n", "37.669998 | \n", "38.240002 | \n", "37.520000 | \n", "38.110001 | \n", "38.110001 | \n", "10728000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1713 | \n", "2018-12-24 | \n", "119.570000 | \n", "120.139999 | \n", "119.570000 | \n", "120.019997 | \n", "120.019997 | \n", "9736400 | \n", "239.039993 | \n", "240.839996 | \n", "234.270004 | \n", "... | \n", "20.650000 | \n", "21.090000 | \n", "21.090000 | \n", "60507000 | \n", "9.490000 | \n", "9.520000 | \n", "9.280000 | \n", "9.290000 | \n", "9.290000 | \n", "21598200 | \n", "
1714 | \n", "2018-12-26 | \n", "120.620003 | \n", "121.000000 | \n", "119.570000 | \n", "119.660004 | \n", "119.660004 | \n", "14293500 | \n", "235.970001 | \n", "246.179993 | \n", "233.759995 | \n", "... | \n", "20.530001 | \n", "20.620001 | \n", "20.620001 | \n", "76365200 | \n", "9.250000 | \n", "9.920000 | \n", "9.230000 | \n", "9.900000 | \n", "9.900000 | \n", "40978800 | \n", "
1715 | \n", "2018-12-27 | \n", "120.570000 | \n", "120.900002 | \n", "120.139999 | \n", "120.570000 | \n", "120.570000 | \n", "11874400 | \n", "242.570007 | \n", "248.289993 | \n", "238.960007 | \n", "... | \n", "20.700001 | \n", "20.969999 | \n", "20.969999 | \n", "52393000 | \n", "9.590000 | \n", "9.650000 | \n", "9.370000 | \n", "9.620000 | \n", "9.620000 | \n", "36578700 | \n", "
1716 | \n", "2018-12-28 | \n", "120.800003 | \n", "121.080002 | \n", "120.720001 | \n", "121.059998 | \n", "121.059998 | \n", "6864700 | \n", "249.580002 | \n", "251.399994 | \n", "246.449997 | \n", "... | \n", "20.570000 | \n", "20.600000 | \n", "20.600000 | \n", "49835000 | \n", "9.540000 | \n", "9.650000 | \n", "9.380000 | \n", "9.530000 | \n", "9.530000 | \n", "22803400 | \n", "
1717 | \n", "2018-12-31 | \n", "120.980003 | \n", "121.260002 | \n", "120.830002 | \n", "121.250000 | \n", "121.250000 | \n", "8449400 | \n", "249.559998 | \n", "250.190002 | \n", "247.470001 | \n", "... | \n", "20.559999 | \n", "21.090000 | \n", "21.090000 | \n", "53866600 | \n", "9.630000 | \n", "9.710000 | \n", "9.440000 | \n", "9.660000 | \n", "9.660000 | \n", "28417400 | \n", "
1718 rows × 81 columns
\n", "