{"id":46644,"date":"2021-05-21T00:00:00","date_gmt":"2021-05-21T07:00:00","guid":{"rendered":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/blog\/parsing-api-data-to-griddb-using-binance-api\/"},"modified":"2025-11-13T12:55:20","modified_gmt":"2025-11-13T20:55:20","slug":"parsing-api-data-to-griddb-using-binance-api","status":"publish","type":"post","link":"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/","title":{"rendered":"Parsing API Data to GridDB using Binance API"},"content":{"rendered":"<p>Cryptocurrency has become a dominant force in the financial sector, offering a decentralized digital currency based on blockchain technology. When it comes to trading these cryptocurrencies, we need a cryptocurrency exchange. Binance is one of the largest cryptocurrency exchanges in the world, providing users with a secure and efficient way to trade cryptocurrencies.<\/p>\n<p>In this article, let&#8217;s look at how to use the Binance API to query information about various cryptocurrencies and parse the data into a GridDB database.<\/p>\n<h2>Collecting Data from Binance<\/h2>\n<p>The first step would be to collect data from Binance. So we will be using the Binance API to connect and retrieve market information about cryptocurrencies. In this section, we will cover how to create an API key and retrieve data via the Binance API.<\/p>\n<h3>Creating the Binance API Key<\/h3>\n<p>Any user with a Binance account can create an API key to utilize the Binance API. Navigate to account settings, then API Management, and create a new API Key in your Binance account. The user will have to provide a name for the API key and authenticate to generate an API key successfully.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/i9LfX_3X_6-PJjXspCkiTO8SE4sCDW5Bc5fXwkGqoQqy2QAg-7gBackI6izOVcFXnUOd1yWX_xhlTDleNdMS4XXN1srd2U80bOlF6KyHEKQ1BzZEqDYN4bolY8BFvwNCLMdg-Af9\" alt=\"\" \/><\/p>\n<h3>Connecting to Binance API<\/h3>\n<p>We will be using Python as the base programming language for this article since it offers a library called <a href=\"https:\/\/pypi.org\/project\/python-binance\/\">python-binance<\/a> that can be used to establish connections to the Binance API easily. The following code block demonstrates how to connect and get the current price of all the cryptocurrencies available in Binance.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">\nfrom binance.client import Client  \nimport pandas as pd  \nimport os  \n  \n# Create the client  \nclient = Client(os.environ['binance_api_key'], os.environ['binance_api_secret'])  \n  \n# Retrieve all data  \nprices = client.get_all_tickers()  \n  \n# Create a Pandas DataFrame  \ndata = pd.DataFrame(prices)  \nprint(data)\n<\/code><\/pre>\n<\/div>\n<h5>RESULT<\/h5>\n<p><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/Ct_okDpTE0rUJMJ8rLtP92J6PDkZ4zSV1cSJdFxbqsYPs-vQuVn55RHByVhJ8Oj30DcNhG5hnBh1b7E1IB_CzQ-KfE6WU9VSNOfByH0Mcie0a-8_ODLrQUlLWYhP-sCweg2czWAw\" alt=\"\" \/><\/p>\n<h3>Retrieving Data Periodically<\/h3>\n<p>Let&#8217;s consider a scenario where a user is required to gather 24-hours market information of a selected set of cryptocurrencies at regular intervals. The below code block demonstrates how to achieve this functionality.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">  \ndef retrive_market_data(currency_list):\n    try:\n        # Create the Connection\n        client = Client(os.environ['binance_api_key'],\n                        os.environ['binance_api_secret'])\n        currency_data = []\n        # Iterate the Currency List\n        for currency in currency_list:\n            # Get Crypto Information\n            tickers = client.get_ticker(symbol=str(currency))\n            currency_data.append(tickers)\n        # Create a DataFrame\n        currency_data_df = pd.DataFrame(currency_data)\n        # Return the DataFrame\n        return currency_data_df\n    except BaseException as error:\n        print(f\"Error Occuered: {error}\")\n  \n  \nif __name__ == \"__main__\":  \n    list = ['DOGEUSDT','BNBBTC','BTCUSDT','ETHUSDT']  \n    print(retrive_market_data(list))\n<\/code><\/pre>\n<\/div>\n<h5>RESULT<\/h5>\n<p><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/B08whr8wg7nXCE2NOJrRqgqVhnqlpg9cYpVTmKUdCLTOjGzWcYQDNHEWwL5Tf5MFUPCZMJmJhe6JyfTdmfTRI5Wme7vtIiuvrtkxhpesBLYa4SMPthkIk7jku8-gxC-Nmk4lEnP8\" alt=\"\" \/><\/p>\n<h2>Parsing Data to a GridDB Database<\/h2>\n<p>Now we have retrieved the data from the Binance API, and the next step would be to parse those data to a GridDB database. Let&#8217;s assume that we only require only the following information from the retrieved data set.<\/p>\n<ul>\n<li>symbol<\/li>\n<li>piceChange<\/li>\n<li>priceChangePercent<\/li>\n<li>weightedAvgPrice<\/li>\n<li>prevClosePrice<\/li>\n<li>lastPrice<\/li>\n<li>openPrice<\/li>\n<li>highPrice<\/li>\n<li>lowPrice<\/li>\n<li>volume<\/li>\n<li>openTime<\/li>\n<li>closeTime<\/li>\n<\/ul>\n<p>We need to clean the retrieved data set before sending it to the database. This can be easily done by dropping the unnecessary columns from the Pandas DataFrame using the below code.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">\nmarket_data.drop(columns=['lastQty','bidPrice','bidQty','askPrice','askQty', 'quoteVolume', 'firstId', 'lastId', 'count'],inplace=True)\n<\/code><\/pre>\n<\/div>\n<p>Then we will need to convert the required fields into the necessary data types. As most values in this data set are float values, we will convert them from string to float while converting the &#8220;openTime&#8221; and &#8220;closeTime&#8221; values from Epoch to TimeStamp data type.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">\n# Convert String to Float  \nmarket_data['priceChange'] = market_data['priceChange'].astype(float)  \nmarket_data['priceChangePercent'] = market_data['priceChangePercent'].astype(float)  \nmarket_data['weightedAvgPrice'] = market_data['weightedAvgPrice'].astype(float)  \nmarket_data['prevClosePrice'] = market_data['prevClosePrice'].astype(float)  \nmarket_data['lastPrice'] = market_data['lastPrice'].astype(float)  \nmarket_data['openPrice'] = market_data['openPrice'].astype(float)  \nmarket_data['highPrice'] = market_data['highPrice'].astype(float)  \nmarket_data['lowPrice'] = market_data['lowPrice'].astype(float)  \nmarket_data['volume'] = market_data['volume'].astype(float)  \n  \n# Convert from Time since Epoch  \nmarket_data['openTime'] = pd.to_datetime(market_data['openTime'], unit='ms')  \nmarket_data['closeTime'] = pd.to_datetime(market_data['closeTime'], unit='ms')\n<\/code><\/pre>\n<\/div>\n<h3>Creating the GridDB Collection<\/h3>\n<p>Now we have transformed our data, and the next step will be to insert them into the GridDB database. However, before that, we need to create a proper container within the database to insert the data. For that, we can create a collection using the griddb_python library. The most important thing to keep in mind is that the data type should match both the Pandas DataFrame and the GridDB database, or else, it might cause errors.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">\nimport griddb_python as griddb\n\nfactory = griddb.StoreFactory.get_instance()\ntry:\n    # Get GridStore object\n    gridstore = factory.get_store(\n        host='10.10.10.100',\n        port=250,\n        cluster_name='default',\n        username='admin',\n        password='admin'\n    )\n\n    # Create Collection\n    containerName = \"Crypto_Data_Container\"\n    crypto_container = griddb.ContainerInfo(containerName,\n                    [[\"symbol\", griddb.Type.STRING],\n                     [\"priceChange\", griddb.Type.FLOAT],\n                     [\"priceChangePercent\", griddb.Type.FLOAT],\n                     [\"weightedAvgPrice\", griddb.Type.FLOAT],\n                     [\"prevClosePrice\", griddb.Type.FLOAT],\n                     [\"lastPrice\", griddb.Type.FLOAT],\n                     [\"openPrice\", griddb.Type.FLOAT],\n                     [\"highPrice\", griddb.Type.FLOAT],\n                     [\"lowPrice\", griddb.Type.FLOAT],\n                     [\"volume\", griddb.Type.FLOAT],\n                     [\"openTime\", griddb.Type.TIMESTAMP],\n                     [\"closeTime\", griddb.Type.TIMESTAMP]],\n                    griddb.ContainerType.COLLECTION, True)\n\n    data_container = gridstore.put_container(crypto_container)\n\nexcept griddb.GSException as e:\n    for i in range(e.get_error_stack_size()):\n        print(\"[\", i, \"]\")\n        print(e.get_error_code(i))\n        print(e.get_location(i))\n        print(e.get_message(i))\n<\/code><\/pre>\n<\/div>\n<p>The above code block demonstrates how to create a collection in GridDB using the griddb_python library.<\/p>\n<h3>Inserting Data Into the GridDB database.<\/h3>\n<p>Finally, we can pass the data retrieved from the Binance API to the GridDB collection. We now have a set of compatible data and database fields. The Pandas &#8220;marketdata&#8221; data frame contains the parsed data, and a GridDB collection is available to receive those data. GridDB provides us the ability to simply use the data frame itself to insert the data, and this functionality is demonstrated below;<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">\ndef insert_data(binance_data):\n    factory = griddb.StoreFactory.get_instance()\n    try:\n        # Get GridStore object\n        gridstore = factory.get_store(\n            host='10.10.10.100',\n            port=250,\n            cluster_name='default',\n            username='admin',\n            password='admin'\n        )\n\n        # Get the Collection\n        containerName = \"Crypto_Data_Container\"\n        data_container = gridstore.get_container(containerName)\n\n        # Insert the DataFrame data\n        data_container.put_rows(binance_data)\n\n    except griddb.GSException as e:\n        for i in range(e.get_error_stack_size()):\n            print(\"[\", i, \"]\")\n            print(e.get_error_code(i))\n            print(e.get_location(i))\n            print(e.get_message(i))\n<\/code><\/pre>\n<\/div>\n<p>That&#8217;s it, and now you have successfully obtained data from the Binance API and stored them in a GridDB database. We can use a cron job to run this program automatically if deployed on a server or use a scheduling service to execute the script periodically if deployed as a cloud function.<\/p>\n<h3>Visualizing Data<\/h3>\n<p>As we now know how to parse data, let&#8217;s try to extract meaningful information from the data set. Assume that we have run the above function every day for a week and we need to create a graph using the \u00e2\u20ac\u0153weightedAvgPrice\u00e2\u20ac\u009d to see the price action of the selected cryptocurrency. The following code block gets the data for \u00e2\u20ac\u02dcETHUSDT\u00e2\u20ac\u2122 by querying the GridDB database using a TQL statement and draw a lin chart using the resulting data set.<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">from binance.client import Client\nimport griddb_python as griddb\nimport pandas as pd\n\ndef get_data(symbol):\n    factory = griddb.StoreFactory.get_instance()\n    try:\n        # Get GridStore object\n        gridstore = factory.get_store(\n            host='10.10.10.100',\n            port=250,\n            cluster_name='default',\n            username='admin',\n            password='admin'\n        )\n\n        # Get the Collection\n        containerName = \"Crypto_Data_Container\"\n        data_container = gridstore.get_container(containerName)\n\n        # Fetch all rows - Crypto_Data_Container\n        query_string = f\"select symbol, weightedAvgPrice, closeTime where symbol = '{symbol}'\"\n        query = data_container.query(query_string)\n        rs = query.fetch(False)\n        \n        # Create a List form the Crypto_Data_Container\n        retrieved_data= []\n        while rs.has_next():\n            data = rs.next()\n            retrieved_data.append(data)\n\n        return retrieved_data\n\n    except griddb.GSException as e:\n        for i in range(e.get_error_stack_size()):\n            print(\"[\", i, \"]\")\n            print(e.get_error_code(i))\n            print(e.get_location(i))\n            print(e.get_message(i))\n\nif __name__ == \"__main__\":\n    # Get the Necessary Data\n    crypto_data = get_data('ETHUSDT')\n    crypto_dataframe = pd.DataFrame(crypto_data, columns=['symbol', 'weightedAvgPrice', 'closeTime'])\n\n    # Create the Plot using Pandas\n    crypto_dataframe.sort_values('closeTime', ascending=True, inplace=True)\n    lines = crypto_dataframe.plot.line(x='closeTime', y=\"weightedAvgPrice\", figsize=(20, 10))<\/code><\/pre>\n<\/div>\n<h5>RESULT<\/h5>\n<p><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/QbFBeANq3fbmF9WB4Loq-PTRRqGyRporUZEP1qAGcaJit2F9dJMNhyKZFLOv9JTr-R9dxMuthPdWX0Egcgu0w9h62s1z329Tmy7Vb3L_0HXVb678LpTQuQAL1Yy4XMUXlXUXQdM8\" alt=\"\" \/><\/p>\n<h2>Conclusion<\/h2>\n<p>In this article, we gained a general understanding of how to interact with an API and retrieve data, and then how to parse the retreived data into a database. When parsing the data, the most important factor is to clean up the required data and convert them into correct data types that the database would accept. Using these kinds of functionality, we can create automated data storage and analytics functions for any organization.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cryptocurrency has become a dominant force in the financial sector, offering a decentralized digital currency based on blockchain technology. When it comes to trading these cryptocurrencies, we need a cryptocurrency exchange. Binance is one of the largest cryptocurrency exchanges in the world, providing users with a secure and efficient way to trade cryptocurrencies. In this [&hellip;]<\/p>\n","protected":false},"author":41,"featured_media":27500,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[121],"tags":[],"class_list":["post-46644","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>Parsing API Data to GridDB using Binance API | GridDB: Open Source Time Series Database for IoT<\/title>\n<meta name=\"description\" content=\"Cryptocurrency has become a dominant force in the financial sector, offering a decentralized digital currency based on blockchain technology. When it\" \/>\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\/parsing-api-data-to-griddb-using-binance-api\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Parsing API Data to GridDB using Binance API | GridDB: Open Source Time Series Database for IoT\" \/>\n<meta property=\"og:description\" content=\"Cryptocurrency has become a dominant force in the financial sector, offering a decentralized digital currency based on blockchain technology. When it\" \/>\n<meta property=\"og:url\" content=\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/\" \/>\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-05-21T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T20:55:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/griddb.net\/wp-content\/uploads\/2021\/05\/74734-chain-zip-bag_1920x1272.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1272\" \/>\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=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/\"},\"author\":{\"name\":\"griddb-admin\",\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233\"},\"headline\":\"Parsing API Data to GridDB using Binance API\",\"datePublished\":\"2021-05-21T07:00:00+00:00\",\"dateModified\":\"2025-11-13T20:55:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/\"},\"wordCount\":805,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2021\/05\/74734-chain-zip-bag_1920x1272.jpg\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/\",\"url\":\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/\",\"name\":\"Parsing API Data to GridDB using Binance API | GridDB: Open Source Time Series Database for IoT\",\"isPartOf\":{\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2021\/05\/74734-chain-zip-bag_1920x1272.jpg\",\"datePublished\":\"2021-05-21T07:00:00+00:00\",\"dateModified\":\"2025-11-13T20:55:20+00:00\",\"description\":\"Cryptocurrency has become a dominant force in the financial sector, offering a decentralized digital currency based on blockchain technology. When it\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#primaryimage\",\"url\":\"\/wp-content\/uploads\/2021\/05\/74734-chain-zip-bag_1920x1272.jpg\",\"contentUrl\":\"\/wp-content\/uploads\/2021\/05\/74734-chain-zip-bag_1920x1272.jpg\",\"width\":1920,\"height\":1272},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#website\",\"url\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.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-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#organization\",\"name\":\"Fixstars\",\"url\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.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-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.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-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233\",\"name\":\"griddb-admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.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":"Parsing API Data to GridDB using Binance API | GridDB: Open Source Time Series Database for IoT","description":"Cryptocurrency has become a dominant force in the financial sector, offering a decentralized digital currency based on blockchain technology. When it","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\/parsing-api-data-to-griddb-using-binance-api\/","og_locale":"en_US","og_type":"article","og_title":"Parsing API Data to GridDB using Binance API | GridDB: Open Source Time Series Database for IoT","og_description":"Cryptocurrency has become a dominant force in the financial sector, offering a decentralized digital currency based on blockchain technology. When it","og_url":"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/","og_site_name":"GridDB: Open Source Time Series Database for IoT","article_publisher":"https:\/\/www.facebook.com\/griddbcommunity\/","article_published_time":"2021-05-21T07:00:00+00:00","article_modified_time":"2025-11-13T20:55:20+00:00","og_image":[{"width":1920,"height":1272,"url":"https:\/\/griddb.net\/wp-content\/uploads\/2021\/05\/74734-chain-zip-bag_1920x1272.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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#article","isPartOf":{"@id":"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/"},"author":{"name":"griddb-admin","@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233"},"headline":"Parsing API Data to GridDB using Binance API","datePublished":"2021-05-21T07:00:00+00:00","dateModified":"2025-11-13T20:55:20+00:00","mainEntityOfPage":{"@id":"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/"},"wordCount":805,"commentCount":0,"publisher":{"@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#organization"},"image":{"@id":"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2021\/05\/74734-chain-zip-bag_1920x1272.jpg","articleSection":["Blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/","url":"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/","name":"Parsing API Data to GridDB using Binance API | GridDB: Open Source Time Series Database for IoT","isPartOf":{"@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#primaryimage"},"image":{"@id":"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2021\/05\/74734-chain-zip-bag_1920x1272.jpg","datePublished":"2021-05-21T07:00:00+00:00","dateModified":"2025-11-13T20:55:20+00:00","description":"Cryptocurrency has become a dominant force in the financial sector, offering a decentralized digital currency based on blockchain technology. When it","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/griddb.net\/en\/blog\/parsing-api-data-to-griddb-using-binance-api\/#primaryimage","url":"\/wp-content\/uploads\/2021\/05\/74734-chain-zip-bag_1920x1272.jpg","contentUrl":"\/wp-content\/uploads\/2021\/05\/74734-chain-zip-bag_1920x1272.jpg","width":1920,"height":1272},{"@type":"WebSite","@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#website","url":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.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-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#organization","name":"Fixstars","url":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.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-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.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-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233","name":"griddb-admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.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\/46644","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=46644"}],"version-history":[{"count":1,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/posts\/46644\/revisions"}],"predecessor-version":[{"id":51319,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/posts\/46644\/revisions\/51319"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/media\/27500"}],"wp:attachment":[{"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/media?parent=46644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/categories?post=46644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/griddb.net\/en\/wp-json\/wp\/v2\/tags?post=46644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}