alphax/app/db/migrations/0019_short_term_strategy_pool.sql
2026-06-04 23:33:21 +08:00

27 lines
1.3 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

INSERT INTO strategy_catalog (
strategy_code, strategy_name, strategy_version, status, mode, description, config_json, created_at, updated_at
) VALUES
('long_momentum_breakout_15m_1h_v1', '多头动量启动', '', 'active', 'paper_enabled', '15m当前突破叠加1H成交量/波动增强捕捉山寨币日内到1-3天启动段。', '{}', NOW()::TEXT, NOW()::TEXT),
('long_second_wave_pullback_1h_v1', '多头二波回踩', '', 'active', 'paper_enabled', '强势榜或放量币第一波后回踩EMA、箱体上沿或前高转支撑再次承接的短线策略。', '{}', NOW()::TEXT, NOW()::TEXT),
('short_breakdown_retest_1h_v1', '空头破位反抽', '', 'active', 'paper_enabled', '1H支撑或箱体下沿破位后反抽失败叠加15m弱确认和相对弱势的空头短线策略。', '{}', NOW()::TEXT, NOW()::TEXT)
ON CONFLICT(strategy_code) DO UPDATE SET
strategy_name=EXCLUDED.strategy_name,
status=EXCLUDED.status,
mode=EXCLUDED.mode,
description=EXCLUDED.description,
updated_at=NOW()::TEXT;
UPDATE strategy_catalog
SET status='retired',
mode='disabled',
updated_at=NOW()::TEXT
WHERE strategy_code IN (
'main_composite_v1',
'volume_ignition_1h_v1',
'intraday_momentum_15m_v1',
'box_retest_1h_v1',
'box_retest_4h_v1',
'compression_breakout_4h_v1',
'breakdown_retest_short_1h_v1'
);