You'll want to use the Twitter public timeline firehose - https://dev.twitter.com/docs/api/1.1/get/statuses/firehose
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])