{"id":46630,"date":"2021-02-05T00:00:00","date_gmt":"2021-02-05T08:00:00","guid":{"rendered":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/blog\/collect-cryptomarket-data-with-griddb\/"},"modified":"2025-11-13T12:55:10","modified_gmt":"2025-11-13T20:55:10","slug":"collect-cryptomarket-data-with-griddb","status":"publish","type":"post","link":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/","title":{"rendered":"Collect Cryptomarket Data with GridDB"},"content":{"rendered":"<h2>Collecting historical data from the cryptomarket, using Coingecko API and GridDB.<\/h2>\n<p>Cryptocurrencies have captured the world&#8217;s attention since the price of the main ones such as Bitcoin has reached record prices. Unlike traditional financial markets, the foundation of cryptocurrencies is in an open ledger, called Blockchain, which works thanks to a network of miners that validate transactions and secure them using cryptographic techniques.<\/p>\n<p>The analysis of financial markets is pertinent since it allows us to understand how it works to make predictions, obtain a better understanding of it, or even as a prerequisite to making investments with a piece of broader and more accurate knowledge.<\/p>\n<p>In particular, the decentralized way of working, the high volatility, and the growing interest in the short and medium-term behavior of cryptocurrencies, motivates us to look for reliable and fast analysis tools to be able to make analyses and predictions in this dynamic market.<\/p>\n<p>In this article, we want to use the features of <a href=\"https:\/\/griddb.net\/en\/\">GridDB<\/a> to store the historical data of the Bitcoin price movements. For this, we will connect to the <a href=\"https:\/\/www.coingecko.com\/en\">Coingecko API<\/a>.<\/p>\n<p>We will also develop a Python script to automate obtaining the information from the API and storing it in our GridDB.<\/p>\n<h3>What technologies we will be using?<\/h3>\n<p>We will build our tool on top of the following:<\/p>\n<ul>\n<li>OS: Ubuntu 18.04<\/li>\n<li>Python 3.6!<\/li>\n<li>GridDB server: last version available v4.5.2<\/li>\n<li>GridDB c client: v4.5.0<\/li>\n<li>GridDB Python client: 0.8.3<\/li>\n<\/ul>\n<h3>Setting up the environment.<\/h3>\n<p>Our environment preparation starts with Python 3.6 over an Ubuntu 18.04 Operating System. Then we will need GridDB both as a server and the client.<\/p>\n<p>Following the instructions from the official repository, first, we downloaded the .deb package from the official release <a href=\"https:\/\/github.com\/griddb\/griddb\/releases\/download\/v4.5.2\/griddb_4.5.2_amd64.deb\">link<\/a> and installed with the command<\/p>\n<p>Getting the package:<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-bash\">wget https:\/\/github.com\/griddb\/griddb\/releases\/download\/v4.5.2\/griddb_4.5.2_amd64.deb\n<\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/wget-c-cient.png\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/wget-c-cient.png\" alt=\"\" width=\"1337\" height=\"344\" class=\"aligncenter size-full wp-image-27258\" srcset=\"\/wp-content\/uploads\/2021\/01\/wget-c-cient.png 1337w, \/wp-content\/uploads\/2021\/01\/wget-c-cient-300x77.png 300w, \/wp-content\/uploads\/2021\/01\/wget-c-cient-1024x263.png 1024w, \/wp-content\/uploads\/2021\/01\/wget-c-cient-768x198.png 768w, \/wp-content\/uploads\/2021\/01\/wget-c-cient-600x154.png 600w\" sizes=\"(max-width: 1337px) 100vw, 1337px\" \/><\/a><\/p>\n<p>And install it as usual.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-bash\">sudo apt install .\/griddb_4.5.2_amd64.deb\n<\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/install-griddb-server.png\"><img decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/install-griddb-server.png\" alt=\"\" width=\"696\" height=\"475\" class=\"aligncenter size-full wp-image-27255\" srcset=\"\/wp-content\/uploads\/2021\/01\/install-griddb-server.png 696w, \/wp-content\/uploads\/2021\/01\/install-griddb-server-300x205.png 300w, \/wp-content\/uploads\/2021\/01\/install-griddb-server-600x409.png 600w\" sizes=\"(max-width: 696px) 100vw, 696px\" \/><\/a><\/p>\n<p>It is important to define the environment variables for Grid. Also, we must log in as gsadm user, to define a password for the admin user and start a node.<\/p>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/env-var-and-gsadmUser.png\"><img decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/env-var-and-gsadmUser.png\" alt=\"\" width=\"555\" height=\"127\" class=\"aligncenter size-full wp-image-27252\" srcset=\"\/wp-content\/uploads\/2021\/01\/env-var-and-gsadmUser.png 555w, \/wp-content\/uploads\/2021\/01\/env-var-and-gsadmUser-300x69.png 300w\" sizes=\"(max-width: 555px) 100vw, 555px\" \/><\/a><\/p>\n<p>The next step is to download and install the <a href=\"https:\/\/software.opensuse.org\/download\/package?project=home:knonomura&amp;package=griddb-c-client\">GridDB c-client<\/a>.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-bash\">wget https:\/\/download.opensuse.org\/repositories\/home:\/knonomura\/xUbuntu_18.04\/amd64\/griddb-c-client_4.5.0_amd64.deb\n<\/code><\/pre>\n<\/div>\n<div class=\"clipboard\">\n<pre><code class=\"language-bash\">sudo apt install .\/griddb-c-client_4.5.0_amd64.deb\n<\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/install-c-client.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/install-c-client.png\" alt=\"\" width=\"786\" height=\"391\" class=\"aligncenter size-full wp-image-27254\" srcset=\"\/wp-content\/uploads\/2021\/01\/install-c-client.png 786w, \/wp-content\/uploads\/2021\/01\/install-c-client-300x149.png 300w, \/wp-content\/uploads\/2021\/01\/install-c-client-768x382.png 768w, \/wp-content\/uploads\/2021\/01\/install-c-client-600x298.png 600w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/a><\/p>\n<p>As a prerequisite for using the GridDB Python client, we need to install Numpy and Pandas. and SWIG.<\/p>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/install-numpy-pandas.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/install-numpy-pandas.png\" alt=\"\" width=\"1173\" height=\"388\" class=\"aligncenter size-full wp-image-27256\" srcset=\"\/wp-content\/uploads\/2021\/01\/install-numpy-pandas.png 1173w, \/wp-content\/uploads\/2021\/01\/install-numpy-pandas-300x99.png 300w, \/wp-content\/uploads\/2021\/01\/install-numpy-pandas-1024x339.png 1024w, \/wp-content\/uploads\/2021\/01\/install-numpy-pandas-768x254.png 768w, \/wp-content\/uploads\/2021\/01\/install-numpy-pandas-1170x388.png 1170w, \/wp-content\/uploads\/2021\/01\/install-numpy-pandas-600x198.png 600w\" sizes=\"(max-width: 1173px) 100vw, 1173px\" \/><\/a><\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-bash\">wget https:\/\/prdownloads.sourceforge.net\/swig\/swig-3.0.12.tar.gz\ntar xvfz swig-3.0.12.tar.gz\ncd swig-3.0.12\n.\/configure\nmake\nsudo make install\n<\/code><\/pre>\n<\/div>\n<p>A good advantage now is that the Python client is already available in the <a href=\"https:\/\/pypi.org\/project\/griddb-python\/\">pypi package manager<\/a>, and the installation process on Ubuntu 18.04 can be done simply with pip:<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-bash\">python3.6 -m pip install griddb_python\n<\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/install-python-client-with-pip.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/install-python-client-with-pip.png\" alt=\"\" width=\"723\" height=\"143\" class=\"aligncenter size-full wp-image-27257\" srcset=\"\/wp-content\/uploads\/2021\/01\/install-python-client-with-pip.png 723w, \/wp-content\/uploads\/2021\/01\/install-python-client-with-pip-300x59.png 300w, \/wp-content\/uploads\/2021\/01\/install-python-client-with-pip-600x119.png 600w\" sizes=\"(max-width: 723px) 100vw, 723px\" \/><\/a><\/p>\n<p>We can see how, if we access the Python console, the package griddb_python is properly installed.<\/p>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/importing-griddb-python.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/importing-griddb-python.png\" alt=\"\" width=\"669\" height=\"160\" class=\"aligncenter size-full wp-image-27253\" srcset=\"\/wp-content\/uploads\/2021\/01\/importing-griddb-python.png 669w, \/wp-content\/uploads\/2021\/01\/importing-griddb-python-300x72.png 300w, \/wp-content\/uploads\/2021\/01\/importing-griddb-python-600x143.png 600w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<h3>Getting the data<\/h3>\n<p>There are several options for getting the data that every day is generated in the market of cryptocurrencies. In this case, for illustration purposes, we will focus on the historical data of the main cryptocurrency, Bitcoin.<\/p>\n<p>It is very interesting to study the behavior of the price of Bitcoin, respecting fiat currencies. Bitcoin officially born in 2009, but we currently don&#8217;t have data for the first years, because at the beginning it wasn&#8217;t exchanged publically. There are of course transactions that are stored in the first blocks of the chain, but the price was not controlled by the market.<\/p>\n<p>Let&#8217;s see how we can get these historical data from Coingecko. We can start by installing the Python client:<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-bash\">python3.6 -m pip install pycoingecko\n<\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/github.com\/man-c\/pycoingecko\">Here<\/a> is the repository, with the information about how to use this API.<\/p>\n<p>When writing the script we will import the Coingecko library in this way:<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-python\">from pycoingecko import CoinGeckoAPI\n<\/code><\/pre>\n<\/div>\n<p>Let&#8217;s import Pandas too, so we can manipulate the data as dataframes:<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-python\">import pandas as pd\n<\/code><\/pre>\n<\/div>\n<p>The first thing to do is creating an instance of the Coingecko API<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-python\">coingecko = CoinGeckoAPI()\n<\/code><\/pre>\n<\/div>\n<p>Now, we can define the functions we will use.<\/p>\n<p>First, we can get the market data of a given cryptocurrency using the <code>get_coin_by_id<\/code> API call. This information we will save in a dictionary called <code>cryptocurrency_data<\/code>, which in turn we will convert into a dataframe, so we can have it as a csv file.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-python\">def get_data(cryptocurrency):\n    cryptocurrency_data = coingecko.get_coin_by_id(cryptocurrency, market_data='true', sparkline='true')\n    df = pd.DataFrame.from_dict(cryptocurrency_data, orient='index')\n    df.to_csv(r'cryptocurrency_data.csv')\n    return df\n<\/code><\/pre>\n<\/div>\n<p>For example, we know that <code>'bitcoin'<\/code> is one of the cryptocurrencies available, then the following line will give us the market data available for Bitcoin.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-python\">get_data('bitcoin')\n<\/code><\/pre>\n<\/div>\n<p>And the information we get in the csv looks like this:<\/p>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/bitcoin_info.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/01\/bitcoin_info.png\" alt=\"\" width=\"409\" height=\"415\" class=\"aligncenter size-full wp-image-27251\" srcset=\"\/wp-content\/uploads\/2021\/01\/bitcoin_info.png 409w, \/wp-content\/uploads\/2021\/01\/bitcoin_info-296x300.png 296w\" sizes=\"(max-width: 409px) 100vw, 409px\" \/><\/a><\/p>\n<p>If we want to know what other cryptocurrencies are available, we can define a function to get all the currencies supported by coingecko.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-python\">def get_available_curr():\n    return coingecko.get_supported_vs_currencies()\n<\/code><\/pre>\n<\/div>\n<p>Now, in order to be more specific about our search, we can refine the output defining a function to get the price for a given specific date:<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-python\"># get data about a crypto currency for a specific date\ndef get_price_by_date(cryptocurrency, a_date):\n    data = coingecko.get_coin_history_by_id(coin_id, a_date)\n    price = data['market_data']['current_price']['usd']\n    return price\n<\/code><\/pre>\n<\/div>\n<p>Finally, our goal here is to get the historical data of the Bitcoin&#8217;s price. A function called <code>get_historical_data<\/code> will help us to achieve it.<\/p>\n<p>According to the documentation, the number of days will define how the data is shown. For example, 1 day will present the data divided in minutes, but if we have more than 1 day and less than 90 days, the data will be present in hours. And if we ask for more than 90 days, the data will be shown on a daily basis.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-python\">def get_hsitorical_data(cryptocurrency, fiat_currency, number_of_days):\n    historic_price = coingecko.get_coin_market_chart_by_id(cryptocurrency, fiat_currency, number_of_days)\n    prices = [price[1] for price in historic_price['prices']]\n    return prices\n<\/code><\/pre>\n<\/div>\n<p>The returned variable <code>prices<\/code> is a list. For example, getting the price of the Bitcoin, of th last 5 days in USD, can be obtained with:<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-python\">print(get_hsitorical_data('bitcoin', 'USD', 5))\n<\/code><\/pre>\n<\/div>\n<p>And the output is:<\/p>\n<pre><code>[19259.08030258841, 19193.068890063274, 19206.672769667563, 19118.969144726925, 18965.63616668234, 18960.652709654136, 19050.430880588847, 18990.7793634949, 18844.52437618184, 18873.21199220193, 18734.216704469767, 18753.288921684914, 18818.24732423196, 18813.656564419583, 18481.79300558414, 17959.305407026557, 17814.023726259376, 17901.579048072937, 17672.036464087603, 16767.389103553738, 17016.96216829086, 17134.181554772298, 17289.54296210973, 17106.587656105632, 17331.4762052838, 17006.44771520346, 16823.201432127884, 17010.20985595975, 16721.488013156064, 16761.546965177848, 16637.362422462975, 16842.53065248619, 17195.84403474497, 17105.9312737208, 17075.8100346244, 17138.029512395206, 17393.535276669707, 17248.96543684629, 17195.531466234796, 17073.86409154308, 17192.598651467735, 17229.806019685024, 17232.39613479942, 16926.28405241609, 16870.3011306117, 16760.47144801828, 16841.31525546079, 16821.304443182802, 17061.937579188543, 16858.460475364325, 16797.14755015842, 16638.44643803269, 16779.904684746798, 16807.83803236001, 16820.094022073426, 16808.808218210037, 17055.615405688295, 17008.343058249597, 17054.024622349476, 17097.50909797396, 17160.944233312493, 17081.86851776995, 16991.665437686977, 17027.683600569744, 16987.94930527874, 17010.59041345089, 17041.641919991886, 17035.614023573155, 16922.606314865297, 16933.710467900757, 17200.332760677484, 17167.860885749073, 17123.01185956512, 17361.901621171553, 17404.918158919027, 17497.251070586633, 17667.212140138796, 17749.984303735313, 17698.71548702206, 17806.829994664855, 17732.254867093405, 17716.16974243831, 17767.95578065574, 17704.67191022015, 17637.20942656516, 17581.23011590924, 17743.80422275333, 17827.476832589644, 17777.23209954322, 17797.354567421582, 17728.82850859051, 17826.57123916383, 18135.82259357728, 18083.917418061254, 18165.51914403239, 18095.05067283884, 18050.805289775806, 18060.28166508652, 18036.475224790385, 18031.013344442, 18089.37740068174, 18091.290368854792, 18112.333933562346, 18102.92697464547, 18202.5966538826, 18266.287411393914, 18140.052096296262, 18192.645660559352, 18408.78365577349, 18483.289178463645, 18494.51841080122, 18566.892532959428, 18535.14020869768, 18510.032786248743, 18509.742863375064, 18439.96937840414, 18453.345378206308, 18485.314339104578, 18516.004629775616, 18606.395740319094, 18801.45191322498]\n<\/code><\/pre>\n<h3>Conclusion<\/h3>\n<p>Every day the cryptocurrencies are more attractive to make investments or purely for research purposes. In either case, we will always need cutting-edge technologies to access the data, manipulating it, and extract useful analysis from it.<\/p>\n<p>In this post we have shown how to extract historical data of the Bitcoin price respecting to USD, using the Coingecko API. Also, we&#8217;ve used GridDB and the GridDB Python client to store the data obtained.<\/p>\n<p>Using GridDB has given us a great tool to use this data, now we can make time series analysis or execute predictions, based on the insight we have.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Collecting historical data from the cryptomarket, using Coingecko API and GridDB. Cryptocurrencies have captured the world&#8217;s attention since the price of the main ones such as Bitcoin has reached record prices. Unlike traditional financial markets, the foundation of cryptocurrencies is in an open ledger, called Blockchain, which works thanks to a network of miners that [&hellip;]<\/p>\n","protected":false},"author":41,"featured_media":27266,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[121],"tags":[],"class_list":["post-46630","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Collect Cryptomarket Data with GridDB | GridDB: Open Source Time Series Database for IoT<\/title>\n<meta name=\"description\" content=\"Collecting historical data from the cryptomarket, using Coingecko API and GridDB. Cryptocurrencies have captured the world&#039;s attention since the price of\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Collect Cryptomarket Data with GridDB | GridDB: Open Source Time Series Database for IoT\" \/>\n<meta property=\"og:description\" content=\"Collecting historical data from the cryptomarket, using Coingecko API and GridDB. Cryptocurrencies have captured the world&#039;s attention since the price of\" \/>\n<meta property=\"og:url\" content=\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/\" \/>\n<meta property=\"og:site_name\" content=\"GridDB: Open Source Time Series Database for IoT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/griddbcommunity\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-05T08:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T20:55:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/02\/andre-francois-mckenzie-Q4W8GjjKjuw-unsplash.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"1603\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"griddb-admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@GridDBCommunity\" \/>\n<meta name=\"twitter:site\" content=\"@GridDBCommunity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"griddb-admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/\"},\"author\":{\"name\":\"griddb-admin\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233\"},\"headline\":\"Collect Cryptomarket Data with GridDB\",\"datePublished\":\"2021-02-05T08:00:00+00:00\",\"dateModified\":\"2025-11-13T20:55:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/\"},\"wordCount\":926,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/griddb.net\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2021\/02\/andre-francois-mckenzie-Q4W8GjjKjuw-unsplash.jpg\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/\",\"url\":\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/\",\"name\":\"Collect Cryptomarket Data with GridDB | GridDB: Open Source Time Series Database for IoT\",\"isPartOf\":{\"@id\":\"https:\/\/griddb.net\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2021\/02\/andre-francois-mckenzie-Q4W8GjjKjuw-unsplash.jpg\",\"datePublished\":\"2021-02-05T08:00:00+00:00\",\"dateModified\":\"2025-11-13T20:55:10+00:00\",\"description\":\"Collecting historical data from the cryptomarket, using Coingecko API and GridDB. Cryptocurrencies have captured the world's attention since the price of\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#primaryimage\",\"url\":\"\/wp-content\/uploads\/2021\/02\/andre-francois-mckenzie-Q4W8GjjKjuw-unsplash.jpg\",\"contentUrl\":\"\/wp-content\/uploads\/2021\/02\/andre-francois-mckenzie-Q4W8GjjKjuw-unsplash.jpg\",\"width\":2400,\"height\":1603},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/griddb.net\/en\/#website\",\"url\":\"https:\/\/griddb.net\/en\/\",\"name\":\"GridDB: Open Source Time Series Database for IoT\",\"description\":\"GridDB is an open source time-series database with the performance of NoSQL and convenience of SQL\",\"publisher\":{\"@id\":\"https:\/\/griddb.net\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/griddb.net\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/griddb.net\/en\/#organization\",\"name\":\"Fixstars\",\"url\":\"https:\/\/griddb.net\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png\",\"contentUrl\":\"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png\",\"width\":200,\"height\":83,\"caption\":\"Fixstars\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/griddbcommunity\/\",\"https:\/\/x.com\/GridDBCommunity\",\"https:\/\/www.linkedin.com\/company\/griddb-by-toshiba\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233\",\"name\":\"griddb-admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bceca1cafc06886a7ba873e2f0a28011a1176c4dea59709f735b63ae30d0342?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bceca1cafc06886a7ba873e2f0a28011a1176c4dea59709f735b63ae30d0342?s=96&d=mm&r=g\",\"caption\":\"griddb-admin\"},\"url\":\"https:\/\/griddb.net\/en\/author\/griddb-admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Collect Cryptomarket Data with GridDB | GridDB: Open Source Time Series Database for IoT","description":"Collecting historical data from the cryptomarket, using Coingecko API and GridDB. Cryptocurrencies have captured the world's attention since the price of","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/","og_locale":"en_US","og_type":"article","og_title":"Collect Cryptomarket Data with GridDB | GridDB: Open Source Time Series Database for IoT","og_description":"Collecting historical data from the cryptomarket, using Coingecko API and GridDB. Cryptocurrencies have captured the world's attention since the price of","og_url":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/","og_site_name":"GridDB: Open Source Time Series Database for IoT","article_publisher":"https:\/\/www.facebook.com\/griddbcommunity\/","article_published_time":"2021-02-05T08:00:00+00:00","article_modified_time":"2025-11-13T20:55:10+00:00","og_image":[{"width":2400,"height":1603,"url":"https:\/\/griddb.net\/wp-content\/uploads\/2021\/02\/andre-francois-mckenzie-Q4W8GjjKjuw-unsplash.jpg","type":"image\/jpeg"}],"author":"griddb-admin","twitter_card":"summary_large_image","twitter_creator":"@GridDBCommunity","twitter_site":"@GridDBCommunity","twitter_misc":{"Written by":"griddb-admin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#article","isPartOf":{"@id":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/"},"author":{"name":"griddb-admin","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233"},"headline":"Collect Cryptomarket Data with GridDB","datePublished":"2021-02-05T08:00:00+00:00","dateModified":"2025-11-13T20:55:10+00:00","mainEntityOfPage":{"@id":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/"},"wordCount":926,"commentCount":0,"publisher":{"@id":"https:\/\/griddb.net\/en\/#organization"},"image":{"@id":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2021\/02\/andre-francois-mckenzie-Q4W8GjjKjuw-unsplash.jpg","articleSection":["Blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/","url":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/","name":"Collect Cryptomarket Data with GridDB | GridDB: Open Source Time Series Database for IoT","isPartOf":{"@id":"https:\/\/griddb.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#primaryimage"},"image":{"@id":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2021\/02\/andre-francois-mckenzie-Q4W8GjjKjuw-unsplash.jpg","datePublished":"2021-02-05T08:00:00+00:00","dateModified":"2025-11-13T20:55:10+00:00","description":"Collecting historical data from the cryptomarket, using Coingecko API and GridDB. Cryptocurrencies have captured the world's attention since the price of","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/griddb.net\/en\/blog\/collect-cryptomarket-data-with-griddb\/#primaryimage","url":"\/wp-content\/uploads\/2021\/02\/andre-francois-mckenzie-Q4W8GjjKjuw-unsplash.jpg","contentUrl":"\/wp-content\/uploads\/2021\/02\/andre-francois-mckenzie-Q4W8GjjKjuw-unsplash.jpg","width":2400,"height":1603},{"@type":"WebSite","@id":"https:\/\/griddb.net\/en\/#website","url":"https:\/\/griddb.net\/en\/","name":"GridDB: Open Source Time Series Database for IoT","description":"GridDB is an open source time-series database with the performance of NoSQL and convenience of SQL","publisher":{"@id":"https:\/\/griddb.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/griddb.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/griddb.net\/en\/#organization","name":"Fixstars","url":"https:\/\/griddb.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png","contentUrl":"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png","width":200,"height":83,"caption":"Fixstars"},"image":{"@id":"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/griddbcommunity\/","https:\/\/x.com\/GridDBCommunity","https:\/\/www.linkedin.com\/company\/griddb-by-toshiba"]},{"@type":"Person","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233","name":"griddb-admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5bceca1cafc06886a7ba873e2f0a28011a1176c4dea59709f735b63ae30d0342?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bceca1cafc06886a7ba873e2f0a28011a1176c4dea59709f735b63ae30d0342?s=96&d=mm&r=g","caption":"griddb-admin"},"url":"https:\/\/griddb.net\/en\/author\/griddb-admin\/"}]}},"_links":{"self":[{"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/posts\/46630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/comments?post=46630"}],"version-history":[{"count":1,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/posts\/46630\/revisions"}],"predecessor-version":[{"id":51306,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/posts\/46630\/revisions\/51306"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/media\/27266"}],"wp:attachment":[{"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/media?parent=46630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/categories?post=46630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/tags?post=46630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}