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.
GOOGL's MACD Histogram crosses above signal line
The Moving Average Convergence Divergence (MACD) for GOOGL turned positive on August 28, 2025. Looking at past instances where GOOGL's MACD turned positive, the stock continued to rise in of 53 cases over the following month. The odds of a continued upward trend are .
Technical Analysis (Indicators)
Bullish Trend Analysis
Following a 3-day Advance, the price is estimated to grow further. Considering data from situations where GOOGL advanced for three days, in of 360 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 296 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 RSI Indicator demonstrates that the ticker has stayed in the overbought zone for 12 days. The longer the ticker stays in the overbought zone, the sooner a price pull-back is expected.
The Stochastic Oscillator demonstrated that the ticker has stayed in the overbought zone for 14 days. The longer the ticker stays in the overbought zone, the sooner a price pull-back is expected.
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 September 03, 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 Price Growth Rating for this company is (best 1 - 100 worst), indicating outstanding price growth. GOOGL’s price grows at a higher rate over the last 12 months as compared to S&P 500 index constituents.
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 90, placing this stock better than average.
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 (8.313) is normal, around the industry mean (9.303). P/E Ratio (26.602) is within average values for comparable stocks, (59.271). Projected Growth (PEG Ratio) (1.697) is also within normal values, averaging (26.725). Dividend Yield (0.003) settles around the average of (0.022) among similar stocks. P/S Ratio (8.271) is also within normal values, averaging (24.685).
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 PE Growth Rating for this company is (best 1 - 100 worst), pointing to outstanding 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