CryptoScraper.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "CryptoScraper.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyMNxduQpnBeKaAzQpIgRPDZ",
      "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/manthanthakker/BitcoinPrediction/blob/master/CryptoScraper.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "zXrwcuzGkirp",
        "colab_type": "text"
      },
      "source": [
        "# **Scrape CryptoCurrency**\n",
        "\n",
        "*   For Frequency (Daily, Hourly, Minute)\n",
        "*   For all cryptocurrencies\n",
        "\n",
        "\n",
        "\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "D-53FVt4hDim",
        "colab_type": "text"
      },
      "source": [
        "Scrape BitCoinData RealTime using this API https://min-api.cryptocompare.com/\n",
        "\n",
        "1. Create a trial account\n",
        "2. Create a free token and fill it here\n",
        "3. Fetch Latest Bitcoin data"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "FJ0hmhsnhe7A",
        "colab_type": "text"
      },
      "source": [
        "# Bitcoin Scraper "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KWZg0nQthAiT",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from datetime import datetime\n",
        "import pandas as pd\n",
        "import requests\n",
        "\n",
        "\n",
        "def convertTimeStampToUTC(data):\n",
        "  from datetime import datetime\n",
        "  return datetime.fromtimestamp(data)\n",
        "  \n",
        "def getURL(apiKey,cryptoSymbol,frequency,timestamp,MaxRecordsToGetOnEachCall):\n",
        "  API_KEY='&api_key='+str(apiKey)\n",
        "  limit='&limit='+str(MaxRecordsToGetOnEachCall)\n",
        "  cryptoHeader='fsym='+str(cryptoSymbol)\n",
        "  ouputCurrency='&tsym=USD'\n",
        "\n",
        "  if(timestamp==\"\"):\n",
        "    url='https://min-api.cryptocompare.com/data/v2/histo'+frequency+'?'+cryptoHeader\n",
        "  else:  \n",
        "    url='https://min-api.cryptocompare.com/data/v2/histo'+frequency+'?'+cryptoHeader+'&toTs='+str(timestamp)\n",
        "\n",
        "  return url+ouputCurrency+API_KEY+limit  \n",
        "\n",
        "\n",
        "def getCryptoData(apikey,crypto,frequency,numOfTimesToHitApi,MaxRecordsToGetOnEachCall):\n",
        "  numOfTimesToHitApi=5\n",
        "  data=pd.DataFrame()\n",
        "  nextTimeStamp=0\n",
        "\n",
        "  for i in range(0,numOfTimesToHitApi):\n",
        "    if(nextTimeStamp==0):\n",
        "      url=getURL(apikey,crypto,frequency,\"\",MaxRecordsToGetOnEachCall)\n",
        "    else:\n",
        "      url=getURL(apikey,crypto,frequency,nextTimeStamp,MaxRecordsToGetOnEachCall)\n",
        "\n",
        "    response = requests.get(url).json()\n",
        "    partialData=pd.DataFrame(response.get('Data').get('Data'))\n",
        "    nextTimeStamp=partialData['time'].min()-1\n",
        "    data=pd.concat([data,partialData])\n",
        "\n",
        "\n",
        "  data=data.sort_values(by=['time'],ignore_index=True)\n",
        "  data['timeUTC']=data['time'].apply(convertTimeStampToUTC)\n",
        "  data=data.reset_index(drop=True)\n",
        "  return data\n"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "oxxYi4oohqJl",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "hv3i969ohsnH",
        "colab_type": "text"
      },
      "source": [
        "# Invoke BitCoin Scraper"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PWIk1Vm6hr64",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 413
        },
        "outputId": "dc087da5-102e-43fb-98df-2b85366e81a8"
      },
      "source": [
        "## Parameters To Scrape Any Bitcoin Data\n",
        "\n",
        "## API_KEY: Create a trial account on https://min-api.cryptocompare.com/ and create a API_KEY (Its free)\n",
        "## Valid Values for crypto: BTC | ETH | XRP | BCH | BSV | LTC | EOS | XMR | ADA and Many More\n",
        "## numOfTimesToHitApi: For Trial Account this is somwhere 1000 per second, which is sufficient here\n",
        "## MaxRecordsToGetOnEachCall: Max is 2000\n",
        "## frequency : Valid Options are  day|hour|minute\n",
        "\n",
        "API_KEY=\"\"\n",
        "crypto=\"BTC\"\n",
        "numOfTimesToHitApi=5\n",
        "MaxRecordsToGetOnEachCall=200\n",
        "frequency=\"hour\"\n",
        "\n",
        "cryptoData=getCryptoData(API_KEY,crypto,frequency,numOfTimesToHitApi,MaxRecordsToGetOnEachCall)\n",
        "cryptoData"
      ],
      "execution_count": 2,
      "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>time</th>\n",
              "      <th>high</th>\n",
              "      <th>low</th>\n",
              "      <th>open</th>\n",
              "      <th>volumefrom</th>\n",
              "      <th>volumeto</th>\n",
              "      <th>close</th>\n",
              "      <th>conversionType</th>\n",
              "      <th>conversionSymbol</th>\n",
              "      <th>timeUTC</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1583985600</td>\n",
              "      <td>7671.97</td>\n",
              "      <td>7574.94</td>\n",
              "      <td>7671.97</td>\n",
              "      <td>3575.29</td>\n",
              "      <td>27208739.92</td>\n",
              "      <td>7634.05</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-03-12 04:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1583989200</td>\n",
              "      <td>7664.82</td>\n",
              "      <td>7609.07</td>\n",
              "      <td>7634.05</td>\n",
              "      <td>1549.63</td>\n",
              "      <td>11831969.34</td>\n",
              "      <td>7653.71</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-03-12 05:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1583992800</td>\n",
              "      <td>7656.60</td>\n",
              "      <td>7470.01</td>\n",
              "      <td>7653.71</td>\n",
              "      <td>6044.18</td>\n",
              "      <td>45503478.49</td>\n",
              "      <td>7510.10</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-03-12 06:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1583996400</td>\n",
              "      <td>7510.64</td>\n",
              "      <td>7368.71</td>\n",
              "      <td>7510.10</td>\n",
              "      <td>8287.60</td>\n",
              "      <td>61461972.46</td>\n",
              "      <td>7396.02</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-03-12 07:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1584000000</td>\n",
              "      <td>7466.43</td>\n",
              "      <td>7321.57</td>\n",
              "      <td>7396.02</td>\n",
              "      <td>6152.71</td>\n",
              "      <td>45465855.44</td>\n",
              "      <td>7383.65</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-03-12 08:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1000</th>\n",
              "      <td>1587585600</td>\n",
              "      <td>7123.76</td>\n",
              "      <td>7094.55</td>\n",
              "      <td>7098.28</td>\n",
              "      <td>1009.65</td>\n",
              "      <td>7182051.74</td>\n",
              "      <td>7119.91</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-22 20:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1001</th>\n",
              "      <td>1587589200</td>\n",
              "      <td>7140.16</td>\n",
              "      <td>7100.17</td>\n",
              "      <td>7119.91</td>\n",
              "      <td>1127.31</td>\n",
              "      <td>8033871.97</td>\n",
              "      <td>7102.78</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-22 21:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1002</th>\n",
              "      <td>1587592800</td>\n",
              "      <td>7124.71</td>\n",
              "      <td>7096.36</td>\n",
              "      <td>7102.78</td>\n",
              "      <td>1100.92</td>\n",
              "      <td>7832794.37</td>\n",
              "      <td>7120.72</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-22 22:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1003</th>\n",
              "      <td>1587596400</td>\n",
              "      <td>7135.41</td>\n",
              "      <td>7113.24</td>\n",
              "      <td>7120.72</td>\n",
              "      <td>1193.30</td>\n",
              "      <td>8502019.00</td>\n",
              "      <td>7135.41</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-22 23:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1004</th>\n",
              "      <td>1587600000</td>\n",
              "      <td>7152.44</td>\n",
              "      <td>7110.82</td>\n",
              "      <td>7135.41</td>\n",
              "      <td>1375.44</td>\n",
              "      <td>9805176.61</td>\n",
              "      <td>7125.60</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-23 00:00:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1005 rows × 10 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            time     high  ...  conversionSymbol             timeUTC\n",
              "0     1583985600  7671.97  ...                   2020-03-12 04:00:00\n",
              "1     1583989200  7664.82  ...                   2020-03-12 05:00:00\n",
              "2     1583992800  7656.60  ...                   2020-03-12 06:00:00\n",
              "3     1583996400  7510.64  ...                   2020-03-12 07:00:00\n",
              "4     1584000000  7466.43  ...                   2020-03-12 08:00:00\n",
              "...          ...      ...  ...               ...                 ...\n",
              "1000  1587585600  7123.76  ...                   2020-04-22 20:00:00\n",
              "1001  1587589200  7140.16  ...                   2020-04-22 21:00:00\n",
              "1002  1587592800  7124.71  ...                   2020-04-22 22:00:00\n",
              "1003  1587596400  7135.41  ...                   2020-04-22 23:00:00\n",
              "1004  1587600000  7152.44  ...                   2020-04-23 00:00:00\n",
              "\n",
              "[1005 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "vu9Whyf_jfss",
        "colab_type": "text"
      },
      "source": [
        "\n",
        "Get Daily Bitcoin Rate\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "l_X1CkVbh1Mv",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 413
        },
        "outputId": "1f8adef1-3990-4cb7-f7fe-b28ed62e1db7"
      },
      "source": [
        "API_KEY=\"\"\n",
        "crypto=\"BTC\"\n",
        "numOfTimesToHitApi=5\n",
        "MaxRecordsToGetOnEachCall=200\n",
        "frequency=\"day\"\n",
        "\n",
        "cryptoData=getCryptoData(API_KEY,crypto,frequency,numOfTimesToHitApi,MaxRecordsToGetOnEachCall)\n",
        "cryptoData"
      ],
      "execution_count": 4,
      "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>time</th>\n",
              "      <th>high</th>\n",
              "      <th>low</th>\n",
              "      <th>open</th>\n",
              "      <th>volumefrom</th>\n",
              "      <th>volumeto</th>\n",
              "      <th>close</th>\n",
              "      <th>conversionType</th>\n",
              "      <th>conversionSymbol</th>\n",
              "      <th>timeUTC</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1500854400</td>\n",
              "      <td>2798.89</td>\n",
              "      <td>2715.69</td>\n",
              "      <td>2756.61</td>\n",
              "      <td>83009.25</td>\n",
              "      <td>2.290474e+08</td>\n",
              "      <td>2763.42</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2017-07-24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1500940800</td>\n",
              "      <td>2779.08</td>\n",
              "      <td>2472.62</td>\n",
              "      <td>2763.42</td>\n",
              "      <td>205883.15</td>\n",
              "      <td>5.347654e+08</td>\n",
              "      <td>2582.58</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2017-07-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1501027200</td>\n",
              "      <td>2631.73</td>\n",
              "      <td>2441.54</td>\n",
              "      <td>2582.58</td>\n",
              "      <td>135502.93</td>\n",
              "      <td>3.404652e+08</td>\n",
              "      <td>2559.21</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2017-07-26</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1501113600</td>\n",
              "      <td>2712.92</td>\n",
              "      <td>2547.74</td>\n",
              "      <td>2559.21</td>\n",
              "      <td>103832.54</td>\n",
              "      <td>2.698809e+08</td>\n",
              "      <td>2691.88</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2017-07-27</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1501200000</td>\n",
              "      <td>2843.78</td>\n",
              "      <td>2683.59</td>\n",
              "      <td>2691.88</td>\n",
              "      <td>138904.86</td>\n",
              "      <td>3.834798e+08</td>\n",
              "      <td>2806.75</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2017-07-28</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1000</th>\n",
              "      <td>1587254400</td>\n",
              "      <td>7276.84</td>\n",
              "      <td>7072.33</td>\n",
              "      <td>7264.29</td>\n",
              "      <td>29493.83</td>\n",
              "      <td>2.114224e+08</td>\n",
              "      <td>7132.88</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1001</th>\n",
              "      <td>1587340800</td>\n",
              "      <td>7225.23</td>\n",
              "      <td>6770.07</td>\n",
              "      <td>7132.88</td>\n",
              "      <td>64707.00</td>\n",
              "      <td>4.523198e+08</td>\n",
              "      <td>6842.45</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1002</th>\n",
              "      <td>1587427200</td>\n",
              "      <td>6948.78</td>\n",
              "      <td>6779.51</td>\n",
              "      <td>6842.45</td>\n",
              "      <td>44531.91</td>\n",
              "      <td>3.058443e+08</td>\n",
              "      <td>6855.11</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-21</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1003</th>\n",
              "      <td>1587513600</td>\n",
              "      <td>7165.43</td>\n",
              "      <td>6831.44</td>\n",
              "      <td>6855.11</td>\n",
              "      <td>43780.72</td>\n",
              "      <td>3.082545e+08</td>\n",
              "      <td>7135.41</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1004</th>\n",
              "      <td>1587600000</td>\n",
              "      <td>7152.44</td>\n",
              "      <td>7110.82</td>\n",
              "      <td>7135.41</td>\n",
              "      <td>1478.46</td>\n",
              "      <td>1.053967e+07</td>\n",
              "      <td>7129.93</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-23</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1005 rows × 10 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            time     high      low  ...  conversionType  conversionSymbol    timeUTC\n",
              "0     1500854400  2798.89  2715.69  ...          direct                   2017-07-24\n",
              "1     1500940800  2779.08  2472.62  ...          direct                   2017-07-25\n",
              "2     1501027200  2631.73  2441.54  ...          direct                   2017-07-26\n",
              "3     1501113600  2712.92  2547.74  ...          direct                   2017-07-27\n",
              "4     1501200000  2843.78  2683.59  ...          direct                   2017-07-28\n",
              "...          ...      ...      ...  ...             ...               ...        ...\n",
              "1000  1587254400  7276.84  7072.33  ...          direct                   2020-04-19\n",
              "1001  1587340800  7225.23  6770.07  ...          direct                   2020-04-20\n",
              "1002  1587427200  6948.78  6779.51  ...          direct                   2020-04-21\n",
              "1003  1587513600  7165.43  6831.44  ...          direct                   2020-04-22\n",
              "1004  1587600000  7152.44  7110.82  ...          direct                   2020-04-23\n",
              "\n",
              "[1005 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "vhtZO9GxjhMW",
        "colab_type": "text"
      },
      "source": [
        "Get Every Minute of Bitcoin Price"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4ovlVZudjhYn",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 413
        },
        "outputId": "5184315e-41b7-4e00-ad38-b4cc66db4a03"
      },
      "source": [
        "API_KEY=\"\"\n",
        "crypto=\"BTC\"\n",
        "numOfTimesToHitApi=5\n",
        "MaxRecordsToGetOnEachCall=200\n",
        "frequency=\"minute\"\n",
        "\n",
        "cryptoData=getCryptoData(API_KEY,crypto,frequency,numOfTimesToHitApi,MaxRecordsToGetOnEachCall)\n",
        "cryptoData"
      ],
      "execution_count": 5,
      "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>time</th>\n",
              "      <th>high</th>\n",
              "      <th>low</th>\n",
              "      <th>open</th>\n",
              "      <th>volumefrom</th>\n",
              "      <th>volumeto</th>\n",
              "      <th>close</th>\n",
              "      <th>conversionType</th>\n",
              "      <th>conversionSymbol</th>\n",
              "      <th>timeUTC</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1587543480</td>\n",
              "      <td>6956.05</td>\n",
              "      <td>6951.09</td>\n",
              "      <td>6951.09</td>\n",
              "      <td>23.080</td>\n",
              "      <td>160433.10</td>\n",
              "      <td>6955.98</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-22 08:18:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1587543540</td>\n",
              "      <td>6956.71</td>\n",
              "      <td>6955.71</td>\n",
              "      <td>6955.98</td>\n",
              "      <td>4.895</td>\n",
              "      <td>34046.80</td>\n",
              "      <td>6955.88</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-22 08:19:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1587543600</td>\n",
              "      <td>6956.38</td>\n",
              "      <td>6954.24</td>\n",
              "      <td>6955.88</td>\n",
              "      <td>37.710</td>\n",
              "      <td>262219.93</td>\n",
              "      <td>6954.75</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-22 08:20:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1587543660</td>\n",
              "      <td>6954.76</td>\n",
              "      <td>6954.44</td>\n",
              "      <td>6954.75</td>\n",
              "      <td>3.223</td>\n",
              "      <td>22407.70</td>\n",
              "      <td>6954.44</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-22 08:21:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1587543720</td>\n",
              "      <td>6956.87</td>\n",
              "      <td>6954.25</td>\n",
              "      <td>6954.44</td>\n",
              "      <td>10.950</td>\n",
              "      <td>76207.62</td>\n",
              "      <td>6955.57</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-22 08:22:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1000</th>\n",
              "      <td>1587603480</td>\n",
              "      <td>7129.56</td>\n",
              "      <td>7128.66</td>\n",
              "      <td>7129.28</td>\n",
              "      <td>10.740</td>\n",
              "      <td>76532.65</td>\n",
              "      <td>7129.17</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-23 00:58:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1001</th>\n",
              "      <td>1587603540</td>\n",
              "      <td>7129.45</td>\n",
              "      <td>7126.76</td>\n",
              "      <td>7129.17</td>\n",
              "      <td>26.470</td>\n",
              "      <td>188599.65</td>\n",
              "      <td>7126.88</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-23 00:59:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1002</th>\n",
              "      <td>1587603600</td>\n",
              "      <td>7127.24</td>\n",
              "      <td>7125.59</td>\n",
              "      <td>7126.88</td>\n",
              "      <td>24.010</td>\n",
              "      <td>171058.44</td>\n",
              "      <td>7125.59</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-23 01:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1003</th>\n",
              "      <td>1587603660</td>\n",
              "      <td>7129.79</td>\n",
              "      <td>7123.11</td>\n",
              "      <td>7125.59</td>\n",
              "      <td>9.072</td>\n",
              "      <td>64643.10</td>\n",
              "      <td>7129.20</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-23 01:01:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1004</th>\n",
              "      <td>1587603720</td>\n",
              "      <td>7129.30</td>\n",
              "      <td>7129.20</td>\n",
              "      <td>7129.20</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>7129.30</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-23 01:02:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1005 rows × 10 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            time     high  ...  conversionSymbol             timeUTC\n",
              "0     1587543480  6956.05  ...                   2020-04-22 08:18:00\n",
              "1     1587543540  6956.71  ...                   2020-04-22 08:19:00\n",
              "2     1587543600  6956.38  ...                   2020-04-22 08:20:00\n",
              "3     1587543660  6954.76  ...                   2020-04-22 08:21:00\n",
              "4     1587543720  6956.87  ...                   2020-04-22 08:22:00\n",
              "...          ...      ...  ...               ...                 ...\n",
              "1000  1587603480  7129.56  ...                   2020-04-23 00:58:00\n",
              "1001  1587603540  7129.45  ...                   2020-04-23 00:59:00\n",
              "1002  1587603600  7127.24  ...                   2020-04-23 01:00:00\n",
              "1003  1587603660  7129.79  ...                   2020-04-23 01:01:00\n",
              "1004  1587603720  7129.30  ...                   2020-04-23 01:02:00\n",
              "\n",
              "[1005 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "SzJvZDYRjhmV",
        "colab_type": "text"
      },
      "source": [
        "Get Ethereum Price, frequency daily"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "q3ERdzMMjhyH",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 413
        },
        "outputId": "d288fd2f-7115-4c12-c5d7-55c7d41db8d3"
      },
      "source": [
        "API_KEY=\"\"\n",
        "crypto=\"ETH\"\n",
        "numOfTimesToHitApi=5\n",
        "MaxRecordsToGetOnEachCall=200\n",
        "frequency=\"day\"\n",
        "\n",
        "cryptoData=getCryptoData(API_KEY,crypto,frequency,numOfTimesToHitApi,MaxRecordsToGetOnEachCall)\n",
        "cryptoData"
      ],
      "execution_count": 6,
      "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>time</th>\n",
              "      <th>high</th>\n",
              "      <th>low</th>\n",
              "      <th>open</th>\n",
              "      <th>volumefrom</th>\n",
              "      <th>volumeto</th>\n",
              "      <th>close</th>\n",
              "      <th>conversionType</th>\n",
              "      <th>conversionSymbol</th>\n",
              "      <th>timeUTC</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1500854400</td>\n",
              "      <td>229.56</td>\n",
              "      <td>224.04</td>\n",
              "      <td>228.32</td>\n",
              "      <td>397799.34</td>\n",
              "      <td>9.016589e+07</td>\n",
              "      <td>225.48</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2017-07-24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1500940800</td>\n",
              "      <td>225.98</td>\n",
              "      <td>192.64</td>\n",
              "      <td>225.48</td>\n",
              "      <td>1382784.11</td>\n",
              "      <td>2.853748e+08</td>\n",
              "      <td>203.59</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2017-07-25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1501027200</td>\n",
              "      <td>209.29</td>\n",
              "      <td>193.10</td>\n",
              "      <td>203.59</td>\n",
              "      <td>809346.64</td>\n",
              "      <td>1.616593e+08</td>\n",
              "      <td>202.88</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2017-07-26</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1501113600</td>\n",
              "      <td>205.68</td>\n",
              "      <td>198.93</td>\n",
              "      <td>202.88</td>\n",
              "      <td>504777.47</td>\n",
              "      <td>1.020094e+08</td>\n",
              "      <td>202.93</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2017-07-27</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1501200000</td>\n",
              "      <td>203.93</td>\n",
              "      <td>189.77</td>\n",
              "      <td>202.93</td>\n",
              "      <td>631780.70</td>\n",
              "      <td>1.234255e+08</td>\n",
              "      <td>191.21</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2017-07-28</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1000</th>\n",
              "      <td>1587254400</td>\n",
              "      <td>185.31</td>\n",
              "      <td>178.32</td>\n",
              "      <td>187.85</td>\n",
              "      <td>1929266.85</td>\n",
              "      <td>3.478839e+08</td>\n",
              "      <td>180.32</td>\n",
              "      <td>multiply</td>\n",
              "      <td>BTC</td>\n",
              "      <td>2020-04-19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1001</th>\n",
              "      <td>1587340800</td>\n",
              "      <td>176.88</td>\n",
              "      <td>169.08</td>\n",
              "      <td>180.32</td>\n",
              "      <td>2362597.95</td>\n",
              "      <td>4.031790e+08</td>\n",
              "      <td>170.65</td>\n",
              "      <td>multiply</td>\n",
              "      <td>BTC</td>\n",
              "      <td>2020-04-20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1002</th>\n",
              "      <td>1587427200</td>\n",
              "      <td>173.37</td>\n",
              "      <td>170.14</td>\n",
              "      <td>170.65</td>\n",
              "      <td>1526448.92</td>\n",
              "      <td>2.610762e+08</td>\n",
              "      <td>171.03</td>\n",
              "      <td>multiply</td>\n",
              "      <td>BTC</td>\n",
              "      <td>2020-04-21</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1003</th>\n",
              "      <td>1587513600</td>\n",
              "      <td>183.59</td>\n",
              "      <td>177.67</td>\n",
              "      <td>171.03</td>\n",
              "      <td>1563640.09</td>\n",
              "      <td>2.861825e+08</td>\n",
              "      <td>183.02</td>\n",
              "      <td>multiply</td>\n",
              "      <td>BTC</td>\n",
              "      <td>2020-04-22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1004</th>\n",
              "      <td>1587600000</td>\n",
              "      <td>183.65</td>\n",
              "      <td>181.76</td>\n",
              "      <td>183.04</td>\n",
              "      <td>14310.17</td>\n",
              "      <td>2.614673e+06</td>\n",
              "      <td>182.49</td>\n",
              "      <td>direct</td>\n",
              "      <td></td>\n",
              "      <td>2020-04-23</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1005 rows × 10 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            time    high     low  ...  conversionType  conversionSymbol    timeUTC\n",
              "0     1500854400  229.56  224.04  ...          direct                   2017-07-24\n",
              "1     1500940800  225.98  192.64  ...          direct                   2017-07-25\n",
              "2     1501027200  209.29  193.10  ...          direct                   2017-07-26\n",
              "3     1501113600  205.68  198.93  ...          direct                   2017-07-27\n",
              "4     1501200000  203.93  189.77  ...          direct                   2017-07-28\n",
              "...          ...     ...     ...  ...             ...               ...        ...\n",
              "1000  1587254400  185.31  178.32  ...        multiply               BTC 2020-04-19\n",
              "1001  1587340800  176.88  169.08  ...        multiply               BTC 2020-04-20\n",
              "1002  1587427200  173.37  170.14  ...        multiply               BTC 2020-04-21\n",
              "1003  1587513600  183.59  177.67  ...        multiply               BTC 2020-04-22\n",
              "1004  1587600000  183.65  181.76  ...          direct                   2020-04-23\n",
              "\n",
              "[1005 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "TNb-HFryj-Q8",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "|"
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}