insert into newly_acquired_stocks
        select * from my_stocks
        where rownum < = (select count(*)/2 from my_stocks);

this will work out check it out