For the month/year(s) with the greatest number of sentiment scores > 0.5, find all economic events that are associated with headlines in that month/year(s). (Note score is -1 to 1)
--- Matthew
Query 4:
For each economic event, find all dates of headlines associated with that event and the minimum intraday volume among all those dates
--- Matthew
Query 5:
Find the index which was affected the most(largest % change), by a given economic event E.
--- Matthew (has to do with showing the Economy graph on this page)
Go to the outline to find the specific SQL, if you can generalize the SQL would make for a better app (for example for query 2, don't do > 0.5, rather do > any value inputted)
Query 2:
For the month/year(s) with the greatest number of sentiment scores > 0.5, find all economic events that are associated with headlines in that month/year(s). (Note score is -1 to 1) --- Matthew
Query 4:
For each economic event, find all dates of headlines associated with that event and the minimum intraday volume among all those dates --- Matthew
Query 5:
Find the index which was affected the most(largest % change), by a given economic event E. --- Matthew (has to do with showing the Economy graph on this page)
Go to the outline to find the specific SQL, if you can generalize the SQL would make for a better app (for example for query 2, don't do > 0.5, rather do > any value inputted)