Allana's Avatar
published in Blogs
Oct 24, 2018

Google BigQuery Makes Ethereum Blockchain Data Available

Blockchain’s immutable ledger is what makes digital currencies tick. Ethereum, created by Vitalik Buterin, augmented their ledger with smart contracts and additional features that differentiate it from cousins like Bitcoin, providing a potential treasure trove of data – if only it was accessible for analysis.

This made Google’s August announcement that their “fast, highly scalable, cost-effective, and fully managed cloud data warehouse for analytics, with built-in machine learning”, called BigQuery, had made the entire Ethereum dataset available particularly exciting – and opened up a series of new, exciting possibilities.

The announcement was music to data analysts’ ears for a number of reasons, outlined in a blog post by Allen Day, a Cloud Developer Advocate at Google Cloud Health AI and Evgeny Medvedev, a Data Engineer with CoinFi. While the Ethereum blockchain software has an existing API for “commonly used random-access functions”, including frequent activities like monitoring transaction statuses and checking wallet balances, it doesn’t offer API endpoints “for easy access to all of the data stored on-chain”.

BigQuery’s features allow users to glean insights from the Ethereum blockchain that were previously unobtainable. Users can now view blockchain data in aggregate – a useful decision-making tool for determining and improving the Ethereum blockchain’s structural efficiency. Day and Medvedev also outlined additional features built into BigQuery for data analysis: the ability to synchronize the Ethereum blockchain to computers running Parity (who provide “blockchain infrastructure for the decentralized web”) in Google Cloud; a daily data extraction “including the results of smart contract transactions, such as token transfers” from Ethereum’s ledger; and organizing data by date “for easy and cost-effective exploration”.  

The ability to analyze smart contract data is particularly exciting – BigQuery can query contract tables and dataset transactions to determine the most-used smart contracts by the number of transactions. Users can also measure the most popular tokens distributed on the Ethereum blockchain within a user-specified time frame, then use the resulting data to create interesting, informative visual representations of that information – Day and Medvedev’s blog post uses visualization software Gephi to map “the first 50,000 transactions that had at least two trading partners” for the OmiseGO token.

BigQuery opens Ethereum blockchain data up to a world of possibilities. The Day- and Medvedev-outlined use cases are the tip of the iceberg, and creative analyses with fresh insights are sure to follow. The world of smart contract analytics is now open for study – with reams of data, backed by powerful tools.
 

Learn More about the Power of Blockchain – and How to Invest – on Tickeron.com

Access Tickeron’s Academy on tickeron.com to learn more about the cryptocurrency and blockchain revolutions, and even how you can use algorithms and AI to invest. Tickeron has created Artificial Intelligence capable of finding trade patterns and generating investment ideas for the cryptocurrency markets. Start a free trial today on tickeron.com.

Related Tickers: GOOGL
John Jacques's Avatar
published in Blogs
May 16, 2022
A.I. Stock Market Predictions: Head & Shoulders

A.I. Stock Market Predictions: Head & Shoulders

Statistics for the Head-and-Shoulders Bottom Pattern The days where only hedge funds used algorithms to trade stocks are officially over. Now retail investors can use Artificial Intelligence (A.I.  Here’s an example of the algorithm in action: Late last year, Tickeron’s A.I.
Edward Flores's Avatar
published in Blogs
Apr 29, 2022
How to Become the Millionaire Next Door

How to Become the Millionaire Next Door

The Golden Gate Bridge is always a fixture of these walks too, one of man's most beautiful creations.  As we were walking, at one point she turned to me and said, "Man, I'll never have a million dollars."" My girlfriend is 27 years old and works as a graphic designer, making about $75,000 a year.
Sergey Savastiouk's Avatar
published in Blogs
May 16, 2022
When Is the Next Recession Coming?

When Is the Next Recession Coming?

However, we also know that economists predicted 22 recessions out of 11 that took place since 1945. Are there real recession signs we should watch for?Indeed, the answer is yes, and here are a few very important ones: The first one is almost obvious and known to everyone – it is the Fed.
Sergey Savastiouk's Avatar
published in Blogs
Mar 14, 2023
How to Start Trading Penny Stocks

How to Start Trading Penny Stocks

Penny stocks have long been marginalized within the professional investment community, oftentimes being painted with a broad brush of simply being “too risky.” Leonardo DiCaprio’s depiction of the penny stock peddling conman, Jordan Belfort, in the Wolf of Wall Street certainly didn’t help.Here are four reasons to start trading them now. Reason #1: Let’s State the Obvious -- Penny Stocks are Cheap A single share of Apple Inc. costs over $350.
Dmitry Perepelkin's Avatar
published in Blogs
Mar 14, 2023
5 Habits that Lead to Successful Investing

5 Habits that Lead to Successful Investing

To consistently make money in this industry, you need emotional fortitude, an analytical mind, and a willingness to self-reflect. Despite trading and investing being two different activities, these principles can be applied to both.Conversely, investors with good habits often become great traders.  Rather than full sentences for titles, we’ve labeled each of our top-five investing habits using a single word principle.
Allana's Avatar
published in Blogs
Mar 23, 2023
What’s the Difference Between Data Analytics and Machine Learning?

What’s the Difference Between Data Analytics and Machine Learning?

Artificial intelligence (AI) technology is developing rapidly.Data mining can deliver raw numbers, but it does not necessarily provide actionable insights. Structure is necessary to taking abstract information and extracting commonalities, like averages, ratios, and percentages.
Sergey Savastiouk's Avatar
published in Blogs
Mar 13, 2023
4 Tips for Fast, Effective Stock Analysis

4 Tips for Fast, Effective Stock Analysis

With just a few clicks, an investor can search for individual stocks, categories of stocks, sectors, or investment themes, and then he or she can conduct a full range of technical and fundamental analysis within seconds.All powered by Artificial Intelligence.  Below, we give you 5 tips for fast, effective stock analysis using Tickeron’s Screener.
Sergey Savastiouk's Avatar
published in Blogs
Mar 20, 2023
5 Golden Principles in Investing

5 Golden Principles in Investing

You have enough faith in that stock, based on research, that the return will equal or exceed the investment.  Do unto others.The principles outlined here will ensure that happens.  Principle #1: Diversification Investors can’t be one-dimensional when constructing a portfolio.
John Jacques's Avatar
published in Blogs
Mar 24, 2023
If Hedge Funds are Using AI to Invest, Why Shouldn’t You?

If Hedge Funds are Using AI to Invest, Why Shouldn’t You?

Some of the world’s biggest financial institutions have devoted multi-million dollar budgets to developing algorithms that can find patterns in the market, identify trends, and perform automated trading designed to take advantage of even the smallest price movements. The AI revolution is so big that as it stands today, the world’s five biggest hedge funds all use systems-based approaches to trade financial markets.Indeed, quantitative trading hedge funds now manage $918 billion (according to HFR), which amounts to 30% of the $3 trillion hedge fund industry – a percentage continues to grow with each year that passes.
Sergey Savastiouk's Avatar
published in Blogs
Mar 15, 2023
The five most important Lessons Learned After 10,000 hours of Trading

The five most important Lessons Learned After 10,000 hours of Trading

Ten thousand hours of active trading, broken down into forty-hour weeks, amounts to almost five years. Having surpassed that milestone myself, I now understand why it's significant for any trader's journey. The early years taught me valuable lessons that have shaped my approach to trading. It's a misconception that great traders are born with innate talent. The truth is that it takes years of...