Polygon Blockchain Datasets are now available on Google BigQuery!

Hosted by Google Cloud as a financial services public dataset, the Polygon blockchain dataset has been listed in the Google Cloud Marketplace, and can be found here.

Polygon aims to serve as Ethereum’s Internet of Blockchains, bringing massive scale to Ethereum via Polygon SDK, supporting stand alone chains and secured chains.

This dataset is part of a larger effort to make cryptocurrency data available in Google BigQuery through the Google Cloud Public Datasets program. The program is hosting a number of real-time cryptocurrency datasets, with plans to expand offerings to include additional distributed ledgers. You can find these datasets by searching for “crypto” in the GCP Marketplace. For analytics interoperability, Google has designed a unified schema that allows all Bitcoin-like datasets to share queries.

This public dataset is hosted in Google BigQuery and is included in BigQuery’s 1TB/mo of free tier processing. This means that each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets.

What is BigQuery?

Google BigQuery makes it simple to query on-chain data in a simple, organized manner on the cloud using standard SQL syntax. You can think of it like a massive indexer that allows you to perform powerful data analysis. You are also able to perform the same or similar queries on multiple blockchains at once and compare them, or track cross-chain activity on interoperable tokens.

Some possibilities unlocked using Google BigQuery on the Polygon Dataset include the ability to:

  • Monitor gas costs over time
  • Monitor a smart contract’s calls and activity
  • Multi-Chain Analysis for SDKs like the Polygon SDK
  • Integrate with traditional financial record processing systems
  • Determine the most active/popular tokens, contracts, or applications on Polygon
  • Audit groups of transactions

Blockchain analytics platform Nansen already built a Polygon dashboard that you can check out here.

Example of using BigQuery for Polygon Datasets

Interested in learning more about how the data from these blockchains were brought into BigQuery? Looking for more ways to analyze the data? Check out the Google Cloud Big Data blog post and try the sample queries to get started.

Who made this happen? It has been a pleasure to work with Helix TechnologiesNansen, and the Google Cloud Developer Relations team on this project.

We look forward to seeing how the vibrant developer community at Polygon uses this powerful platform to bring further utility to their Dapps!

Other relevant links:

About Google Cloud

  • Google Cloud Platform is a suite of cloud computing services that runs on the same infrastructure that Google uses internally for its end-user products, such as Google Search, Gmail, file storage, and YouTube.
  • Google BigQuery is a serverless, highly scalable, and cost-effective multi-cloud data warehouse designed for business agility.
  • GooglePublic Datasets provide a playground for those new to big data and data analysis and offers a powerful data repository of more than 100 public datasets from different industries, allowing users to join these with your own to produce new insights.

About Polygon

Polygon is the first well-structured, easy-to-use platform for Ethereum scaling and infrastructure development. Its core component is Polygon SDK, a modular, flexible framework that supports building and connecting Secured Chains like Plasma, Optimistic Rollups, zkRollups, Validium etc and Standalone Chains like Polygon POS, designed for flexibility and independence. Polygon’s scaling solutions have seen widespread adoption with 350+ Dapps, ~121M txns and ~1M+ unique users.

If you’re an Ethereum Developer, you’re already a Polygon developer! Leverage Polygon’s fast and secure txns for your Dapp, get started here.

More from the Polygon Blog
The Many Lives of Tokens

Tokens are the élan vital of Web3 networks, and projects are often perceived through the price at which they trade. But token price, subject to market sentiment and speculation, is not synonymous with token value. To understand the fundamentals, we must first unpack the different ways that value accrues to tokens in the new Internet […]

Read More
Going Beyond the Green Manifesto: Our New Impact Commitment 

With Ethereum’s Merge finally upon us, we’ve been thinking about how this historic milestone will affect our sustainability efforts. Polygon’s initial commitment to become carbon neutral and eventually carbon negative was largely addressing emissions generated by our relationship with Ethereum. The Merge dramatically changes that equation. Ethereum’s transition from Proof-of-Work to Proof-of-Stake consensus, known as […]

Read More
Starbucks Taps Polygon for Its 'Starbucks® Odyssey' Web3 Experience 

Today, we are thrilled to announce that Starbucks Coffee Company is working with Polygon to provide the blockchain technology to build its recently announced Web3 experience, Starbucks Odyssey. As a result of the partnership, this new Web3-powered experience will allow Starbucks Rewards loyalty program members and Starbucks partners (employees) in the United States to earn […]

Read More
Polygon Avail’s Ability to Scale: What We Can Improve Next

The Polygon Avail Testnet is now live. As users begin incorporating Avail into their chain designs, a question that often comes up is, “How many transactions can Avail process?” This is Part Two in a three-part series of articles that will address Polygon Avail’s current performance, as well as its ability to scale in the […]

Read More
Ethereum Merge FAQ and Common Misconceptions

Ethereum’s much-anticipated transition to the proof of stake (PoS) consensus, known as the Merge, is almost upon us. It’s a momentous event with broad-ranging implications for the greater Ethereum ecosystem. So we wanted to provide a definitive list of frequently asked questions (and answers) as well as address some of the common misconceptions, both of […]

Read More
Polygon-Powered Icetea Labs Accelerator Launches With 6 Startups

Polygon has teamed up with Alpha Venture DAO and Icetea Labs to launch the inaugural Icetea Labs Accelerator Program for blockchain startups.  Working in a tight three-way partnership, Polygon is co-creating an accelerator to funnel resources, mentorship, education, and business acumen to promising Web3 companies from around the world. The startups selected for the accelerator […]

Read More
Apply to Polygon Bootcamp Africa and Kickstart Your Web3 Developer Journey

Applications are open for Polygon Bootcamp Africa, launched in partnership with Xend Finance! The eight-week intensive educational course and hackathon combo will put developers in Africa on the Web3 map.  This is Polygon’s biggest step in providing resources to developers, builders, and creators in Africa, and it comes during an important time.  An internet and […]

Read More
ZK White Paper: Efficient ZK Proofs for Keccak

As part of our ongoing efforts to inform the Ethereum community about the efforts of Polygon’s zero-knowledge (ZK) teams, we will be posting a series of technical papers by our engineers and researchers. We hope that everyone who’s interested in the inner workings of Polygon’s ZK projects, Ethereum itself, and cryptographic engineering in general will […]

Read More
crossmenuchevron-down-circle