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 have been updated.

    CoinDesk is an award-winning media outlet that covers the cryptocurrency industry. Its journalists abide by a strict set of editorial policies. CoinDesk has adopted a set of principles aimed at ensuring the integrity, editorial independence and freedom from bias of its publications. CoinDesk is part of the Bullish group, which owns and invests in digital asset businesses and digital assets. CoinDesk employees, including journalists, may receive Bullish group equity-based compensation. Bullish was incubated by technology investor Block.one.


    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.