Google Adds Ethereum Blockchain Dataset to Its Big Data Analytics Platform

Published at: Sept. 4, 2018

The Google Cloud team has officially made the Ethereum (ETH) dataset available in BigQuery, the company’s big data warehouse for analytics, according to a post published on Google’s official blog August 29.

The Ethereum blockchain data is posted in the dataset and updated on a daily basis. As the team explains, the tool was created to help make business decisions, prioritize improvements to the Ethereum architecture itself (for example, to prepare updates), and balance sheet adjustments, e.g. how quickly a wallet can be rebalanced.

As Google explains, the Ethereum blockchain contains APIs for random functions such as checking transaction status, looking up wallet-transaction associations, and checking wallet balances. Still, the API endpoints cannot be easily reached. For that reason, BigQuery’s OLAP features help aggregate such types of data and and visualize it.

Screenshot of Ethereum transfers and transactions costs in 2018. Source: BigQuery

Furthermore, the software based on Google Cloud synchronizes the Ethereum blockchain to computers running Parity — a UK-based provider of infrastructure software for interacting with the Ethereum network, which performs a daily extraction of data from the Ethereum blockchain ledger and stores date-partitioned data to BigQuery for exploration.

Google also shows some examples of the uses of the new tool. One of them relates to CryptoKitties — a game based on the Ethereum blockchain that is the most popular ERC-721 smart contract by transaction count. BigQuery collects data on accounts that own at least 10 CryptoKitties (a color on the graphics indicates owner) and their mascots’ reproductive fitness (size).

Screenshot of CryptoKitties infographic of owners and CryptoKitties’ reproductive fitness. Source: BigQuery

Google has already expanded into blockchain-based tools and services this year. In February, the company created a similar tool for the Bitcoin (BTC) blockchain to visualize transactions, detect anomalies, and extract necessary data from the blockchain ledger.

As Cointelegraph wrote in July, Google also partnered with two blockchain-focused firms, Digital Asset and BlockApps, to offer new distributed ledger technology (DLT) solutions on Google's Cloud Platform.

Tags
Blockchain
Ethereum
Cryptocurrencies
Google
Api
Related Posts
How to Keep Data Private With Google and Apple’s Contact Tracing App
In a rare instance of cooperation, Google and Apple, two pillars of the global tech industry, announced a joint effort to create a COVID-19 exposure tracing application for mobile phones in conjunction with world governments. The app, which is set to be available on both Android and iOS phones, relies on Bluetooth technology to warn against potential exposure to a person infected with COVID-19. Due to its participating organizations, all three of which have shoddy track-records on privacy, the application immediately raised the suspicions of privacy proponents. The Electronic Frontier Foundation, a staunch supporter of digital privacy, posed questions to …
Decentralization / May 14, 2020
Blockchain Browsers — How DLT Could Affect Web Surfing
The appearance of blockchain technology can be compared with the emergence of internet at the initial stage of its development: Users were cautious about a decentralized system and failed to understand many of its subtleties. But just as firms opened up to the internet, almost all corporations are now working on integrating blockchain into their processes — at least as a trial. And there are some reasons for this trend: With the acceleration of data transfers, globalization and the amount of information, the security questions concerning personal data are becoming more acute for users. Personal information, in a way, is …
Blockchain / July 5, 2019
Ethereum’s Joe Lubin: Blockchain Will ‘Take a Little Longer’ to Develop Than the Web
Blockchain will “probably take a little longer” to develop than the internet, because it is “much more complicated,” ConsenSys creator Joseph Lubin told German media outlet t3n in an interview, Cointelegraph auf Deutsch reported Nov. 9. Lubin, who is also the co-founder of Ethereum (ETH), told reporters that blockchain technology is developing in a similar way to the web, citing its exponential growth with “hundreds of projects that are already practical for humans” to date. Based on blockchain’s use case for decentralized cryptocurrencies, the digital entrepreneur also suggested that distributed ledger technology (DLT) will be able to “permeate society more …
Decentralization / Nov. 10, 2018
Five Crypto Trailblazers Make Fortune's '40 Under 40' List
Five major crypto innovators have clinched four spots on Fortune’s “40 Under 40” annual rankings for the most powerful young disruptors in global business, released for 2018 on July 19. The first incarnation of Fortune’s under 40 list ran from 1999-2003 and ranked the new titans of the dot-com boom purely based on their wealth. Post-2008 financial crash, the list has been reinvented to take the pulse of figures’ wider achievements, power, and influence on the global stage. This year, Ethereum (ETH) co-founder Vitalik Buterin, 24, has sealed a spot on the list for the third year running, ranked 22nd …
Adoption / July 20, 2018
Robinhood Wallet rolls out on iOS with Android support to follow
Trading platform Robinhood has launched its Web3 wallet on Apple’s App Store, becoming available to iOS users in over 130 countries. Robinhood shared the news in a Mar. 1 post, stating that users would no longer need to sit on a waitlist to access the new multi-chain, self-custody wallet. It added that it will be supported on Android “later this year.” #RobinhoodWallet is now available to everyone with iOS: https://t.co/yUdL8jCgJN pic.twitter.com/q7RIWBJUIT — Johann Kerbrat (@JohannKerbrat) March 1, 2023 Since the beta launch of the Robinhood Wallet in September, the trading platform integrated Ethereum — in addition to already supporting Polygon …
Adoption / March 2, 2023