Re:Ask HN: How to graph total tweets about "bitcoin" in give...
by makerops on Friday December 06, 2013 @11:22AM
(#6861821)
I think its hard/expensive to access the firehose no?
Re:Ask HN: How to graph total tweets about "bitcoin" in give...
by dylz on Friday December 06, 2013 @02:58PM
(#6863334)
Wasn't much of an issue for me but since he is somewhat new I imagine reading a stream and basically doing an infinite foreach would be a tad easier than adding queuing, API ratelimits (per hour? forget which), timed polling, etc.
Insert any matching bitcoin into your database with the associated time. Then you can sum/avg/aggregate it by time (within [epoch seconds] - [epoch seconds + 3600])