check it http://maluta.github.io/blog/things-todo-with-twitter-archive/

tweets_url.py

#!/usr/bin/python
# -*- coding:utf-8 -*-
import re
import csv

tweets = csv.reader(open("tweets.csv"), delimiter=',', quotechar='"')

exp = 'http[s]?://(?:[a-zA-Z]|[0-9]|[$-_@.&+]|[!*\(\),]|(?:%[0-9a-fA-F][0-9a-fA-F]))+'
for tweet in tweets:
    urls = re.findall(exp, tweet[5]) 
    for url in urls:
        if url != "":
            print url