I was using yahoo firehose table in YQL but it seems to my there is no updates in the past month.
For example, with this query select * from social.updates.search(0,100) where query="IBM";
The first entry I get is at Feb. 26, 2012. I try different queries and none of them have entries since Mar. 1, 2012 (espacially for AAPL which ends at Dec 6, 2011). I guess firehose table can access to thousands of updates per day, it makes no sense to get nothing in a month!