Google’s BigQuery Helps You Analyze and Visualize Bitcoin and Ethereum Blockchain Data

Google’s BigQuery Helps You Analyze and Visualize Bitcoin and Ethereum Blockchain Data

Recently Google has proclaimed that its data analytics product Bigquery now analyze and visualize data in the Ethereum and bitcoin blockchain (which it has been supporting for the past several months).

BigQuery is Google’s serverless, highly scalable, enterprise data warehouse. You can analyze data to find meaningful insights using familiar SQL queries.

Google published on 8 Feb 2018 in its cloud blog that since developing transparency of cryptocurrency systems “makes the contained data becomes more accessible and useful”,

Using BigQuery, it was decided to make available bitcoin blockchain data for exploration.

It said that all actual data was in the “bigquery-public-data:bitcoin_blockchain dataset” (which updates every 10 minutes). its aim is to help users understand better how cryptocurrency work through data more transparent in their blockchain.

Presently, Google gives its statement that they decided to make the ethereum dataset accessible for research. All historical data is in the” ethereum_blockchain dataset”, which is updated daily.
If user wants to see a data chart ether transfers and average transaction cost, aggregated by day:

With this BigQuery you can see that visualization, Google says such visualization is “useful for making the business decision”, such as prioritizing changes to the Ethereum architecture itself to balance sheet adjustments (how quickly can a wallet be rebalanced?).”

Lastly, Google has mentioned three examples of the type of queries user might want to perform on ethereum data set.

  • Active engagement function calls
  • On-chain transaction time-series and transaction networks
  • Smart engagement function analytics

About The Author

Related posts

Leave a Reply

Your email address will not be published. Required fields are marked *