o
    >`Èj   ã                   @   sè   d Z ddlZddlZddlZddlZddlmZ ddlmZmZm	Z	 ddl
mZ ddlmZ ddlZeeƒ ¡ jZedƒZeeejƒdkrJejd nd	 Zddd„Zdd„ Zdd„ Zdd„ Zddd„Zedkrreejdd… Ž  dS dS )a8  
up2_styles_build.py -- [2026-10-08] The user: "find all styles of stocks that went 2-3% above the open price", 5 years
first (2021-10 .. now; the other 5 later if it is interesting). Step 1 of 2: one row per stock-day -> CSV.
Universe: bars10y (every $5-15 stock with >= 500k shares that day). Scanner-like = the day's top 30 by the v3 score
(pm_history, same formula as score_weights_10y.py).
For each level L = +2% / +3% over the official open: the first minute the high reaches it, the STYLE of the path up
to that minute (only what was known then), the features at that minute, and what happened after.
  STYLE (first match):  deep V      the low before the hit was <= -3% under the open
                        dip, then up  the low before the hit was <= -1% under the open
                        straight      hit in the first 15 min (no 1% dip)
                        late move     hit at 14:00 or later
                        base break    the 30 bars ending 5 bars before the hit stayed in a <= 1% range
                        slow grind    hit after >= 60 min with a straight path (efficiency >= 0.25)
                        choppy        the rest
  GAP: up >= +3%, down <= -3%, else flat.
  AFTER: max gain after the hit (vs the open), +5% reached, back to the open, which came first, close vs open;
         trade = buy at the level (or the bar's open if it gapped through), sell at the close / or +5% target vs the
         open-price stop (both in one bar = stop). Stored GROSS (no cost).
    python3 up2_styles_build.py [START] [END]     default 2021-10-08 .. 2026-12-31
é    N)Údefaultdict)ÚdatetimeÚ	timedeltaÚtimezone)ÚPath)ÚZoneInfozAmerica/New_Yorké   zup2_styles_rows.csv.gzç        ç      ð?c                 C   s   t t| |ƒ|ƒS ©N)ÚminÚmax)ÚxÚloÚhi© r   ú?/var/www/screener/trade/reports/open_window/up2_styles_build.pyÚ<lambda>#   s    r   c              	      sn  t d | › d� }| ¡ stƒ S g }t t |d¡¡d D ]Š‰ ‡ fdd„}|dƒ|dƒ|d	ƒp0d
|dƒ|dƒˆ  d¡f\}}}}}}	|rN||krN|| d nd}
|
|
ksX|
dkrZdn|
}
||krbdn|}dt|
d ƒ dtt	|ƒd ƒ  dt|d ƒ  d|rŒ||krŒt|| d ƒnd
  d|	d u r–dnt|	d ƒ  }| 
|ˆ d f¡ qdd„ t|dd�d d… D ƒS )NÚ
pm_historyz.json.gzÚrtÚrowsc                    s   ˆ   | ¡d urˆ   | ¡S tjS r   )ÚgetÚnpÚnan)Úk©Úrr   r   r   ,   s    zv3_top30.<locals>.<lambda>Ú
prev_closeÚatrÚpm_volr   Úadv20ÚgapÚdistéd   r	   é   é#   é
   é   g     jø@gš™™™™™©?é   é   Úsc                 S   s   h | ]\}}|’qS r   r   )Ú.0Ú_r*   r   r   r   Ú	<setcomp>4   ó    zv3_top30.<locals>.<setcomp>T)Úreverseé   )ÚHEREÚexistsÚsetÚjsonÚloadÚgzipÚopenr   ÚclÚabsÚappendÚsorted)ÚdayÚfÚscÚgÚpcr   ÚpmvÚadvr!   r"   Úatrpr*   r   r   r   Úv3_top30&   s"   :2"ÿÿrD   c           
      C   sø   t  dt j¡}| D ]7\}}}}}}t |tj¡ t¡}|j	d d |j
 d }	d|	  kr1dk r@n q	|||||f|d d …|	f< q	t  |d ¡sSt  |d ¡ ¡ d	krUd S td
dƒD ]}	t  |d|	f ¡ry|d|	d
 f |dd…|	f< d|d|	f< qZ|S )N)é   é†  é	   é<   r0   r   rF   ©r   r   r   éx   r(   é   )r   Úfullr   r   Úfromtimestampr   ÚutcÚ
astimezoneÚETÚhourÚminuteÚisnanÚsumÚrange)
ÚbarsÚaÚtÚoÚhÚlÚcÚvÚttÚmr   r   r   Úarrays7   s   ,€$(€r`   c           "      C   sÒ  | \}}}}}	|d|d   }
t  |d d… |
k¡d }t|ƒs"d S t|d ƒ}|r<t|d |d …  ¡ | d ƒd nd}|rPt  t  |d |d … ¡¡ ¡ nd}|dkr^|| | | nd}|dkr€||d |d …  	¡ ||d |d …  ¡  | d nt j
}|d	krŠd
}n-|dkr‘d}n&|dk r˜d}n|dkrŸd}n||krª|dkrªd}n|dkrµ|dkrµd}nd}|	d |d …  ¡ }|d |d … |d |d …  |d |d …  d |	d |d …   ¡ }|rë|| n|| }|	t	d|d ƒ|d …  ¡ }|	d |d …  ¡ }|�r|d |…  	¡ | d d nd}t	|
|| ƒ}||d d… ||d d… }}tt	|| t|ƒ�rA| 	¡ n|| ƒ| d ƒd }t  ||d k¡d }t  ||k¡d }t|ƒ�rj|d nd}t|ƒ�ru|d nd}||k �r~dn|dk �r…dnd} ||k�r“|dk �r“d} | dk�r£|d | d d }!n| dk�r±|| d d }!n
|d | d d }!i d|“d |“d!t|d"ƒ“d#t|d"ƒ“d$t|dƒ“d%||k�rßt|d"ƒnd&“d'|�rìt|| dƒnd&“d(|�rùt|| d"ƒnd&“d)t|| | d d d"ƒ“d*|�rt|| d"ƒnd&“d+t|d"ƒ“d,| “d-tt|d | d ƒd d"ƒ“d.tt|d | d ƒd dƒ“d/tt|!ƒdƒ“d0ttt|ƒ�r]|d t	dt|dƒƒ…  ¡ n|| d ƒd d"ƒ“S )1Nr(   r#   i‚  r   r	   r
   r%   rE   éýÿÿÿzdeep Véÿÿÿÿzdip, then upé   Ústraighti  z	late movez
base breakrH   g      Ð?z
slow grindÚchoppyr   rK   rF   gÍÌÌÌÌÌð?iç  z+5%r7   Úneitheré…  r_   ÚstyleÚ
low_beforeé   Ú	hi_beforeÚeffÚbaseÚ ÚrvolÚacc5Úvwap_pctÚatr_xÚ	max_afterÚfirstÚ	close_pctÚtr_closeÚ	tr_5_openÚmae)r   ÚwhereÚlenÚintÚfloatr   r9   ÚdiffrT   r   r   ÚmeanÚround)"rW   ÚOÚpctrB   rC   ÚOpÚHÚLÚCÚVÚlvÚhitr   Úlow_bÚpathrl   rm   ÚstÚcvÚpvÚvwapÚv5ÚvallÚhi_bÚeÚHaÚLaÚmxÚt5Út0Úf5Úf0rt   Útrr   r   r   ÚlevelE   sn   ,(FH2&"4(,  2ÿÿþþý
üüüûû@úr›   ú
2021-10-08ú
2026-12-31c                 C   s*  t td  d¡ƒ}ttƒ}t | ¡tdd�  ¡  	¡ }d }d}t
jtddd���]}d }|D �]O}	|	jd d	… }
|
|kr> �n@|
|k rCq-|
| k }t t
 |	d
¡¡}| di ¡}|�sKt|
ƒ}|d  ¡ D ]ç\}}||vrlqc|| d d… \}}}}}}|| }t|ƒdkr’t dd„ |dd … D ƒ¡nd }d }t|ƒdkr»dd„ t|dd … |dd … ƒD ƒ}t |¡|d d  d }t|ƒ}|d u rÄqct|d ƒ}|
|t||v ƒ|rÞt|| d d dƒnd|ræt|dƒndtt|d  ¡ | d ƒd dƒtt|d | d ƒd dƒdœ}dD ]$}t|||||ƒ}dD ]}|d u �rdn|| |d|› d|› �< �q�q
|d u �rAtj|t|ƒd �}| ¡  |  |¡ |d7 }qc| ¡ D ]"\}}||  !|d |d |d! |d" f¡ || d#d … ||< �qO~|�s}t"|
|d$d%� q-W d   ƒ n	1 �s‰w   Y  t"d&|ƒ d S )'NÚbars10yz*/*.json.gzrH   )Údaysr   Úwtrn   )Únewliner&   r   ÚdailyrV   é   rE   c                 S   s   g | ]}|d  ‘qS )r   r   )r+   r   r   r   r   Ú
<listcomp>ˆ   r.   zmain.<locals>.<listcomp>iìÿÿÿc              	   S   sH   g | ] \}}t |d  |d  t|d  |d  ƒt|d |d  ƒƒ‘qS )r   r(   rj   )r   r9   )r+   ÚpÚbr   r   r   r¤   ‹   s   H iñÿÿÿiòÿÿÿrb   rj   r#   rI   r(   )r   rg   )r<   ÚsymÚscanr!   rC   Úday_maxru   )rj   r   )r_   rh   ri   rk   rl   rm   ro   rp   rq   rr   rs   rt   rv   rw   rx   r[   r,   )Ú
fieldnamesr   rK   iëÿÿÿT)ÚflushÚUP2_BUILD_DONE)#r;   r1   Úglobr   Úlistr   Úfromisoformatr   ÚdateÚ	isoformatr6   r7   ÚOUTÚnamer4   r5   r   rD   Úitemsrz   r   r~   Úzipr`   r|   r{   r   r   r›   ÚcsvÚ
DictWriterÚwriteheaderÚwriterowr:   Úprint)ÚstartÚendÚfilesÚhistÚ	warm_fromÚcolsÚnÚfhÚwr=   r<   ÚwarmÚdr¢   Útopr*   rV   r€   r,   Úvolr@   ÚhsrB   rC   rš   rW   Úrowr�   r   Úkkr   r   r   r   Úmainp   sh   
,$*0þ*þ
>€Ö+rË   Ú__main__r(   )r	   r
   )rœ   r�   )Ú__doc__r¶   r6   r4   ÚsysÚcollectionsr   r   r   r   Úpathlibr   Úzoneinfor   Únumpyr   Ú__file__ÚresolveÚparentr1   rP   rz   Úargvr²   r8   rD   r`   r›   rË   Ú__name__r   r   r   r   Ú<module>   s*     

+4ÿ