price predictor.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "10da477f-a67e-4123-ac9d-15d2264c835d",
   "metadata": {},
   "source": [
    "# Predicting 100x crypto coins"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ce8f0b96-641c-475d-b004-0fe998aa2615",
   "metadata": {},
   "source": [
    "## Time-series machine-learning model for cryptocurrencies"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0ceccbd7-0dd1-49c2-96f1-df105473e552",
   "metadata": {},
   "source": [
    "**Goal:** to train a predictor which is capable of identyfing \"100x\" coins and tokens basing solely on the past trace data. \n",
    "\n",
    "**Definitions:**\n",
    "\n",
    "* The \"100x\" term means an asset which price (in USD) grows hundred times fold during short period of data. \n",
    "* Let's assume by short period we mean 3 months, 6 months or 12 months. \n",
    "\n",
    "**Data:** past data on token price is taken from CoinGecko"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "48a41cbb-938d-4814-8cd5-ef68eaf04e1a",
   "metadata": {},
   "source": [
    "## Import libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "0031b2e1-e637-4f1b-975a-69ec7504c1c6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c00786e0-8b04-460c-9024-272cdd499587",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pycoingecko import CoinGeckoAPI"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "07d2db79-27f5-468a-a637-a4bce94674f9",
   "metadata": {},
   "outputs": [],
   "source": [
    "import random"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "1badc888-8815-4bdc-a32d-ad2d4b0c7e33",
   "metadata": {},
   "outputs": [],
   "source": [
    "from tqdm import tqdm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "e593ed76-7e52-4e92-90fe-a4b194519dca",
   "metadata": {},
   "outputs": [],
   "source": [
    "import time\n",
    "import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "ed6a68ff-b762-4b0c-9175-338215fde9de",
   "metadata": {},
   "outputs": [],
   "source": [
    "import defi.defi_tools as dft"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d110a86b-de38-43b2-8e87-e3afefd46ba6",
   "metadata": {},
   "source": [
    "## Data"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2ac38723-b47f-4464-8e39-3cf9985ba44e",
   "metadata": {},
   "source": [
    "### CoinGecko API client"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "3b86f05a-0ea2-40cc-826c-85294e0f9da5",
   "metadata": {},
   "outputs": [],
   "source": [
    "cg = CoinGeckoAPI()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "011010d9-ccd7-4617-b29a-f725f4f0cc60",
   "metadata": {},
   "source": [
    "#### Test with simple example"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "355e50b4-cdd4-4b96-b366-798049edb469",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'bitcoin': {'usd': 27549}}"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cg.get_price(ids='bitcoin', vs_currencies='usd')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "470c3191-2dbb-4174-9b3a-003f14fa8751",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'ethereum': {'usd': 1868.69,\n",
       "  'usd_market_cap': 225013094531.53198,\n",
       "  'usd_24h_vol': 7352961352.311256,\n",
       "  'usd_24h_change': 1.074688914060943,\n",
       "  'btc': 0.0678303,\n",
       "  'btc_market_cap': 8167591.1429964965,\n",
       "  'btc_24h_vol': 266899.9426054162,\n",
       "  'btc_24h_change': -0.07842932474885035,\n",
       "  'last_updated_at': 1682246998}}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cg.get_price(ids='ethereum', \n",
    "             vs_currencies='usd,btc', \n",
    "             include_market_cap=True, \n",
    "             include_24hr_vol=True, \n",
    "             include_24hr_change=True, \n",
    "             include_last_updated_at=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7276ea4e-9fbe-4659-8237-a45b839e70cd",
   "metadata": {},
   "source": [
    "### Parse"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "0214e22a-b984-4799-b6fc-703ae015e09f",
   "metadata": {},
   "outputs": [],
   "source": [
    "derivatives = cg.get_derivatives()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "cea539cc-6a40-4ea4-ac37-acb13528e629",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Number of derivatives downloaded: 4175'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f'Number of derivatives downloaded: {len(derivatives)}'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "45d27f4c-7267-4fbc-a712-0d39ad56f94d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'market': 'BIT (Futures)',\n",
       "  'symbol': 'USD-M:RSS3-USD-PERPETUAL',\n",
       "  'index_id': 'RSS3',\n",
       "  'price': '0.15',\n",
       "  'price_percentage_change_24h': 6.9124424,\n",
       "  'contract_type': 'perpetual',\n",
       "  'index': 0.1508866,\n",
       "  'basis': 0.0574271,\n",
       "  'spread': 0.4,\n",
       "  'funding_rate': 0.01,\n",
       "  'open_interest': None,\n",
       "  'volume_24h': 1168829.8388,\n",
       "  'last_traded_at': 1682246850,\n",
       "  'expired_at': None}]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "random.sample(derivatives, 1)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cb9863dc-c9a5-4c10-920a-241f8a3dc2b5",
   "metadata": {},
   "source": [
    "#### Supported coins"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "1ad107e5-85fe-4d0a-8711-9f6dd605649c",
   "metadata": {},
   "outputs": [],
   "source": [
    "all_coins_list = cg.get_coins_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "9447bf44-7068-44e4-8386-c87af1098c56",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'id': 'exodusext', 'symbol': 'ext', 'name': 'ExodusExt'},\n",
       " {'id': 'cryptopunk-7171-hoodie',\n",
       "  'symbol': 'hoodie',\n",
       "  'name': 'CryptoPunk #7171'},\n",
       " {'id': 'x42-protocol', 'symbol': 'x42', 'name': 'X42 Protocol'}]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "random.sample(all_coins_list, 3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "511ee472-b665-449e-bea4-f6852fe68668",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Number of all known coin symbols: 10723'"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f'Number of all known coin symbols: {len(all_coins_list)}'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "078c02e5-025c-4e47-be4e-ccc9a9b1ffe4",
   "metadata": {},
   "outputs": [],
   "source": [
    "# TODO: check if this holds \"tokens\" (as categorized by CMC) as well "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "b0f76b51-d19e-4a2d-9525-abd4983f9da1",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'id': 'shiba-world-cup',\n",
       " 'symbol': 'swc',\n",
       " 'name': 'Shiba World Cup',\n",
       " 'asset_platform_id': 'binance-smart-chain',\n",
       " 'platforms': {'binance-smart-chain': '0x27dcc73cbbbe57d006303316dd3e91a0d5d58eea'},\n",
       " 'detail_platforms': {'binance-smart-chain': {'decimal_place': 18,\n",
       "   'contract_address': '0x27dcc73cbbbe57d006303316dd3e91a0d5d58eea'}},\n",
       " 'block_time_in_minutes': 0,\n",
       " 'hashing_algorithm': None,\n",
       " 'categories': [],\n",
       " 'public_notice': None,\n",
       " 'additional_notices': [\"Kindly be aware of <a href='https://www.coingecko.com/en/glossary/rug-pulled' target='_blank'>liquidity-related risks</a>. This notice is not directed at any project in particular, and is more of a cautionary reminder.\",\n",
       "  'The following token has a variable tax function on the smart contract to <a href=\"https://support.coingecko.com/hc/en-us/articles/4499153900185-What-are-variable-taxes-on-Smart-Contracts-\">change tax rates post deployment</a>. <br>\\nDo your own research and be careful if you are trading this token.\\n'],\n",
       " 'localization': {'en': 'Shiba World Cup',\n",
       "  'de': 'Shiba World Cup',\n",
       "  'es': 'Shiba World Cup',\n",
       "  'fr': 'Shiba World Cup',\n",
       "  'it': 'Shiba World Cup',\n",
       "  'pl': 'Shiba World Cup',\n",
       "  'ro': 'Shiba World Cup',\n",
       "  'hu': 'Shiba World Cup',\n",
       "  'nl': 'Shiba World Cup',\n",
       "  'pt': 'Shiba World Cup',\n",
       "  'sv': 'Shiba World Cup',\n",
       "  'vi': 'Shiba World Cup',\n",
       "  'tr': 'Shiba World Cup',\n",
       "  'ru': 'Shiba World Cup',\n",
       "  'ja': 'Shiba World Cup',\n",
       "  'zh': 'Shiba World Cup',\n",
       "  'zh-tw': 'Shiba World Cup',\n",
       "  'ko': 'Shiba World Cup',\n",
       "  'ar': 'Shiba World Cup',\n",
       "  'th': 'Shiba World Cup',\n",
       "  'id': 'Shiba World Cup',\n",
       "  'cs': 'Shiba World Cup',\n",
       "  'da': 'Shiba World Cup',\n",
       "  'el': 'Shiba World Cup',\n",
       "  'hi': 'Shiba World Cup',\n",
       "  'no': 'Shiba World Cup',\n",
       "  'sk': 'Shiba World Cup',\n",
       "  'uk': 'Shiba World Cup',\n",
       "  'he': 'Shiba World Cup',\n",
       "  'fi': 'Shiba World Cup',\n",
       "  'bg': 'Shiba World Cup',\n",
       "  'hr': 'Shiba World Cup',\n",
       "  'lt': 'Shiba World Cup',\n",
       "  'sl': 'Shiba World Cup'},\n",
       " 'description': {'en': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'de': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'es': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'fr': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'it': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'pl': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'ro': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'hu': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'nl': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'pt': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'sv': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'vi': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'tr': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'ru': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'ja': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'zh': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'zh-tw': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'ko': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'ar': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'th': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'id': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'cs': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'da': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'el': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'hi': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'no': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'sk': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'uk': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'he': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'fi': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'bg': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'hr': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'lt': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.',\n",
       "  'sl': 'The Shiba worldcup will start at an initial size pre-public launch. 50% of the amount of the pre sale will be used to grow the fund. Shiba world token taxes will also be used to grow the fund Every week, 70% of the total fund value is contributed to a gambling stack. This stack will be bet throughout the following week. Earnings from the weeksbets will be re-invested into the fund as well as used to buyback and burn Shiba Worldcup tokens, boosting the price and increasing the liquidity.'},\n",
       " 'links': {'homepage': ['https://shiba-worldcup.io/', '', ''],\n",
       "  'blockchain_site': ['https://bscscan.com/token/0x27dcc73cbbbe57d006303316dd3e91a0d5d58eea',\n",
       "   '',\n",
       "   '',\n",
       "   '',\n",
       "   '',\n",
       "   '',\n",
       "   '',\n",
       "   '',\n",
       "   '',\n",
       "   ''],\n",
       "  'official_forum_url': ['', '', ''],\n",
       "  'chat_url': ['', '', ''],\n",
       "  'announcement_url': ['', ''],\n",
       "  'twitter_screen_name': None,\n",
       "  'facebook_username': None,\n",
       "  'bitcointalk_thread_identifier': None,\n",
       "  'telegram_channel_identifier': 'shibawolrdcup_ENG',\n",
       "  'subreddit_url': None,\n",
       "  'repos_url': {'github': [], 'bitbucket': []}},\n",
       " 'image': {'thumb': 'https://assets.coingecko.com/coins/images/28054/thumb/logo.jpg?1667287324',\n",
       "  'small': 'https://assets.coingecko.com/coins/images/28054/small/logo.jpg?1667287324',\n",
       "  'large': 'https://assets.coingecko.com/coins/images/28054/large/logo.jpg?1667287324'},\n",
       " 'country_origin': None,\n",
       " 'genesis_date': None,\n",
       " 'contract_address': '0x27dcc73cbbbe57d006303316dd3e91a0d5d58eea',\n",
       " 'sentiment_votes_up_percentage': None,\n",
       " 'sentiment_votes_down_percentage': None,\n",
       " 'market_cap_rank': None,\n",
       " 'coingecko_rank': None,\n",
       " 'coingecko_score': 0.0,\n",
       " 'developer_score': 0.0,\n",
       " 'community_score': 0.0,\n",
       " 'liquidity_score': 0.0,\n",
       " 'public_interest_score': 0.0,\n",
       " 'market_data': {'current_price': {'aed': 0.00033572,\n",
       "   'ars': 0.01948157,\n",
       "   'aud': 0.00013631,\n",
       "   'bch': 6.84806e-07,\n",
       "   'bdt': 0.00968822,\n",
       "   'bhd': 3.432e-05,\n",
       "   'bmd': 9.142e-05,\n",
       "   'bnb': 2.69656e-07,\n",
       "   'brl': 0.00044886,\n",
       "   'btc': 3.02e-09,\n",
       "   'cad': 0.00012359,\n",
       "   'chf': 8.163e-05,\n",
       "   'clp': 0.072365,\n",
       "   'cny': 0.00062819,\n",
       "   'czk': 0.00193921,\n",
       "   'dkk': 0.00061948,\n",
       "   'dot': 1.359e-05,\n",
       "   'eos': 7.372e-05,\n",
       "   'eth': 4.3707e-08,\n",
       "   'eur': 8.234e-05,\n",
       "   'gbp': 7.359e-05,\n",
       "   'hkd': 0.00071764,\n",
       "   'huf': 0.03106217,\n",
       "   'idr': 1.35,\n",
       "   'ils': 0.00033323,\n",
       "   'inr': 0.007482,\n",
       "   'jpy': 0.01223334,\n",
       "   'krw': 0.119245,\n",
       "   'kwd': 2.784e-05,\n",
       "   'lkr': 0.02940796,\n",
       "   'ltc': 9.40312e-07,\n",
       "   'mmk': 0.191188,\n",
       "   'mxn': 0.00164654,\n",
       "   'myr': 0.00040243,\n",
       "   'ngn': 0.04192081,\n",
       "   'nok': 0.0009452,\n",
       "   'nzd': 0.00014714,\n",
       "   'php': 0.00506,\n",
       "   'pkr': 0.02557163,\n",
       "   'pln': 0.00038592,\n",
       "   'rub': 0.00745676,\n",
       "   'sar': 0.00034291,\n",
       "   'sek': 0.00094448,\n",
       "   'sgd': 0.00012162,\n",
       "   'thb': 0.00309952,\n",
       "   'try': 0.00176983,\n",
       "   'twd': 0.00279004,\n",
       "   'uah': 0.00336253,\n",
       "   'usd': 9.142e-05,\n",
       "   'vef': 9.15e-06,\n",
       "   'vnd': 2.14,\n",
       "   'xag': 3.6e-06,\n",
       "   'xau': 4.5609e-08,\n",
       "   'xdr': 6.735e-05,\n",
       "   'xlm': 0.00085919,\n",
       "   'xrp': 0.00017595,\n",
       "   'yfi': 1.0036e-08,\n",
       "   'zar': 0.00164723,\n",
       "   'bits': 0.00302032,\n",
       "   'link': 1.145e-05,\n",
       "   'sats': 0.302032},\n",
       "  'total_value_locked': None,\n",
       "  'mcap_to_tvl_ratio': None,\n",
       "  'fdv_to_tvl_ratio': None,\n",
       "  'roi': None,\n",
       "  'ath': {'aed': 0.01046421,\n",
       "   'ars': 0.449728,\n",
       "   'aud': 0.00451214,\n",
       "   'bch': 2.463e-05,\n",
       "   'bdt': 0.289997,\n",
       "   'bhd': 0.00107417,\n",
       "   'bmd': 0.00284897,\n",
       "   'bnb': 8.7e-06,\n",
       "   'brl': 0.01457616,\n",
       "   'btc': 1.46886e-07,\n",
       "   'cad': 0.00390714,\n",
       "   'chf': 0.00288275,\n",
       "   'clp': 2.69,\n",
       "   'cny': 0.02078791,\n",
       "   'czk': 0.071269,\n",
       "   'dkk': 0.02170969,\n",
       "   'dot': 0.00043643,\n",
       "   'eos': 0.00277959,\n",
       "   'eth': 1.98e-06,\n",
       "   'eur': 0.00291696,\n",
       "   'gbp': 0.00254242,\n",
       "   'hkd': 0.02236452,\n",
       "   'huf': 1.18,\n",
       "   'idr': 44.81,\n",
       "   'ils': 0.01019743,\n",
       "   'inr': 0.235479,\n",
       "   'jpy': 0.421909,\n",
       "   'krw': 4.06,\n",
       "   'kwd': 0.00088496,\n",
       "   'lkr': 1.044,\n",
       "   'ltc': 4.582e-05,\n",
       "   'mmk': 5.97,\n",
       "   'mxn': 0.055941,\n",
       "   'myr': 0.01352404,\n",
       "   'ngn': 1.25,\n",
       "   'nok': 0.03002036,\n",
       "   'nzd': 0.00491718,\n",
       "   'php': 0.167204,\n",
       "   'pkr': 0.630725,\n",
       "   'pln': 0.01369884,\n",
       "   'rub': 0.177633,\n",
       "   'sar': 0.01070895,\n",
       "   'sek': 0.03181568,\n",
       "   'sgd': 0.00404097,\n",
       "   'thb': 0.107679,\n",
       "   'try': 0.053062,\n",
       "   'twd': 0.09186,\n",
       "   'uah': 0.104951,\n",
       "   'usd': 0.00284897,\n",
       "   'vef': 0.00028527,\n",
       "   'vnd': 70.84,\n",
       "   'xag': 0.00014559,\n",
       "   'xau': 1.74e-06,\n",
       "   'xdr': 0.0021219,\n",
       "   'xlm': 0.02753889,\n",
       "   'xrp': 0.00684359,\n",
       "   'yfi': 4.28161e-07,\n",
       "   'zar': 0.052285,\n",
       "   'bits': 0.146886,\n",
       "   'link': 0.00039464,\n",
       "   'sats': 14.69},\n",
       "  'ath_change_percentage': {'aed': -96.79359,\n",
       "   'ars': -95.67067,\n",
       "   'aud': -96.98091,\n",
       "   'bch': -97.21904,\n",
       "   'bdt': -96.66115,\n",
       "   'bhd': -96.80666,\n",
       "   'bmd': -96.79299,\n",
       "   'bnb': -96.90136,\n",
       "   'brl': -96.92237,\n",
       "   'btc': -97.94487,\n",
       "   'cad': -96.83876,\n",
       "   'chf': -97.17015,\n",
       "   'clp': -97.31271,\n",
       "   'cny': -96.97985,\n",
       "   'czk': -97.28061,\n",
       "   'dkk': -97.1482,\n",
       "   'dot': -96.88419,\n",
       "   'eos': -97.34803,\n",
       "   'eth': -97.79117,\n",
       "   'eur': -97.17879,\n",
       "   'gbp': -97.10723,\n",
       "   'hkd': -96.79303,\n",
       "   'huf': -97.37705,\n",
       "   'idr': -96.98566,\n",
       "   'ils': -96.73416,\n",
       "   'inr': -96.8245,\n",
       "   'jpy': -97.10217,\n",
       "   'krw': -97.06152,\n",
       "   'kwd': -96.85561,\n",
       "   'lkr': -97.18568,\n",
       "   'ltc': -97.94786,\n",
       "   'mmk': -96.79814,\n",
       "   'mxn': -97.05834,\n",
       "   'myr': -97.02607,\n",
       "   'ngn': -96.64161,\n",
       "   'nok': -96.85332,\n",
       "   'nzd': -97.00932,\n",
       "   'php': -96.97553,\n",
       "   'pkr': -95.94804,\n",
       "   'pln': -97.18446,\n",
       "   'rub': -95.8046,\n",
       "   'sar': -96.79979,\n",
       "   'sek': -97.03314,\n",
       "   'sgd': -96.99196,\n",
       "   'thb': -97.12319,\n",
       "   'try': -96.66655,\n",
       "   'twd': -96.9645,\n",
       "   'uah': -96.79796,\n",
       "   'usd': -96.79299,\n",
       "   'vef': -96.79299,\n",
       "   'vnd': -96.97695,\n",
       "   'xag': -97.52868,\n",
       "   'xau': -97.38138,\n",
       "   'xdr': -96.82773,\n",
       "   'xlm': -96.88005,\n",
       "   'xrp': -97.42972,\n",
       "   'yfi': -97.65495,\n",
       "   'zar': -96.85136,\n",
       "   'bits': -97.94487,\n",
       "   'link': -97.0994,\n",
       "   'sats': -97.94487},\n",
       "  'ath_date': {'aed': '2022-11-04T03:02:49.015Z',\n",
       "   'ars': '2022-11-04T03:02:49.015Z',\n",
       "   'aud': '2022-11-04T03:02:49.015Z',\n",
       "   'bch': '2022-11-13T10:58:05.838Z',\n",
       "   'bdt': '2022-11-04T03:02:49.015Z',\n",
       "   'bhd': '2022-11-04T03:02:49.015Z',\n",
       "   'bmd': '2022-11-04T03:02:49.015Z',\n",
       "   'bnb': '2022-11-13T10:58:05.838Z',\n",
       "   'brl': '2022-11-04T03:02:49.015Z',\n",
       "   'btc': '2022-11-13T10:58:05.838Z',\n",
       "   'cad': '2022-11-04T03:02:49.015Z',\n",
       "   'chf': '2022-11-04T03:02:49.015Z',\n",
       "   'clp': '2022-11-04T03:02:49.015Z',\n",
       "   'cny': '2022-11-04T03:02:49.015Z',\n",
       "   'czk': '2022-11-04T03:02:49.015Z',\n",
       "   'dkk': '2022-11-04T03:02:49.015Z',\n",
       "   'dot': '2022-11-04T03:02:49.015Z',\n",
       "   'eos': '2022-11-13T10:58:05.838Z',\n",
       "   'eth': '2022-11-13T10:58:05.838Z',\n",
       "   'eur': '2022-11-04T03:02:49.015Z',\n",
       "   'gbp': '2022-11-04T03:02:49.015Z',\n",
       "   'hkd': '2022-11-04T03:02:49.015Z',\n",
       "   'huf': '2022-11-04T03:02:49.015Z',\n",
       "   'idr': '2022-11-04T03:02:49.015Z',\n",
       "   'ils': '2022-11-04T03:02:49.015Z',\n",
       "   'inr': '2022-11-04T03:02:49.015Z',\n",
       "   'jpy': '2022-11-04T03:02:49.015Z',\n",
       "   'krw': '2022-11-04T03:02:49.015Z',\n",
       "   'kwd': '2022-11-04T03:02:49.015Z',\n",
       "   'lkr': '2022-11-04T03:02:49.015Z',\n",
       "   'ltc': '2022-11-04T03:02:49.015Z',\n",
       "   'mmk': '2022-11-04T03:02:49.015Z',\n",
       "   'mxn': '2022-11-04T03:02:49.015Z',\n",
       "   'myr': '2022-11-04T03:02:49.015Z',\n",
       "   'ngn': '2022-11-04T03:02:49.015Z',\n",
       "   'nok': '2022-11-04T03:02:49.015Z',\n",
       "   'nzd': '2022-11-04T03:02:49.015Z',\n",
       "   'php': '2022-11-04T03:02:49.015Z',\n",
       "   'pkr': '2022-11-04T03:02:49.015Z',\n",
       "   'pln': '2022-11-04T03:02:49.015Z',\n",
       "   'rub': '2022-11-04T03:02:49.015Z',\n",
       "   'sar': '2022-11-04T03:02:49.015Z',\n",
       "   'sek': '2022-11-04T03:02:49.015Z',\n",
       "   'sgd': '2022-11-04T03:02:49.015Z',\n",
       "   'thb': '2022-11-04T03:02:49.015Z',\n",
       "   'try': '2022-11-04T03:02:49.015Z',\n",
       "   'twd': '2022-11-04T03:02:49.015Z',\n",
       "   'uah': '2022-11-04T03:02:49.015Z',\n",
       "   'usd': '2022-11-04T03:02:49.015Z',\n",
       "   'vef': '2022-11-04T03:02:49.015Z',\n",
       "   'vnd': '2022-11-04T03:02:49.015Z',\n",
       "   'xag': '2022-11-04T03:02:49.015Z',\n",
       "   'xau': '2022-11-04T03:02:49.015Z',\n",
       "   'xdr': '2022-11-04T03:02:49.015Z',\n",
       "   'xlm': '2022-11-13T10:58:05.838Z',\n",
       "   'xrp': '2022-11-13T10:58:05.838Z',\n",
       "   'yfi': '2022-11-13T10:58:05.838Z',\n",
       "   'zar': '2022-11-04T03:02:49.015Z',\n",
       "   'bits': '2022-11-13T10:58:05.838Z',\n",
       "   'link': '2022-11-13T10:58:05.838Z',\n",
       "   'sats': '2022-11-13T10:58:05.838Z'},\n",
       "  'atl': {'aed': 0.00027843,\n",
       "   'ars': 0.01513675,\n",
       "   'aud': 0.00011507,\n",
       "   'bch': 5.93288e-07,\n",
       "   'bdt': 0.00799484,\n",
       "   'bhd': 2.858e-05,\n",
       "   'bmd': 7.581e-05,\n",
       "   'bnb': 2.68621e-07,\n",
       "   'brl': 0.00039122,\n",
       "   'btc': 2.86e-09,\n",
       "   'cad': 0.00010486,\n",
       "   'chf': 7.047e-05,\n",
       "   'clp': 0.060394,\n",
       "   'cny': 0.00052794,\n",
       "   'czk': 0.00169411,\n",
       "   'dkk': 0.00053284,\n",
       "   'dot': 1.164e-05,\n",
       "   'eos': 6.062e-05,\n",
       "   'eth': 4.2072e-08,\n",
       "   'eur': 7.16e-05,\n",
       "   'gbp': 6.354e-05,\n",
       "   'hkd': 0.00059509,\n",
       "   'huf': 0.02748039,\n",
       "   'idr': 1.17,\n",
       "   'ils': 0.0002706,\n",
       "   'inr': 0.00622033,\n",
       "   'jpy': 0.0103116,\n",
       "   'krw': 0.100496,\n",
       "   'kwd': 2.33e-05,\n",
       "   'lkr': 0.02472518,\n",
       "   'ltc': 8.56723e-07,\n",
       "   'mmk': 0.159258,\n",
       "   'mxn': 0.00138929,\n",
       "   'myr': 0.00034273,\n",
       "   'ngn': 0.03490969,\n",
       "   'nok': 0.00080838,\n",
       "   'nzd': 0.0001242,\n",
       "   'php': 0.00418647,\n",
       "   'pkr': 0.01935931,\n",
       "   'pln': 0.00033573,\n",
       "   'rub': 0.00575168,\n",
       "   'sar': 0.0002846,\n",
       "   'sek': 0.00081318,\n",
       "   'sgd': 0.00010251,\n",
       "   'thb': 0.00265563,\n",
       "   'try': 0.00142028,\n",
       "   'twd': 0.00233861,\n",
       "   'uah': 0.00280085,\n",
       "   'usd': 7.581e-05,\n",
       "   'vef': 7.59e-06,\n",
       "   'vnd': 1.8,\n",
       "   'xag': 3.35e-06,\n",
       "   'xau': 4.0936e-08,\n",
       "   'xdr': 5.702e-05,\n",
       "   'xlm': 0.00076433,\n",
       "   'xrp': 0.00015585,\n",
       "   'yfi': 7.266e-09,\n",
       "   'zar': 0.00140076,\n",
       "   'bits': 0.00285951,\n",
       "   'link': 1.084e-05,\n",
       "   'sats': 0.285951},\n",
       "  'atl_change_percentage': {'aed': 20.50684,\n",
       "   'ars': 28.62881,\n",
       "   'aud': 18.38225,\n",
       "   'bch': 15.46218,\n",
       "   'bdt': 21.11026,\n",
       "   'bhd': 20.02866,\n",
       "   'bmd': 20.52324,\n",
       "   'bnb': 0.41192,\n",
       "   'brl': 14.66827,\n",
       "   'btc': 5.56686,\n",
       "   'cad': 17.78386,\n",
       "   'chf': 15.7683,\n",
       "   'clp': 19.75114,\n",
       "   'cny': 18.92062,\n",
       "   'czk': 14.40087,\n",
       "   'dkk': 16.19113,\n",
       "   'dot': 16.85112,\n",
       "   'eos': 21.59767,\n",
       "   'eth': 3.82733,\n",
       "   'eur': 14.93833,\n",
       "   'gbp': 15.74425,\n",
       "   'hkd': 20.52374,\n",
       "   'huf': 12.96805,\n",
       "   'idr': 15.06242,\n",
       "   'ils': 23.07141,\n",
       "   'inr': 20.21281,\n",
       "   'jpy': 18.56754,\n",
       "   'krw': 18.58712,\n",
       "   'kwd': 19.41792,\n",
       "   'lkr': 18.87002,\n",
       "   'ltc': 9.76305,\n",
       "   'mmk': 19.97893,\n",
       "   'mxn': 18.44797,\n",
       "   'myr': 17.35088,\n",
       "   'ngn': 20.01361,\n",
       "   'nok': 16.85644,\n",
       "   'nzd': 18.40262,\n",
       "   'php': 20.79494,\n",
       "   'pkr': 32.01259,\n",
       "   'pln': 14.88411,\n",
       "   'rub': 29.56933,\n",
       "   'sar': 20.4156,\n",
       "   'sek': 16.0777,\n",
       "   'sgd': 18.57808,\n",
       "   'thb': 16.64717,\n",
       "   'try': 24.53874,\n",
       "   'twd': 19.23396,\n",
       "   'uah': 19.98405,\n",
       "   'usd': 20.52324,\n",
       "   'vef': 20.52324,\n",
       "   'vnd': 19.20105,\n",
       "   'xag': 7.34284,\n",
       "   'xau': 11.35018,\n",
       "   'xdr': 18.05048,\n",
       "   'xlm': 12.41224,\n",
       "   'xrp': 12.86293,\n",
       "   'yfi': 38.1813,\n",
       "   'zar': 17.52643,\n",
       "   'bits': 5.56686,\n",
       "   'link': 5.61588,\n",
       "   'sats': 5.56686},\n",
       "  'atl_date': {'aed': '2023-03-09T21:02:30.419Z',\n",
       "   'ars': '2023-01-01T05:05:06.583Z',\n",
       "   'aud': '2023-03-09T21:02:30.419Z',\n",
       "   'bch': '2023-02-21T01:51:10.118Z',\n",
       "   'bdt': '2023-03-09T21:02:30.419Z',\n",
       "   'bhd': '2023-03-09T21:02:30.419Z',\n",
       "   'bmd': '2023-03-09T21:02:30.419Z',\n",
       "   'bnb': '2023-04-11T16:51:28.317Z',\n",
       "   'brl': '2023-03-09T21:02:30.419Z',\n",
       "   'btc': '2023-04-13T06:02:21.061Z',\n",
       "   'cad': '2023-03-09T21:02:30.419Z',\n",
       "   'chf': '2023-03-10T21:52:28.739Z',\n",
       "   'clp': '2023-03-10T01:28:26.163Z',\n",
       "   'cny': '2023-03-10T21:41:34.404Z',\n",
       "   'czk': '2023-03-10T01:28:26.163Z',\n",
       "   'dkk': '2023-03-10T01:28:26.163Z',\n",
       "   'dot': '2023-02-19T16:19:06.114Z',\n",
       "   'eos': '2023-03-03T23:49:30.877Z',\n",
       "   'eth': '2023-04-14T21:33:25.751Z',\n",
       "   'eur': '2023-03-10T01:28:26.163Z',\n",
       "   'gbp': '2023-03-10T21:52:28.739Z',\n",
       "   'hkd': '2023-03-09T21:02:30.419Z',\n",
       "   'huf': '2023-03-10T01:28:26.163Z',\n",
       "   'idr': '2023-03-10T01:28:26.163Z',\n",
       "   'ils': '2023-03-09T21:02:30.419Z',\n",
       "   'inr': '2023-03-09T21:02:30.419Z',\n",
       "   'jpy': '2023-03-10T01:28:26.163Z',\n",
       "   'krw': '2023-03-10T01:28:26.163Z',\n",
       "   'kwd': '2023-03-09T21:02:30.419Z',\n",
       "   'lkr': '2023-03-10T21:41:34.404Z',\n",
       "   'ltc': '2023-03-02T08:20:21.478Z',\n",
       "   'mmk': '2023-03-09T21:02:30.419Z',\n",
       "   'mxn': '2023-03-09T21:02:30.419Z',\n",
       "   'myr': '2023-03-09T21:02:30.419Z',\n",
       "   'ngn': '2023-03-09T21:02:30.419Z',\n",
       "   'nok': '2023-03-09T21:02:30.419Z',\n",
       "   'nzd': '2023-03-10T01:28:26.163Z',\n",
       "   'php': '2023-03-09T21:02:30.419Z',\n",
       "   'pkr': '2023-01-01T05:05:06.583Z',\n",
       "   'pln': '2023-03-10T01:28:26.163Z',\n",
       "   'rub': '2023-03-10T01:28:26.163Z',\n",
       "   'sar': '2023-03-09T21:02:30.419Z',\n",
       "   'sek': '2023-03-10T01:28:26.163Z',\n",
       "   'sgd': '2023-03-09T21:02:30.419Z',\n",
       "   'thb': '2023-03-10T01:28:26.163Z',\n",
       "   'try': '2023-03-10T01:20:15.706Z',\n",
       "   'twd': '2023-03-09T21:02:30.419Z',\n",
       "   'uah': '2023-03-09T21:02:30.419Z',\n",
       "   'usd': '2023-03-09T21:02:30.419Z',\n",
       "   'vef': '2023-03-09T21:02:30.419Z',\n",
       "   'vnd': '2023-03-09T21:02:30.419Z',\n",
       "   'xag': '2023-04-07T12:01:24.447Z',\n",
       "   'xau': '2023-03-10T21:52:28.739Z',\n",
       "   'xdr': '2023-03-09T21:02:30.419Z',\n",
       "   'xlm': '2023-04-01T05:10:31.217Z',\n",
       "   'xrp': '2023-03-29T19:13:31.879Z',\n",
       "   'yfi': '2023-03-03T14:15:11.700Z',\n",
       "   'zar': '2023-03-10T21:41:34.404Z',\n",
       "   'bits': '2023-04-13T06:02:21.061Z',\n",
       "   'link': '2023-02-20T08:13:42.280Z',\n",
       "   'sats': '2023-04-13T06:02:21.061Z'},\n",
       "  'market_cap': {'aed': 0.0,\n",
       "   'ars': 0.0,\n",
       "   'aud': 0.0,\n",
       "   'bch': 0.0,\n",
       "   'bdt': 0.0,\n",
       "   'bhd': 0.0,\n",
       "   'bmd': 0.0,\n",
       "   'bnb': 0.0,\n",
       "   'brl': 0.0,\n",
       "   'btc': 0.0,\n",
       "   'cad': 0.0,\n",
       "   'chf': 0.0,\n",
       "   'clp': 0.0,\n",
       "   'cny': 0.0,\n",
       "   'czk': 0.0,\n",
       "   'dkk': 0.0,\n",
       "   'dot': 0.0,\n",
       "   'eos': 0.0,\n",
       "   'eth': 0.0,\n",
       "   'eur': 0.0,\n",
       "   'gbp': 0.0,\n",
       "   'hkd': 0.0,\n",
       "   'huf': 0.0,\n",
       "   'idr': 0.0,\n",
       "   'ils': 0.0,\n",
       "   'inr': 0.0,\n",
       "   'jpy': 0.0,\n",
       "   'krw': 0.0,\n",
       "   'kwd': 0.0,\n",
       "   'lkr': 0.0,\n",
       "   'ltc': 0.0,\n",
       "   'mmk': 0.0,\n",
       "   'mxn': 0.0,\n",
       "   'myr': 0.0,\n",
       "   'ngn': 0.0,\n",
       "   'nok': 0.0,\n",
       "   'nzd': 0.0,\n",
       "   'php': 0.0,\n",
       "   'pkr': 0.0,\n",
       "   'pln': 0.0,\n",
       "   'rub': 0.0,\n",
       "   'sar': 0.0,\n",
       "   'sek': 0.0,\n",
       "   'sgd': 0.0,\n",
       "   'thb': 0.0,\n",
       "   'try': 0.0,\n",
       "   'twd': 0.0,\n",
       "   'uah': 0.0,\n",
       "   'usd': 0.0,\n",
       "   'vef': 0.0,\n",
       "   'vnd': 0.0,\n",
       "   'xag': 0.0,\n",
       "   'xau': 0.0,\n",
       "   'xdr': 0.0,\n",
       "   'xlm': 0.0,\n",
       "   'xrp': 0.0,\n",
       "   'yfi': 0.0,\n",
       "   'zar': 0.0,\n",
       "   'bits': 0.0,\n",
       "   'link': 0.0,\n",
       "   'sats': 0.0},\n",
       "  'market_cap_rank': None,\n",
       "  'fully_diluted_valuation': {'aed': 335588,\n",
       "   'ars': 19473841,\n",
       "   'aud': 136251,\n",
       "   'bch': 685.126,\n",
       "   'bdt': 9684376,\n",
       "   'bhd': 34308,\n",
       "   'bmd': 91384,\n",
       "   'bnb': 270.497,\n",
       "   'brl': 448684,\n",
       "   'btc': 3.018697,\n",
       "   'cad': 123537,\n",
       "   'chf': 81593,\n",
       "   'clp': 72336557,\n",
       "   'cny': 627942,\n",
       "   'czk': 1938437,\n",
       "   'dkk': 619233,\n",
       "   'dot': 13597,\n",
       "   'eos': 73773,\n",
       "   'eth': 43.698646,\n",
       "   'eur': 82309,\n",
       "   'gbp': 73560,\n",
       "   'hkd': 717356,\n",
       "   'huf': 31049841,\n",
       "   'idr': 1350846130,\n",
       "   'ils': 333094,\n",
       "   'inr': 7479030,\n",
       "   'jpy': 12228488,\n",
       "   'krw': 119197944,\n",
       "   'kwd': 27832,\n",
       "   'lkr': 29396289,\n",
       "   'ltc': 939.57,\n",
       "   'mmk': 191111921,\n",
       "   'mxn': 1645891,\n",
       "   'myr': 402270,\n",
       "   'ngn': 41904174,\n",
       "   'nok': 944821,\n",
       "   'nzd': 147084,\n",
       "   'php': 5057987,\n",
       "   'pkr': 25561477,\n",
       "   'pln': 385768,\n",
       "   'rub': 7453796,\n",
       "   'sar': 342772,\n",
       "   'sek': 944102,\n",
       "   'sgd': 121577,\n",
       "   'thb': 3098292,\n",
       "   'try': 1769130,\n",
       "   'twd': 2788934,\n",
       "   'uah': 3361197,\n",
       "   'usd': 91384,\n",
       "   'vef': 9150.23,\n",
       "   'vnd': 2142030113,\n",
       "   'xag': 3598.56,\n",
       "   'xau': 45.59,\n",
       "   'xdr': 67325,\n",
       "   'xlm': 859320,\n",
       "   'xrp': 176002,\n",
       "   'yfi': 10.036543,\n",
       "   'zar': 1646573,\n",
       "   'bits': 3018697,\n",
       "   'link': 11450,\n",
       "   'sats': 301869738},\n",
       "  'total_volume': {'aed': 21.14,\n",
       "   'ars': 1226.68,\n",
       "   'aud': 8.58,\n",
       "   'bch': 0.04311963,\n",
       "   'bdt': 610.03,\n",
       "   'bhd': 2.16,\n",
       "   'bmd': 5.76,\n",
       "   'bnb': 0.01697919,\n",
       "   'brl': 28.26,\n",
       "   'btc': 0.00019018,\n",
       "   'cad': 7.78,\n",
       "   'chf': 5.14,\n",
       "   'clp': 4556.57,\n",
       "   'cny': 39.55,\n",
       "   'czk': 122.1,\n",
       "   'dkk': 39.01,\n",
       "   'dot': 0.85585941,\n",
       "   'eos': 4.642144,\n",
       "   'eth': 0.00275205,\n",
       "   'eur': 5.18,\n",
       "   'gbp': 4.63,\n",
       "   'hkd': 45.19,\n",
       "   'huf': 1955.87,\n",
       "   'idr': 85091,\n",
       "   'ils': 20.98,\n",
       "   'inr': 471.11,\n",
       "   'jpy': 770.29,\n",
       "   'krw': 7508.42,\n",
       "   'kwd': 1.75,\n",
       "   'lkr': 1851.71,\n",
       "   'ltc': 0.05920788,\n",
       "   'mmk': 12038.37,\n",
       "   'mxn': 103.68,\n",
       "   'myr': 25.34,\n",
       "   'ngn': 2639.59,\n",
       "   'nok': 59.52,\n",
       "   'nzd': 9.27,\n",
       "   'php': 318.61,\n",
       "   'pkr': 1610.15,\n",
       "   'pln': 24.3,\n",
       "   'rub': 469.52,\n",
       "   'sar': 21.59,\n",
       "   'sek': 59.47,\n",
       "   'sgd': 7.66,\n",
       "   'thb': 195.17,\n",
       "   'try': 111.44,\n",
       "   'twd': 175.68,\n",
       "   'uah': 211.73,\n",
       "   'usd': 5.76,\n",
       "   'vef': 0.576384,\n",
       "   'vnd': 134929,\n",
       "   'xag': 0.226677,\n",
       "   'xau': 0.00287185,\n",
       "   'xdr': 4.24,\n",
       "   'xlm': 54.1,\n",
       "   'xrp': 11.078967,\n",
       "   'yfi': 0.00063192,\n",
       "   'zar': 103.72,\n",
       "   'bits': 190.18,\n",
       "   'link': 0.72080147,\n",
       "   'sats': 19017.78},\n",
       "  'high_24h': {'aed': 0.00033559,\n",
       "   'ars': 0.01947384,\n",
       "   'aud': 0.00013625,\n",
       "   'bch': 6.85126e-07,\n",
       "   'bdt': 0.00968438,\n",
       "   'bhd': 3.431e-05,\n",
       "   'bmd': 9.138e-05,\n",
       "   'bnb': 2.70964e-07,\n",
       "   'brl': 0.00044868,\n",
       "   'btc': 3.019e-09,\n",
       "   'cad': 0.00012354,\n",
       "   'chf': 8.159e-05,\n",
       "   'clp': 0.072337,\n",
       "   'cny': 0.00062794,\n",
       "   'czk': 0.00193844,\n",
       "   'dkk': 0.00061923,\n",
       "   'dot': 1.36e-05,\n",
       "   'eos': 7.377e-05,\n",
       "   'eth': 4.3699e-08,\n",
       "   'eur': 8.231e-05,\n",
       "   'gbp': 7.356e-05,\n",
       "   'hkd': 0.00071736,\n",
       "   'huf': 0.03104984,\n",
       "   'idr': 1.35,\n",
       "   'ils': 0.00033309,\n",
       "   'inr': 0.00747903,\n",
       "   'jpy': 0.01222849,\n",
       "   'krw': 0.119198,\n",
       "   'kwd': 2.783e-05,\n",
       "   'lkr': 0.02939629,\n",
       "   'ltc': 9.40365e-07,\n",
       "   'mmk': 0.191112,\n",
       "   'mxn': 0.00164589,\n",
       "   'myr': 0.00040227,\n",
       "   'ngn': 0.04190417,\n",
       "   'nok': 0.00094482,\n",
       "   'nzd': 0.00014708,\n",
       "   'php': 0.00505799,\n",
       "   'pkr': 0.02556148,\n",
       "   'pln': 0.00038577,\n",
       "   'rub': 0.0074538,\n",
       "   'sar': 0.00034277,\n",
       "   'sek': 0.0009441,\n",
       "   'sgd': 0.00012158,\n",
       "   'thb': 0.00309829,\n",
       "   'try': 0.00176913,\n",
       "   'twd': 0.00278893,\n",
       "   'uah': 0.0033612,\n",
       "   'usd': 9.138e-05,\n",
       "   'vef': 9.15e-06,\n",
       "   'vnd': 2.14,\n",
       "   'xag': 3.6e-06,\n",
       "   'xau': 4.5591e-08,\n",
       "   'xdr': 6.732e-05,\n",
       "   'xlm': 0.00085932,\n",
       "   'xrp': 0.000176,\n",
       "   'yfi': 1.0041e-08,\n",
       "   'zar': 0.00164657,\n",
       "   'bits': 0.0030187,\n",
       "   'link': 1.145e-05,\n",
       "   'sats': 0.30187},\n",
       "  'low_24h': {'aed': 0.00033111,\n",
       "   'ars': 0.01921393,\n",
       "   'aud': 0.00013443,\n",
       "   'bch': 6.75346e-07,\n",
       "   'bdt': 0.00955512,\n",
       "   'bhd': 3.385e-05,\n",
       "   'bmd': 9.016e-05,\n",
       "   'bnb': 2.69116e-07,\n",
       "   'brl': 0.0004427,\n",
       "   'btc': 2.975e-09,\n",
       "   'cad': 0.00012189,\n",
       "   'chf': 8.05e-05,\n",
       "   'clp': 0.071371,\n",
       "   'cny': 0.00061956,\n",
       "   'czk': 0.00191256,\n",
       "   'dkk': 0.00061097,\n",
       "   'dot': 1.339e-05,\n",
       "   'eos': 7.271e-05,\n",
       "   'eth': 4.3117e-08,\n",
       "   'eur': 8.121e-05,\n",
       "   'gbp': 7.258e-05,\n",
       "   'hkd': 0.00070778,\n",
       "   'huf': 0.03063542,\n",
       "   'idr': 1.33,\n",
       "   'ils': 0.00032865,\n",
       "   'inr': 0.00737921,\n",
       "   'jpy': 0.01206528,\n",
       "   'krw': 0.117607,\n",
       "   'kwd': 2.746e-05,\n",
       "   'lkr': 0.02900394,\n",
       "   'ltc': 9.31243e-07,\n",
       "   'mmk': 0.188561,\n",
       "   'mxn': 0.00162392,\n",
       "   'myr': 0.0003969,\n",
       "   'ngn': 0.04134488,\n",
       "   'nok': 0.00093221,\n",
       "   'nzd': 0.00014512,\n",
       "   'php': 0.00499048,\n",
       "   'pkr': 0.02522031,\n",
       "   'pln': 0.00038062,\n",
       "   'rub': 0.00735431,\n",
       "   'sar': 0.0003382,\n",
       "   'sek': 0.0009315,\n",
       "   'sgd': 0.00011995,\n",
       "   'thb': 0.00305694,\n",
       "   'try': 0.00174552,\n",
       "   'twd': 0.00275171,\n",
       "   'uah': 0.00331634,\n",
       "   'usd': 9.016e-05,\n",
       "   'vef': 9.03e-06,\n",
       "   'vnd': 2.11,\n",
       "   'xag': 3.55e-06,\n",
       "   'xau': 4.4983e-08,\n",
       "   'xdr': 6.643e-05,\n",
       "   'xlm': 0.00084534,\n",
       "   'xrp': 0.00017358,\n",
       "   'yfi': 9.878e-09,\n",
       "   'zar': 0.0016246,\n",
       "   'bits': 0.00297473,\n",
       "   'link': 1.128e-05,\n",
       "   'sats': 0.297473},\n",
       "  'price_change_24h': 1.26e-06,\n",
       "  'price_change_percentage_24h': 1.39299,\n",
       "  'price_change_percentage_7d': 8.80981,\n",
       "  'price_change_percentage_14d': 6.03213,\n",
       "  'price_change_percentage_30d': 0.49638,\n",
       "  'price_change_percentage_60d': 6.49466,\n",
       "  'price_change_percentage_200d': 0.0,\n",
       "  'price_change_percentage_1y': 0.0,\n",
       "  'market_cap_change_24h': 0.0,\n",
       "  'market_cap_change_percentage_24h': 0.0,\n",
       "  'price_change_24h_in_currency': {'aed': 4.61e-06,\n",
       "   'ars': 0.00026765,\n",
       "   'aud': 1.87e-06,\n",
       "   'bch': 9.079e-09,\n",
       "   'bdt': 0.0001331,\n",
       "   'bhd': 4.71535e-07,\n",
       "   'bmd': 1.26e-06,\n",
       "   'bnb': -2.34019304e-10,\n",
       "   'brl': 6.17e-06,\n",
       "   'btc': 4.5583e-11,\n",
       "   'cad': 1.7e-06,\n",
       "   'chf': 1.12e-06,\n",
       "   'clp': 0.00099419,\n",
       "   'cny': 8.63e-06,\n",
       "   'czk': 2.664e-05,\n",
       "   'dkk': 8.51e-06,\n",
       "   'dot': 2.06225e-07,\n",
       "   'eos': 1.01e-06,\n",
       "   'eth': 5.89295e-10,\n",
       "   'eur': 1.13e-06,\n",
       "   'gbp': 1.01e-06,\n",
       "   'hkd': 9.86e-06,\n",
       "   'huf': 0.00042675,\n",
       "   'idr': 0.01856604,\n",
       "   'ils': 4.58e-06,\n",
       "   'inr': 0.00010279,\n",
       "   'jpy': 0.00016807,\n",
       "   'krw': 0.00163826,\n",
       "   'kwd': 3.82521e-07,\n",
       "   'lkr': 0.00040402,\n",
       "   'ltc': 5.228e-09,\n",
       "   'mmk': 0.00262664,\n",
       "   'mxn': 2.262e-05,\n",
       "   'myr': 5.53e-06,\n",
       "   'ngn': 0.00057593,\n",
       "   'nok': 1.299e-05,\n",
       "   'nzd': 2.02e-06,\n",
       "   'php': 6.952e-05,\n",
       "   'pkr': 0.00035132,\n",
       "   'pln': 5.3e-06,\n",
       "   'rub': 0.00010245,\n",
       "   'sar': 4.71e-06,\n",
       "   'sek': 1.298e-05,\n",
       "   'sgd': 1.67e-06,\n",
       "   'thb': 4.258e-05,\n",
       "   'try': 2.431e-05,\n",
       "   'twd': 3.833e-05,\n",
       "   'uah': 4.62e-05,\n",
       "   'usd': 1.26e-06,\n",
       "   'vef': 1.25761e-07,\n",
       "   'vnd': 0.02944007,\n",
       "   'xag': 4.9459e-08,\n",
       "   'xau': 6.26606e-10,\n",
       "   'xdr': 9.25313e-07,\n",
       "   'xlm': 1.385e-05,\n",
       "   'xrp': 2.31e-06,\n",
       "   'yfi': 1.57791e-10,\n",
       "   'zar': 2.263e-05,\n",
       "   'bits': 4.558e-05,\n",
       "   'link': 1.65997e-07,\n",
       "   'sats': 0.00455825},\n",
       "  'price_change_percentage_1h_in_currency': {'aed': 1.32872,\n",
       "   'ars': 1.32872,\n",
       "   'aud': 1.32872,\n",
       "   'bch': 1.09736,\n",
       "   'bdt': 1.32872,\n",
       "   'bhd': 1.32872,\n",
       "   'bmd': 1.32872,\n",
       "   'bnb': -0.08669,\n",
       "   'brl': 1.32872,\n",
       "   'btc': 1.35771,\n",
       "   'cad': 1.32872,\n",
       "   'chf': 1.32872,\n",
       "   'clp': 1.32872,\n",
       "   'cny': 1.32872,\n",
       "   'czk': 1.32872,\n",
       "   'dkk': 1.32872,\n",
       "   'dot': 0.85253,\n",
       "   'eos': 1.0632,\n",
       "   'eth': 1.13287,\n",
       "   'eur': 1.32872,\n",
       "   'gbp': 1.32872,\n",
       "   'hkd': 1.32872,\n",
       "   'huf': 1.32872,\n",
       "   'idr': 1.32872,\n",
       "   'ils': 1.32872,\n",
       "   'inr': 1.32872,\n",
       "   'jpy': 1.32872,\n",
       "   'krw': 1.32872,\n",
       "   'kwd': 1.32872,\n",
       "   'lkr': 1.32872,\n",
       "   'ltc': 0.67179,\n",
       "   'mmk': 1.32872,\n",
       "   'mxn': 1.32872,\n",
       "   'myr': 1.32872,\n",
       "   'ngn': 1.32872,\n",
       "   'nok': 1.32872,\n",
       "   'nzd': 1.32872,\n",
       "   'php': 1.32872,\n",
       "   'pkr': 1.32872,\n",
       "   'pln': 1.32872,\n",
       "   'rub': 1.32872,\n",
       "   'sar': 1.32872,\n",
       "   'sek': 1.32872,\n",
       "   'sgd': 1.32872,\n",
       "   'thb': 1.32872,\n",
       "   'try': 1.32872,\n",
       "   'twd': 1.32872,\n",
       "   'uah': 1.32872,\n",
       "   'usd': 1.32872,\n",
       "   'vef': 1.32872,\n",
       "   'vnd': 1.32872,\n",
       "   'xag': 1.32872,\n",
       "   'xau': 1.32872,\n",
       "   'xdr': 1.32872,\n",
       "   'xlm': 1.21372,\n",
       "   'xrp': 1.18482,\n",
       "   'yfi': 1.0467,\n",
       "   'zar': 1.32872,\n",
       "   'bits': 1.35771,\n",
       "   'link': 1.07418,\n",
       "   'sats': 1.35771},\n",
       "  'price_change_percentage_24h_in_currency': {'aed': 1.39299,\n",
       "   'ars': 1.39299,\n",
       "   'aud': 1.39299,\n",
       "   'bch': 1.34352,\n",
       "   'bdt': 1.39299,\n",
       "   'bhd': 1.39299,\n",
       "   'bmd': 1.39299,\n",
       "   'bnb': -0.08671,\n",
       "   'brl': 1.39299,\n",
       "   'btc': 1.53232,\n",
       "   'cad': 1.39299,\n",
       "   'chf': 1.39299,\n",
       "   'clp': 1.39299,\n",
       "   'cny': 1.39299,\n",
       "   'czk': 1.39299,\n",
       "   'dkk': 1.39299,\n",
       "   'dot': 1.54058,\n",
       "   'eos': 1.38921,\n",
       "   'eth': 1.36672,\n",
       "   'eur': 1.39299,\n",
       "   'gbp': 1.39299,\n",
       "   'hkd': 1.39299,\n",
       "   'huf': 1.39299,\n",
       "   'idr': 1.39299,\n",
       "   'ils': 1.39299,\n",
       "   'inr': 1.39299,\n",
       "   'jpy': 1.39299,\n",
       "   'krw': 1.39299,\n",
       "   'kwd': 1.39299,\n",
       "   'lkr': 1.39299,\n",
       "   'ltc': 0.55904,\n",
       "   'mmk': 1.39299,\n",
       "   'mxn': 1.39299,\n",
       "   'myr': 1.39299,\n",
       "   'ngn': 1.39299,\n",
       "   'nok': 1.39299,\n",
       "   'nzd': 1.39299,\n",
       "   'php': 1.39299,\n",
       "   'pkr': 1.39299,\n",
       "   'pln': 1.39299,\n",
       "   'rub': 1.39299,\n",
       "   'sar': 1.39299,\n",
       "   'sek': 1.39299,\n",
       "   'sgd': 1.39299,\n",
       "   'thb': 1.39299,\n",
       "   'try': 1.39299,\n",
       "   'twd': 1.39299,\n",
       "   'uah': 1.39299,\n",
       "   'usd': 1.39299,\n",
       "   'vef': 1.39299,\n",
       "   'vnd': 1.39299,\n",
       "   'xag': 1.39299,\n",
       "   'xau': 1.39299,\n",
       "   'xdr': 1.39299,\n",
       "   'xlm': 1.63855,\n",
       "   'xrp': 1.33055,\n",
       "   'yfi': 1.59739,\n",
       "   'zar': 1.39299,\n",
       "   'bits': 1.53232,\n",
       "   'link': 1.47142,\n",
       "   'sats': 1.53232},\n",
       "  'price_change_percentage_7d_in_currency': {'aed': 8.80107,\n",
       "   'ars': 10.53527,\n",
       "   'aud': 8.24203,\n",
       "   'bch': 1.03625,\n",
       "   'bdt': 9.69082,\n",
       "   'bhd': 8.37163,\n",
       "   'bmd': 8.80981,\n",
       "   'bnb': -0.20056,\n",
       "   'brl': 5.64931,\n",
       "   'btc': 0.56953,\n",
       "   'cad': 8.4808,\n",
       "   'chf': 7.28346,\n",
       "   'clp': 5.25821,\n",
       "   'cny': 8.82248,\n",
       "   'czk': 7.94976,\n",
       "   'dkk': 7.94323,\n",
       "   'dot': -0.71835,\n",
       "   'eos': 4.6738,\n",
       "   'eth': -3.67106,\n",
       "   'eur': 7.75132,\n",
       "   'gbp': 8.79238,\n",
       "   'hkd': 8.81259,\n",
       "   'huf': 7.35794,\n",
       "   'idr': 7.65341,\n",
       "   'ils': 10.13808,\n",
       "   'inr': 8.81208,\n",
       "   'jpy': 10.17661,\n",
       "   'krw': 7.81217,\n",
       "   'kwd': 8.01925,\n",
       "   'lkr': 10.22907,\n",
       "   'ltc': 0.72864,\n",
       "   'mmk': 8.34286,\n",
       "   'mxn': 8.11946,\n",
       "   'myr': 8.7851,\n",
       "   'ngn': 7.30116,\n",
       "   'nok': 7.19218,\n",
       "   'nzd': 9.77303,\n",
       "   'php': 10.52511,\n",
       "   'pkr': 7.16864,\n",
       "   'pln': 7.10081,\n",
       "   'rub': 9.29793,\n",
       "   'sar': 8.80407,\n",
       "   'sek': 7.34375,\n",
       "   'sgd': 8.85891,\n",
       "   'thb': 8.95658,\n",
       "   'try': 9.43672,\n",
       "   'twd': 9.20664,\n",
       "   'uah': 8.84445,\n",
       "   'usd': 8.80981,\n",
       "   'vef': 8.80981,\n",
       "   'vnd': 8.77891,\n",
       "   'xag': 7.01661,\n",
       "   'xau': 8.98676,\n",
       "   'xdr': 8.02695,\n",
       "   'xlm': 6.77301,\n",
       "   'xrp': 6.05704,\n",
       "   'yfi': 3.74973,\n",
       "   'zar': 7.49119,\n",
       "   'bits': 0.56953,\n",
       "   'link': -2.66704,\n",
       "   'sats': 0.56953},\n",
       "  'price_change_percentage_14d_in_currency': {'aed': 6.02058,\n",
       "   'ars': 8.42895,\n",
       "   'aud': 5.73181,\n",
       "   'bch': 0.34775,\n",
       "   'bdt': 4.99918,\n",
       "   'bhd': 5.71451,\n",
       "   'bmd': 6.03213,\n",
       "   'bnb': -1.41271,\n",
       "   'brl': 2.81973,\n",
       "   'btc': -0.1498,\n",
       "   'cad': 5.95375,\n",
       "   'chf': 3.48188,\n",
       "   'clp': 6.12075,\n",
       "   'cny': 6.07381,\n",
       "   'czk': 3.90909,\n",
       "   'dkk': 4.56767,\n",
       "   'dot': 0.2213,\n",
       "   'eos': 2.21428,\n",
       "   'eth': -7.54501,\n",
       "   'eur': 3.78779,\n",
       "   'gbp': 5.36639,\n",
       "   'hkd': 6.03213,\n",
       "   'huf': 2.87564,\n",
       "   'idr': 4.71111,\n",
       "   'ils': 7.34438,\n",
       "   'inr': 5.59545,\n",
       "   'jpy': 6.86261,\n",
       "   'krw': 5.8617,\n",
       "   'kwd': 5.30466,\n",
       "   'lkr': 3.3409,\n",
       "   'ltc': 1.10974,\n",
       "   'mmk': 5.67116,\n",
       "   'mxn': 5.99564,\n",
       "   'myr': 5.77982,\n",
       "   'ngn': 5.62047,\n",
       "   'nok': 4.50857,\n",
       "   'nzd': 6.80012,\n",
       "   'php': 8.09545,\n",
       "   'pkr': 4.50645,\n",
       "   'pln': 3.70506,\n",
       "   'rub': 11.55772,\n",
       "   'sar': 5.9926,\n",
       "   'sek': 5.54889,\n",
       "   'sgd': 6.00026,\n",
       "   'thb': 5.47253,\n",
       "   'try': 7.03395,\n",
       "   'twd': 5.95887,\n",
       "   'uah': 6.34883,\n",
       "   'usd': 6.03213,\n",
       "   'vef': 6.03213,\n",
       "   'vnd': 5.82896,\n",
       "   'xag': 0.64588,\n",
       "   'xau': 4.18401,\n",
       "   'xdr': 5.02441,\n",
       "   'xlm': 7.96311,\n",
       "   'xrp': 4.33276,\n",
       "   'yfi': 2.34527,\n",
       "   'zar': 7.36937,\n",
       "   'bits': -0.1498,\n",
       "   'link': 0.34252,\n",
       "   'sats': -0.1498},\n",
       "  'price_change_percentage_30d_in_currency': {'aed': 0.4827,\n",
       "   'ars': 5.5262,\n",
       "   'aud': -0.13956,\n",
       "   'bch': -4.34077,\n",
       "   'bdt': -0.7337,\n",
       "   'bhd': 0.06327,\n",
       "   'bmd': 0.49638,\n",
       "   'bnb': -1.72503,\n",
       "   'brl': -5.68872,\n",
       "   'btc': -16.49911,\n",
       "   'cad': -0.95813,\n",
       "   'chf': -3.42,\n",
       "   'clp': -3.74448,\n",
       "   'cny': 0.10305,\n",
       "   'czk': -5.67943,\n",
       "   'dkk': -2.90389,\n",
       "   'dot': -8.41888,\n",
       "   'eos': -11.84242,\n",
       "   'eth': -19.31359,\n",
       "   'eur': -3.91182,\n",
       "   'gbp': -2.01319,\n",
       "   'hkd': 0.5015,\n",
       "   'huf': -8.15288,\n",
       "   'idr': -3.71406,\n",
       "   'ils': -0.03569,\n",
       "   'inr': -0.45314,\n",
       "   'jpy': 0.83384,\n",
       "   'krw': 0.68356,\n",
       "   'kwd': -0.33254,\n",
       "   'lkr': -5.51505,\n",
       "   'ltc': -17.84819,\n",
       "   'mmk': 0.04359,\n",
       "   'mxn': -3.55766,\n",
       "   'myr': -1.77952,\n",
       "   'ngn': 0.09346,\n",
       "   'nok': -3.34775,\n",
       "   'nzd': 0.35491,\n",
       "   'php': 1.86564,\n",
       "   'pkr': -0.42692,\n",
       "   'pln': -4.14938,\n",
       "   'rub': 7.13603,\n",
       "   'sar': 0.33059,\n",
       "   'sek': -1.14644,\n",
       "   'sgd': -0.67198,\n",
       "   'thb': -1.03815,\n",
       "   'try': 2.35533,\n",
       "   'twd': 0.34841,\n",
       "   'uah': 0.53894,\n",
       "   'usd': 0.49638,\n",
       "   'vef': 0.49638,\n",
       "   'vnd': -0.08577,\n",
       "   'xag': -13.9046,\n",
       "   'xau': -3.65186,\n",
       "   'xdr': -1.77979,\n",
       "   'xlm': -19.58752,\n",
       "   'xrp': -28.73501,\n",
       "   'yfi': -8.18561,\n",
       "   'zar': -1.49877,\n",
       "   'bits': -16.49911,\n",
       "   'link': -15.62168,\n",
       "   'sats': -16.49911},\n",
       "  'price_change_percentage_60d_in_currency': {'aed': 6.47413,\n",
       "   'ars': 18.19009,\n",
       "   'aud': 10.94533,\n",
       "   'bch': 1.12404,\n",
       "   'bdt': 5.35044,\n",
       "   'bhd': 6.05595,\n",
       "   'bmd': 6.49466,\n",
       "   'bnb': -6.91488,\n",
       "   'brl': 0.6929,\n",
       "   'btc': -21.78016,\n",
       "   'cad': 7.94027,\n",
       "   'chf': 3.16524,\n",
       "   'clp': 7.06829,\n",
       "   'cny': 7.19038,\n",
       "   'czk': 2.32303,\n",
       "   'dkk': 3.95882,\n",
       "   'dot': -1.32041,\n",
       "   'eos': -9.96445,\n",
       "   'eth': -20.63284,\n",
       "   'eur': 2.96611,\n",
       "   'gbp': 4.3491,\n",
       "   'hkd': 6.50415,\n",
       "   'huf': 2.84561,\n",
       "   'idr': 3.66027,\n",
       "   'ils': 10.18639,\n",
       "   'inr': 5.1781,\n",
       "   'jpy': 7.07699,\n",
       "   'krw': 9.15032,\n",
       "   'kwd': 5.97307,\n",
       "   'lkr': -6.1267,\n",
       "   'ltc': 4.66459,\n",
       "   'mmk': 6.07566,\n",
       "   'mxn': 3.6265,\n",
       "   'myr': 7.80487,\n",
       "   'ngn': 5.98863,\n",
       "   'nok': 8.6166,\n",
       "   'nzd': 8.59686,\n",
       "   'php': 7.25815,\n",
       "   'pkr': 11.43338,\n",
       "   'pln': 1.05285,\n",
       "   'rub': 18.02547,\n",
       "   'sar': 6.45424,\n",
       "   'sek': 6.16684,\n",
       "   'sgd': 6.64696,\n",
       "   'thb': 6.5497,\n",
       "   'try': 9.38242,\n",
       "   'twd': 7.33911,\n",
       "   'uah': 6.61258,\n",
       "   'usd': 6.49466,\n",
       "   'vef': 6.49466,\n",
       "   'vnd': 5.72801,\n",
       "   'xag': -8.31716,\n",
       "   'xau': -1.46662,\n",
       "   'xdr': 4.92139,\n",
       "   'xlm': -14.0431,\n",
       "   'xrp': -21.3646,\n",
       "   'yfi': -17.16185,\n",
       "   'zar': 7.25273,\n",
       "   'bits': -21.78016,\n",
       "   'link': -9.10301,\n",
       "   'sats': -21.78016},\n",
       "  'price_change_percentage_200d_in_currency': {},\n",
       "  'price_change_percentage_1y_in_currency': {},\n",
       "  'market_cap_change_24h_in_currency': {'aed': 0.0,\n",
       "   'ars': 0.0,\n",
       "   'aud': 0.0,\n",
       "   'bch': 0.0,\n",
       "   'bdt': 0.0,\n",
       "   'bhd': 0.0,\n",
       "   'bmd': 0.0,\n",
       "   'bnb': 0.0,\n",
       "   'brl': 0.0,\n",
       "   'btc': 0.0,\n",
       "   'cad': 0.0,\n",
       "   'chf': 0.0,\n",
       "   'clp': 0.0,\n",
       "   'cny': 0.0,\n",
       "   'czk': 0.0,\n",
       "   'dkk': 0.0,\n",
       "   'dot': 0.0,\n",
       "   'eos': 0.0,\n",
       "   'eth': 0.0,\n",
       "   'eur': 0.0,\n",
       "   'gbp': 0.0,\n",
       "   'hkd': 0.0,\n",
       "   'huf': 0.0,\n",
       "   'idr': 0.0,\n",
       "   'ils': 0.0,\n",
       "   'inr': 0.0,\n",
       "   'jpy': 0.0,\n",
       "   'krw': 0.0,\n",
       "   'kwd': 0.0,\n",
       "   'lkr': 0.0,\n",
       "   'ltc': 0.0,\n",
       "   'mmk': 0.0,\n",
       "   'mxn': 0.0,\n",
       "   'myr': 0.0,\n",
       "   'ngn': 0.0,\n",
       "   'nok': 0.0,\n",
       "   'nzd': 0.0,\n",
       "   'php': 0.0,\n",
       "   'pkr': 0.0,\n",
       "   'pln': 0.0,\n",
       "   'rub': 0.0,\n",
       "   'sar': 0.0,\n",
       "   'sek': 0.0,\n",
       "   'sgd': 0.0,\n",
       "   'thb': 0.0,\n",
       "   'try': 0.0,\n",
       "   'twd': 0.0,\n",
       "   'uah': 0.0,\n",
       "   'usd': 0.0,\n",
       "   'vef': 0.0,\n",
       "   'vnd': 0.0,\n",
       "   'xag': 0.0,\n",
       "   'xau': 0.0,\n",
       "   'xdr': 0.0,\n",
       "   'xlm': 0.0,\n",
       "   'xrp': 0.0,\n",
       "   'yfi': 0.0,\n",
       "   'zar': 0.0,\n",
       "   'bits': 0.0,\n",
       "   'link': 0.0,\n",
       "   'sats': 0.0},\n",
       "  'market_cap_change_percentage_24h_in_currency': {'aed': 0.0,\n",
       "   'ars': 0.0,\n",
       "   'aud': 0.0,\n",
       "   'bch': 0.0,\n",
       "   'bdt': 0.0,\n",
       "   'bhd': 0.0,\n",
       "   'bmd': 0.0,\n",
       "   'bnb': 0.0,\n",
       "   'brl': 0.0,\n",
       "   'btc': 0.0,\n",
       "   'cad': 0.0,\n",
       "   'chf': 0.0,\n",
       "   'clp': 0.0,\n",
       "   'cny': 0.0,\n",
       "   'czk': 0.0,\n",
       "   'dkk': 0.0,\n",
       "   'dot': 0.0,\n",
       "   'eos': 0.0,\n",
       "   'eth': 0.0,\n",
       "   'eur': 0.0,\n",
       "   'gbp': 0.0,\n",
       "   'hkd': 0.0,\n",
       "   'huf': 0.0,\n",
       "   'idr': 0.0,\n",
       "   'ils': 0.0,\n",
       "   'inr': 0.0,\n",
       "   'jpy': 0.0,\n",
       "   'krw': 0.0,\n",
       "   'kwd': 0.0,\n",
       "   'lkr': 0.0,\n",
       "   'ltc': 0.0,\n",
       "   'mmk': 0.0,\n",
       "   'mxn': 0.0,\n",
       "   'myr': 0.0,\n",
       "   'ngn': 0.0,\n",
       "   'nok': 0.0,\n",
       "   'nzd': 0.0,\n",
       "   'php': 0.0,\n",
       "   'pkr': 0.0,\n",
       "   'pln': 0.0,\n",
       "   'rub': 0.0,\n",
       "   'sar': 0.0,\n",
       "   'sek': 0.0,\n",
       "   'sgd': 0.0,\n",
       "   'thb': 0.0,\n",
       "   'try': 0.0,\n",
       "   'twd': 0.0,\n",
       "   'uah': 0.0,\n",
       "   'usd': 0.0,\n",
       "   'vef': 0.0,\n",
       "   'vnd': 0.0,\n",
       "   'xag': 0.0,\n",
       "   'xau': 0.0,\n",
       "   'xdr': 0.0,\n",
       "   'xlm': 0.0,\n",
       "   'xrp': 0.0,\n",
       "   'yfi': 0.0,\n",
       "   'zar': 0.0,\n",
       "   'bits': 0.0,\n",
       "   'link': 0.0,\n",
       "   'sats': 0.0},\n",
       "  'total_supply': 1000000000.0,\n",
       "  'max_supply': 1000000000.0,\n",
       "  'circulating_supply': 0.0,\n",
       "  'last_updated': '2023-04-16T12:47:39.587Z'},\n",
       " 'community_data': {'facebook_likes': None,\n",
       "  'twitter_followers': 0,\n",
       "  'reddit_average_posts_48h': 0.0,\n",
       "  'reddit_average_comments_48h': 0.0,\n",
       "  'reddit_subscribers': 0,\n",
       "  'reddit_accounts_active_48h': 0,\n",
       "  'telegram_channel_user_count': 11023},\n",
       " 'developer_data': {'forks': 0,\n",
       "  'stars': 0,\n",
       "  'subscribers': 0,\n",
       "  'total_issues': 0,\n",
       "  'closed_issues': 0,\n",
       "  'pull_requests_merged': 0,\n",
       "  'pull_request_contributors': 0,\n",
       "  'code_additions_deletions_4_weeks': {'additions': None, 'deletions': None},\n",
       "  'commit_count_4_weeks': 0,\n",
       "  'last_4_weeks_commit_activity_series': []},\n",
       " 'public_interest_stats': {'alexa_rank': None, 'bing_matches': None},\n",
       " 'status_updates': [],\n",
       " 'last_updated': '2023-04-16T12:47:39.587Z',\n",
       " 'tickers': [{'base': '0X27DCC73CBBBE57D006303316DD3E91A0D5D58EEA',\n",
       "   'target': 'WBNB',\n",
       "   'market': {'name': 'PancakeSwap (v2)',\n",
       "    'identifier': 'pancakeswap_new',\n",
       "    'has_trading_incentive': False},\n",
       "   'last': 2.69719208788831e-07,\n",
       "   'volume': 62965.1676073314,\n",
       "   'converted_last': {'btc': 3.02e-09, 'eth': 4.3707e-08, 'usd': 9.142e-05},\n",
       "   'converted_volume': {'btc': 0.00019018, 'eth': 0.00275205, 'usd': 5.76},\n",
       "   'trust_score': 'yellow',\n",
       "   'bid_ask_spread_percentage': 0.605959,\n",
       "   'timestamp': '2023-04-16T10:50:56+00:00',\n",
       "   'last_traded_at': '2023-04-16T10:50:56+00:00',\n",
       "   'last_fetch_at': '2023-04-16T12:47:39+00:00',\n",
       "   'is_anomaly': False,\n",
       "   'is_stale': False,\n",
       "   'trade_url': 'https://pancakeswap.finance/swap?inputCurrency=0x27dcc73cbbbe57d006303316dd3e91a0d5d58eea&outputCurrency=0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c',\n",
       "   'token_info_url': None,\n",
       "   'coin_id': 'shiba-world-cup',\n",
       "   'target_coin_id': 'wbnb'}]}"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cg.get_coin_by_id('shiba-world-cup')\n",
    "\n",
    "# Looks there is a lot of cool features around a single coin\n",
    "# Many attributes possibly usefull for some machine learning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "955c6fc7-df69-4d0c-a093-7f23c4a05bf0",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'coins': [{'item': {'id': 'arbitrum',\n",
       "    'coin_id': 16547,\n",
       "    'name': 'Arbitrum',\n",
       "    'symbol': 'ARB',\n",
       "    'market_cap_rank': 34,\n",
       "    'thumb': 'https://assets.coingecko.com/coins/images/16547/thumb/photo_2023-03-29_21.47.00.jpeg?1680097630',\n",
       "    'small': 'https://assets.coingecko.com/coins/images/16547/small/photo_2023-03-29_21.47.00.jpeg?1680097630',\n",
       "    'large': 'https://assets.coingecko.com/coins/images/16547/large/photo_2023-03-29_21.47.00.jpeg?1680097630',\n",
       "    'slug': 'arbitrum',\n",
       "    'price_btc': 5.325666542074022e-05,\n",
       "    'score': 0}},\n",
       "  {'item': {'id': 'chromaway',\n",
       "    'coin_id': 5000,\n",
       "    'name': 'Chromia',\n",
       "    'symbol': 'CHR',\n",
       "    'market_cap_rank': 299,\n",
       "    'thumb': 'https://assets.coingecko.com/coins/images/5000/thumb/Chromia.png?1559038018',\n",
       "    'small': 'https://assets.coingecko.com/coins/images/5000/small/Chromia.png?1559038018',\n",
       "    'large': 'https://assets.coingecko.com/coins/images/5000/large/Chromia.png?1559038018',\n",
       "    'slug': 'chromia',\n",
       "    'price_btc': 6.143152115423967e-06,\n",
       "    'score': 1}},\n",
       "  {'item': {'id': 'baby-doge-coin',\n",
       "    'coin_id': 16125,\n",
       "    'name': 'Baby Doge Coin',\n",
       "    'symbol': 'BABYDOGE',\n",
       "    'market_cap_rank': 93,\n",
       "    'thumb': 'https://assets.coingecko.com/coins/images/16125/thumb/babydoge.jpg?1676303229',\n",
       "    'small': 'https://assets.coingecko.com/coins/images/16125/small/babydoge.jpg?1676303229',\n",
       "    'large': 'https://assets.coingecko.com/coins/images/16125/large/babydoge.jpg?1676303229',\n",
       "    'slug': 'baby-doge-coin',\n",
       "    'price_btc': 1.1733316574112777e-13,\n",
       "    'score': 2}},\n",
       "  {'item': {'id': 'tominet',\n",
       "    'coin_id': 28730,\n",
       "    'name': 'tomiNet',\n",
       "    'symbol': 'TOMI',\n",
       "    'market_cap_rank': 258,\n",
       "    'thumb': 'https://assets.coingecko.com/coins/images/28730/thumb/logo_for_token.png?1673690005',\n",
       "    'small': 'https://assets.coingecko.com/coins/images/28730/small/logo_for_token.png?1673690005',\n",
       "    'large': 'https://assets.coingecko.com/coins/images/28730/large/logo_for_token.png?1673690005',\n",
       "    'slug': 'tominet',\n",
       "    'price_btc': 8.28019302900119e-05,\n",
       "    'score': 3}},\n",
       "  {'item': {'id': 'space-id',\n",
       "    'coin_id': 29468,\n",
       "    'name': 'SPACE ID',\n",
       "    'symbol': 'ID',\n",
       "    'market_cap_rank': 171,\n",
       "    'thumb': 'https://assets.coingecko.com/coins/images/29468/thumb/sid_token_logo_%28green2%29.png?1679454702',\n",
       "    'small': 'https://assets.coingecko.com/coins/images/29468/small/sid_token_logo_%28green2%29.png?1679454702',\n",
       "    'large': 'https://assets.coingecko.com/coins/images/29468/large/sid_token_logo_%28green2%29.png?1679454702',\n",
       "    'slug': 'space-id',\n",
       "    'price_btc': 2.9124396052870205e-05,\n",
       "    'score': 4}},\n",
       "  {'item': {'id': 'xen-crypto',\n",
       "    'coin_id': 27713,\n",
       "    'name': 'XEN Crypto',\n",
       "    'symbol': 'XEN',\n",
       "    'market_cap_rank': 486,\n",
       "    'thumb': 'https://assets.coingecko.com/coins/images/27713/thumb/Xen.jpeg?1665453190',\n",
       "    'small': 'https://assets.coingecko.com/coins/images/27713/small/Xen.jpeg?1665453190',\n",
       "    'large': 'https://assets.coingecko.com/coins/images/27713/large/Xen.jpeg?1665453190',\n",
       "    'slug': 'xen-crypto',\n",
       "    'price_btc': 1.7496401273742097e-10,\n",
       "    'score': 5}},\n",
       "  {'item': {'id': 'optimus-ai',\n",
       "    'coin_id': 29328,\n",
       "    'name': 'Optimus AI',\n",
       "    'symbol': 'OPTI',\n",
       "    'market_cap_rank': 526,\n",
       "    'thumb': 'https://assets.coingecko.com/coins/images/29328/thumb/Optimus_AI_Logo.png?1678170818',\n",
       "    'small': 'https://assets.coingecko.com/coins/images/29328/small/Optimus_AI_Logo.png?1678170818',\n",
       "    'large': 'https://assets.coingecko.com/coins/images/29328/large/Optimus_AI_Logo.png?1678170818',\n",
       "    'slug': 'optimus-ai',\n",
       "    'price_btc': 1.6055961137022917e-05,\n",
       "    'score': 6}}],\n",
       " 'exchanges': []}"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cg.get_search_trending()\n",
    "\n",
    "# unfortuanetly no historical data for this"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "33800570-fe3c-454e-a062-74424d234efe",
   "metadata": {},
   "source": [
    "### Query API for historical prices"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d2056a4b-30cb-46b5-931d-f38c67120008",
   "metadata": {},
   "source": [
    "#### Test single execution"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "8230b3fb-06a7-48c9-8e9f-1b99d2f7280f",
   "metadata": {},
   "outputs": [],
   "source": [
    "btc_prices = cg.get_coin_market_chart_range_by_id(id='bitcoin', \n",
    "                                                  vs_currency='usd', \n",
    "                                                  from_timestamp='1661990400', \n",
    "                                                  to_timestamp='1664582399')  # from September 1, 2022 to September 30, 2022"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "67130035-c877-4255-b4b2-75f9eb49b109",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['prices', 'market_caps', 'total_volumes'])"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "btc_prices.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "b39aeb79-ab0c-489d-8646-6f62ba57b569",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "722"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(btc_prices['prices'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "e10aef0c-9f83-4a9a-86e7-2ea79c6eb796",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'A single day has 24 price entries on average'"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f'A single day has {int(722/30)} price entries on average'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "3f63429c-63ab-4d52-87c3-5550a3bdd739",
   "metadata": {},
   "outputs": [],
   "source": [
    "btc_coin_ohlc = cg.get_coin_ohlc_by_id(id='bitcoin',\n",
    "                                       vs_currency='usd',\n",
    "                                       days=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "b9747832-0d20-4a0c-826a-de8a0f3e33a0",
   "metadata": {},
   "outputs": [
    {
     "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1682168400000</td>\n",
       "      <td>27335.45</td>\n",
       "      <td>27364.24</td>\n",
       "      <td>27335.45</td>\n",
       "      <td>27364.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1682170200000</td>\n",
       "      <td>27370.72</td>\n",
       "      <td>27378.83</td>\n",
       "      <td>27346.68</td>\n",
       "      <td>27346.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1682172000000</td>\n",
       "      <td>27317.43</td>\n",
       "      <td>27337.31</td>\n",
       "      <td>27277.85</td>\n",
       "      <td>27277.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1682173800000</td>\n",
       "      <td>27276.35</td>\n",
       "      <td>27298.31</td>\n",
       "      <td>27268.28</td>\n",
       "      <td>27298.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1682175600000</td>\n",
       "      <td>27363.04</td>\n",
       "      <td>27423.62</td>\n",
       "      <td>27323.74</td>\n",
       "      <td>27423.62</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Time      Open      High       Low     Close\n",
       "0  1682168400000  27335.45  27364.24  27335.45  27364.24\n",
       "1  1682170200000  27370.72  27378.83  27346.68  27346.68\n",
       "2  1682172000000  27317.43  27337.31  27277.85  27277.85\n",
       "3  1682173800000  27276.35  27298.31  27268.28  27298.31\n",
       "4  1682175600000  27363.04  27423.62  27323.74  27423.62"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "coin_ohlc_df = pd.DataFrame(\n",
    "    btc_coin_ohlc, columns = ['Time', 'Open', 'High', 'Low', 'Close'])\n",
    "coin_ohlc_df.head() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "b9040909-dfb5-4291-baac-06b5a4862e1e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'A single day holds 48 entries'"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f'A single day holds {len(coin_ohlc_df)} entries'"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7a9a45e7-9eb0-4eab-af85-868f07d02ac6",
   "metadata": {},
   "source": [
    "#### Date ranges"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "2073c506-a587-4c83-b1e4-01f83b3237da",
   "metadata": {},
   "outputs": [],
   "source": [
    "from_date = '2020-03-01'  # let's discard stuff pre-COVID\n",
    "to_date = '2023-04-15'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "9f0cbd61-044b-435b-96c7-1d2721afe809",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1583017200.0"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from_date_timestamp = time.mktime(datetime.datetime.strptime(from_date, \"%Y-%m-%d\").timetuple())\n",
    "from_date_timestamp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "ba57c5a6-e2c9-4865-b3f4-fe0972b161dd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1681509600.0"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "to_date_timestamp = time.mktime(datetime.datetime.strptime(to_date, \"%Y-%m-%d\").timetuple())\n",
    "to_date_timestamp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "15acd03b-5c1e-4f5f-aacb-90ee9fc46c31",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Initialize an empty dictionary to store the historical data for each coin\n",
    "# coin_data = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "fad03330-428f-4cc6-be03-d724e177ee0d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# coin_features = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "88d90566-48b0-401e-94e3-8c280968caf2",
   "metadata": {},
   "outputs": [],
   "source": [
    "# for coin in tqdm(all_coins_list):\n",
    "#     coin_id = coin['id']\n",
    "#     coin_history = cg.get_coin_market_chart_range_by_id(id=coin_id, \n",
    "#                                                         vs_currency='usd', \n",
    "#                                                         from_timestamp=from_date_timestamp, \n",
    "#                                                         to_timestamp=to_date_timestamp)\n",
    "    \n",
    "#     coin_data[coin_id] = coin_history\n",
    "#     coin_details = cg.get_coin_by_id(coin_id)\n",
    "    \n",
    "#     coin_features[coin_id] = coin_details"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "1adefa1e-58c8-4215-92df-d39d8c745870",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "# coin_features['1inch']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "63810dae-f9b6-473f-af69-a1678ce2c0b8",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Takes lof of time to compute, let's switch to something smarter!"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d8fe8cee-ad59-4310-a29d-6b867606a8b8",
   "metadata": {},
   "source": [
    "### Async query for prices"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "c506df9c-2d99-4f9b-8e25-561cd94d7744",
   "metadata": {},
   "outputs": [],
   "source": [
    "btc_defi_df = dft.geckoHistorical('bitcoin')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "84e42582-cfca-448d-9f2c-2c0f21f8d29b",
   "metadata": {},
   "outputs": [
    {
     "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>price</th>\n",
       "      <th>market_caps</th>\n",
       "      <th>total_volumes</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2013-04-28 00:00:00</th>\n",
       "      <td>135.300000</td>\n",
       "      <td>1.500518e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-04-29 00:00:00</th>\n",
       "      <td>141.960000</td>\n",
       "      <td>1.575032e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-04-30 00:00:00</th>\n",
       "      <td>135.300000</td>\n",
       "      <td>1.501657e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-05-01 00:00:00</th>\n",
       "      <td>117.000000</td>\n",
       "      <td>1.298952e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-05-02 00:00:00</th>\n",
       "      <td>103.430000</td>\n",
       "      <td>1.148668e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-20 00:00:00</th>\n",
       "      <td>28833.217501</td>\n",
       "      <td>5.587965e+11</td>\n",
       "      <td>2.413662e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-21 00:00:00</th>\n",
       "      <td>28255.578249</td>\n",
       "      <td>5.461411e+11</td>\n",
       "      <td>2.169590e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-22 00:00:00</th>\n",
       "      <td>27300.157129</td>\n",
       "      <td>5.283573e+11</td>\n",
       "      <td>2.042033e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-23 00:00:00</th>\n",
       "      <td>27861.640663</td>\n",
       "      <td>5.394547e+11</td>\n",
       "      <td>1.170023e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-23 06:29:37</th>\n",
       "      <td>27645.655927</td>\n",
       "      <td>5.349183e+11</td>\n",
       "      <td>1.165117e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3647 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            price   market_caps  total_volumes\n",
       "date                                                          \n",
       "2013-04-28 00:00:00    135.300000  1.500518e+09   0.000000e+00\n",
       "2013-04-29 00:00:00    141.960000  1.575032e+09   0.000000e+00\n",
       "2013-04-30 00:00:00    135.300000  1.501657e+09   0.000000e+00\n",
       "2013-05-01 00:00:00    117.000000  1.298952e+09   0.000000e+00\n",
       "2013-05-02 00:00:00    103.430000  1.148668e+09   0.000000e+00\n",
       "...                           ...           ...            ...\n",
       "2023-04-20 00:00:00  28833.217501  5.587965e+11   2.413662e+10\n",
       "2023-04-21 00:00:00  28255.578249  5.461411e+11   2.169590e+10\n",
       "2023-04-22 00:00:00  27300.157129  5.283573e+11   2.042033e+10\n",
       "2023-04-23 00:00:00  27861.640663  5.394547e+11   1.170023e+10\n",
       "2023-04-23 06:29:37  27645.655927  5.349183e+11   1.165117e+10\n",
       "\n",
       "[3647 rows x 3 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "btc_defi_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e55980f4-b237-4cd9-8188-3905c391bc9d",
   "metadata": {},
   "source": [
    "### Store the results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0f17d12d-57c2-4886-9161-b1fee6af1471",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}