In this presentation, we'll discuss our adoption of Apache Pinot to enhance real-time, user-facing analytics for Web3 applications. We'll explore how Pinot was integrated into our analytics stack and the specific use cases it now empowers, from handling massive data volumes to delivering instant query responses. The focus will be on the technical strategies and insights that enabled us to leverage Pinot's capabilities to meet the scalability and performance demands of the Web3 ecosystem.