FiFO with SQL

I am going to create small system/website that will allow me to manage my stocks, and monitor the portfolio. I do not have much of it, but I cannot access the data from wherever I want and it is not so dynamic. Beside the design itself I came across a problem of recreating a FIFO ...