Google Now Provides a Big Data View of the Ethereum Blockchain

Internet search giant Google is providing a Big Data window into ethereum after adding the network to its analytics platform BigQuery.

AccessTimeIconSep 3, 2018 at 1:00 p.m. UTC
Updated Sep 13, 2021 at 8:20 a.m. UTC
10 Years of Decentralizing the Future
May 29-31, 2024 - Austin, TexasThe biggest and most established global hub for everything crypto, blockchain and Web3.Register Now

Internet search giant Google has added ethereum to its big data analytics platform BigQuery.

Making the announcement in a blog post on Saturday, the company said that, while an API exists for commonly used functions such as checking transaction status or wallet balances, it's not so easy to access all of the data stored on the ethereum blockchain.

The post continues to say that "perhaps more importantly," the API doesn't allow for viewing blockchain data "in aggregate."

Aiming the new service to provide more of a Big Data window into ethereum, Google said:

"A visualization like this ... is useful for making business decisions, such as prioritizing improvements to the ethereum architecture itself (is the system running close to capacity and due for an upgrade?) to balance sheet adjustments (how quickly can a wallet be rebalanced?)."

The software system Google has built on its Cloud platform does several things: it synchronizes the ethereum blockchain to computers running Parity; it pulls data from the ethereum ledger on a daily basis, including the results of smart contract transactions; and it "de-normalizes and stores date-partitioned data to BigQuery for easy and cost-effective exploration."

In some examples of why the addition may be useful and/or interesting to users, Google sets out several examples, showing that, for one, CryptoKitties (a crypto collectibles game) has by far the most numerous ERC-721 smart contract transactions on the ethereum network.

It further adds a visualization for "pedigrees" of accounts that own more than 10 CryptoKitties:

 CryptoKitty visualization courtesy of Google
CryptoKitty visualization courtesy of Google

A second example looks at data from ERC-20 token project OmiseGo, with a visualization that shows how token recipients spiked on Sept. 13, 2017, while senders didn't. The explanation? The surge marked the OmiseGo project's airdrop of tokens to its community.

was added to BigQuery earlier this year, according to the post.

Anyone interested in using Google's new service can already query ethereum's data in Kaggle.

Edit (07:45 UTC, Sept. 4, 2018): The article was amended to clarify detail of the CryptoKitties data, in particular that it runs on an ERC-721 smart contract.

Hat tip The Next Web.

Images courtesy of Google

Disclosure

Please note that our privacy policy, terms of use, cookies, and do not sell my personal information has been updated.

CoinDesk is an award-winning media outlet that covers the cryptocurrency industry. Its journalists abide by a strict set of editorial policies. In November 2023, CoinDesk was acquired by the Bullish group, owner of Bullish, a regulated, digital assets exchange. The Bullish group is majority-owned by Block.one; both companies have interests in a variety of blockchain and digital asset businesses and significant holdings of digital assets, including bitcoin. CoinDesk operates as an independent subsidiary with an editorial committee to protect journalistic independence. CoinDesk employees, including journalists, may receive options in the Bullish group as part of their compensation.


Learn more about Consensus 2024, CoinDesk's longest-running and most influential event that brings together all sides of crypto, blockchain and Web3. Head to consensus.coindesk.com to register and buy your pass now.