📊 Data Quality Report

Generated: 2025-12-27 12:22:00 IST

📋 Table Inventory

Table Today Yesterday Coverage Status
📊 Daily Ingestion (Critical)
delivery_1d 0 3,090 1825 days ❌
ohlcv_1d 0 3,090 1830 days ❌
participant_oi 0 10 2187 days ❌
bulk_block_deals 0 62 4 days ✅
insider_trading 0 32 4035 days ✅
📈 Options Data (Pending Setup) - Options ingestion not yet configured - tables exist but empty.
option_chain_history 0 0 1 days ❌
option_chain_intraday 0 0 1 days ✅
📋 Screener (Weekly/Quarterly) - Static data updated weekly. Today/Yesterday show total rows.
screener_ratios 500 500 static ✅
screener_quarterly 6,356 6,356 static ✅
screener_annual 5,383 5,383 static ✅
screener_balance_sheet 5,414 5,414 static ✅
screener_cashflow 5,412 5,412 static ✅
screener_shareholding 5,678 5,678 static ✅
⚡ Real-time (L1 Ingestion)
stream_ticks 0 8,335,308 5 days ❌
ohlcv_1m 0 180,880 20449 days ❌

🔄 Continuity Check (Last 7 Trading Days)

Table 17/1218/1219/1222/1223/1224/1226/12 Status
delivery_1d ✓✓✓✓✓✓✓ ✓
ohlcv_1d ✓✓✓✓✓✓✓ ✓
participant_oi ✓✓✓✓✓✓✓ ✓
bulk_block_deals ✓✓✓✓✓✓✓ ✓
insider_trading ✓✓✓✓✓✓✓ ✓
option_chain_history ✗✗✗✗✗✗✗ ✗ 7 missing
option_chain_intraday ✓✓✓✓✓✓✓ ✓
stream_ticks ✗✗✗⚠✓✓✓ ✗ 3 missing
ohlcv_1m ✗✗✗⚠✓✓✓ ✗ 3 missing

✅ 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 ✓
⚠️ ISSUES DETECTED - Review above