# Total Columns in fin_equity: 53 (27 Newly Added + 26 Original Base Columns) PART 1: NEWLY ADDED COLUMNS (27 Columns) 10. figi - Type: VARCHAR(20) - Meaning: Bloomberg Financial Instrument Global Identifier (OpenFIGI). - Example: "BBG000B9XRY4" (AAPL), "BBG000MM2P62" (META) 12. pe_ratio - Type: DECIMAL(10,4) - Meaning: Trailing Price-to-Earnings ratio (stock price / last 12-month EPS). - Example: 39.9335 (Apple), 22.1375 (Meta) 13. fwd_pe - Type: DECIMAL(10,4) - Meaning: Forward Price-to-Earnings ratio based on projected future earnings. - Example: 36.3840 (Apple), 18.6462 (Meta) 14. beta - Type: DECIMAL(8,4) - Meaning: Stock volatility relative to the overall market (S&P 500 = 1.0). - Example: 1.0690 (Apple), 1.1850 (Meta) 24. target_price - Type: DECIMAL(12,4) - Meaning: Average 1-year target stock price predicted by Wall Street analysts. - Example: 328.3503 (Apple), 843.4800 (Meta) 25. inst_count - Type: INT - Meaning: Total number of institutional funds and firms holding this stock. - Example: 7707 (Apple), 6620 (Meta) 26. hld_inst_float_pcnt - Type: VARCHAR(20) - Meaning: Percentage of freely traded shares (float) held by institutions. - Example: "0.67457" (Apple = 67.46%), "0.79253" (Meta = 79.25%) 27. insider_pct - Type: DECIMAL(8,4) - Meaning: Percentage of shares held by company insiders (founders, executives). - Example: 0.0165 (Apple = 1.65%), 0.0015 (Meta = 0.15%) PART 2: ORIGINAL BASE COLUMNS (26 Columns) 38. hld_etf_mf - Type: INT - Meaning: Number of shares held by ETFs and Mutual Funds in thousands. - Example: 1889131 (Apple), 315072 (Meta) 39. hld_etf_mf_pcnt - Type: VARCHAR(20) - Meaning: Percentage of total shares held by ETFs and Mutual Funds. - Example: "12.94" (Apple), "14.29" (Meta) 40. hld_inst_shr - Type: INT - Meaning: Number of shares held by all institutional owners in thousands. - Example: 4658060 (Apple), 763981 (Meta) 41. hld_inst_shr_pcnt - Type: VARCHAR(20) - Meaning: Percentage of total shares held by institutions (raw decimal). - Example: "0.66345" (Apple = 66.35%), "0.79136" (Meta = 79.14%) 42. hld_ind_shr - Type: INT - Meaning: Number of shares held by individual/retail investors in thousands. - Example: 4669261 (Apple), 457850 (Meta) 43. hld_ind_shr_pcnt - Type: VARCHAR(20) - Meaning: Percentage of shares held by individual/retail investors. - Example: "0.32007" (Apple = 32.01%), "0.20716" (Meta = 20.72%) 44. hld_run_dt - Type: DATE - Meaning: Date when the shareholder metrics were updated. - Example: 2026-10-23 45. run_hld - Type: CHAR(1) - Meaning: Flag indicating whether holder update was executed ('Y' / 'N'). - Example: "Y" 46. chk_st_dt - Type: DATE - Meaning: Start date when this stock began being tracked. - Example: 2026-10-23 47. chk_lst_dt - Type: DATE - Meaning: Latest date when this record was checked and synchronized. - Example: 2026-10-23 48. chk_stat - Type: CHAR(1) - Meaning: Record check status flag ('N' = clean/ready, 'Y' = flagged). - Example: "N" 49. del_dt - Type: DATE - Meaning: Soft deletion date (NULL when company record is active). - Example: NULL 50. del_by - Type: INT - Meaning: User or process ID that marked row for deletion. - Example: NULL 51. del_day - Type: INT - Meaning: Soft-deletion retention day counter. - Example: NULL 52. archv_dt - Type: DATETIME - Meaning: Archive timestamp (NULL when record is active in primary table). - Example: NULL 53. archv_by - Type: INT - Meaning: User or process ID that archived the record. - Example: NULL