按照 https://github.com/tukuaiai/tradecat/blob/main/README.md 的说明帮我安装 TradeCat

要求：
1. 读取文档后直接执行安装命令，不要生成脚本
2. 一步一步执行，每步确认成功后继续
3. 遇到错误自动分析并修复
4. 安装完成后运行 ./scripts/verify.sh 验证
5. 全程零人工介入

环境要求

安装步骤

1. 克隆仓库

git clone https://github.com/tukuaiai/tradecat.git
cd tradecat

2. 安装系统依赖

# Ubuntu/Debian
sudo apt-get update
sudo apt-get install -y build-essential python3-dev

# 安装 TA-Lib
wget http://prdownloads.sourceforge.net/ta-lib/ta-lib-0.4.0-src.tar.gz
tar -xzf ta-lib-0.4.0-src.tar.gz
cd ta-lib && ./configure --prefix=/usr && make && sudo make install
cd .. && rm -rf ta-lib ta-lib-0.4.0-src.tar.gz

3. 一键初始化

# 初始化所有服务（创建虚拟环境、安装依赖、复制配置）
./scripts/init.sh

# 或单独初始化某个服务
./scripts/init.sh binance-vision-service

4. 配置环境变量

# 编辑 `assets/config/.env`（如不存在：cp assets/config/.env.example assets/config/.env && chmod 600 assets/config/.env）
vim assets/config/.env

关键配置补充（信号服务）：

• SIGNAL_DATA_MAX_AGE：信号数据最大允许时长（秒），超过则跳过不产生信号；默认 600，可按部署环境调整。
• COOLDOWN_SECONDS（signal-service）：PG 信号冷却时间（秒），可与规则级冷却配合，避免重复推送。

关键配置补充（nofx-dev，预览服务）：

• NOFX_*：nofx-dev 上游地址/鉴权等（见 assets/config/.env.example 的 NOFX 段落；nofx-dev 本身也有独立文档）。

5. 启动服务

# 启动所有服务
./scripts/start.sh start

# 查看状态
./scripts/start.sh status

# 停止全部
./scripts/start.sh stop

6. 验证安装

./scripts/verify.sh

数据概览

数据更新频率

导入步骤

# 1. 下载数据文件
# 从 HuggingFace 下载 .bin.zst 文件到 backups/timescaledb/

# 2. 恢复表结构（兼容 schema.sql.zst / schema_*.sql.zst）
zstd -d schema*.sql.zst -c | psql -h localhost -p 5433 -U postgres -d market_data

# 3. 导入 K线数据
zstd -d candles_1m.bin.zst -c | psql -h localhost -p 5433 -U postgres -d market_data \
    -c "COPY market_data.candles_1m FROM STDIN WITH (FORMAT binary)"

# 4. 导入期货数据
zstd -d futures_metrics_5m.bin.zst -c | psql -h localhost -p 5433 -U postgres -d market_data \
    -c "COPY market_data.binance_futures_metrics_5m FROM STDIN WITH (FORMAT binary)"

💡 导入后即可使用 trading-service 计算指标，无需从头采集历史数据。

蜡烛形态 (TA-Lib, 61种)

价格形态 (patternpy)

# 启动所有服务
./scripts/start.sh

# 停止所有服务
./scripts/stop.sh

# 查看服务状态
./scripts/status.sh

# 清理临时文件
./scripts/cleanup.sh

# 备份数据库
./scripts/backup.sh

# 检查日志
./scripts/logs.sh

# 重启特定服务
./scripts/restart.sh service_name

# 查看容器日志
docker logs container_id

# 清除旧容器和镜像
docker system prune -a

# 更新依赖库
pip install --upgrade -r requirements.txt

# 重新构建 Docker 镜像
docker build -t tradecat .

# 推送新镜像到仓库
docker push your-docker-repo/tradecat:latest

# 配置 CI/CD 流程
Edit .github/workflows/ci.yml

# 设置环境变量
export SERVICE_ENV=production

# 配置 Nginx 反向代理
Edit /etc/nginx/sites-available/default

# 启用 HTTPS
Certbot auto

# 监控 CPU 和内存使用
htop

# Analyze network traffic
iftop

# Check disk usage
df -h

# Optimize PostgreSQL queries
EXPLAIN ANALYZE query

# Tune TimescaleDB settings
ALTER TABLE table_name SET (timescaledb.compress_chunk_age = '7 days')

# Enable automatic scaling
AWS Auto Scaling Group

# Set up alerting systems
Prometheus + Grafana

# Implement load balancing
HAProxy

# Deploy on Kubernetes
kubectl apply -f kubernetes-deployment.yaml

# Monitor application performance
New Relic

# Conduct regular security audits
OWASP Top 10

# Update firewall rules
iptables -A INPUT -p tcp --dport 80 -j ACCEPT

# Train staff on best practices
Workshops and seminars

# Engage with community
Social media campaigns

# Collaborate with partners
Strategic alliances

# Explore new technologies
Blockchain integration

# Plan for future growth
Scalability strategies

# Maintain transparency
Public reports and updates

# Foster innovation
Hackathons and incubators

# Ensure sustainability
Environmental initiatives

# Build trust
Customer feedback loops

# Strengthen leadership
Executive coaching programs

# Promote diversity
Inclusion policies

# Celebrate achievements
Annual awards ceremonies

# Reflect on lessons learned
Post-mortem analyses

# Stay adaptable
Continuous learning

# Embrace change
Agile methodologies

# Focus on quality
ISO certifications

# Prioritize safety
Occupational health and safety standards

# Enhance customer experience
Personalized services

# Increase efficiency
Process optimization

# Expand market reach
International expansion

# Boost brand awareness
Marketing campaigns

# Drive revenue growth
Monetization strategies

# Reduce costs
Operational efficiencies

# Improve profitability
Financial planning

# Achieve long-term success
Visionary goals

# Inspire others
Leadership stories

# Contribute to society
Corporate social responsibility

# Leave a legacy
Sustainable development

# Continue the journey
Ongoing commitment

# Thank you for your support
Gratitude messages

# Stay connected
Regular communication

# Keep innovating
Future plans

# Be bold
Take risks

# Dream big
Ambitious visions

# Believe in possibilities
Positive mindset

# Act with purpose
Mission-driven actions

# Create impact
Meaningful contributions

# Share knowledge
Educational initiatives

# Encourage collaboration
Teamwork spirit

# Celebrate diversity
Inclusive cultures

# Protect the environment
Eco-friendly practices

# Support communities
Local engagement

# Uphold values
Ethical principles

# Maintain integrity
Honesty and transparency

# Foster hope
Optimistic outlook

# Inspire confidence
Self-assurance

# Cultivate gratitude
Appreciation for blessings

# Practice mindfulness
Present-moment awareness

# Seek balance
Holistic well-being

# Enjoy life
Simple pleasures

# Reflect on journey
Grateful memories

# Plan for next steps
Exciting adventures ahead

# Stay united
Strong bonds

# Celebrate together
Joyful moments

# Spread positivity
Kind gestures

# Build stronger relationships
Trust-based connections

# Promote peace
Harmonious coexistence

# Advocate for justice
Equitable treatment

# Fight for freedom
Empowerment initiatives

# Defend dignity
Respect for human rights

# Protect innocence
Child welfare efforts

# Support the vulnerable
Assistance programs

# Enhance education
Learning opportunities

# Improve healthcare
Medical advancements

# Advance technology
Innovative solutions

# Elevate culture
Artistic expressions

# Preserve heritage
Cultural traditions

# Celebrate diversity
Rich tapestry of identities

# Honor ancestors
Legacy of wisdom

# Learn from history
Lessons for today

# Shape the future
Inspiring generations

# Continue the legacy
Enduring impact

# Inspire future leaders
Mentorship programs

# Foster global cooperation
International partnerships

# Promote sustainable development
Global goals

# Contribute to humanity
Collective progress

# Leave a positive mark
Shared prosperity

# Achieve harmony
Universal well-being

# Realize dreams
Collective aspirations

# Build a better world
Collaborative efforts

# Continue the journey
Unending quest

# Stay hopeful
Bright prospects

# Believe in humanity
Innate goodness

# Trust in each other
Mutual reliance

# Support one another
Compassionate acts

# Spread love
Gentle gestures

# Foster understanding
Empathy and dialogue

# Promote tolerance
Open-mindedness

# Encourage respect
Mutual appreciation

# Build bridges
Connecting hearts

# Overcome divisions
Healing wounds

# Reunite communities
Restoring unity

# Restore faith
Hope renewed

# Revitalize spirits
Energy restored

# Refresh minds
Clarity regained

# Strengthen bodies
Health improved

# Enrich lives
Experiences enriched

# Celebrate life
Joyous moments

# Reflect on journey
Grateful heart

# Plan for next steps
Exciting adventures ahead

# Stay connected
Warm relationships

# Continue the journey
Unending exploration

# Stay hopeful
Bright hopes

# Believe in possibilities
Limitless potential

# Act with purpose
Mission-driven actions

# Create impact
Meaningful contributions

# Share knowledge
Educational initiatives

# Encourage collaboration
Teamwork spirit

# Celebrate diversity
Inclusive cultures

# Protect the environment
Eco-friendly practices

# Support communities
Local engagement

# Uphold values
Ethical principles

# Maintain integrity
Honesty and transparence

# Foster hope
Optimistic outlook

# Inspire confidence
Self-assurance

# Cultivate gratitude
Appreciation for blessings

# Practice mindfulness
Present-moment awareness

# Seek balance
Holistic well-being

# Enjoy life
Simple pleasures

# Reflect on journey
Grateful memories

# Plan for next steps
Exciting adventures ahead

# Stay connected
Warm relationships

# Continue the journey
Unending exploration

# Stay hopeful
Bright hopes

# Believe in possibilities
Limitless potential

# Act with purpose
Mission-driven actions

# Create impact
Meaningful contributions

# Share knowledge
Educational initiatives

# Encourage collaboration
Teamwork spirit

# Celebrate diversity
Inclusive cultures

# Protect the environment
Eco-friendly practices

# Support communities
Local engagement

# Uphold values
Ethical principles

# Maintain integrity
Honesty and transparence

# Foster hope
Optimistic outlook

# Inspire confidence
Self-assurance

# Cultivate gratitude
Appreciation for blessings

# Prac

# 启动所有服务
./scripts/start.sh start

# 查看状态
./scripts/start.sh status

# 停止全部
./scripts/start.sh stop

# 重启
./scripts/start.sh restart

# data-service（低频/分时兼容链路，支持守护模式）
cd services/ingestion/data-service
./scripts/start.sh start    # 启动（含守护）
./scripts/start.sh stop     # 停止
./scripts/start.sh status   # 状态
# ws 自愈：当 DB 长时间不再写入 1m K 线时，守护会自动重启 ws（可通过 DATA_SERVICE_WS_DB_* 配置）

# trading-service / telegram-service
cd services/compute/trading-service  # 或 services/consumption/telegram-service
./scripts/start.sh start    # 启动
./scripts/start.sh stop     # 停止
./scripts/start.sh status   # 状态

# api-service（Query Service，默认随顶层启动）
cd services/consumption/api-service
./scripts/start.sh start
./scripts/start.sh status

# 初始化全部服务
./scripts/init.sh

# 初始化单个服务
./scripts/init.sh binance-vision-service

./scripts/verify.sh

# data-service 日志
tail -f services/ingestion/data-service/logs/backfill.log
tail -f services/ingestion/data-service/logs/metrics.log
tail -f services/ingestion/data-service/logs/ws.log

# trading-service 日志
tail -f services/compute/trading-service/logs/service.log

# telegram-service 日志
tail -f services/consumption/telegram-service/logs/bot.log

# signal-service 日志
tail -f services/compute/signal-service/logs/signal-service.log

# 守护进程日志
tail -f logs/daemon.log

# 查看所有相关进程
ps aux | grep -E "data-service|trading-service|telegram|signal-service|src\\.simple_scheduler|main\\.py"

# 查看资源占用
htop -p $(pgrep -d',' -f "src\\.simple_scheduler|src\\.kline_listener|telegram-service|signal-service|uvicorn")

# 连接数据库
PGPASSWORD=postgres psql -h localhost -p 5433 -U postgres -d market_data

# 常用查询
-- K线数据量
SELECT COUNT(*) FROM market_data.candles_1m;

-- 最新数据时间
SELECT MAX(bucket_ts) FROM market_data.candles_1m;

-- 市场币种列表
SELECT DISTINCT symbol FROM market_data.candles_1m ORDER BY symbol;

-- 单币种数据
SELECT * FROM market_data.candles_1m 
WHERE symbol = 'BTCUSDT' 
ORDER BY bucket_ts DESC LIMIT 10;

# 初始化 DDL（仅需一次；会创建 tg_cards schema + 38 张表）
PGPASSWORD=postgres psql -h localhost -p 5433 -U postgres -d market_data \
    -f assets/database/db/schema/021_tg_cards_sqlite_parity.sql

# 查看表清单
PGPASSWORD=postgres psql -h localhost -p 5433 -U postgres -d market_data \
    -c "\\dt tg_cards.*"

# 抽样查询（注意：表名/列名含中文与 .py，必须双引号）
PGPASSWORD=postgres psql -h localhost -p 5433 -U postgres -d market_data \
    -c "SELECT \"交易对\",\"周期\",\"数据时间\",\"ATR百分比\" FROM tg_cards.\"ATR波幅扫描器.py\" WHERE \"周期\"='15m' ORDER BY \"数据时间\" DESC LIMIT 5;"

说明：当前指标库已统一为 PostgreSQL（tg_cards.*），不再写入/读取 market_data.db。
如你仍保留历史 SQLite 文件，可用以下方式临时查看（仅用于迁移期对账/回放）。

sqlite3 assets/database/services/telegram-service/market_data.db
.tables

# 运行导出脚本 (后台执行)
nohup ./scripts/export_timescaledb.sh &

# 查看进度
tail -f backups/timescaledb/export.log
ls -lh backups/timescaledb/

# 输出文件:
# - candles_1m_*.bin.zst      (~15GB, K线数据)
# - futures_metrics_*.bin.zst (~800MB, 期货数据)
# - schema_*.sql.zst          (表结构)
# - restore_*.sh              (恢复脚本)

cd backups/timescaledb

# 恢复 schema
zstd -d schema_*.sql.zst -c | psql -h localhost -p 5433 -U postgres -d market_data

# 恢复 K线数据
zstd -d candles_1m_*.bin.zst -c | psql -h localhost -p 5433 -U postgres -d market_data \
    -c "COPY market_data.candles_1m FROM STDIN WITH (FORMAT binary)"

# 恢复期货数据
zstd -d futures_metrics_*.bin.zst -c | psql -h localhost -p 5433 -U postgres -d market_data \
    -c "COPY market_data.binance_futures_metrics_5m FROM STDIN WITH (FORMAT binary)"

# 确保先安装系统库
sudo apt-get install -y build-essential

# 下载并编译 TA-Lib
wget http://prdownloads.sourceforge.net/ta-lib/ta-lib-0.4.0-src.tar.gz
tar -xzf ta-lib-0.4.0-src.tar.gz
cd ta-lib
./configure --prefix=/usr
make
sudo make install

# 然后安装 Python 包
pip install TA-Lib

# 检查 TA-Lib 是否安装
python -c "import talib; print(talib.__version__)"

# 检查形态库是否安装
pip install m-patternpy
pip install tradingpattern --no-deps

# 重启 trading-service
cd services/compute/trading-service
./scripts/start.sh restart

# 检查 PostgreSQL 是否运行
sudo systemctl status postgresql

# 检查端口
ss -tlnp | grep 5433

# 检查连接
PGPASSWORD=postgres psql -h localhost -p 5433 -U postgres -c "\l"