calculations
Balance per user per date
Symbol Price per date
examples of produced variables from above :
Profit(user, date) can be calculated as : balance(user, date) - total value from transactions (user,date)
Profit(user, symbol, date) : balance(user, date) - total value from transactions (user,date)
Symbol price change (symbol,curr date, past date) = symbol price (curr date) - symbol(past date)
there will be two components
examples of produced variables from above : Profit(user, date) can be calculated as : balance(user, date) - total value from transactions (user,date) Profit(user, symbol, date) : balance(user, date) - total value from transactions (user,date) Symbol price change (symbol,curr date, past date) = symbol price (curr date) - symbol(past date)