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 Aug 18, 2021 at 9:45 p.m. UTC

Presented By Icon

Election 2024 coverage presented by

Stand with crypto

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.

  • Bitcoin Mining in the U.S. Will Become 'a Lot More Decentralized': Core Scientific CEO
    13:18
    Bitcoin Mining in the U.S. Will Become 'a Lot More Decentralized': Core Scientific CEO
  • Binance to Discontinue Its Nigerian Naira Services After Government Scrutiny
    05:10
    Binance to Discontinue Its Nigerian Naira Services After Government Scrutiny
  • The first video of the year 2024
    04:07
    The first video of the year 2024
  • The last regression video of the year 3.67.0
    40:07
    The last regression video of the year 3.67.0
  • 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.