Go to the list of all blogs
Allana's Avatar
published in Blogs
Oct 24, 2018
TickeronGET DAILY SIGNALS
Google BigQuery Makes Ethereum Blockchain Data Available

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 Ticker: GOOGL

Contributor

Allana's AvatarAllana|Expert

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 sees its 50-day moving average cross bearishly below its 200-day moving average

The 50-day moving average for GOOGL moved below the 200-day moving average on October 29, 2026. This could be a long-term bearish signal for the stock as the stock shifts to an downward trend.

Price Prediction Chart

Technical Analysis (Indicators)

Bearish Trend Analysis

The Momentum Indicator moved below the 0 level on October 16, 2026. You may want to consider selling the stock, shorting the stock, or exploring put options on GOOGL as a result. In 48 of 78 cases where the Momentum Indicator fell below 0, the stock fell further within the subsequent month. The odds of a continued downward trend are 62%.

The Moving Average Convergence Divergence Histogram (MACD) for GOOGL turned negative on October 16, 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 48 similar instances when the indicator turned negative. In 28 of the 48 cases the stock turned lower in the days that followed. This puts the odds of success at 58%.

GOOGL moved below its 50-day moving average on October 16, 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 October 23, 2026. This indicates that the trend has shifted lower and could be considered a sell signal. In 9 of 15 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 60%.

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 October 27, 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.

Bullish Trend Analysis

The RSI Indicator shows that the ticker has stayed in the oversold zone for 6 days. The price of this ticker is presumed to bounce back soon, since the longer the ticker stays in the oversold zone, the more promptly an Uptrend is expected.

The Stochastic Oscillator shows that the ticker has stayed in the oversold zone for 14 days. The price of this ticker is presumed to bounce back soon, since the longer the ticker stays in the oversold zone, the more promptly an upward trend is expected.

Following a +3.56% 3-day Advance, the price is estimated to grow further. Considering data from situations where GOOGL advanced for three days, in 228 of 337 cases, the price rose further within the following month. The odds of a continued upward trend are 68%.

GOOGL may jump back above the lower band and head toward the middle band. Traders may consider buying the stock or exploring call options.

Fundamental Analysis (Ratings)

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 Profit vs. Risk Rating rating for this company is 36 (best 1 - 100 worst), indicating well-balanced risk and returns. The average Profit vs. Risk Rating rating for the industry is 94, placing this stock slightly better than average.

The Tickeron Price Growth Rating for this company is 64 (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 Valuation Rating of 69 (best 1 - 100 worst) indicates that the company is slightly overvalued 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 (5.595) is normal, around the industry mean (0.998). P/E Ratio (14.126) is within average values for comparable stocks, (-39.045). Projected Growth (PEG Ratio) (1.225) is also within normal values, averaging (17.274). Dividend Yield (0.003) settles around the average of (1.003) among similar stocks. P/S Ratio (9.416) is also within normal values, averaging (71.888).

The Tickeron PE Growth Rating for this company is 90 (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

The most notable companies in this group are Alphabet (NASDAQ:GOOGL), Alphabet (NASDAQ:GOOG), Meta Platforms (NASDAQ:META), Spotify Technology SA (NYSE:SPOT), Nebius Group N.V. (NASDAQ:NBIS), Baidu (NASDAQ:BIDU), Tencent Music Entertainment Group (NYSE:TME), Pinterest (NYSE:PINS), Snap (NYSE:SNAP), Zillow Group (NASDAQ:Z).

Industry description

Companies in this industry typically license software on a subscription basis and it is centrally hosted. Such products usually go by the names web-based software, on-demand software and hosted software. Cloud computing has emerged as a major force in this space, making it possible to save files to a remote database (without requiring them to be saved on local storage device); as long as a device has access to the web, it can access the data and the software programs to run it. This has in many cases facilitated cost efficiency, speed and security of data for businesses and consumers. Alphabet Inc., Facebook, Inc. and Yahoo! Inc. are some well-known names in the internet software/services industry.

Market Cap

The average market capitalization across the Internet Software/Services Industry is 126.08B. The market cap for tickers in the group ranges from 107 to 3.48T. GOOGL holds the highest valuation in this group at 3.48T. The lowest valued company is STBXF at 107.

High and low price notable news

The average weekly price growth across all stocks in the Internet Software/Services Industry was -1%. For the same Industry, the average monthly price growth was -2%, and the average quarterly price growth was -14%. GIBO experienced the highest price growth at 102%, while BZFD experienced the biggest fall at -43%.

Volume

The average weekly volume growth across all stocks in the Internet Software/Services Industry was -38%. For the same stocks of the Industry, the average monthly volume growth was 27% and the average quarterly volume growth was -33%

Fundamental Analysis Ratings

The average fundamental analysis ratings, where 1 is best and 100 is worst, are as follows

Valuation Rating: 42
P/E Growth Rating: 64
Price Growth Rating: 65
SMR Rating: 77
Profit Risk Rating: 93
Seasonality Score: 10 (-100 ... +100)
View a ticker or compare two or three
Interact to see
Advertisement
A.I.Advisor
published price charts
A.I. Advisor
published General Information

General Information

a holding company with interests in software, health care, transportation and other technologies

Industry InternetSoftwareServices

Industry
Internet Software Or Services
Address
1600 Amphitheatre Parkway
Phone
+1 650 253-0000
Employees
190820
Web
https://www.abc.xyz
Interact to see
Advertisement
The Bitwise Solana Staking ETF (BSOL) advanced roughly 18% over the trailing 30 days, closely tracking a sharp rally in Solana (SOL). The move extends a broader recovery, with BSOL up approximately 77% over the past three months from its mid-2026 trough.
MSTY is an actively managed single-stock option income ETF (exchange-traded fund) that writes call options on Strategy (MSTR), formerly MicroStrategy, to generate current income. The portfolio is anchored by U.S. Treasury bills and MSTR option contracts rather than a diversified basket of equities, concentrating exposure in one volatile underlying.
AMDL has surged roughly +64% over the past 30 days, from about $47.59 to $78.10, mirroring a powerful rally in its sole underlying stock, AMD . The fund is a leveraged single-stock ETF (exchange-traded fund) designed to deliver 2x the daily return of AMD, amplifying both gains and losses.
PANW stock rose approximately +11% over the past 30 days, driven by recovery in cybersecurity sentiment and strong enterprise wins. Over the past quarter, shares gained +3% amid volatility, reflecting a post-earnings dip followed by steady rebound.
Altria Group (MO) stock rose approximately +13% over the past 30 days, driven primarily by a strong Q1 2026 earnings beat that propelled shares sharply higher at month-end. Over the past quarter, shares gained around +16%, reflecting recovery from earlier lows amid consistent operational performance and a shift toward smokefree products.