MENU
Go to the list of all blogs
Allana's Avatar
published in Blogs
Oct 24, 2018
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

GOOGL sees its Stochastic Oscillator recovers from oversold territory

On February 23, 2026, the Stochastic Oscillator for GOOGL moved out of oversold territory and this could be a bullish sign for the stock. Traders may want to buy the stock or buy call options. Tickeron's A.I.dvisor looked at 54 instances where the indicator left the oversold zone. In of the 54 cases the stock moved higher in the following days. This puts the odds of a move higher at over .

Price Prediction Chart

Technical Analysis (Indicators)

Bullish Trend Analysis

The RSI Oscillator points to a transition from a downward trend to an upward trend -- in cases where GOOGL's RSI Indicator exited the oversold zone, of 17 resulted in an increase in price. Tickeron's analysis proposes that the odds of a continued upward trend are .

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

The Aroon Indicator entered an Uptrend today. In of 300 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 Momentum Indicator moved below the 0 level on March 04, 2026. You may want to consider selling the stock, shorting the stock, or exploring put options on GOOGL as a result. In of 76 cases where the Momentum Indicator fell below 0, the stock fell further within the subsequent month. The odds of a continued downward trend are .

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

GOOGL moved below its 50-day moving average on February 10, 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 February 17, 2026. This indicates that the trend has shifted lower and could be considered a sell signal. In 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 .

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 .

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 96, placing this stock better than average.

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.

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 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.842) is normal, around the industry mean (24.858). P/E Ratio (28.083) is within average values for comparable stocks, (66.631). Projected Growth (PEG Ratio) (2.286) is also within normal values, averaging (23.316). Dividend Yield (0.003) settles around the average of (0.034) among similar stocks. P/S Ratio (9.217) is also within normal values, averaging (64.264).

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

Notable companies

The most notable companies in this group are Alphabet (NASDAQ:GOOG), Alphabet (NASDAQ:GOOGL), Meta Platforms (NASDAQ:META), Spotify Technology SA (NYSE:SPOT), Baidu (NASDAQ:BIDU), Nebius Group N.V. (NASDAQ:NBIS), Tencent Music Entertainment Group (NYSE:TME), Pinterest (NYSE:PINS), Bilibili (NASDAQ:BILI), 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 90.78B. The market cap for tickers in the group ranges from 12.09K to 3.71T. GOOGL holds the highest valuation in this group at 3.71T. The lowest valued company is BTIM at 12.09K.

High and low price notable news

The average weekly price growth across all stocks in the Internet Software/Services Industry was 0%. For the same Industry, the average monthly price growth was -5%, and the average quarterly price growth was -21%. FLNCF experienced the highest price growth at 89%, while QQQFF experienced the biggest fall at -30%.

Volume

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

Fundamental Analysis Ratings

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

Valuation Rating: 49
P/E Growth Rating: 71
Price Growth Rating: 70
SMR Rating: 72
Profit Risk Rating: 95
Seasonality Score: -24 (-100 ... +100)
View a ticker or compare two or three
GOOGL
Daily Signal:
Gain/Loss:
Interact to see
Advertisement
A.I.Advisor
published price charts
These past five trading days, the stock lost 0.00% with an average daily volume of 0 shares traded.The stock tracked a drawdown of 0% for this period. GOOGL showed earnings on February 04, 2026. You can read more about the earnings report here.
A.I. Advisor
published General Information

General Information

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

Industry InternetSoftwareServices

Profile
Fundamentals
Details
Industry
Internet Software Or Services
Address
1600 Amphitheatre Parkway
Phone
+1 650 253-0000
Employees
18502
Web
https://www.abc.xyz
Interact to see
Advertisement
Tickeron, a leader in AI-driven financial tools, today announced exceptional results from its AI Trading Agents, showcasing annualized returns ranging from 102% to 210% across various high-liquidity stocks and strategies.
#artificial_intelligence
Tickeron, a leader in AI-driven financial technology, today announced groundbreaking performance from its suite of AI Trading Agents. Powered by Financial Learning Models (FLMs), these agents have demonstrated exceptional returns, with top performers achieving annualized gains of up to 83% over periods ranging from 127 to 390 days.
#artificial_intelligence
Tickeron, a leader in AI-driven financial tools, today unveils its Top 10 Day Traders: AI Trading Robots, showcasing exceptional performance in volatile markets. Powered by advanced Financial Learning Models (FLMs), these robots integrate AI with technical analysis to deliver real-time insights for day traders.
#artificial_intelligence
Tickeron, a leader in AI-driven financial solutions, announces groundbreaking performance results for its Crypto AI Trading Robots, achieving annualized returns of up to 85% for ETH.X, 56% for OM.X, and 49% for XRP.X in 2025, powered by advanced Financial Learning Models (FLMs).
#artificial_intelligence
Tickeron, a leader in AI-driven financial technology, today announced groundbreaking results from its AI Trading Agents, showcasing annualized returns as high as +84% across various stocks and portfolios.
#artificial_intelligence
Tickeron, a leader in AI-driven financial technology, today announced the launch of its advanced AI Trading Agents. These innovative brokerage agents provide real-time trading signals powered by machine learning, utilizing tick-level brokerage data and precise trade amounts across 5-, 15-, and 60-minute timeframes.
#artificial_intelligence
Tickeron, a leading innovator in AI-driven financial technology, today announced groundbreaking results from its AI Trading Agents, showcasing exceptional performance in real-time trading signals powered by machine learning. Utilizing tick-level brokerage data and precise trade amounts, these agents operate on 5-, 15-, and 60-minute timeframes to provide traders with actionable insights in volatile markets.
#artificial_intelligence
Tickeron, a leading innovator in AI-driven financial technology, today announced the launch of its advanced AI Trading Agents. These cutting-edge brokerage agents deliver real-time trading signals powered by machine learning, leveraging tick-level brokerage data and precise trade amounts across 5-, 15-, and 60-minute timeframes. Designed to empower traders with superior insights, the agents have demonstrated exceptional performance, including annualized returns as high as 82%.
#artificial_intelligence
The financial markets have undergone a profound transformation in recent years, driven by the integration of artificial intelligence (AI) into trading strategies. As a financial analyst, writer, and AI specialist, one observes that AI trading agents represent a pinnacle of this evolution, blending machine learning algorithms with real-time data analysis to execute trades with unprecedented precision.
#artificial_intelligence
AI trading represents a revolutionary shift in how financial markets operate, combining artificial intelligence, machine learning, and sophisticated algorithmic trading strategies to execute trades with unprecedented precision and speed.
#artificial_intelligence
Tickeron, a leader in AI-driven financial tools, today announced exceptional trading results from its AI Trading Agent focused on Hubbell Incorporated (HUBB). The agent, operating on a 5-minute timeframe, delivered a +105% annualized return, starting from an initial balance of $100,000.
#artificial_intelligence
Tickeron, a leader in AI-driven financial technology, today announced the launch of its advanced AI Trading Agents, delivering real-time trading signals and sophisticated money management for retail and institutional traders. Powered by Financial Learning Models (FLMs) and machine learning, these agents operate across 5-, 15-, and 60-minute timeframes, achieving annualized returns of up to 145% on select portfolios.
#artificial_intelligence
Tickeron, a leading innovator in AI-driven financial technology, today announced the exceptional performance of its AI Trading Agents, achieving annualized returns of up to 162%, profitable trade percentages as high as 90.51%, and a robust profit factor across multiple assets.
#artificial_intelligence
Tickeron, a leading innovator in AI-driven financial technology, proudly announces the exceptional performance of its AI Trading Agents, delivering annualized returns of up to 188% on a 5-minute timeframe.
#artificial_intelligence
Tickeron, a leader in AI-driven financial tools, today announced the launch of its advanced Pattern Search Engine (PSE), a revolutionary platform that scans 39 distinct trading patterns across stocks, penny stocks, ETFs, crypto, and forex.
#artificial_intelligence
AI trading bots represent the pinnacle of financial technology innovation, transforming how traders and investors interact with global markets.
#artificial_intelligence
As a financial analyst, writer, and AI specialist, I've always pushed for innovations that merge artificial intelligence with actionable trading tools. In the fast-paced world of modern markets, where volatility demands quick decisions, Tickeron's new "My Trades Aggregator (from AI Robots Followed)" aggregator stands out as a revolutionary feature.
#artificial_intelligence#trading
Tickeron, a leading provider of AI-driven trading solutions, is thrilled to announce the exceptional performance of its AI Trading Agents, delivering outstanding results across multiple high-profile stocks.
#artificial_intelligence
Tickeron, a leader in AI-driven financial technologies, today announced groundbreaking results from its AI Crypto Trading Virtual Agents. These innovative tools provide real-time trading signals, integrated money management, and customizable balances, all powered by advanced machine learning algorithms operating on 5-, 15-, and 60-minute timeframes.
#artificial_intelligence
Tickeron, a leading innovator in AI-driven financial technologies, today announced the launch of its advanced AI Trading Brokerage Agents. These cutting-edge tools deliver real-time trading signals powered by machine learning, utilizing tick-level brokerage data and precise trade amounts across 5-, 15-, and 60-minute timeframes.
#artificial_intelligence