Hello, everyone!
After doing some research on the web and talking with my working partners, I ended up finding a way to structure this table.
First, I constructed a table with all the historical data, adding the calculated fields I needed. Then I made a query that consults the max date of the historical table, filtering all the data that's greater than this max date, and inserts them on the historical table.
I don't know if this is the best way in performance, but it's running pretty fast.
Anyway, if someone knows a better format to do this type of script, I'm open for suggestions.
Thanks!