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.
Contributor
Financial analyst and market blogger with expertise in equity research, fundamental analysis, and macroeconomic trends. I regularly publish coverage on individual stocks, ETFs, and sector developments — combining rigorous financial analysis with clear, engaging writing for a broad investment audience.
GOOGL's Stochastic Oscillator remains in oversold zone for 2 days
Be on the lookout for a price bounce soon.
Technical Analysis (Indicators)
Bullish Trend Analysis
Following a +2.37% 3-day Advance, the price is estimated to grow further. Considering data from situations where GOOGL advanced for three days, in 228 of 343 cases, the price rose further within the following month. The odds of a continued upward trend are 66%.
GOOGL may jump back above the lower band and head toward the middle band. Traders may consider buying the stock or exploring call options.
Bearish Trend Analysis
The Momentum Indicator moved below the 0 level on September 04, 2026. You may want to consider selling the stock, shorting the stock, or exploring put options on GOOGL as a result. In 42 of 77 cases where the Momentum Indicator fell below 0, the stock fell further within the subsequent month. The odds of a continued downward trend are 55%.
The Moving Average Convergence Divergence Histogram (MACD) for GOOGL turned negative on August 14, 2026. This could be a sign that the stock is set to turn lower in the coming weeks. Traders may want to sell the stock or buy put options. Tickeron's A.I.dvisor looked at 49 similar instances when the indicator turned negative. In 34 of the 49 cases the stock turned lower in the days that followed. This puts the odds of success at 69%.
GOOGL moved below its 50-day moving average on August 11, 2026 date and that indicates a change from an upward trend to a downward trend.
The 10-day moving average for GOOGL crossed bearishly below the 50-day moving average on August 17, 2026. This indicates that the trend has shifted lower and could be considered a sell signal. In 9 of 16 past instances when the 10-day crossed below the 50-day, the stock continued to move higher over the following month. The odds of a continued downward trend are 56%.
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 50 of 62 cases within the following month. The odds of a continued downward trend are 62%.
The Aroon Indicator for GOOGL entered a downward trend on September 11, 2026. This could indicate a strong downward move is ahead for the stock. Traders may want to consider selling the stock or buying put options.
Fundamental Analysis (Ratings)
The Tickeron Profit vs. Risk Rating rating for this company is 16 (best 1 - 100 worst), indicating low risk on high returns. The average Profit vs. Risk Rating rating for the industry is 94, placing this stock better than average.
The Tickeron Valuation Rating of 19 (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.649) is normal, around the industry mean (5.843). P/E Ratio (16.984) is within average values for comparable stocks, (27.560). Projected Growth (PEG Ratio) (1.210) is also within normal values, averaging (27.634). Dividend Yield (0.002) settles around the average of (0.048) among similar stocks. P/S Ratio (9.294) is also within normal values, averaging (69.922).
The Tickeron SMR rating for this company is 21 (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 47 (best 1 - 100 worst), indicating steady 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 PE Growth Rating for this company is 82 (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