pandadata-warehouse

Build, repair, query, and maintain a local Pandadata market-data warehouse backed by DuckDB and Parquet for repeat quant research, backtests, factor studies, and batch reports. Use when the user asks to cache Pandadata or panda_data results locally, create or update a local market-data database layer, perform incremental data refreshes, query downloaded data with DuckDB SQL, design table partitions and watermarks, validate local data against Pandadata APIs, or avoid repeated Pandadata API calls.

الانتقال إلى التثبيت

المستودع: quantskills/skill-pandadata-warehouse
آخر نشاط في المصدر: ١١ أغسطس ٢٠٢٦ في ٠٨:٢٢
لغة SKILL.md المكتشفة: الإنجليزية
النجوم: ٠
التفرعات: ٠

خيارات التثبيت

يُحدَّد Prompt الذي يراجع المصدر أولًا بشكل افتراضي. يمكنك التبديل إلى أمر مباشر أو تنزيل نسخة محلية.

التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.

يتجاوز الأمر المباشر Prompt المخصّص للمراجعة. افحص المصدر قبل تشغيله.

npx skills add https://github.com/quantskills/skill-pandadata-warehouse --skill pandadata-warehouse

يبقى الأمر في سطر واحد. مرّر أفقيًا لمراجعته كاملًا قبل النسخ.

تفضّل نسخة محلية؟ نزّل الملفات المتاحة حاليًا لدى SkillsMP.

مراجعة ملفات المصدر

اقرأ SKILL.md وأي ملفات مرافقة يعرضها SkillsMP قبل أن تقرر التثبيت.

SKILL.md

تعليمات المصدر · معاينة للقراءة فقط

العودة إلى البحث العودة إلى التثبيت

name	pandadata-warehouse
description	Build, repair, query, and maintain a local Pandadata market-data warehouse backed by DuckDB and Parquet for repeat quant research, backtests, factor studies, and batch reports. Use when the user asks to cache Pandadata or panda_data results locally, create or update a local market-data database layer, perform incremental data refreshes, query downloaded data with DuckDB SQL, design table partitions and watermarks, validate local data against Pandadata APIs, or avoid repeated Pandadata API calls.
quantSkills	{"schema_version":"2.1.0","organization":"quantskills","organization_url":"https://github.com/quantskills","repository":"skill-pandadata-warehouse","repository_url":"https://github.com/quantskills/skill-pandadata-warehouse","project_type":"skill","license":"GPL-3.0-only","maintainer":"abgyjaguo","collection":"pandadata-warehouse","catalog":{"category":"01","subcategory":"01.warehouse-cache"},"workflow":{"primary_stage":"data-ingestion","workflow_stages":["data-ingestion","data-quality"]},"tags":["pandadata","warehouse","duckdb","parquet","data-engineering"],"platforms":["cursor","claude-code","codex","hermes","openclaw"],"status":"stable","requires":["skill-pandadata-api"],"validation_level":"runnable","maintainer_type":"community","summary_en":"Manages local Pandadata DuckDB and Parquet quantitative data warehouses, caches, and queries.","summary_zh":"管理本地Pandadata DuckDB和Parquet量化数据仓库、缓存和查询流程。","interface":{"mode":"structured","envelope":{"name":"quantskills-envelope","version":"1.0.0"},"inputs":[],"outputs":["[Truncated]"],"adapters":[]}}

{
  "version": 1,
  "task": {
    "placeholder": "补充数据表、接口、分区、SQL 查询、校验或修复要求"
  },
  "fields": [
    {
      "key": "operation",
      "label": "仓库操作",
      "type": "select",
      "default": "refresh",
      "options": [
        { "value": "initialize", "label": "初始化仓库" },
        { "value": "refresh", "label": "增量刷新" },
        { "value": "query", "label": "SQL 查询" },
        { "value": "validate", "label": "数据校验" },
        { "value": "repair", "label": "修复仓库" }
      ]
    },
    {
      "key": "asset_class",
      "label": "资产类别",
      "type": "select",
      "default": "stock",
      "options": [
        { "value": "stock", "label": "A 股" },
        { "value": "index", "label": "指数" },
        { "value": "future", "label": "期货" },
        { "value": "option", "label": "期权" },
        { "value": "hk_us", "label": "港美股" },
        { "value": "factor", "label": "研究因子" }
      ]
    },
    {
      "key": "universe",
      "label": "标的范围",
      "type": "textarea",
      "placeholder": "代码列表、指数成分或明确的下载范围；分钟数据必须限定范围"
    },
    {
      "key": "start_date",
      "label": "开始日期",
      "type": "date"
    },
    {
      "key": "end_date",
      "label": "结束日期",
      "type": "date"
    },
    {
      "key": "warehouse_path",
      "label": "仓库路径",
      "type": "text",
      "placeholder": "留空则使用 ~/.pandadata/warehouse"
    }
  ],
  "prompt_template": "{{#task}}任务与材料：\n{{task}}\n\n{{/task}}{{#attachments}}用户上传的材料（已放入工作区）：\n{{attachments}}\n\n{{/attachments}}请对 Pandadata 本地仓库执行 {{operation}}，资产类别为 {{asset_class}}。{{#universe}}标的范围：{{universe}}。{{/universe}}{{#start_date}}开始日期：{{start_date}}。{{/start_date}}{{#end_date}}结束日期：{{end_date}}。{{/end_date}}{{#warehouse_path}}仓库路径：{{warehouse_path}}。{{/warehouse_path}}确认真实 API 契约，以分区 Parquet 保存原始字段并通过 DuckDB 暴露视图；优先增量、保持可恢复，校验覆盖范围、重复键、行数与 API 抽样，任何破坏性修复先列出影响并征得确认，输出中文报告。"
}