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.
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:
# Calculate Active Monthly EOA's from Polygon Transactions
DATE(TIMESTAMP_TRUNC(block_timestamp, MONTH, "UTC")) AS month,
COUNT(DISTINCT from_address) AS active_addresses
GROUP BY month
ORDER BY month DESC
After running the query, you will get the results which can then be exported as CSV/to Google Sheets for further analysis. You can also proceed to use Google Data Studio to generate interactive visualizations based on this data, by clicking on the ‘Explore Data’ button.
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.
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:
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 connectingSecured 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.
Polygon has teamed up with Axelar network, a secure communication layer that connects Web3 ecosystems, to enhance secure cross-chain communications of Polygon Supernets. Polygon Supernets technology allows for the creation of application-specific, scalable, and customizable blockchain networks. Axelar, one of our early adopters, will allow dApp users to securely transfer assets to and from Supernets...
Polygon has teamed up with Moralis and Google Cloud as an official Gold-Tier-Sponsor for the Moralis x Google 2022 Defining DeFi Hackathon! From Oct. 3 to Nov. 11, hundreds of developers around the world will build the DeFi applications of their dreams, competing for prizes, bounties, and rewards from a pool of $155,000, with $50,000...
Hola readers! We announced Polygon Bootcamp Africa, an eight-week intensive educational course and hackathon combo, in partnership with Xend Finance, Polygon-based carbon compensation project Coorest has become the first Web3 initiative to have an officially verified carbon standard, and Quadrata, a passport network bringing the identity and compliance layer to public blockchains, is integrating its...