On the Economy page, you will want to additionally show related headlines for a time frame, etc, goes along with the SQL Queries we wrote. Check the SQL Query outline to find the SQL code.
Query 1: Find the day with the highest close for intraday turnout for each month where headlines exist and calculate the average sentiment score for the headlines on those days. ---- Anant
Query 3:
On the day of Dow 30’s 5 worst openings, print the name of the worst headline by sentiment score --- Anant
Query 4:
For each index, return the headline with the largest sentiment score on the day of it’s largest intraday turnout. --- Anant
Query 5:
For a given index, Idx, find the day with the largest change and return all the headlines associated with that date --- Anant
Where you can try to generalize the query functionality -- for example for query 1, you can replace with highest close or volume, or what not -- just a word replacement. This is second priority though.
On the Economy page, you will want to additionally show related headlines for a time frame, etc, goes along with the SQL Queries we wrote. Check the SQL Query outline to find the SQL code.
Query 1: Find the day with the highest close for intraday turnout for each month where headlines exist and calculate the average sentiment score for the headlines on those days. ---- Anant
Query 3: On the day of Dow 30’s 5 worst openings, print the name of the worst headline by sentiment score --- Anant
Query 4: For each index, return the headline with the largest sentiment score on the day of it’s largest intraday turnout. --- Anant
Query 5: For a given index, Idx, find the day with the largest change and return all the headlines associated with that date --- Anant
Where you can try to generalize the query functionality -- for example for query 1, you can replace with highest close or volume, or what not -- just a word replacement. This is second priority though.