Discover how we’re building our datasets for exceptional efficiency, ease of use, and performance. TL;DR: Pinax’s datasets simplify blockchain data access using Parquet files and S3. This combination provides efficient storage, accelerated query performance, and seamless integration with various analytics tools. Raw blockchain data is structured using SQL schema, making it readily available for analysis. Our datasets offer a user-friendly…
web3 analytics
TL;DR: Pinax datasets simplify accessing blockchain data, making it easy for analysts to focus on analysis without needing specialized tools. Accessing blockchain data for analysis is complex, especially for analysts without specialized blockchain data extraction knowledge, but demand in this space is growing. Pinax will soon offer datasets that make it effortless for anyone to access blockchain data for analysis…
TL;DR: Substreams and ClickHouse revolutionize blockchain data handling, as demonstrated by Pinax co-op students Maryam and Syed in their insightful bulk-loading project. Handling and analyzing vast amounts of blockchain data is a challenge in a rapidly evolving digital landscape. Substreams and ClickHouse are two powerful technologies that promise to revolutionize the way we manage and analyze blockchain data. In this…
Use this quick overview and easy step-by-step to get started with ClickHouse. TL;DR: For developers new to ClickHouse: learn what it is, why you should care, and how you can use it, including instructions to get started. This is the first article in our analytics developer quickstart series. Are you a developer looking for a database management system that is…
Your curated news source for web3 and The Graph. The web3 space and blockchain technology evolve rapidly, especially in an ecosystem as complex as The Graph Protocol. Due to a chain-agnostic model, The Graph has touchpoints with many other ecosystems. This makes it even more difficult to keep up with all the latest news and developments. So how can you…
The Substreams-Sink Library is a tool that makes it easy to create sinks in TypeScript to route blockchain data to any destination you need. Whether you need to stream data to a database, a messaging queue, or a text file, the Substreams-Sink Library has you covered. This article will cover how to install Substreams-Sink, its benefits, and how to create…
Unlock powerful analytics with Messari standardized subgraphs. TL;DR: Led by Dylan from Messari, this session provides an in-depth exploration of subgraphs, covering their critical role in data analysis, the tools for building and managing them, and how to contribute to the Messari subgraph repository, emphasizing community and open-source development. Builders Office Hours session #9 was a standout event, featuring Dylan…
We’re excited to announce the launch of our new and improved Pinax app, a web-based platform that helps you easily manage your Pinax Firehose and Substreams services. Whether you’re an indexer, a developer, or a curious explorer, the new app will help you get the most out of our services. If you’ve been using the old app, which is no…
TL;DR: ClickHouse Sink revolutionizes blockchain data analytics by offering a fast, flexible, and user-friendly platform for efficient data extraction and processing. Hey there! Let’s dive into the world of blockchain analytics and see how ClickHouse is changing the game. ClickHouse isn’t just any database; it’s a powerhouse for crunching big data in real time. And when it comes to blockchain,…
Discover how DappLooker leverages Substreams to deliver real-time data for their web3 analytics. Ever wondered how DappLooker, a leading no-code analytics platform, manages to provide real-time data? The answer lies in the magic of Substreams. This video provides a dive deep into how DappLooker uses Substreams to revolutionize web3 analytics. The journey of DappLooker DappLooker uses Substreams in their approach…