Well hello there possible Twitter bots ...
SELECT screen_name, percentile_disc(0.5) within group (ORDER BY tweet_id_to_timestamp(id) - tweet_id_to_timestamp(retweeted_id)) "Median Retweet Delay", count(*) from retweet GROUP BY screen_name HAVING count(*) > 10 ORDER BY 2 ASC;
Conversation
This Tweet was deleted by the Tweet author. Learn more
This Tweet was deleted by the Tweet author. Learn more
Replying to
Good question.
It's an extremely low median delay time. I haven't looked the account yet but it's either next to their datacenter on in it.