web3 analytics

Introducing the New Pinax App, a Better Way to Manage Your Firehose and Substreams Services

Pinax Dec 08, 2023 1 Comment

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…

Simplify Real-Time Blockchain Analytics with ClickHouse

Substreams Dec 05, 2023 3 Comments

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, that’s…

DappLooker and the Power of Substreams

Substreams Oct 24, 2023 2 Comments

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…

Enhancing Web3 Analytics with Spyglass and Substreams

Substreams Oct 22, 2023 No Comments

Learn how Spyglass is building a cutting-edge web3 analytics platform to tackle the issues of complexity and slow access to blockchain data by harnessing the power of Substreams. The challenges of web3 analytics Web3 analytics have always been complex and time-consuming, involving hours of crafting extensive SQL queries on platforms like Dune Analytics. Another challenge is the delay in data…