a JOj@sdZddlZddZdS)u& 大股东质押比例信号计算。 NcCs2d}tj||dtid}|ddd|d<|S)u'获取所有股票最新质押比例。zo SELECT DISTINCT ON (code) code, pledge_ratio FROM pledge_ratio ORDER BY code, trade_date DESC code)dtype pledge_ratiocSst|r|dkrdSdS)N2r)pdnotna)xr 4/tmp/quant_ocf_run_20260709_v2/ocf/signals/pledge.pyzfetch_pledge..pledge_high_flag)rread_sqlstrapply)connsqldfr r r fetch_pledgesr)__doc__pandasrrr r r r s