Show OSX download history

To view a complete history of every file your Mac has downloaded, you can use this simple command:

sqlite3 ~/Library/Preferences/com.apple.LaunchServices.QuarantineEventsV* 'select LSQuarantineAgentName,LSQuarantineDataURLString from LSQuarantineEvent' |less

The first column (LSQuarantineAgentName) shows the app that has downloaded the file, the second column (LSQuarantineDataURLString) instead shows the file downloaded.