I have a table in snowflake as below:

I need to update columns “Velocity” & “Share_pt” based on the below scenario

for Velocity Column: for min of row_ts where velocity column is not unknow, update velocity column values with values from min row_ts valie and any unkonwn values after min row_ts should not be updated

Same for Share_pt column as well.

This logic should work on similar scenarios for the entire table.