Now that the data we need has been uploaded into the database:
#'''REDUCE''' data to US companies and completed IPO/Acquisitions (create new table with only US companies)
## allipo and allacquis reduced so far- avesh## cleaned used getreal function to replace np values- versions called allipo_us_clean and allacquis_us_clean- avesh
#'''REDUCE''' data to NYSE and NASDAQ and AMEX
## allipo reduced to NYSE NASDAQ and AMEX in allipo_usexch