MENU
Go to the list of all blogs
Allana's Avatar
published in Blogs
Oct 24, 2018

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

Momentum Indicator for GOOGL turns positive, indicating new upward trend

GOOGL saw its Momentum Indicator move above the 0 level on June 06, 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 86 similar instances where the indicator turned positive. In of the 86 cases, the stock moved higher in the following days. The odds of a move higher are at .

Price Prediction Chart

Technical Analysis (Indicators)

Bullish Trend Analysis

The Moving Average Convergence Divergence (MACD) for GOOGL just turned positive on June 06, 2025. Looking at past instances where GOOGL's MACD turned positive, the stock continued to rise in of 51 cases over the following month. The odds of a continued upward trend are .

GOOGL moved above its 50-day moving average on May 14, 2025 date and that indicates a change from a downward trend to an upward trend.

The 10-day moving average for GOOGL crossed bullishly above the 50-day moving average on May 15, 2025. This indicates that the trend has shifted higher and could be considered a buy signal. In of 17 past instances when the 10-day crossed above the 50-day, the stock continued to move higher 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 353 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 287 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 47 similar instances where the indicator moved out of overbought territory. In of the 47 cases, the stock moved lower in the following days. This puts the odds of a move lower at .

The Stochastic Oscillator may be shifting from an upward trend to a downward trend. In of 70 cases where GOOGL's Stochastic Oscillator exited the overbought zone, the price fell further within 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 .

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.940). 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.480).

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 88, 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 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 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 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

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), Pinterest (NYSE:PINS), Tencent Music Entertainment Group (NYSE:TME), Snap (NYSE:SNAP), Twilio (NYSE:TWLO), 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 69.89B. The market cap for tickers in the group ranges from 1.11K to 1.94T. GOOGL holds the highest valuation in this group at 1.94T. The lowest valued company is MSEZ at 1.11K.

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 0%, and the average quarterly price growth was 10%. SOGP experienced the highest price growth at 22%, while LCFY experienced the biggest fall at -25%.

Volume

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

Fundamental Analysis Ratings

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

Valuation Rating: 45
P/E Growth Rating: 66
Price Growth Rating: 60
SMR Rating: 74
Profit Risk Rating: 88
Seasonality Score: 5 (-100 ... +100)
View a ticker or compare two or three
GOOGL
Daily Signalchanged days ago
Gain/Loss if bought
Show more...
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

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
Paper wallets are extremely useful tools – beyond being one of the most popular and secure cold storage methods, they make it simple to transfer coins between owners.You can access the funds on your paper wallet by “sweeping” (or importing) them to either a live wallet (like Trezor or Exodus) or an exchange service (like Coinbase). Most services allow you to import them directly from your wallet’s private key, but there are two key exceptions.
Learn the 27 essential intraday trading rules that every manual trader should master—and discover how Tickeron’s AI platform applies them automatically for consistent, emotion-free execution and smarter, real-time decision-making.
#investment#trading
A $2 trillion sell-off has investors asking: is 2025 the next dot-com crash or a replay of the 2008 recession? This deep dive compares both scenarios, outlines warning signs, and reveals how AI-powered trading strategies can help navigate rising volatility.
#trading#investment
New to trading? Discover 21 powerful lessons every beginner must learn—and see how Tickeron’s AI Double Agent strategies apply them in real time. From mastering risk to managing emotions, this guide helps you trade smarter, safer, and more confidently.
#investment#trading
From the railroads of the 1920s to the AI giants of 2025, market history shows that extreme concentration often precedes massive bubbles and crashes. This article explores five key turning points and how Tickeron’s AI helps traders navigate today’s bubble-prone landscape.
#investment#trading
U.S. tariff tensions rocked markets this week, sending tech stocks into retreat and safe-haven assets like gold and the yen soaring. As investors brace for major earnings and global policy shifts, volatility remains high across equities, currencies, and commodities.
#investment#trading
Tesla’s Q1 2025 earnings could surprise investors as the EV giant looks to rebound from last quarter’s miss. With lowered expectations and increased volatility, Tickeron’s AI-powered strategy helps traders navigate both upside potential and downside risk.
#investment#trading
Gold is on a historic run—up 29% YTD with record-breaking inflows and growing macro tailwinds. Discover why smart investors are eyeing gold, silver, and miners for opportunity, and how AI trading tools are unlocking new ways to profit from the 2025 gold rush.
#investment#trading
Tickeron launches its innovative Double Agent Trading Bot, combining long NVDA trades with hedged NVDS positions. Using AI-driven pattern trading and real-time risk management, the bot achieves a 75% success rate, revolutionizing automated trading strategies.
#trading#investment
Tickeron’s AI trading bots are setting new standards in finance, achieving up to 86.6% win rates across leveraged and sector ETFs. Powered by advanced Financial Learning Models (FLMs), Tickeron’s AI delivers precision, adaptability, and real-time trading success.
#trading
Wall Street expects strong profit growth from the Magnificent Seven tech giants in 2025. Discover how to trade Apple, Microsoft, Amazon, Nvidia, Tesla, Meta, and Alphabet using AI-powered Double Agent strategies and smart hedging with inverse ETFs like QID.
On May 2, 2025, a diverse group of companies across energy, financial services, basic materials, consumer discretionary, and healthcare will release their Q1 2025 earnings.
In April 2025, five tech giants—NVIDIA, Tesla, Meta, Palantir, and Amazon—each surged over 40%, driven by AI breakthroughs, strong earnings, and market momentum. Discover what fueled the rally and how Tickeron’s AI trading bots helped investors outperform even these star stocks.
#investment
Markets ended April with mixed signals—gold slid on trade optimism, Big Tech lifted the Nasdaq, and Bitcoin steadied near $94K. With U.S. GDP contracting and job growth beating forecasts, investors brace for more volatility amid tariffs and central bank moves.
In a turbulent market, Tickeron's AI-powered Double Agent Bot is outperforming traditional strategies. Leveraging real-time intraday signals and inverse ETFs, the bot posted a +9.77% quarterly gain while the S&P 500 dropped 9.28%. Here's how AI is reshaping trading.
#trading
As Warren Buffett announces his retirement, investors turn to his trusted Buffett Indicator—a ratio of market cap to GDP—as a key gauge of market valuation.
#investment
Markets move in repeating cycles—Accumulation, Uptrend, Distribution, and Downtrend. Learn how to recognize each phase and deploy Tickeron’s AI-powered Double Agent strategy to adapt, protect capital, and profit in any market condition.
#trading
Discover how confirmation trading techniques—like moving average crossovers and volume-backed breakouts—can improve accuracy and reduce false signals. Learn how Tickeron’s AI automates these strategies for smarter, faster, and more disciplined trading.
#trading
Hedge funds are ramping up bearish bets on small-cap stocks, with Russell 2000 short interest hitting new highs. As macro headwinds mount and technical support teeters, Tickeron’s AI Double Agents step in to navigate the looming sell-off with precision.
#investment#trading#artificial_intelligence
SPY’s Momentum Indicator turned bullish on April 25, 2025, signaling a potential trend shift with a 90% historical success rate. This article explores how economic scarcity, technical signals, and AI-driven tools like Tickeron’s A.I.dvisor shape investor decisions in volatile markets.
#trading