Google BigQuery Makes Ethereum Blockchain Data...

Alla Petriaieva

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

Sergey Savastiouk

published in Blogs

Mar 07, 2021

4 Tricks Hedge Funds Use to Get Ahead

If the stock market were Major League Baseball, hedge funds and institutional investors would be the pros on championship teams while everyday self-directed investors (SDIs) are the benchwarmers in the minors.It’s how they get ahead, and it’s why 90% of SDIs lose money trying to play (invest and trade) in the major leagues. The 4 tricks we discuss below are rooted in one common theme: they all use Artificial Intelligence and algorithms to generate data and ideas.

John Jacques

published in Blogs

Mar 22, 2018

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.

Sergey Savastiouk

published in Blogs

Jul 10, 2020

3 Stocks to Buy if Coronavirus Second Wave Hits

By analyzing market trends from the first wave, you can predict behavior for the second. Technology stocks have performed at historic levels this year, but the market is severely overbought.To compensate for that, look at performance during Q1 and Q2, the height of global Covid shutdowns.

Edward Flores

published in Blogs

Feb 06, 2021

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.

Alla Petriaieva

published in Blogs

Feb 23, 2021

Is Ethereum’s Bomb about to Explode?

Ethereum’s software is set for an update in October.Until it is finished, participants in the Ethereum blockchain must determine how to delay the difficulty bomb – code that necessitates a steadily increasing amount of computer power to mine blocks and unlock rewards – that is already in place.

Sergey Savastiouk

published in Blogs

Aug 07, 2018

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.

Abhoy Sarkar

published in Blogs

May 22, 2020

Central banks have been buying $2.4 billion in assets every hour for the past two months

Some $17.8 billion has been poured into bond markets over the past week, the biggest move in more than three months.Around $3.5 billion has been invested into gold, the second largest on record.

Rick Pendergraft

published in Blogs

Feb 07, 2021

Mid-January Short Interest Report Shows 8 Stocks with Good Fundamentals and High Short Interest

Sergey Savastiouk

published in Blogs

Mar 10, 2021

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.

Abhoy Sarkar

published in Blogs

May 08, 2020

US unemployment rate jumps to 14.7%, the highest in series history

The U.S. economy’s employment fell by -20.5 million in April. The coronavirus crisis led to unemployment rate soaring to 14.7% in the U.S, the highest rate in the Bureau of Labor Statistics-tracked series history that goes back to 1948. However, the figures were better compared to several economists'/analysts' forecasts of 22 million job losses and 16% unemployment rate. Another unemployment measure that includes those who have stopped looking for work as well as those holding part-time jobs for economic reasons also touched an all-time high of 22.8%.