📊 Data Quality Report

Generated: 2026-01-02 16:00:02 IST

📋 Table Inventory

Table Today Yesterday Coverage Status
📊 Daily Ingestion (Critical)
delivery_1d 3,068 3,077 1825 days ✅
ohlcv_1d 3,068 3,077 1837 days ✅
participant_oi 5 5 2194 days ✅
bulk_block_deals 54 94 11 days ✅
insider_trading 58 41 4042 days ✅
📈 Options Data (Pending Setup) - Options ingestion not yet configured - tables exist but empty.
option_chain_history 8 8 9 days 🟡
option_chain_intraday 208,808 203,150 6 days ✅
📋 Screener (Weekly/Quarterly) - Static data updated weekly. Today/Yesterday show total rows.
screener_ratios 1,000 1,000 static ✅
screener_quarterly 6,356 6,356 static ✅
screener_annual 5,385 5,385 static ✅
screener_balance_sheet 5,416 5,416 static ✅
screener_cashflow 5,415 5,415 static ✅
screener_shareholding 5,682 5,682 static ✅
⚡ Real-time (L1 Ingestion)
stream_ticks 8,647,893 8,073,325 12 days ✅
ohlcv_1m 183,174 176,092 20456 days ✅
intraday_signals 0 0 1 days ✅

🔄 Continuity Check (Last 7 Trading Days)

Table 24/1226/1229/1230/1231/1201/0102/01 Status
delivery_1d ✓✓✓✓✓✓✓ ✓
ohlcv_1d ✓✓✓✓✓✓✓ ✓
participant_oi ✓✓✓✓✓✓✓ ✓
bulk_block_deals ✓✓✓✓✓✓✓ ✓
insider_trading ✓✓✓✓✓✓✓ ✓
option_chain_history ✗✗✓✓⚠⚠⚠ ✗ 2 missing
option_chain_intraday ✓✓✓✓✓✓✓ ✓
stream_ticks ✓✓✓✓✓✓✓ ✓
ohlcv_1m ✓✓✓✓✓✓✓ ✓
intraday_signals ✓✓✓✓✓✓✓ ✓

✅ Quality Checks

TableCheckViolationsStatus
delivery_1d null_check 0 ✓
ohlcv_1d null_check 0 ✓
bulk_block_deals null_check 0 ✓
insider_trading null_check 0 ✓
option_chain_history null_check 0 ✓
stream_ticks null_check 0 ✓
intraday_signals null_check 0 ✓
⚠️ ISSUES DETECTED - Review above