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.
Momentum Indicator for GOOGL turns positive, indicating new upward trend
GOOGL saw its Momentum Indicator move above the 0 level on July 02, 2025. This is an indication that the stock could be shifting in to a new upward move. Traders may want to consider buying the stock or buying call options. Tickeron's A.I.dvisor looked at 85 similar instances where the indicator turned positive. In of the 85 cases, the stock moved higher in the following days. The odds of a move higher are at .
Technical Analysis (Indicators)
Bullish Trend Analysis
The Moving Average Convergence Divergence (MACD) for GOOGL just turned positive on July 11, 2025. Looking at past instances where GOOGL's MACD turned positive, the stock continued to rise in of 52 cases over the following month. The odds of a continued upward trend are .
Following a 3-day Advance, the price is estimated to grow further. Considering data from situations where GOOGL advanced for three days, in of 350 cases, the price rose further within the following month. The odds of a continued upward trend are .
The Aroon Indicator entered an Uptrend today. In of 286 cases where GOOGL Aroon's Indicator entered an Uptrend, the price rose further within the following month. The odds of a continued Uptrend are .
Bearish Trend Analysis
The 10-day RSI Indicator for GOOGL moved out of overbought territory on June 11, 2025. This could be a bearish sign for the stock. Traders may want to consider selling the stock or buying put options. Tickeron's A.I.dvisor looked at 46 similar instances where the indicator moved out of overbought territory. In of the 46 cases, the stock moved lower in the following days. This puts the odds of a move lower at .
The Stochastic Oscillator entered the overbought zone. Expect a price pull-back in the foreseeable future.
Following a 3-day decline, the stock is projected to fall further. Considering past instances where GOOGL declined for three days, the price rose further in of 62 cases within the following month. The odds of a continued downward trend are .
GOOGL broke above its upper Bollinger Band on June 10, 2025. This could be a sign that the stock is set to drop as the stock moves back below the upper band and toward the middle band. You may want to consider selling the stock or exploring put options.
The Tickeron Valuation Rating of (best 1 - 100 worst) indicates that the company is slightly undervalued in the industry. This rating compares market capitalization estimated by our proprietary formula with the current market capitalization. This rating is based on the following metrics, as compared to industry averages: P/B Ratio (6.821) is normal, around the industry mean (11.909). P/E Ratio (26.802) is within average values for comparable stocks, (50.062). Projected Growth (PEG Ratio) (1.626) is also within normal values, averaging (3.572). Dividend Yield (0.000) settles around the average of (0.027) among similar stocks. P/S Ratio (6.435) is also within normal values, averaging (20.696).
The Tickeron Profit vs. Risk Rating rating for this company is (best 1 - 100 worst), indicating low risk on high returns. The average Profit vs. Risk Rating rating for the industry is 89, placing this stock better than average.
The Tickeron SMR rating for this company is (best 1 - 100 worst), indicating very strong sales and a profitable business model. SMR (Sales, Margin, Return on Equity) rating is based on comparative analysis of weighted Sales, Income Margin and Return on Equity values compared against S&P 500 index constituents. The weighted SMR value is a proprietary formula developed by Tickeron and represents an overall profitability measure for a stock.
The Tickeron Price Growth Rating for this company is (best 1 - 100 worst), indicating fairly steady price growth. GOOGL’s price grows at a lower rate over the last 12 months as compared to S&P 500 index constituents.
The Tickeron Seasonality Score of (best 1 - 100 worst) indicates that the company is fair valued in the industry. The Tickeron Seasonality score describes the variance of predictable price changes around the same period every calendar year. These changes can be tied to a specific month, quarter, holiday or vacation period, as well as a meteorological or growing season.
The Tickeron PE Growth Rating for this company is (best 1 - 100 worst), pointing to worse than average earnings growth. The PE Growth rating is based on a comparative analysis of stock PE ratio increase over the last 12 months compared against S&P 500 index constituents.
Notable companies
Industry description
Market Cap
High and low price notable news
Volume
Fundamental Analysis Ratings
The average fundamental analysis ratings, where 1 is best and 100 is worst, are as follows
Advertisement
General Information
a holding company with interests in software, health care, transportation and other technologies
Industry InternetSoftwareServices
Advertisement