Description: Verification of financial data change detection.
| Metric | Original Data | Revised Data | Change |
|---|---|---|---|
| Revenue | 100 Billion | 95 Billion | -5% |
| Net Profit | 10 Billion | 8 Billion | -20% |
| Earnings Per Share | 1.0 元 | 0.8 元 | -20% |
Data Events Query: SELECT * FROM data_events WHERE table_name = 'company_announcement' AND record_id = '123' AND event_type = 'UPDATE'
Data Quality Results Query: SELECT * FROM data_quality_results WHERE table_name = 'company_announcement' AND record_id = '123' AND rule_id = '456'
Description: Verification of public opinion mutation detection.
| Metric | Historical Data | Current Data | Change |
|---|---|---|---|
| Positive Sentiment | 70% | 20% | -50% |
| Negative Sentiment | 30% | 80% | +50% |
| News Count | 500 | 300 | -40% |
Historical Data Query: SELECT AVG(CASE WHEN sentiment IN ('very_positive', 'positive') THEN 1 ELSE 0 END) AS positive_sentiment FROM social_media_sentiment WHERE relevant_stock = '600520' AND date BETWEEN '2024-01-01' AND '2024-01-25'
Current Data Query: SELECT AVG(CASE WHEN sentiment IN ('very_positive', 'positive') THEN 1 ELSE 0 END) AS positive_sentiment FROM social_media_sentiment WHERE relevant_stock = '600520' AND date BETWEEN '2024-01-26' AND '2024-01-31'
Description: Verification of trading data abnormal fluctuation detection.
| Metric | Historical Data | Current Data | Change |
|---|---|---|---|
| Average Volume | 1000万股 | 5000万股 | +400% |
| Average Price Change | 2% | 10% | +400% |
| Volatility | 5% | 20% | +300% |
Historical Data Query: SELECT AVG(volume) AS average_volume FROM historical_trading_data WHERE stock_code = '600520' AND date BETWEEN '2024-01-01' AND '2024-01-25'
Current Data Query: SELECT AVG(volume) AS average_volume FROM historical_trading_data WHERE stock_code = '600520' AND date BETWEEN '2024-01-26' AND '2024-01-31'