{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "### Imports" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "data": { "text/html": [ "" ], "text/vnd.plotly.v1+html": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "import pandas as pd\n", "import plotlyink\n", "import plotly\n", "plotly.offline.init_notebook_mode(connected=True)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Let's get some cryptocurrencies datas" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "base_polo_url = 'https://poloniex.com/public?command=returnChartData¤cyPair={}&start={}&end={}&period={}'\n", "start_date = pd.Timestamp('2018-01-01', tz='CET')\n", "end_date = pd.Timestamp('2018-02-01', tz='CET')\n", "period = 86400 # pull daily data (86,400 seconds per day)\n", "\n", "def get_crypto_data(poloniex_pair):\n", " '''Retrieve cryptocurrency data from poloniex'''\n", " json_url = base_polo_url.format(poloniex_pair, start_date.timestamp(), end_date.timestamp(), period)\n", " df = pd.read_json(json_url)\n", " return df.set_index('date')" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "altcoins = ['ETH','LTC','XRP','ETC','STR','DASH','SC','XMR','XEM']\n", "dfs = []\n", "for altcoin in altcoins:\n", " coinpair = 'BTC_{}'.format(altcoin)\n", " crypto_price_df = get_crypto_data(coinpair)[['weightedAverage']]\n", " dfs.append(crypto_price_df.rename(columns={'weightedAverage': coinpair}))\n", " \n", "df = pd.concat(dfs, axis=1)" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | BTC_ETH | \n", "BTC_LTC | \n", "BTC_XRP | \n", "BTC_ETC | \n", "BTC_STR | \n", "BTC_DASH | \n", "BTC_SC | \n", "BTC_XMR | \n", "BTC_XEM | \n", "
---|---|---|---|---|---|---|---|---|---|
date | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2018-01-01 | \n", "0.055675 | \n", "0.016723 | \n", "0.000145 | \n", "0.002194 | \n", "0.000033 | \n", "0.075174 | \n", "0.000002 | \n", "0.024788 | \n", "0.000076 | \n", "
2018-01-02 | \n", "0.060632 | \n", "0.017649 | \n", "0.000147 | \n", "0.002258 | \n", "0.000037 | \n", "0.078409 | \n", "0.000002 | \n", "0.025384 | \n", "0.000077 | \n", "
2018-01-03 | \n", "0.059944 | \n", "0.016570 | \n", "0.000171 | \n", "0.002121 | \n", "0.000051 | \n", "0.074916 | \n", "0.000002 | \n", "0.025083 | \n", "0.000094 | \n", "
2018-01-04 | \n", "0.064191 | \n", "0.015864 | \n", "0.000199 | \n", "0.002334 | \n", "0.000053 | \n", "0.075819 | \n", "0.000003 | \n", "0.025095 | \n", "0.000123 | \n", "
2018-01-05 | \n", "0.062074 | \n", "0.015331 | \n", "0.000165 | \n", "0.002104 | \n", "0.000041 | \n", "0.070231 | \n", "0.000003 | \n", "0.022440 | \n", "0.000103 | \n", "