Popular Symbols Based on Social Data


Highest Avg. # Pulses / Day (+)

SELECT s.Id, s.Symbol, s.CName, COUNT(m.StockId) AS Pulse, DATEDIFF(Now(), PostCreationTime) AS days, ((COUNT(m.StockId)) / (DATEDIFF(Now(), PostCreationTime))) AS Average FROM Post p, PostStockMentions m, Stock s WHERE m.StockId = s.Id AND p.Id = m.PostId GROUP BY m.StockId ORDER BY Average DESC LIMIT 15

Symbol Company Name Pulses