Skill UI

This comprehensive guide provides advanced workflows for interacting with ClickHouse. It covers efficient bulk data insertion (CSV, JSON), complex analytical querying (funnel analysis, retention), implementing materialized views for pre-aggregation, and utilizing powerful window functions. Ideal for building high-performance OLAP dashboards and executing large-scale data transformations.

This comprehensive guide teaches users how to set up a ClickHouse database environment. It covers creating a MergeTree table, inserting structured event data using TypeScript, and executing essential analytical queries (e.g., counting, grouping, unique user metrics). Ideal for beginners learning OLAP databases, testing connections, or mastering core data warehousing concepts.

This guide provides comprehensive steps for setting up and authenticating the official ClickHouse client for both Node.js and Python. It covers connecting to ClickHouse Cloud or a self-hosted instance, managing environment variables, and verifying the connection using sample code snippets. Ideal for new ClickHouse projects or integrating data analytics pipelines into existing applications.

This specialized skill provides a robust framework for tracking and updating financial investment signals. It systematically assesses the impact of new market information—such as breaking news or price movements—on existing investment theses. The system determines if a signal is Strengthened, Weakened, Falsified, or Unchanged, providing a crucial layer of continuous signal validation for sophisticated financial decision-making.

A comprehensive tutor designed to build robust statistical thinking. It guides users through the entire data analysis lifecycle, from exploratory data visualization and descriptive statistics to complex hypothesis testing and regression modeling. The focus is on understanding the 'why' and 'how' of statistical logic using real datasets and practical problems, rather than just memorizing formulas. It is tool-agnostic, supporting concepts learned in Python, R, SPSS, or Stata.

This advanced technique allows users to identify an obscure actor by linking indirect clues across three domains: the director, the film's characteristics, and the actor's biographical details. It is essential when direct searches fail, using the director's work or a film's context as the primary entry point to resolve the actor's identity.

This skill aggregates real-time financial information, including hot news articles and market trends from multiple sources (e.g., Weibo, Zhihu). It is also capable of retrieving structured data from prediction markets like Polymarket. Use this when you need a unified, comprehensive view of the financial market landscape, spanning breaking news, aggregated sentiment, and forward-looking market predictions.

This skill provides a comprehensive workflow for generating professional and structured financial reports. It guides the user through planning, writing, and editing various sections, and can also generate necessary chart configurations using visual tools. Ideal for condensing complex financial analysis into clear, actionable reports.

A comprehensive skill designed for finance-related information retrieval. It provides dual search capabilities: real-time web searching across multiple engines (Jina, DDG, Baidu) for general market knowledge, and Retrieval-Augmented Generation (RAG) for querying local, proprietary document stores (e.g., daily news). Ideal for financial analysts needing both broad market context and specific internal data insights.

This skill enables searching for stock tickers across A-Share, HK, and US markets. It can retrieve comprehensive historical price data (OHLCV) over specified date ranges, and also fetches crucial fundamental financial metrics such as market capitalization, P/E ratio, and industry sector information. Use this tool when needing to analyze the past or current performance of a publicly traded company.

Execute comprehensive, asynchronous transcription workflows using AssemblyAI. This tool handles file upload, queues jobs, and provides advanced audio intelligence features. Capabilities include speaker diarization, sentiment analysis, named entity recognition (NER), topic categorization (IAB), content safety moderation, and sensitive PII redaction. Ideal for processing meeting recordings, interviews, and large volumes of spoken content.

This skill provides comprehensive access to Bright Data's SERP API and Web Scraper API. It allows users to collect structured search engine results (Google, Bing, Yahoo) synchronously, or trigger large-scale, asynchronous data collections with webhooks. Ideal for market research, SEO analysis, and large-scale data scraping projects.