@A_G,
Building off of @anaptfox response above, using Notebooks and workflows will allow you to change the file type from CSV to JSON (question 1), with this process being performed by your Notebook. The output from that process can then trigger a workflow that places the data into a specific AWS bucket using the AWS Put Node (question 2).
For your third question, are you asking if you can preprocess the data to show a 30-day average prior to sending it to a Notebook or to AWS? Notebooks would be the preferred method of performing any batch processing/analytics. Let us know if we’ve misinterpreted your question.
To be clear, the process we’ve described would only work for data less than 5MB, which is the maximum size of the payload.
Thanks,
@Aidan_Zebertavage